Professional Summary:

• 8 years of experience in Data Warehouse/ETL procedure loading data from various sources into DW using Power Center Designer, Workflow Manager and Workflow Monitor
• Experience in Developing Complex Mappings, Reusable Transformations, Sessions and Workflows using Informatica ETL tool for data extraction from various sources and loading into target tables
• Experience in performance tuning of mapping and workflow to reduce the data load and process time
• Worked and Implemented Pushdown Optimization PDO to optimize performance issues of complex mappings involving numerous transformations and hence degrading the performance of the session
• Experience in creating various transformations using Aggregator, Look Up, Update Strategy, Joiner, Filter, Sequence Generator, Normalizer, Sorter, Router, Stored Procedure in Informatica Power Center Designer
• Involved in data migration and data quality check through ETL processes
• Expertise in DW concepts like Star Schema, Snowflake Schema, Fact Tables and Dimension Tables
• Hands on Experience in ERWIN Data Modeling tool
• Experience in understanding the Physical and Logical Data Models and assisting the modeling team in restructuring the Data Model
• Experience using Teradata utilities SQL, FastLoad, MultiLoad, Tpump ,TPT .
• Experience in gathering business requirements, establishing functional specifications and translating them to design specifications
• Experience in creating sessions in Workflow Manager and running the workflows in Workflow Monitor and analyzing them. Hands on experience in various Active and Passive Transformations
• Worked with re-usable objects like Re-Usable Transformation and Mapplets
• Extensively used SQL Override function in Source Qualifier Transformation
• Extensive ETL Testing experience using Informatica Power Center 8.6/7.1 components Designer, Workflow Manager, Workflow Monitor and Server Manager
• Sound Knowledge Profound Experience in various phases of Software Development Life Cycle SDLC
• Expertise in writing UNIX Shell Scripts for scheduling session for Work Flow
• Experience in Production Support post implementation
• Experience working with TOAD Querying Tool

TECHNICAL SKILLS:

Professional Experience:

Confidential

ETL Developer

Role and Responsibilities:

• Created design pattern templates for deliverable objects
• Strong working experience with Informatica Power Center
• Experience in wrapping the Informatica WorkFlows and UNIX scripts with Control framework
• Involved in designing the process flow for extracting data across various interacting systems
• Involved in extracting the data from Flat Files and loading into staging tables
• Experience with SQL Override and source filter usage in Source Qualifiers and data flow management using Filter Transformation
• Created and used reusable transformations for Data type conversions
• Experience with transformations including complex LookUps, Stored Procedures, Update Strategy, etc.
• Expert in designing and developing the reusable sessions and Worklets
• Debugging the Informatica mappings and validating the data in target tables once it got loaded
• Involved in performance tuning by identifying and optimizing source, target, mappings and session bottlenecks
• Fine tuning Informatica mappings for Performance Optimization
• Problem solving and troubleshooting design and development issues and providing appropriate solutions
• Involved in deploying/migrating Informatica Workflows, Database Objects and Metadata within UAT and Production environment
• Expert in switching the Metadata between different schemas in various environments like UAT and Production
• Involved in deploying the Informatica WorkFlows using Subversion and Quick-build process.
• Troubleshoot the issues by checking sessions, workflow logs and metadata
• Actively participated in database activities like checking the Primary Indexes, correctness of the data and field size validation, etc.
• Performed System Testing, Regression Testing, Acceptance Testing, Functional Testing and Stress Testing
• Worked closely with Production Control team to schedule Informatica WorkFlows and Shell Scripts for Archive and Purge in Control M
• Prepared the Standard Operating Procedure Knowledge Transfer document, which provides necessary information, required for the Maintenance and Operation of the application

Confidential

ETL Developer

Environment: Informatica 8.6, Oracle DB, UNIX

Role and Responsibilities:

• Requirement analysis, Impact Analysis and Preparing detailed design
• Requirement gathering and detailed design walkthroughs for the team members, Coding and Testing of ETLs, Co-ordination of deployment activities with other teams, Data validation , Preparing Unit Test cases, Triaging of defects, Conducting code review sessions
• Interacting with senior peers or subject matter experts to learn more about the data
• Designing and creation of complex mappings using SCD Type II involving transformations such as Expression, Joiner, Aggregator, LookUp, Update Strategy, and Filter
• Defined Target Load Order Plan for loading data into Target Tables
• Used Informatica Power Center Workflow manager to create sessions, batches and workflows to run the logic embedded in the mappings
• Used Mapplets and Reusable Transformations to prevent redundancy of transformation usage and maintainability
• Performed functionality, Integration, positive and negative testing
• Worked on issues with ETL and DB migration from development to SIT, SIT to Pre-Production and Pre-Production to Production environments
• Reviewed ETL Mappings, Sessions, Unix Scripts, Test Results, Parameter Files, Test Cases, Mapping Specification Documents etc developed by team members
• Assisted/groomed team members and provided guidance during ETL development
• Check project progress, status reporting, risk identification and communicating to proper channel
• Writing UNIX Shell Scripts for Informatica ETL tool to run the Sessions and also for job scheduling
• Integrated Data Cleansing processes within the Mappings
• Ensuring the SLA during production support during the release cycles

