We provide IT Staff Augmentation Services!

Senior Etl Principal Consultant Resume

4.00/5 (Submit Your Rating)

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.

We'd love your feedback!