We provide IT Staff Augmentation Services!

Elt/informatica Developer Resume

5.00/5 (Submit Your Rating)
Hire Now

PROFESSIONAL SUMMARY:

  • +3 years experience using Extract Transform Load (ETL), Analysis, Design, Development, Testing, and Implementation.
  • Strong Data Warehousing, ETL experience using Informatica 10.1/9.x. PowerCenter Client tools - Mapping Designer, Repository Manager, Workflow Manager/Monitor and Server tools.

TECHNICAL SKILLS:

  • Informatica10.1/9.x PowerCenter
  • Client tools - Designer
  • Workflow Manager
  • Workflow Monitor
  • Repository Manager
  • SQL
  • Project Management
  • Data Flow Management
  • Data Integration
  • Data Warehousing
  • Problem Solving Abilities
  • OLAP

PROFESSIONAL EXPERIENCE:

Confidential

ELT/Informatica Developer

  • Developed SQL procedures, functions, stored procedures and packages within the mappings retrieving data, inserting new data, and updating database tables without errors.
  • Successfully created and imported different types of sources in Informatica using Source Analyzer.
  • Tuned Informatica mappings and sessions for optimum performance.
  • Assisted the other ETL developers in solving complex scenarios and coordinated with source systems owners with day-to-day ETL progress monitoring.
  • Created mappings and procedures in the database level which optimized performance.
  • Created and reviewing documents that mapped data, successfully moving them from source table to target table.
  • Worked with various transformations including router transformation, update strategy, expression transformation, lookup transformation, sequence generator, aggregator transformation and sorter transformation.
  • Debuged the Informatica mappings and validated the data in the target tables once it was loaded with mappings.
  • Created and Monitored Work Flows using Workflow Manager and Work Flow Monitor.
  • Created Workflows / Worklets and scheduled them using workflow manager.
  • Worked extensively on different types of transformations like Update Strategy, Look Up, Filter and Router Transformations.
  • Developed Mapping to load data in Slowly Changing Dimensions.
  • Ensured proper Dependencies and Proper running of loads (Incremental and Complete loads).
  • Developed Informatica Mappings to capture data changes from the operational sources systems into data warehouse and data marts (SCD mappings).

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship