We provide IT Staff Augmentation Services!

Informatica Developer Resume

Branchburg, NJ

SUMMARY

  • Over 6+ years of work experience in IT industry in analysis, design, development, implementation and troubleshooting in the area of ETL tool Informatica
  • Extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
  • Well acquainted with Informatica Designer Components - Source Analyzer, Target Designer, Transformation Developer, Mapplet and Mapping Designer.
  • Extensive experience in developing complex mappings from varied transformations like Router, Filter, Sorter, Connected and Unconnected lookups, Expression, Aggregator, Joiner, Union, Update Strategy, TCL and Sequence Generator.
  • Expertise in design and implementation of Slowly Changing Dimensions (SCD) type1, type2, type3.
  • Strong Experience in developing Sessions/tasks, Worklets, Workflows using Workflow Manager Tools- Task Developer, Workflow & Worklet Designer.
  • Experience in creating and using Mapping Parameters, Mapping Variables, and Mapplets & Parameter files in Informatica Power Center.
  • Experience in all data processing phases, from the Enterprise Data Model, Logical and Physical Model, Dimensional Modeling, designing and modeling Star & Snow flake schemas, Data Warehousing (ETL).
  • Extensively worked on Data Extraction, Transformation and loading with RDBMS and Flat files.
  • Experience in performance tuning of targets, source, Transformations, mapping and sessions.
  • Prepared migration document to move the mappings from development to testing and then to production repositories.
  • Worked with various look up cache like Static Cache, Persistent Cache, Re Cache from database.
  • Strong knowledge in DW concepts like Dimensional modeling, Star schema/Snowflake modeling, Facts and Dimensions, Slowly changing dimensions, OLAP, Data Cleansing etc.
  • Strong SQL and working/troubleshooting experience in using PL/SQL Procedures/Functions.
  • Efficient in scheduling and monitoring Informatica jobs using Informatica scheduler, Crontab and ESP schedulers.
  • Ability to perform consistently under pressure and varied environment.
  • Excellent Verbal and Written Communication Skills. Have proven to be highly effective in interfacing across business and technical groups.
  • Worked in Agile and Waterfall Methodologies

TECHNICAL SKILLS

ETL Tools: Informatica Powercenter Version 9.x,8.x.10.x,(Repository Manager, Designer, Workflow Manager, and Workflow Monitor), SSIS

RDBMS: Oracle 12c,11g/10g/9i/8i, Teradata 13

Database Tools: TOAD, SQL Assistant, SQL Developer

Design Tools: Erwin 4.5/3.5.2 (Star Schema, Snow Flake Modeling).

Testing Tools: HP Quality Center 9.2, Clear Quest

O/S: Windows2008/2003 Server/NT/XP Prof/2000/98/95,UNIX,(Solaris 9), Linux

Languages: SQL, PL/SQL, XML

Others: MS Office-2003, MS Project, SVN,Putty,WinSCP

PROFESSIONAL EXPERIENCE

Confidential, Branchburg, NJ

Informatica Developer

Responsibilities:

  • Developed complex Informatica mappings, reusable transformations to implement the business logic and to load the data incrementally.
  • Developed Informatica mappings by usage of Aggregator, TCL, Lookup, Filter and data flow management into multiple targets using Router transformations.
  • Created SCD Type2 mapping for inserting and updating the data in a dimension tables.
  • Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data Warehouse.
  • Used Parameters for connections and variables for change data capture based on the date columns in the source tables.
  • Created the Low Level Design (LLD) document for the mappings developed.
  • Created Unit test cases and performed unit testing by writing SQL queries to ensure the mappings worked as desired
  • Created and scheduled Informatica jobs using D series Scheduler.
  • Supported SIT by troubleshooting the issues and resolving them.
  • Prepared the Migration document and implementation steps so that production support team could implement the migration correctly.
  • Interacted with the business users in getting clarifications on requirements.
  • Involved in performance tuning of Informatica and optimizing the performance by identifying and eliminating Target, Source, Mapping, and Session bottlenecks

Environment: Informatica 10.1.1, Oracle 12c, D Series scheduler.Putty,WinScp

Confidential, Reston, VA

Informatica Developer

