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.