Confidential

ETL Developer

Environment: Informatica 8.6, Oracle DB, UNIX, SQL Developer

Role and Responsibilities:

• Requirement gathering-analysis and detailed design walkthroughs for the team members, Coding and Testing of ETLs, Co-ordination of deployment activities with other teams, Data validation , Preparing Unit Test cases, Triaging of defects, Conducting code review sessions
• Interacting with senior peers or subject matter experts to learn more about the data
• Designing and creation of complex mappings using SCD Type II involving transformations such as Expression, Joiner, Aggregator, LookUp, Update Strategy, and Filter
• Defined Target Load Order Plan for loading data into Target Tables
• Used Informatica Power Center Workflow manager to create sessions, batches and workflows to run the logic embedded in the mappings.
• Used Mapplets and Reusable Transformations prevent redundancy of transformation usage and maintainability
• Performed functionality, Integration, positive and negative testing
• Worked on issues with ETL and DB migration from development to SIT, SIT to Pre-Production and Pre-Production to Production environments
• Reviewed ETL Mappings, Sessions, Unix Scripts, Test Results, Parameter Files, Test Cases, Mapping Specification Documents etc developed by team members
• Assisted/groomed team members and provided guidance during ETL development
• Check project progress, status reporting, risk identification and communicating to proper channel
• Writing UNIX Shell Scripts for Informatica ETL tool to run the Sessions and also for job scheduling
• Integrated Data Cleansing processes within the Mappings
• Ensuring the SLA during production support during the release cycles

Confidential

ETL Developer

Environment: Informatica 8.x, Teradata V2R6

Role and Responsibilities:

• Participated in the Data Model design according to the Business Requirements
• Created Design Specification Documents including Source Target
• Translated Business Requirements into Informatica mappings to build Data Warehouse using Informatica Designer which populated the data into the Target Star Schema on Teradata
• Extensively used Router, Joiner, LookUp, Aggregator, Expression and Filter transformations in mappings
• Extensively worked with performance tuning of the mappings by implementing the Hash Key Algorithms for the Flat Files
• Debugged and resolved load failures by verifying the log files. Supported QA-Testing in fixing the bugs and also helped to resolve various data issues
• Performed System Testing, Regression Testing, Acceptance Testing, Functional Testing and Stress Testing
• Maintained a very good interaction with Analysts, Project Managers, Architects and Testers to have efficient and better results
• Partially Involved in writing the UNIX Shell Scripts, which triggers the workflows to run in a particular order as a part of the daily loading into the Data Warehouse

Confidential

ETL Developer

Environment: Informatica 8.x, DB2, Flat files, UNIX, SQL Developer, OBIEE, HP QUALITY CENTER.

Responsibilities:

• Extensively worked on Informatica Power Center tools- Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Worked with Data modeler, according to changes in the model worked on changes in the informatica.
• Imported the source definition into source analyzer from oracle
• Imported the Target definitions into Target Designer from oracle and DB2
• Working with Business Analyst, Translating Business requirements into Functional requirements.
• Developed and Tested new mappings.
• Created and configured the sessions for work flow.
• Created and maintained parameter files for workflows in the UNIX and CVS.
• Worked on Joiner, Aggregator, Update Strategy, Rank, Router, Lookup static and Dynamic , Sequence Generator, Filter, Sorter, Source Qualifier.
• Implemented slowly changing dimensions - Type I, II III in different mappings as per the requirements.
• Performed System Testing, Regression Testing, Acceptance Testing, Functional Testing and Stress Testing
• Created connections for relational, Non-relational and applications in the workflow manager.
• Created mappings using Reusable Transformations.
• Migrating mappings, workflows and parameter files from development to production.
• Developed PL/SQL scripts line packages and store procedures for data updates.

Confidential

Informatica Developer.

Environment: Informatica 8.x, ORACLE DB, Flat files, UNIX, SQL Developer, OBIEE, HP QUALITY CENTER.

Responsibilities:

• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Parsing high-level design spec to simple ETL coding and mapping standards.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping Mapplet Designer and Transformation Designer.
• Tuning Informatica Mappings and Sessions for optimum performance.
• Implemented Slowly Changing Dimensions - Type I II in different mappings as per the requirements.
• Extensively worked on the Repository Manager to create/modify/delete users/group/roles
• Provided technical support to Quality Assurance team and Production group.
• Performed System Testing, Regression Testing, Acceptance Testing, Functional Testing and Stress Testing
• Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations.
• Created new mappings and updated old mappings according to changes in Business logic.
• Created and monitored workflows and tasks using Informatica Power Center workflow manager