We provide IT Staff Augmentation Services!

Dw/etl Informatica Developer Resume

3.00 Rating

PA

SUMMARY:

  • Over 9 years of IT industry experience in Healthcare, Insurance, Banking and Retail Business domains.
  • Experienced working in Agile and Waterfall methodologies.
  • Analysis, design, development, testing and deployment of mission critical software applications using Informatica, IBM DB2, Oracle, Microsoft Sql server, Tableau and SAP Business Objects
  • Involved in functional and technical system analysis & Design, System Architectural design, Presentation, process data flow design, system impact analysis, Gap analysis and documentation.
  • Extensive experience in Data warehousing, Data Analysis, Meta - data management, Data quality, Data Modeling, ETL tools and Reporting.
  • Proficiently rendered services in Informatica 10.1.1/9.6.1/9.1/8.6 (Power Center, Power Exchange, Cloud and Data Quality), Oracle 11g/10g/9i/8i, Microsoft SSIS and SSRS.
  • Hand’s on experience in creating complex Informatica mappings, transformation logic, sessions and workflows to extract data from various sources and load into targets and proficient in creating mapplets and worklets.
  • Expertise in Database development skills using SQL, PL/SQL, stored procedures, functions, packages, and triggers.
  • Proficient using IBM Data studio, TOAD, Sql Developer for system testing of the reports.
  • Expertise in deriving Analytical, Logical, Physical, Dimensional and Statistical Data Models.
  • Good knowledge of Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling using Erwin tool.
  • Experienced in Developing Unix Shell Scripts and scheduling Shell scripts by using scheduling tools Control-M & Autosys.
  • Involved in Unit testing, User acceptance testing, Integration testing, Performance testing and Production support.
  • Experienced in interacting with Business users, Business Analysts, IT leads and developers in analyzing business requirements and translating requirements into functional and technical design specifications.
  • Excellent verbal and written communication skills, strong time management skills
  • Strong skills on analyzing requirements & technical issues, and then designing technical solutions.
  • Experienced with on/off-shore model and also have the ability to manage time efficiently and effectively, prioritizing efforts to handle multiple activities in parallel.

TECHNICAL SKILLS:

Operating Systems: AIX/Unix, GNU/Linux, Windows 10/8/7/Vista/XP/2000/98

RDBMS: Teradata, DB2 UDB, Oracle 11g/10g/9i/8i/, SQL Server, My SQL

Languages: UNIX, Pearl, Shell Scripting (Bourne, Korn), TSQL, SQL, PL/SQL, HTML, C++, C#, VB.NET, ASP.NET

Tools: IBM Data studio, Putty, MS-office & Visio, SharePoint, TOAD 8.5/9.0, Erwin, Control-M & Autosys, Visual studio 2013/08/05, Oracle Golden gate 11g/10g

ETL Tools: Informatica 10.1.1/9.6.1/9.1/8.6, OWB 10gR1/11gR2, MS-SSIS 2012/08r2

Reporting Tools: Tableau, SAP-Business Objects XI 3.1, Cognos, OBIEE 11.1/10.x, MS-SSRS 2012/08r2

PROFESSIONAL EXPERIENCE:

Confidential, PA

DW/ETL Informatica Developer

Responsibilities:

  • Gathering the requirements by coordinating with the users, effort estimation, preparation of project timelines & design for ETL & reporting modules.
  • Identification of source systems to data warehouse by coordinating with respective source teams.
  • Analyzed the existing operational sources and involved in development of the conceptual, logical and physical data models for the newly built data warehouse.
  • Identification of dimensions and measures per business needs and prepare the design of dimensions and facts in star schema model using ERWIN tool.
  • Design walkthrough with team and made changes where required and got user sign-off approvals.
  • Development of Informatica mappings to load DW tables and dimension and fact tables.
  • Developed ETL objects for data warehousing purpose in local database and migrated into QA environment for testing purposes.
  • Used workflows to schedule the ETL processes to run at periodic intervals for various period close operations.
  • Developing Unix shell scripts to perform pre & post load activities and execution of parent and child ETL process cycles using PMCMD utility.
  • Enhanced workflow performance by creating indexes, views, altering the cache sizes and maintained Informatica logs where required and also did Performance Tuning for better performance on SQL and Informatica side.
  • Performed unit, system & end-to-end testing. Documented processing times for each module, developed test cases and used them to run through each process. Implemented and day-to-day supported the BI environment and mentoring to end users who are interacting with the data.
  • Understanding the reporting requirements of users and design the Data Source and reporting layers.
  • Assisted with Cognos reporting team to generate the reports for business users need.
  • Guided reporting team on building, publishing interactive reports and dashboards, report scheduling using Tableau server.

Environment: Informatica 10.1.1, Oracle 11gR2, Erwin, Tableau and Cognos BI tool.

Confidential, MI

Senior Lead Informatica Developer

Responsibilities:

  • Gap Analysis on the existing legacy system and other relational source systems.
  • Did data profiling on the source system to confine and streamline the business requirements for ETL and reporting components.
  • Involved in creation of data marts for design of Star schemas for Data warehouse.
  • Coordinated with project manager to document the project planning and also bi-weekly updates.
  • Daily status meetings with teams and provided guidance and mentoring in technical areas to the team of Developer/Analysts and then document and submit status reports to leadership.
  • Coordinated with Business Analyst and prepared Table and column level Business/Transformation rules documents (STTM).
  • Developed the several ETL processes, and created the Informatica mappings, workflows, sessions etc, and also tuned them for better performance.
  • Enforcing coding best practices like naming conventions and Error Handling.
  • Performance tuning of ETL code through session partitioning, incremental aggregation and push down optimization techniques.
  • Database query cost analysis to identify the performance bottlenecks and fine tune the SQLs to achieve better performance
  • Developing reusable code modules (ETL, Unix and database) for performing Audit, Balance and Control for any data that loads into EDBI warehouse & datamarts.
  • Developed UNIX script to perform operations by bringing down the source files from a legacy mainframe source to the respective UNIX source directory, trigger necessary Informatica workflows, archiving the files and updating the necessary log files on the operations performed.
  • Developed ETL objects for data warehousing purpose in local database and migrated into QA environment for testing purposes.
  • Prepared test cases, test scripts & test data. UAT coordination with business and defect tracking using Quality Center tool. Defect fixes, support and follow up on necessary approvals for production deployment.
  • Pre-production walk though and preparation of project artifacts such as Requirements Traceability Matrix, Low Level Design, High Level Design, Unit Test Results etc. involved at all phases of SDLC.
  • Guiding team members, performing code reviews, mentoring new members and bringing them up to speed per the project needs.

Environment: DB2, Informatica 9.6.1, Guidware, UNIX, TOAD for DB2, Flat file and XML Sources.

Confidential, CA

Lead Informatica Developer

Responsibilities:

  • Involved in the Design, Development, Testing phases of ETL process for Auto and home policy data marts.
  • Design of end user reports using SAP Business Objects which will be replacing the legacy based system reports
  • Generating the reports from data warehouse and data marts and making them balanced against the reports from source systems.
  • Close co-ordination with business users to analyze and elicit the requirements for building reports.
  • Data profiling to confine and streamline the business requirements for generating the end reports.
  • Following the PDLC process to move the code across the environments though proper approvals and source control environments.
  • Develop the audit, balance and control process which will enable the control on history of ETL job statistics.
  • Analysis on the existing legacy system to correlate it in Informatica based solution.
  • Requirements gathering form business team and data profiling as per the same.
  • Effort estimations& schedule planning for the given requirements
  • Design the ETL process.
  • Developing, Unit testing
  • System testing and migration support
  • Code defect fixes, support and follow up on system testing approval and client approvals on UAT.
  • Preparing and reviewing deployment documents and support of production migration
  • and testing.

Environment: DB2, Informatica 9.1, SAP BO, UNIX, TOAD, Flat file and XML Sources.

Confidential, CA

ETL / Informatica Developer

