EXPERIENCE SUMMARY:

• Over 7 years of ETL(Extract, Transform and Load) and data integration experience in developing ETL mappings and scripts using Informatica Power Center 9.X/8.x/7.x using Designer (Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Transformation Developer), Repository Manager, Workflow Manager & Workflow Monitor, ETL, OLAP, OLTP.
• Extensive experience with ETL tool Informatica in designing the Workflows, Worklets, Mappings, scheduling the Workflows and sessions using Informatica Power Center 8.6.0/9.1.
• Good experience in the field of Data Warehousing, OLAP(online analytical processing), OLTP(online transaction processing) using ETL Informatica tool.
• Experience in batch processing and experience in working in EDW environment.
• Vast experience in Designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.
• Well Experienced in doing Error Handling and Troubleshooting using various log files.
• Extensively worked on developing and debugging Informatica mappings, mapplets, sessions and workflows.
• Good knowledge on Hadoop.
• Experience in various phases of IT projects Software Development Life Cycle (SDLC) such as analysis, design, coding, testing, deployment and production support.
• Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Good knowledge of Oracle PL/SQL programming.
• Worked with performance tuning of Oracle using Oracle Partitioning and Indexes.
• Good exposure of Data Modeling Schema(Star Schema, Snow - Flake Schema, Facts and Dimensions).
• Understanding & working knowledge of Informatica CDC (Change Data Capture).
• Implementation experience of CDC using mapping variable and using Informatica power center SCD(Slowly Changing Dimension).
• Strong skills in data mapping for the Slowly Changing Dimensions - SCD1,SCD2(Flagging, date and Version), and SCD3.
• Hands on experience with IDQ(Informatica Data Quality) using Informatica Power Center.
• Experience in working with XML and Flat Files.
• Good Business knowledge in Healthcare Insurance, Pharmaceutical Business area.
• Experienced in working with tools like TOAD and SQL plus for development and customization.
• Developed UNIX Shell Scripts for triggering the Informatica workflows using PMCMD command.
• Experience in mentoring and providing knowledge transfer to team members, support teams and customers.
• Possess strong communication and problem solving skills developed through a variety of projects.

TECHNICAL SKILLS

ETL & Reporting Tools: Informatica Power Center 8.x,9.x, IDQ, Business Objects 6.5/XI.

Database: Oracle 9i/10g/11g, SQL Server 2008.

Operating System: Linux and Windows NT.

Languages: SQL, PL/SQL, C++, JAVA, C, UNIX Shell Scripting.

Tools/Utilities: SQL*Loader, TOAD, SQL Plus, WIN-SCP, SCP.

Version Control Tools: SVN, PVCS

Tracking Tools: Jira, Heat.

Scheduling Tools: Crontab, Auto Sys.

PROFESSIONAL EXPERIENCE:

ETL Informatica Developer

Confidential

Responsibilities:

• Responsible for developing, support and maintenance for theETL(Extract, Transform and Load) processesusingInformatica power center.
• Extract data from flat files, Oracle and SQL Server 2008, and to load the data into the target database.
• Strong working experience on Data Warehousing applications, directly responsible for the Extraction, Transformation and Loading of data from multiple sources into Data Warehouse.
• Developed, implemented and maintained Informatica PowerCenter and IDQ application for matching and merging process
• Prepared various mappings to load the data into different stages like Prestage, Stage and Target tables.
• Involved in Designed and developed shell scripts to load data from Oracle into Hadoop.
• Scheduled daily and weekly informatica load using Unix Shell scripts and Crontab.
• Worked extensively on Informatica Partitioning when dealing with huge volumes of data and also partitioned the tables in Oracle for optimal performance.
• Prepared SQL Queries to validate the data in both source and target databases.
• UsedInformaticato load data fromfixed widthanddelimited Flat files.
• Worked withInformatica Powercenter Designer,Workflow ManagerandWorkflow Monitor, also imported Source Definitions usingSource Analyzer and Target Definitions using Target Designer.
• Created Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Extensively used Informatica for loading the historical data from various sources.
• Identified the errors by analyzing the session logs.
• Extensively used SCD’s (Slowly Changing Dimension) to handle the Incremental Loading for Dimension tables, Fact tables
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed Debugged the mapping of the failed session to check the progress of data load.
• Involved in Unit testing of ETL Code (Mappings and Workflows).
• Involved in identifying the performance Bottlenecks on source, target, mapping, session and successfully tuned them to increase session performance.
• Used IDQ(Informatica Data Quality) for data quality measurement and data cleansing.
• Strong skills in data mapping for the Slowly Changing Dimensions - SCD1,SCD2(Flagging, Date and Version), and SCD3
• Utilized Informatica Data Quality(IDQ) to complete initial data profiling and matching/removing duplicate data
• Identified and resolved performance bottlenecks using session logs during initial load
• Troubleshoot the mapping from Session logs and used the debugger.
• Worked with mapping parameters and variables to load data from different sources to database table.
• Developed Low and High Level Process Design document for each mapping.

Environment: Windows NT, Oracle 10g, UNIX, Informatica 8.6/9.1, IDQ, SVN, PVCS, SQL *PLUS.

Confidential

ETL Informaticadeveloper

Responsibilities:

• Developed mappings/Reusable Objects/Transformation/mapplets by using mapping designer, transformation developer and Mapplet designer in Informatica PowerCenter 8.6.0/ 9.1.
• Create reusable transformations and mapplets and used them in mappings.
• Implemented Slowly Changing Dimension to populate and maintain current information and history information in dimension tables.
• Used Informatica Power Center Workflow Manager to create sessions, batches to run with the logic embedded in the mappings.
• Worked with mappings using expressions, aggregators, filters, lookup, xml, update strategy and stored procedures transformations.
• Created flexible mappings/sessions using parameters, variables and heavily using parameter files.
• Created Tasks, Workflows, Sessions to move the data at specific intervals on demand using Workflow Manager and Workflow Monitor.
• Involved in Attribute mapping/ Data mapping, and natural key profiling (data profiling).
• Involved in monitoring Informatica jobs/processes using Workflow Monitor.
• Partitioned sources to improve session performance.
• Involved in cleansing and extraction of data and defined quality process for the warehouse.
• Prepared scripts to email the records that do not satisfy the business rules (Error Records) to the uploaded business users.
• Developed mappings for the Slowly Changing Dimensions for type 1, type 2, type 3 using flag.
• Created Test cases for the mappings developed and then created integration Testing Document.
• Stored reformatted data from relational, flat file, XML files using Informatica (ETL).
• Prepared the error handling document to maintain the Error handling process.
• Data integrity between the various source tables and relationships.
• Completed various data load simulations to test the mappings.
• Improved session run times by partitioning the sessions. Was also involved in the database tuning (creating indexes), partitioning Oracle databases.
• Involved in Unit testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Wrote UNIX shell scripts for Informatica ETL tool to run the Sessions.
• Extensively worked on tuning of Informatica map for better performance.
• Developed UNIX Shell scripts to automate repetitive database processes and maintained shell scripts for data conversion.

Environment: Informatica Power Center 8.6.0, Oracle 10g, SQL*Plus, Unix, PVCS, SVN, Windows NT,WIN-SCP. Sierra Atlantic Software Services May 2007 to Dec 2010

ETL Developer

Confidential

Responsibilities:

• Designed and developed business rules to generate consolidated (fact/summary) data identified by dimensions usingInformaticaETL(Power Center) tool.
• Maintained stored definitions, transformation rules and targets definitions usingInformaticaRepository Manager.
• Created and scheduled sessions and Batch process based on demand, run on time, run only once usingInformaticaserver manager.
• Involved in the performance tuning of mappings and sessions.
• Scheduled and monitored transformation processes using Informatica Server Manager.
• Wrote Queries, Procedures and Functions that are used as part of different application modules.
• Implemented the best practices for the creation of mappings, sessions and workflows and performance optimization.
• Created mappings using transformations like Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator.
• Designed and developed the logic for handling Slowly Changing Dimension tables load by date the record using update strategy for populating the desired.
• Involved in cleansing and extraction of data and defined quality process for the warehouse.
• Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volume of data.
• Involved in migration of mappings and sessions from development repository to production repository.
• Involved in Unit testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Involved in Production support working with various mitigation tickets created while the users working to retrieve the database.
• Created Stored Procedures to transform the Data and worked in PL/SQL for various needs of the transformations while loading the data.
• Experience in loading different sources(Flat file, Excel file) to database tables using SQL Loader.