SUMMARY:

• More than Ten years of experience in data warehousing and business intelligence, with a strong focus inInformatica PowerCenter ETL development, testingandbugfixing, SQL, PL/SQL, scheduling jobs, and performance tuning.
• Employed ETL Methodology for supporting Data Extraction, transformation and loading processing using Informatica Powercenter.
• Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups, Aggregators and Update Strategy with Re - usable transformations.
• Experience in full cycle of Software Development including project planning, requirements analysis and documentation, design, development, testing and implementation, integration and deployment.
• Experience in developing back end programs on various databases including Oracle, DB2, MS SQL Server.
• Expertise in writing, testing and implementation of the triggers, stored procedures, functions and packages at database level using PL/SQL.
• Experience in Push Down Optimization (PDO) and Power Center Performance Tuning.
• Expertise in migration process across different environments Dev/IT/UAT/Prod and developing several shell scripts to run/stop/monitor workflows/trap errors.
• Working knowledge of Business Objects XI.
• Working knowledge of Hyperion Essbase.
• Working knowledge of Informatica MDM.
• Theoretical knowledge of Hadoop, Hbase, HDFS, Hive, PIG

TECHNICAL SKILLS:

ETL Tools: Informatica Power center 9.6,9.1,9.0/8.X/7.X,Talend 4.2.3/4.1.3.

DW Tools: Business Objects, Hyperion Essbase, Informatica MDM

Databases: Oracle 11g/10g//9i, MS SQL Server 2005/2008/2012, MS Access

Languages: SQL, PL/SQL, TSQL, Shell Scripting, Java and XML.

Operating Systems: Microsoft Windows XP/7, Windows Server 2008/2012, UNIX

Development Tools: Utilities TOAD, SQL Plus, SQL Developer, SSMS

PROFESSIONAL EXPERIENCE:

Confidential, Cincinnati, OH

Sr. ETL Developer and Lead.

Responsibilities:

• Responsible for full life cycle development including gathering requirements.
• Analyzing, coding, testing, and assisting with user acceptance testing, production implementation and system support for the Enterprise Data Warehouse Application.
• Part of interviewing, gathering, documenting requirements and determining project scope from Users; analyzing user requirements to create system designs, either coding all or sharing in the coding and development, unit testing, system testing, final implementation and post implementation monitoring.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, SQL, Union, Lookup, Joiner, XML Source Qualifier, Unconnected lookup transformations.
• Involved in Debugging and Troubleshooting Informatica mappings.
• Populated error tables as part of the ETL process to capture the records that failed the migration.
• Used Informatica Power Center 9.6.0/9.1.1/8.6.2 for extraction, loading and transformation (ETL) of data in the data warehouse.
• Communicating with Onshore team for the issue clarification, status updates etc;
• Implemented various Data Transformations for Slowly Changing Dimensions.
• Working on the changes in the Informatica Mappings and testing them to Analyze and Fix gaps in Daily Jobs related to ERP project.
• Respond and resolve ad hoc requests from application and business users. Created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.

Environment: Informatica Power Center 9.6.0, SQL Server 2012, MS Excel, Windows XP/7 Windows Server 2008/2012

Confidential, Cincinnati, OH

Informatica MDM Tester

Responsibilities:

• Involved in Extraction, Transformation and Loading of data.
• Involved in requirement gathering
• Involved in designing HLD and LLD for 4 milestones
• Has got working knowledge in developing the mappings
• Completed the end to end testing for entire engagement without any escalations.
• Got appreciations from the business for our on time deliverables..

Environment: Informatica MDM 9.1, Oracle 10g

Confidential, Cincinnati, OH

ETL Developer

Responsibilities:

• Involved in performance tuning using partition and transformation techniques.
• Involved in the preparation of documentation for ETL, standards, procedures and naming conventions.
• Developing Mapping/Mapplets/Workflows involving various ETL processes using Informatica tools.
• Setting up Batches and sessions to schedule the loads at required frequency using Autosys. Generated completion messages and status reports using Workflow manager.
• Compare the data between Siebel and SFDC and need to synchronize between them.
• Moved the T&M data from Siebel to SFDC.
• Contributed to Performance Tuning of the mappings/sessions/workflows
• Conducting and participating in the Peer review of the project deliverables
• Developed Unit Test Cases, Design Documents and Effective Test Data to ensure successful execution of the data loading process.
• Involved in production support for troubleshooting data issues and overnight batch support.

Environment: Informatica Power Center 8.6, oracle10g, SQL Server, TOAD, SQL Developer

Confidential, Cincinnati, OH

ETL Developer

Responsibilities:

• Worked with the business users to get the business rule modifications in development and testing phases and analyzed claims data through rigorous evaluation methodology.
• Wrote PL/SQL, stored procedures & triggers for implementing business rules and transformations.
• Worked on Informatica tool Source Analyzer, Data Warehousing designer, Mapping Designer, Transformations, Informatica Repository Manager and Informatica Server Manager.
• Developing ETL mappings to extract data from the Oracle and load it into the Natezza database.
• Contributed to Performance Tuning of the mappings/sessions/workflows
• Communicating with Onshore team for the issue clarification, status updates etc;
• Handling complex Informatica issues faced by team.
• Conducting and participating in the Peer review of the project deliverables.
• Puts sincere efforts to achieve the deadline; communicates in case of any issues \ roadblocks
• helped\mentored various new joiners in project both on technical\functional front.
• Worked on Data Cleansing Processes.
• Documented the Informatica Mappings and workflow process, error handling of ETL procedures
• Extensively worked on Performance Tuning using various components like parameter files, variables and dynamic cache.
• Used Business Objects for reporting. Interacted with Users for analyzing various Reports.
• Verify the logs to confirm all the relevant jobs are completed successfully and timely and involved in production support to resolve the production issues.

Environment: Informatica Power center 8.1/8.6, Microsoft SQL Server 7, SQL,Oracle10g

Confidential

Informatica Developer

Responsibilities:

• Did extensive analysis on the business requirements and gathered information for the development of several small applications.
• Developing ETL mappings to extract data from the Oracle and load it into the Natezza database.
• Do the error validation of the data moving from Oracle to the Natezza database.
• Test the mappings and check the quality of the deliverables.
• Communicating with Onshore team for the issue clarification, status updates etc;
• Conducting and participating in the Peer review of the project deliverables.
• Bug Analysis and fixing.
• Contributed to Performance Tuning of the mappings/sessions/workflows

Environment: Informatica Power Center 7.6, SQL Server 2005, Oracle 9g, TOAD,SQL Plus and Windows XP

Confidential

Informatica Developer

Responsibilities:

• Developing Mapping/Mapplets/Workflows involving various ETL processes using Informatica tools for Concurrent workflows project.
• Configuring concurrent workflows for all data marts.
• Bug Analysis and Bug fixing when running the concurrent workflows
• communicating with Onshore team for the issue clarification, status updates etc;
• Conducting and Participating Peer Code review of the project deliverables.
• Contributed to Performance Tuning of the mappings/sessions/workflows

Environment: Informatica 8.1, Oracle, Unix

Confidential

Informatica Developer

Responsibilities:

• Daily loads and handling production failure issues for Alizes application.
• Checking for the Data Quality on a daily basis.
• Participating in daily Onsite/Offshore co-ordination call meeting.
• Production Monitoring and Support.

Environment: Informatica 8.1, Oracle, Unix