Responsibilities:

  • Analyzed the existing operational data sources and involved in development of the logical and physical data models for the newly built data warehouse.
  • Developed initial ETL (Informatica) objects in local repository folders, while using the shared objects for sources, targets and transformations.
  • Involved in creation of data marts for design of Star schemas for Data warehouse application.
  • Created several database objects like views, indexes, procedures etc., to resolve the performance issues.
  • Developed the several ETL processes, and created the Informatica mappings, workflows, sessions etc, and also tuned them for better performance.
  • Used stored procedures, functions, cursors etc. to load data from different sources i.e., ‘Infinity controlled’ to target area called ‘Finance Area - controlled’ databases.
  • Developed ETL objects for data warehousing purpose in local database and migrated into QA environment for testing purposes.
  • Assisted with reporting team to generate the reports for business users need.
  • Used workflows to schedule the ETL processes to run at periodic intervals for various period close operations.
  • Developed UNIX script to perform operations by bringing down the source files from a staging area (Infinity) to the respective UNIX source directory, trigger necessary Informatica workflows, archiving the files and updating the necessary log files on the operations performed.
  • Prepared test cases, test scripts & test data.
  • Did code walkthrough of all the designs with team and made changes where required.
  • Coordinated with project manager to document the project planning, scheduling and also bi-weekly updates.
  • Enhanced workflow performance by creating indexes, views, altering the cache sizes and maintained Informatica logs where required.
  • Used Power Analyzer to generate data profiling reports & to monitor data quality during production run.
  • Performed unit, system & end-to-end testing. Documented processing times for each module, developed test cases and used them to run through each process. Implemented and supported the BI environment and User Interface.
  • Participated in and made presentations to the higher management on the developments made.

Environment: Oracle 10g/9i, Informatica 8.6, Business Objects, PL/SQL, ERWin, TOAD and HP Unix

Confidential, CA

ETL Developer

Responsibilities:

  • Interacted with the investment brokers, advisors, analysts and account executives and understood the business requirements by analyzing and defining key issues related to the earlier work system.
  • Involved in the design, data modeling, development and testing phases of various projects and enhancements.
  • Analysis, requirements gathering, functional/technical specification, develop-ment, deploying and testing.
  • Logical & Physical Database Layout Design. Created Informatica mappings for initial load and daily updates.
  • Created Informatica mappings for initial load and daily updates.
  • Developed mapplets and worklets.
  • Generated flat files using Informatica power center and extracted XML and Flatfile Designed reusable transformations and shortcuts to share different mappings.
  • Implemented Slowly Changing dimension Type 1, Type 2, and Type 3 methodology for accessing the full history of accounts and transaction information.
  • Developed, tested procedures, Functions and packages in PL/SQL for Data ETL
  • Generated Reports using Metadata Reporter
  • Day-to-Day Production support.
  • Involved in fixing, testing of store procedures and functions, unit and integration testing of Stored Procedures and the target data.
  • Developing Unix shell scripts and scheduling Unix Scripts by using scheduling tools.
  • Worked with end users to develop and collect feedbacks in the User Acceptance Testing (UAT)
  • Involved in Production Deployment and Support.

Environment: Oracle 9i, Informatica 8.1, PL/SQL, ERWin, TOAD, XML and Flat file Source Data and HP UNIX, AIX

Confidential

Unix Consultant

Responsibilities:

  • Developing Perl scripts for automating the scheduled backup process for all the programs and web pages those saved over sever.
  • Creating of shell scripts to automate the user creation setup for the list of programmers in the organization.
  • Scripts for automated monitoring and alter setup for disk overload and CPU overload on the server.
  • Installation of apache web server on Ubuntu GNU/Linux server.
  • Hardware and network setups for the Unix servers with the local area network.
  • Setup of required programming platforms for users on the GNU/Linux servers.
  • Understanding the requirements as per the business and technical need
  • Developing the code and testing the same for meeting the requirement
  • Handling maintenance and support for the production environment
  • Guiding new trainees on the maintaining the environment

Environnent: PERL, GNU/Linux, UNIX, Shell Scripting (Bourne, Korn)

We'd love your feedback!