We provide IT Staff Augmentation Services!

Senior Etl Informatica Developer Resume

Phoenix, AZ

SUMMARY

  • Around 6+ experience in IT Software Development Life cycle involved in Business Requirement Analysis, Application Design, Data Modeling, Development, Testing and Implementation of Data Warehousing applications in Banking domain.
  • Experience in Analysis, Design, Development and Maintenance of various Business Intelligence Tools like Informatica, MicroStrategy
  • Experience in Agile (SCRUM) Data integration projects involving different Informatica tools and Oracle.
  • Very good experience on different data sources such as Flat files, XML files and Excel files for the development of mappings.
  • Performing Data validation, Data integrity, Data Quality checking before delivering data to operations, Business, Financial analyst.
  • Having very good development experience in Informatica designer/workflow manager/workflow monitor and Repository Manager and good experience in UNIX.
  • Experience in all phases of SDLC including Requirements Gathering, Design, Development, Unit Testing, Ongoing support and Maintenance.
  • Experience in Data profiling, Data masking, dimensional data modeling of star schema.
  • Good understanding of ETL, Dimensional Data Modeling, Slowly Changing Dimensions (SCD) and Data Warehouse Concepts.
  • Experienced with coordinating cross - functional teams.

TECHNICAL SKILLS

Business Intelligence: Informatica 10.2/9.6, MicroStrategy

Database: Oracle 12c

Languages: SQL, PL/SQL, Shell Scripting, Hivesql

Tools: SQL Developer, TOAD, Control M, Automic, BPM, Hive, Rally

EIM tools Informatica TDM:

OS/Environment: Windows, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

Senior ETL Informatica Developer

Responsibilities:

  • Build Operational data store (ODS) to support Federal regulatory report.
  • Through this data federal reports like FR Y9C, Y11, Y14, Y2314 are filed.
  • Requirements gathering and requirements analysis through coordination with business analysts and define business and functional specifications.
  • Provided documentation of ETL design and technical specifications, high level and low-level design specifications.
  • Good amount of experience working in Data Warehouse project i.e. creating and loading different Data Feeds through Informatica.
  • Used Informatica Power Center 10.2 for extraction, transformation and load (ETL) of data into the data warehouse.
  • Worked extensively on different types of transformations like Source qualifier, Expression, Filter, Aggregator, Lookup, Sequence generator, Router and Joiner.
  • Worked on Informatica Advanced concepts & also Implementation of Informatica PushDown Optimization and Partitioning.
  • Created mapplets and reusable transformations to leverage the coding efforts and to help code maintenance.
  • Used Type 2 SCD logic in Informatica to load Slowly Changing Dimension tables.
  • Worked with testing team to define a robust test plan and support them during the functional testing of the application.
  • Identifying & removing the bottlenecks, tuning the mappings and sessions to improve performance.
  • Precise Documentation was done for all mappings and workflows.
  • Involved in automation & scheduling of jobs through Automic.
  • Review and deploy the code.
  • Prepare and use test data/cases to verify accuracy and completeness of ETL process.

Environment: Informatica Power Center 10.2, Informatica TDM, Oracle, Oracle BPM, Unix, Automic

Confidential

ETL Informatica Developer

Responsibilities:

  • Build Operational data store (ODS) to support BASEL regulatory report.
  • To provide high data quality for regulatory reporting, all AET systems within the “ecosystem” will be required to provide insight into their respective data quality controls. Items which are required to be provided include DQ Checks implemented at the identified system and DQ Check occurrences at the identified system.
  • Requirements gathering and requirements analysis through coordination with business analysts and define business and functional specifications.
  • Provided documentation of ETL design and technical specifications, high level and low-level design specifications.
  • Good amount of experience working in Data Warehouse project i.e. creating and loading different Data Feeds through Informatica.
  • Used Informatica Power Center 9.61 for extraction, transformation and load (ETL) of data into the data warehouse.
  • Worked extensively on different types of transformations like Source qualifier, Expression, Filter, Aggregator, Lookup, Sequence generator, Router and Joiner.
  • Created mapplets and reusable transformations to leverage the coding efforts and to help code maintenance.
  • Used Type 2 SCD logic in Informatica to load Slowly Changing Dimension tables.
  • Worked with testing team to define a robust test plan and support them during the functional testing of the application.
  • Identifying & removing the bottlenecks, tuning the mappings and sessions to improve performance.
  • Precise Documentation was done for all mappings and workflows.
  • Involved in automation & scheduling of jobs through Control M.
  • Worked on Data validation report through MicroStrategy.
  • Review and deploy the code.

Environment: Informatica Power Center 9.61, Oracle, Unix, Control M, MicroStrategy

Hire Now