Senior Informatica ETL Consultant Resume

SUMMARY:

8 years of ETL and data integration experience in developing ETL mappings and scripts using Informatica PowerCenter 9.x/8.x, Designer (Source Analyzer, Mapping designer, Mapplet Designer, Transformation Developer), Repository Manager, Workflow Manager & Workflow Monitor
Strong Knowledge of Data Warehouse Architecture, Star Schema, Snow flake Schema, FACT and Dimensional Tables, Physical and Logical Data Modeling
Experience in ETL Requirements Analysis, Data Profiling, Technical Design and Source - to-Target Mappings Specifications
Extensive experience in designing and developing complex mappings from varied transformation logics like Unconnected /Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Union, Update Strategy and strategies like Push Down Optimization (PDO)
Extensively worked with Slowly Changing Dimensions (Type I, Type II and Type III)
Extensive experience in extracting, transforming and loading of data using Informatica Power Center from different source systems including Oracle, DB2, SQL Server databases, flat files and excel files
Experience in trouble shooting and implementing performance tuning at various levels such as Source, Target, Mappings and Sessions
Hands on experience in creating & configuring sessions, batches/workflows and worklets using the Workflow Manager of Informatica
Hands on experience through complete Software Development Life Cycle (SDLC) including Analysis, Design, Development, Testing and Implementation
Strong SQL, PL/SQL skills with proficiency in creating stored procedures, functions and packages using PL/SQL
Worked on UNIX shell scripts (Korn Shell) in scheduling Informatica workflows
Experience in Test Planning, Test Case design, Test Scripting, Test Execution and Test Analysis
Experienced in working in large data warehouses (>5 TB)
Experienced at Creating Effective Test data and development thorough Unit test cases to ensure successful execution of the data
Excellent communication, presentation and documentation skills, a very good team player and self-starter with ability to work independently and as part of a team

TECHNICAL SKILLS:

ETL tools: Informatica PowerCenter 9.x/8.x, Designer (Source Analyzer, Mapping designer, Mapplet Designer, Transformation Developer), Repository Manager, Workflow Manager & Workflow Monitor

BI tools: SAP BI 7.x, BEX Analyzer

Databases: Oracle 12c/ 10g, MS SQL Server 2012/ 2008

Tools: Toad, UNIX Shell Scripting, Autosys, Control M, Test Director, CA Erwin, Visio

Operating Systems: Windows 2012/ 2008, HP-Unix, UNIX AIX, Linux

Data Modeling: Dimensional Data Modeling, Star Join Schema Modeling, Snow Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship