Senior Etl Principal Consultant Resume
Holmdel, NJ
SUMMARY
- 18+ years of strong technical IT experience in Finance, Health Care, Banking industries as Informatica Lead/Developer with ETL Data warehousing background
- Effective working relationships with client team to understand support requirements, and effectively manage client expectations.
- Business strategist; plan, manage & implement multimillion - dollar projects aligning business goals with global and scalable technology solutions to drive process improvements and bottom-line gains
- Experience in using Informatica Power Center tools such as Source Analyzer, Transformation Developer, Moppet Designer, Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager
- Extensive experience in developing complex mappings from varied transformations like Router, Filter, Sorter, Connected and Unconnected lookups,, Normalizer, Expression, Aggregator, Joiner, Union, Update Strategy, Stored Procedure and Sequence Generator etc.
- Extensive experience in Databases in Oracle 10g/9i/8.x/7.x, MS SQL Server 2000, MS Access and strong experience using SQL, PL/SQL Procedures/Functions, Triggers and Packages.
- Extensive experience in Production support dealing with support escalations from Level 1 team, including complex user and monitoring support queries, with as minimal as possible escalations to L3 teams by planning and execution of proactive non-ticket tasks
TECHNICAL SKILLS
ETL Tools: Informatica 8.x/7.x/6.x/5 (Power Center/PowerMart) (Designer, Workflow Manager, Workflow Monitor, Server Manager, Power Connect)
Data Modeling: Physical Modelling, Logical Modelling, Relational Modelling, Dimensional Modelling (Star Schema, Snow-Flake, Fact, Dimensions), Entities, Attributes, Cardinality, ER Diagrams.
Databases: Oracle 10g/9i/8i, MS SQL Server 2005/2000, MS Access and DB2
Languages: SQL, PL/SQL,C,C++,Data Structures, Unix Shell Script, Visual Basic
Web Technologies: HTML, XML, Java Script
Tools: SQL plus, PL/SQL Developer, Toad, SQL* Loader
Operating Systems: Windows NT/2000/2003/XP/Vista/7, UNIX, MS-DOS and Linux
PROFESSIONAL EXPERIENCE
Confidential
Senior ETL Principal Consultant
Responsibilities:
- Analysis of business requirements for end-to-end ETL process
- Worked closely with business analysts to understand the business needs for decision support data
- Analyzed and Created Facts and Dimension Tables for star schema
- Participated in system analysis and data modeling, which included creating tables, views, indexes,
- Synonyms, triggers, functions, procedures, cursors and packages.
- Writing queries and stored procedures in PL/SQL to fetch data from the OLTP system and executed at regular intervals of time.
- Designed, developed, implemented and maintain programs to load, aggregate, and extract data to meet a wide range of business and system requirements using Informatica.
- Performed data mappings and design of system ETL workflow solutions.
- Worked with functional team of Confidential users to establish and clarify requirements.
- Investigated and corrected application defects and analyzed to maintains data quality
- Prepared comprehensive documentation
Environment: Informatica 9.5,Cognos 10.1, Framework Manager, Transformer, Sql Server, TOAD, SQL Navigator, PL/SQL,Window 7, Unix.
Confidential, Holmdel, NJ
Senior ETL Consultant
Responsibilities:
- Designed and developed ETL Mappingsto extract data from HP Flat files and Oracle to load the data into the target database.
- Developing several complex mappings in Informatica a variety of PowerCenter transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using Informatica PowerCenter.
- Built complex reports using SQL scripts.
- Designed the ETL processes using Informatica to extract data from Oracle, Flat Files, and XML files to load into target tables.
- Developed various Sessions, Batches for all Mappings to load from Source flat files tables to Target tables
Environment: Informatica 10.1,Cognos 10.1, Oracle 11g, TOAD, SQL Navigator, Rally SVN,PL/SQL,Window8, Unix.
Confidential, Washington, DC
Senior ETL Consultant/Application Analyst
Responsibilities:
- Associated with team in offsite/onsite and assigned tasks to different team members
- Coordinated with upstream/downstream consumers/users, analyzed the business systems gathered requirements and coordinated accordingly.
- Monitored Day to day activities and conducted meeting for reviewing codes and updated management accordingly
- Created User stories in Rally for requirements and assigned accordingly to individual.
- Conducted daily stand up calls for status updates and made sure work assigned is completed in given spirit
- Designed and developed ETL Mappingsto extract data from flat files, MS Excel and Oracle to load the data into the target database.
- Involved and develop several complex mappings in Informatica a variety of PowerCenter transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using Informatica PowerCenter.
- Created complex mappings to load the data mart and monitored them.
- Working extensively with the QA team for designing Test Plan and Test Cases.
- Created Shell Scripts for new business strategies/plan.
Environment: Informatica 9.6, Business Objects 11x, Oracle 11g, TOAD, SQL Navigator, Rally SVN,PL/SQL,Window8, Unix.