We provide IT Staff Augmentation Services!

Informatica Developer Resume

5.00/5 (Submit Your Rating)
Hire Now

PROFESSIONAL SUMMARY:

  • About 8 years of Information Technology Experience in Data Warehouse using Tools like Informatica Power Center 9.6/9/5/9.1.1/8.6/8.1.1/7. x
  • Extensive experience in Insurance, Banking, Financial, Retail, Pharmacy and Healthcare domains.
  • Strong Knowledge of Data Warehouse Architecture and Designing Star Schema, Snow flake Schema, FACT and Dimensional Tables, Physical and Logical Data Modeling using Erwin.
  • Extensive experience in Extracting, Transforming and Loading of data using Informatica from different Source systems including flat files, RDBMS tables and Excel Sheet to Warehouse system.
  • 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 more.
  • Hands on experience in Trouble shooting and implementing Performance tuning at various levels such as Source, Target, Mapping and Sessions.
  • Experience creating and administering repositories, folders, mappings, sessions, workflows, mapplets and transformations using Repository Manger, Designer and Server Manager/Workflow Manager.
  • Good knowledge in Informatica Power Exchange.
  • Hands on experience in creating & configuring sessions, batches/workflows and worklets using the Server Manager/Workflow Manager of Informatica.
  • Worked on UNIX shell scripts in scheduling Informatica pre/post session operations.
  • Worked with PMCMD to interact with Informatica Server from command mode and execute the Shell scripts.
  • Proficiency in data warehousing techniques for Data cleansing, Slowly Changing Dimension phenomenon’s (SCD’s) and Surrogate key assignment.
  • Hands on experience through complete Software Development Life Cycle (SDLC) including Analysis, Design, Development, Testing and Implementation.
  • Expertise in Developing PL/SQL Packages, Stored Procedures/Functions, triggers and Indexes
  • Expertise in working with the Unix and Windows systems.
  • Scheduled jobs and automated the workload using the Autosys Job Scheduler.
  • Good working knowledge in Unit testing, Functional, System, Performance, User Acceptance Testing.
  • Excellent communication, presentation 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 Power Center 9.x/8.x/7.x, Power Exchange.

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables

Databases: Oracle 11g/10g/9i, SQL Server 2000/05/08, DB2, Teradata, SYBASE, MS Access 2000, TOAD.

Reporting Tool: Cognos 10.x/8.x

Tools: & Utilities: Control-m and Autosys

Programming: SQL, PL/SQL, Transact SQL, DTS, HTML, and XML.

Environment: Unix,Linux and Windows

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship