SUMMARY

• 6 years of experience in Data Warehouse/ETL procedure to load data from different sources into data warehouse using Power Center Designer, Workflow Manager and Workflow Monitor.
• Experience in Developing complex Mappings, Reusable Transformations, Sessions and Workflows using Informatica ETL tool to extract data from various sources and load into target tables. Experience with performance tuning of mapping and workflow to reduce the data load and processing time.
• Experienced in relational databases Oracle, Teradata
• Significant work experience in Onsite/Offshore co - ordination, Client Interfacing and Technical Leadership.
• Involved in data migration and data quality check through ETL processes.
• Expertise in Star schema, Snowflake schema, Fact tables and Dimension tables.
• Experienced 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 9.1/8.6/7.1 components (Designer, Workflow Manager, Workflow Monitor and Server Manager).
• Knowledge of various phases of Software Development Life Cycle (SDLC).
• Expertise in writing UNIX Shell Scripts for scheduling session for work flow.
• Supported production post implementation.
• Worked with TOAD Querying Tool and SQL Assistance.
• Ability to quickly understand existing business model and applications in order to perform reengineering to in corporate new business rules and functionality Highly adaptive to a team environment and capable of making decisions and performing tasks on an individual basis.
• Excellent communication and interpersonal skills. Demonstrated ability to quickly grasp new concepts, both technical and business rela=ted and utilize as necessary.

TECHNICAL SKILLS

Tools: Informatica 7.1/8.x/9.1, Toad, MKS, TWS, QC

OFFICE S/W: MS Office( MS Word, MS Excel, MS Power Point)

Data Base: Oracle 10i/9.x, Teradata 13.10, MS SQL Server 2008

Methodologies: Data Modeling - Logical, Physical. Dimensional Modeling - Star/Snowflake. SDLC - Agile and Waterfall models

Programming: UNIX Shell Scripting, SQL, PL/SQL

Operating Systems: Unix, Windows XP/7/8

Functional Experience: Banking, Pharmacy, Health Insurance

PROFESSIONAL EXPERIENCE

Confidential, PA

ETL Developer

Environment: Informatica 9.1, Teradata, UNIX

Responsibilities:

• Responsible for Requirements analysis, Impact Analysis and preparing detailed design.
• Responsible for Offshore-onshore coordination.
• Responsible for Requirement and detailed design walkthroughs for the team members, Coding and Testing of ETLs, Co-ordination of deployment activities with other teams, Data validation, preparing the unit test cases, Triaging of defects, Conducting code review sessions.
• Interacting with senior peers or subject matter experts and BSA to learn more about the data and requirement.
• Designing and creation of complex mappings using SCD Type II involving transformations such as expression, joiner, aggregator, lookup, update strategy, and filter.
• Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that they conform to the business needs.
• 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 functional, 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.
• Regularly checking project progress, status reporting, risk identification and communicating to proper channel.
• Involved in writing the UNIX shell scripts for Informatica ETL tool to run the Sessions and also for job scheduling.
• Integrated data cleansing processes within the Mappings.

Confidential, LA

ETL Developer

Environment: Informatica 8.6, Oracle PL/SQL, UNIX

Responsibilities:

• I was responsible for Requirements analysis, Impact Analysis and Preparing detailed design.
• Responsible for Offshore-onshore coordination.
• Responsible for Requirement and detailed design walkthroughs for the team members, Coding and Testing of ETLs, Co-ordination of deployment activities with other teams, Data validation, Preparing the 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.
• Regularly checking project progress, status reporting, risk identification and communicating to proper channel.
• Involved in writing the 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, LA

ETL Developer

Environment: Informatica 8.1, PL/SQL, UNIX, Tivoli Workflow Scheduler TWS

Responsibilities:

• I was responsible for Requirements analysis, Offshore-onshore coordination, design, Requirement and detailed design walkthroughs for the team members.
• Worked on Informatica Power Center tool - Source Analyzer, Warehouse Designer, Mapping Designer, Workflow Manager, Mapplets and Reusable Transformations.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Worked extensively on different types of transformations like source qualifier, expression, filter, aggregator, rank, update strategy, lookup, stored procedure, and sequence generator, joiner Transformation.
• Performed all aspects of verification, validation including Functional testing, Unit Testing, System testing, Regression testing, structural testing, Performance, load and Back-End testing manually.
• Schedule and Run Extractionand Load process andmonitor sessionsusing Informatica Workflow Manager
• Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions and scheduling them to run at specified time and as well to read data from different sources and write it to target databases.
• Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that they conform to the business needs.
• Worked closely with the testing team helping them writing the test cases and fixing the bugs.
• Supported the daily load batch process and gave post production support by fixing some of the post production issues during the project release.
• I was also responsible for Data validation, Unix Scripting, Developing Test Case and Mapping Specification Documents, Triaging of defects.
• Ensuring the SLA during production support during the release cycles.

Confidential, LA

ETL Developer

Responsibilities:

• I worked as a developer responsible for Coding and Testing of ETLs.
• Writing test cases for the application with respect to the user requirement document.
• Creating necessary test data for testing the applications.
• Developed various slowly changing Type1, Type2 and slowly growing dimensional mappings according to the data mart schemas for the Change data capture.
• Developed and Scheduled workflows using workflow manager created and modified parameter files according to the business requirements.
• Performed the Database testing on the databases to check whether the data is generated correctly as per the business requirement.
• Formulated various mappings using various active and passive transformations, Created Mapplets and reusable Transformations.
• Defined Target Load Order Plan for loading data into Target Tables.
• Used Informatica Workflow Manager and Workflow Monitor to schedule and monitor session status.
• Supported production during the release cycles.

Confidential, LA

ETL Developer

Environment: Windows/Unix, Oracle, Informatica 7.1

Responsibilities:

• I was responsible for Data Analysis and Code Development.
• Testing of various kinds of interfaces depending on the applications.
• I was also responsible for the code deployment and have developed test case and Mapping Specification Documents.
• Involved in the creation of shortcuts for source, targets and in the creation of reusable transformations according to business logic.
• Analyzed dependencies and developed transformation logic for various enhancements and integrating various sub marts.
• Used Informatica Power center tools to extract data from multiple sources, which include relational sources, flat files and excel files.
• Extensively worked on ETL development for masking the production data, Unit testing/Validation of ETLs, Test data preparation and metadata migration to SIT, Pre-Production and Production environments.
• Created sessions, database connections and batches, Scheduled and monitored transformation processes using Informatica Server Manager.
• Created tables and inserted the required data.
• Co-ordinated with different teams like DBA and Infa-Admin during the Project development and Release phase.

Confidential

ETL Developer

Environment: Informatica 7.1, Oracle PL/SQL, UNIX

Responsibilities:

• I was responsible for the design of Informatica mappings.
• Used various transformations like Filter, Aggregator, Lookup, Update strategy, Filter, source qualifier etc.
• Performing impact analysis and performing requirement analysis.
• Extensively involved in working on different active and passive transformations and involved in generating, modifying and processing the data.
• I was also responsible for the development/testing of Informatica mappings.
• I have done data Analytics and exploration of data to fix the history data by developing the FIPs (Fix In Place) and also involved in Unit Testing, Integration Testing and Performance Testing.
• I have prepared ETL Specifications, Unit Test Case, Test Plan and Test Report, Migration Documents, Performance Documents and checklists for the project.
• Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions and scheduling them to run at specified time and as well to read data from different sources and write it to target databases.
• I have handled migration to Test followed PROD movement and provided support during SIT/UAT.