Responsibilities:

  • Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data Warehouse.
  • Developed Informatica mappings by usage of Aggregator, Lookup, Filter and data flow management into multiple targets using Router transformations.
  • Used various transformations like SQ, Union, Filter, Expression, Joiner and Update strategy.
  • Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
  • Created and used mapping parameters and mapping Variables.
  • Did unit testing and wrote SQL queries to ensure loading of data.
  • Involved in performance tuning at source, target, mappings, sessions levels.
  • Extensively used expression, lookup, Update and router transformations.
  • Created error log tables in database and sending the error rows to error table so that they can be corrected and reloaded into a target system.
  • Configured session properties and target options for better performance.
  • Configured sessions to send an email to notify business and Production/Development teams when any Data errors/warnings occurs.
  • Migrated Informatica objects, ESP and BEE scripts from Development to higher environments.
  • Prepared migration document to move the code from development to testing and then to production repositories. Also, prepared Incident Resolution Documents to provide production support.
  • Experience in mentoring and providing knowledge transfer to team members and support teams.
  • Have good experience in solving production issues during nightly on-call support.

Environment: Informatica 9.6.1, Oracle 12c, Microsoft SQL Server 2008 or 2012, c AQT (Advances Query Tool), UNIX, ESP (IBM CICS Explorer), Harvest (workbench), CAWA Workstation, Undraleu.

Confidential

Informatica Developer

Responsibilities:

  • Involved in Dimensional modeling (Star Schema) of the Data Warehouse.
  • Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data Warehouse.
  • Developed number of complex Informatica mappings, reusable transformations to implement the business logic and to load the data incrementally.
  • Developed Informatica mappings by usage of Aggregator, Lookup, Filter and data flow management into multiple targets using Router transformations.
  • Created List files and Used Indirect method to load multiple source Files into one target.
  • Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
  • Migrated mappings, sessions, and workflows from Development to testing and then to production environments.
  • Created and used mapping parameters and mapping Variables.
  • Created SCD Type2 mapping for inserting and updating the data in a dimension table.
  • Involved in writing the shell scripting for accessing the flat files from the FTP location and archiving the files.
  • Session performance was improved with pipeline partitioning and increasing block size, data cache size, sequence buffer length and target based commit interval.
  • Involved in performance tuning at source, target, mappings, sessions levels.
  • Used Power Center Workflow Manager for session management, database connection management and scheduling of jobs to be run in the batch process using Informatica scheduler and Crontab.
  • Created error log tables in database and sending the error rows to error table so that they can be corrected and reloaded into a target system.
  • Configured session properties and target options for better performance.

Environment: Informatica Power Center 9.5.1, Oracle, Sql Server 2008,UNIX.

Confidential, Detroit, MI

Informatica Developer

Responsibilities:

  • Studied the existing environment and accumulating the requirements by querying the Clients on various aspects
  • Used Information power center 9.1 to Extract, Transform and Load data into Data Warehouse from various sources like Oracle and Flat files.
  • Designed and developed complex mappings by using Lookup, Expression, Update, Sequence generator, router, Filter etc., transformations to implement complex logics while coding a mapping.
  • Created connected Lookup transformations to look up the data from the source and target tables.
  • Created a mapping to update the slowly changing dimensions to keep full history to the target database e.
  • Used workflow monitor to monitor the jobs, reviewed session/workflow logs that were generated for each session to resolve issues, used Informatica debugger to identify issues in mapping execution.
  • Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the business requirements.
  • Extensively used ETL to load data from Flat files which involved both fixed width as well as Delimited files and also from the relational database, which was Oracle 9i.
  • Involved in the development of Informatica mappings and also performed tuning for better performance.
  • Experience in working with Teradata Utilities such aas BTEQ, Fast Load, Multi Load, T pump, etc.
  • Experience in performance tuning of targets, source, Transformations, mapping and sessions.
  • Monitored sessions that were scheduled, running, completed or failed.
  • Attended daily status call with internal team and weekly calls with client and updated the status report.

Environment : Informatica Power Center 8.6, Oracle, Oracle 10g, Putty, PL/SQL, SQL, SQL Developer, Win SCP, Tera data 13, UNIX.

Hire Now