We provide IT Staff Augmentation Services!

Informatica Developer Resume

SUMMARY

  • 6 years of experience in IT industry and 5years with expertise in Analysis, Design, Development, Implementation, testing and Support for Data Warehouse project.
  • ETL/Informatica developer with extensive strong work experience with large scale Data warehouse implementation using informatica 10.1/10.2/9.6 , Oracle, SQLserver, Teradata on Unix platforms.
  • Have extensive strong work experience with large scale Data Warehouse projects with different Domain like Insurance, Health care and Financial domain.
  • Strong working experience of SDLC process and experience of working in Agile Methodology
  • Excellent communication, analytical and interpersonal skills.
  • Quick learner, adaptive to new and challenging technological environments

TECHNICAL SKILLS

Operating Systems: Windows 2008/2007/2005 , UNIX, MS - DOS

ETL Tools: Informatica Power Center 10.2/10.1/9.6 (Designer, Workflow Manager, Workflow Monitor, Repository manager and Informatica Server),, Microsoft word,Excel,Access

Databases: Oracle 11g/ MS SQL Server 2008/2005, DB2/ Teradata/Hadoop

Data Management Tool: Jira, Confluence,Remedy

Languages: SQL, UNIX, Shell Scripts

Scheduling Tools: Tivoli, ESP

PROFESSIONAL EXPERIENCE

Confidential

Informatica Developer

Responsibilities:

  • Developed and tested he ETL Process using Informatica 10.1 to load data from Flat Files, Oracle to Hadoop, Hadoop to Unix server, source to stage area then apply ETL logic to load the data in Teradata Data Ware house.
  • Created ETL mapping by using various transformations according to the business logic like Source Qualifier, Normalizer, Lookup, Stored Procedure, Sequence Generator, Router, Filter, Aggregator, Joiner, Expression and Update Strategy.
  • Worked on different tasks in Workflow Manager like Sessions, Events raise, Event wait, Decision, E-mail, Command, Worklets, Assignment, Timer and Scheduling of the workflow
  • Create Teradata table for stage and target table
  • Have experience of working on Fast load and Multi load and TPUMP.
  • Create CR to deployed the code and worked on Jira tool to assign the work to DB and ETL Admin Team.
  • Worked on Existing code to improve the Performance of the code in production.
  • Worked on ESP scheduler to schedule the jobs.
  • Have created PI, USI, NUSI, PPI, JI on the tables.

Confidential

Informatica Developer

Responsibilities:

  • Developed and tested the ETL Process using Informatica 10.1 to load data from Flat Files, Oracle to stage area then apply ETL logic to load the data in Data mart and Oracle Data Warehouse database.
  • Created ETL mapping by using various transformations according to the business logic like Source Qualifier, Normalizer, Lookup, Stored Procedure, Sequence Generator, Router, Filter, Aggregator, Joiner, Expression and Update Strategy.
  • Created Design Document, Informatica mappings Document and Unit Testing Document and does Code Review.
  • Created Informatica workflow using various Tasks like Event wait, Event Raise, Command, E-mail, Worklet and Assignment task.
  • Create SCD type 1 and type 2 mapping according to the requirement.
  • Involved in the performance improvement project.
  • Involved in designing of testing plan (Unit Testing and system testing).
  • Tested scripts by running workflows and assisted in debugging the failed sessions.
  • Improving workflow performance by shifting filters as close as possible to the source and selecting tables with fewer rows as the master during joins.
  • Used persistent caches whenever data from workflows were to be retained.
  • Used connected and unconnected lookups whenever appropriate, along with the use of appropriate caches.
  • Created tasks and workflows in the Workflow Manager and monitored the sessions in the Workflow Monitor.
  • Unix shell scripting experience with loading the date, update the data, manipulating the files.
  • Tuning the ETL mapping by Oracle SQL query tuning and in Informatica Power center to identify bottle necks, tune and remove bottlenecks.
  • Modify, Execute and Test the shell script to do file validation, to back fill the data and to the change the file format.
  • Implemented performance tuning logic on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance.
  • Co-ordinate and worked with Data modeler, Database team, ETL admin team and Testing team.
  • Worked on Tivoli scheduler to schedule the jobs.
  • Create DDL statement, Index, Synonym, Grant

Confidential

Junior Informatica Developer

Responsibilities:

  • Worked with Informatica Power Center 9.6 (Designer, Repository manager, Work flow manager, workflow monitor)
  • Well acquainted with Informatica Designer Tools like Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer.
  • Extracted data from Flat files, DB2, SQL and Oracle to build ETL mapping by Applied business logic to load the data into Data Warehouse.
  • Used various transformations like Filter, Router, Expression, Lookup (connected and unconnected), Aggregator, Sequence Generator, Update Strategy, Joiner, Normalizer, Sorter and Union to develop mappings in the Informatica Designer.
  • Worked on Source Qualifier queries, Pre and Post SQL queries in the Target.
  • Worked on different tasks in Workflow Manager like Sessions, Events raise, Event wait, Decision, E-mail, Command, Worklets, Assignment, Timer and Scheduling of the workflow.
  • Extensively used workflow variables, mapping parameters and mapping variables.
  • Created sessions, batches for incremental load into staging tables and scheduled them to run daily.
  • Create objects in Share Folder to reuse the objects without creating multiple objects in the repository and inherit changes made to the source automatically.

Hire Now