SUMMARY

• 8 years of Experience as ETL Developer in designing and implementing Data Mart / Data Warehouse and Business applications in Insurance, Banking, Industrial &Retail sectors using INFORMATICA PowerCenter.
• Involved in all phases of Software Development Life Cycle including Requirement Analysis, Documentation, Design, Development, Testing and Deployment.
• Designed and developed ETL Architecture to load data from/to various sources/targetslike DB2, Oracle, Flat files, and XML files, Teradataand MS SQL Server.
• Experience in analyzingDimensional Data Modeling using Star Schema, Snowflake Schema, Fact&Dimensions tables, Physical&Logical Data Modeling using Erwin.
• Worked on AgileMethodology, participated in daily/weekly team meetings, guided developers in Informatica Power Center, peer reviewed their development works and provided the technical solutions.
• Proficiency in Data Warehousing techniques for Data Cleansing, Slowing Changing Dimension (type 1, 2 & 3) phenomenon and Surrogate Key assignment.
• Extensively used Oracle SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers.
• Worked with Teradata loaders within Workflow manager to configure FLoad, TPUMP and MLoad sessions.
• Proficient in creating UNIX Shell Scripts for daily batch jobs, validating files, creating parameter files, processing tasks, scheduling pre session and post sessions.
• Designed and developed Complex mappingsusing various transformations.
• Well experienced inPerformance Tuning of Informatica (sources, mappings, sessions and targets) and Databases, Multi - Threading and parallel processing.
• Made performance improvements to the database by building Partitioned tables, Index Organized Tables and Bitmap Indexes.
• Experience in Unit testing, Functional, Performanceand User Acceptance Testing.
• Knowledge in OLAP Tools - Business Objects, Cognos and Micro strategy used for developing Reports.
• Ability to meet deadlines and handle pressures coordinating multiple tasks in project environment, excellent communication, interpersonal, analytical skills.

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Sr. Informatica Developer/ ETL

Responsibilities:

• Coordinated with business analysts for requirement gathering, understanding the requirements and explanation of technical probabilities and possibilities with business users.
• Created Time Estimate Proposal document with estimation of hours required for completion of each ETL task.
• Extensively used Power Exchange to create data maps, registration to connect to Mainframe.
• Extracted data from Flat files and loaded into Oracle Staging and target tables applying business rules as per the requirement by using Informatica Power Center.
• Worked on Informatica Power Center 9.5 - Source Analyzer, Target Designer, Mapping Designer & Mapplet, Transformations, Work Flow Manager (Task Developer, Worklets, and Work Flow Designer) and Work Flow Monitor.
• Worked on various types of transformations like Lookup, Update Strategy, Joiner, Filter, Aggregator, Expression, Rank, Router, Normalizer, Sorter, Sequence Generator, and Source qualifier.
• Developed mapping parameters and variables to support SQL override.
• Created reusable transformations and Mapplets and used them in complex mappings.
• Used type1 SCD and Type 2 SCD mappings to update Slowly Changing Dimension Tables.
• Used the Informatica Workflow Manager to embed sessions with pre- and post-session shell scripts.
• Worked on different tasks in workflows like Event raise, Event wait, Decision, E-mail, Command, Assignment, Timer and Scheduling the workflow.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Wrote Scripts for bulk load process MLOAD, FLOAD and MPUMP.
• Designed and developed UNIX shell scripts to create job to run the workflows by scheduler.
• Troubleshoot problems by checking Sessions and Error logs.
• Worked on SQL tools like TOAD to run SQL queries to validate the data.
• Extensively Involved in performance tuning of the ETL process by determining the bottlenecks at various points like target, source, mapping, session or system.
• Developed Test Automation suite and test cases for unit testing and system testing using cucumber and ruby.
• Participated in Review of Test Plan, Test Cases and Test Scripts prepared by system integration testing team.
• Created various Documents such as Source-To-Target Data mapping Document, Unit Test Cases and Data Migration Document.
• Actively involved in building the system test environment and migrated mappings from Development to System Test environment and executed code in QA environment.

Environment: Informatica Power Center 9.5, Power Exchange 9.1,Mainframe, Oracle 12c/11g, SQL, PL/SQL, ESP, Shell Scripts, Teradata, HP Quality Center.

Confidential, Columbus, OH

Informatica/ ETL

Responsibilities:

• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Re-engineered on existing Mappings to support new/changing business requirements.
• Used Mapping, Sessions Variables/Parameters, and Parameter Files to support change data capture and automate workflow execution process to provide 24x7 available data processing.
• Extensively worked on Expression variables, Source Qualifier Sql Override, Union, Filter, Sequence Generator, Sorter, Joinerand Update Strategy Transformations.
• Developed Informatica Mappings to populate the data into dimension and Fact tables for data classifications to end developers.
• Extensively worked with various lookup caches like Static Cache, Dynamic Cache, and Persistent Cache.
• Created synonyms for copies of time dimensions, used the sequence generator transformation type to create sequences for generalized dimension keys, stored procedure transformation for encoding and decoding functions and Lookup transformation to identify slowly changing dimensions (SCD).
• Modified several of the existing mappings based on the user requirements and documented it.
• Involved in writing UNIX Shell scripts (Pre/Post Sessions commands) for the Sessions & used PMCMD command to kickoff the workflows.
• Created various tasks like Command, Timer and Event wait.
• Prepared SQL Queries to validate the data in both source and target databases.
• Error Handling is done by validating records and bifurcating the data into valid/invalid records and loading the erroneous records into the error table.
• Created Test cases for the mappings developed and then created Integration Testing Document, Error handling document to maintain the error handling process.
• Validated the Mappings, Sessions & Workflows, Generated & Loaded the Data into the target database.
• Monitored batches and sessions for weekly and Monthly extracts from various data sources to the target database.

Environment: Informatica Power Center 9.1, Oracle 10g, PL/SQL, SQL Loader, Shell Scripts.

Confidential, Bentonville, AR

Informatica Developer

Responsibilities:

• Logical and Physical data modeling was done using Erwin for data warehouse database in STAR SCHEMA.
• Designed and developed many simple as well as Complex Mappings using various transformations like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy.
• Designed the ETL processes using Informatica tool to load data from File system and Oracle into the target Database.
• Involved in identifying the sources for various dimensions and facts for different Datamart according to star schema design pattern.
• Have used BTEQ, FLOAD, MLOAD Teradata utilities to export and load data to/from Flat files.
• Developed multiple Workflows using workflow manager for initial loading, historical data loading using sessions, commands, decisions, events and timers.
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter.
• Used Informatica user defined functions to reduce the code dependency.
• Used debugger to track the path of the source data and also to check the errors in the mapping.
• Worked on test cases and test plans.
• Performing ETL & database code migrations across environments.
• Documented the process for further maintenance and production support.
• Provided production support by running the jobs and fixing the bugs.

Environment: Informatica Power Center 8.1, Power Exchange 8.1, Teradata, Shell scripting, Oracle 10g, PL/SQL, flat files, WinSCP.

Confidential, Birmingham, AL

Informatica Developer

Responsibilities:

• Coordinated with the client and gathered user requirements.
• Responsible for development of robust and reliable solutions requiring low maintenance, thorough testing of solutions.
• Created Tables, Keys (Unique and Primary) and Indexes in the SQL server.
• Created various Transformations in Informatica PowerCenter like Source Qualifier, Lookup, Stored Procedure, Sequence Generator, Router, Filter, Aggregator, Joiner, Expression and Update Strategy.
• Extensively worked with aggregate functions like Avg, Min, Max, First, Last and Count in Aggregator Transformation.
• Extensively used SQL Override, Sorter and Filter in the Source Qualifier Transformation.
• Extensively used Normal Join, Full Outer Join, Detail Outer Join and Master Outer Join in the joiner Transformation.
• Created Connected and Unconnected Lookup Transformation for better performance.
• Worked on Caching optimization techniques in Aggregator, Lookup and Joiner Transformation.
• Worked on test cases and test plans.
• Aided in migrating the code migrations across environments.
• Developed Complex Reports (Used multiple data providers, Union, Intersection and Master/Detail, cross tab, Charts).
• Extensively used Calculations, Variables, and Sorted inputs, Drill down, Slice and Dice, Alerts for creating Business Objects reports.
• Used Broadcast Agent Publisher for Report Bursting, so that each individual receives particular information in Excel format and Created Web I reportsand deployed them through Info View.

Environment: Informatica Power Center 8.1, Oracle 9i, SQL Server, Shell Scripts, Flat Files.

Confidential

ETL Developer

Responsibilities:

• Developed Mappings as per the Design Document with proper naming conventions for Transformations and Mapping Variables.
• Created and Monitored Batches and Sessions.
• Used debugger to test the data flow and fix the mappings.
• Worked on Informatica utilities like pmcmd to start, stop and get status of workflows.
• Created complex SQL queries for the purpose of data analysis.
• Migrated ETL objects to QA, Test and Production Environments.

Environment: Informatica Power Center 7.1, Oracle 8i, Flat files, Shell Scripts, PL/SQL.