SUMMARY

• Over seven years of Strong experience in Data Warehousing and ETL using Informatica Power Center with Strong skills in Data Analysis, Requirements Analysis and Data Mapping for ETL processes. Hands on experience in all aspects of Software Development Life Cycle (SDLC).
• Expertise in Informatica PowerCenter 9.5/9.1/8.6/8.5/8.1 Designer tools like Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Repository Manager, Workflow Manager and Workflow Monitor.
• Extensive Experience in Extraction, Transformation and Loading of data using Informatica Power Center from heterogeneous sources like Flat files, IBM DB2, Oracle, Sybase and SQL Server.
• Experience in Data Modeling, Dimensional Data modeling concepts Star/Snowflake Schema modeling fact and dimensional tables, Physical and logical data modeling.
• Expertise in implementing complex Business rules by creating robust mappings, Mapplets, reusable transformations using transformations like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator and Update Strategy etc. .
• Expert in implementing Type 1 and Type 2 Slowly Changing Dimensions as per the requirements.
• Hands on experience in identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Strong in database programming using PL/SQL and SQL with creation of packages, stored procedures, functions, triggers, materialized views, cursors and performance tuning of SQL.
• Knowledge of Data warehouse concepts and principles (Kimball/Inman) and created Star Schema, Snowflake schema, Normalization/Denormalization Fact and Dimensional Tables using Erwin.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results.
• Good experience in working with onsite - offshore team model projects.
• Strong in scheduling ETL load using utilities like Control M, Tivoli, Austosys.
• Good experience in performing and supporting Unit testing, System Integration testing(SIT), UAT And production support for issues raised by application users.
• Excellent Analytical, Communication skills, working in a team and ability to communicate effectively at all levels of the development process.

TECHNICAL SKILLS

RDBMS: Oracle 12c/11g/10g/9i, SQL Server2005/2008, Teradata V2R5,IBM DB2.

ETL Tools: Informatica PowerCenter 9.6/9.5/9.1/8.1/8.5/8.6/7. x/ Power Exchange / Power Connect.

BI Tools: Business Objects XI R2/R1/6.x, Cognos.

Operating System: UNIX,IBM AIX 4.3/4.2, Windows7/NT/2000/XP

Job Scheduling Tools: Control-M7.0,TIDAL Scheduler, Autosys 4.5

Defect Management tools: HP Quality Center 9x, Test Director 7x, Remedy 7x

Languages: SQL, PL/SQL, TSQL, Unix Shell Scripting, XML, C, C++, C#, Cobol, JavaScript, NZSQL

Modeling Tools: ER Studio, Erwin 4.1,UML

Database frontend tools: Oracle SQL Developer, IBM Data Studio 3.1.1, Quest Toad for Oracle, DB Artisan.

PROFESSIONAL EXPERIENCE

Confidential, Baltimore, MD

Sr ETL Developer

Responsibilities:

• Interacted with business users and business analyst to understand requirements, analyzed business requirements and functional specifications.
• Prepared technical specifications/mapping documents for the development of Informatica (ETL) mappings to load data into various target tables.
• Used Informatica 9.6/9.5 client tools - Source Analyzer, target designer, Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor designer tools for process the data from source systems to data warehouse.
• Working on multiple projects using Informatica as ETL tool to extract data from IBM DB2, Oracle12c and flat file systems performed massive data cleansing applied all the business rules and loaded into Target system.
• Developed complex Informatica mappings, Mapplets using connected and unconnected Lookups, Rank, Sorter, Joiner, Aggregator, Filter, Router, Sequence generator and Stored Procedure transformations to transform the data as per the client requirements.
• Implemented Slowly Change Dimension Type I & II to capture history and created process flow mapping for insert/update using effective end date while loading data into the data marts.
• Prepared various mappings to load the data into different stages like staging1, Staging2 and Target tables.
• Extensively used Mapping parameters, mapping variables to make mappings more flexible and minimizing hard coding in ETL logic.
• Developed the complex SQL queries, unions, multiple table joins, sub queries and Views as per the requirement.
• Created sessions, Workflows and used various tasks like command, Timer and Assignment tasks.
• Worked on performance tuning of the ETL processes. Optimized/tuned queries in source qualifier, Lookup transformations in mappings for better performance and efficiency.
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Created and modified UNIX shell scripts for invoke, abort the workflows and sessions through PMCMD.
• Worked with the Informatica Administration team to ensure successful promotion of objects in various environments.
• Performed unit testing for the Informatica mappings and UNIX scripts developed, Created and executed unit test plans based on system and validation requirements and Assisted Testing team in creating test plan and test cases.
• Involved in production support activities, providing support, addressing and Resolving Client Issues.
• Followed Informatica recommendations, methodologies and best practices.

Environment: Informatica Power Center 9.6/9.5, Oracle12c, IBM DB2, IBM DtataStudio,Toad, SQL Developer, Teradata SQL Assistance, SQL, Erwin, MS Visio, PL/SQL (Stored Procedures, Triggers, Packages), UNIX shell Scripting, UNIX/ZLinux, Windows 7

Confidential, Chicago, IL

Sr.Informatica Developer

Responsibilities:

• Involved closely with the team and working with the Business analysts for gathering functional requirements and creating functional design documents.
• Exclusively Worked on Informatica8.6/9.1 - Source Analyzer, Mapping Designer & Mapplet Designer, Workflow Manager, Workflow Monitor and Transformations.
• Extracted data from flat files, SQL Server, Oracle10g using Informatica Power Center and performed massive data cleansing applying all the business rules prior to loading them into Oracle staging and final target tables.
• Involved in developing complex Informatica mappings using different types of transformations like union transformation, Connected and Unconnected Lookup transformations, Router, Filter, Aggregator, Normalizer, Expression and Update strategy transformations for large volumes of Data.
• Experienced in logical and physical data modeling of staging and warehouse environments using Data modeling tool Erwin and Oracle Designer.
• Applied slowly changing dimensions like Type 1 and 2 effectively to handle the delta Loads.
• Created Workflows and sessions using Informatica workflow manager and monitor the workflow run and statistic properties on Informatica Workflow Monitor.
• Involved in Performance tuning for sources, targets, mappings and SQL queries in the transformations to increase the performance.
• Created Mapping parameters and variables and Session parameters according to the requirements and performance related issues.
• Used SQL tools like SQL Developer, TOAD to run SQL queries to validate the data.
• Involved in working with DBA’s and Data Modellers for project coordination. Involved in creating Detail design for each interface.
• Designed and developed UNIX shell scripts and PMCMD commands as part of the ETL process, automate the process of loading and pulling the data.
• Used Control-M as the scheduling tool for scheduling Batch jobs.
• Developed Test Cases for Unit Testing, also involved in user acceptance, system, and performance testing levels.

Environment: Informatica Power Center 8.6/9, Oracle11g, DB2, SQL Server 2008,XML, Toad, Sybase,SQL Developer, Control - M,PL/SQL (Stored Procedures, Triggers, Packages), Erwin, MS Visio, UNIX shell Scripting, Windows XP

Confidential, Virginia Beach, VA

ETL Analyst/ Developer

Responsibilities:

• Extensive use of B2B Data Transformation for handling vendor data, where it is in EDI, Unstructured data and Complex structured data (XML Schemas).
• Have good experience in dealing with HIPAA 5010 files.
• Involved in analysis, requirement gathering, and documenting functional and technical specifications.
• Involved in the preparation of the mapping document for 5010 by identifying the minor changes from 4010.
• Involved in the installation of B2B plug-ins in the machine.
• Designed the mappings to load data from HIPAA and 271 files into Database.
• Created the mappings to generate HIPAA and 270 files from the data in the data bases.
• Upgraded Informatica power center 8.1 to version 8.6 on servers.
• Hands-On experience in developing Transformations like Joiner, Aggregate, Expression, Lookup (connected and un connected), Filter, Union, Stored Procedures, Router, XML generator and parser, unstructured Data Transformation etc. using best practices.
• Configure the session so that power center server sends the e-mail when the session fails.
• Extensive use of flat files as sources and targets depending on the inbound and outbound processes.
• Deal with data files with lot of data (almost up to 6 million members in one file).
• Involved in the performance tuning of the maps to reduce the runtime for the big files.
• Extensively worked in the performance tuning of the programs, PL/SQL Procedures and processes.
• Involved in the preparation of test cases for the mappings.
• Involved in unit, mechanical and regression testing.
• Created stored procedures to do insert into tables.
• Designed and created Oracle Database objects, tables, Indices, Views, Procedures, Packages, and Functions.
• Cleansing data using Trillium, RTRIM and LTRIM.
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• Run the mappings using Tidal 3rd party tool and implemented the concurrent running of the workflow for different files at the same time.
• Fixed the minor issues in the parser and serializers (built in java codes).
• Build XML parser and serializer transformations with the xsd files.
• Involved in the resolution of the issues in the built in java codes along with the informatica people through GoToMeeting.
• Passed the parameters to work flow from the tool Tidal directly to run the map.

Environment: Informatica Power Center 9.1, Data Transformation Studio, Oracle 10g, SQL Server 2005, Tidal, SQL, T-SQL, PL/SQL.

Confidential, IL

ETL Informatica Developer

Responsibilities:

• Involved in study of existing operational systems, data modeling, analysis and translated business requirements into data mart design.
• Define the entity-relations - ER Diagrams and designed the physical databases for OLTP and OLAP (data warehouse).
• Identified all the dimensions to be included in the target warehouse design and confirmed the granularity of the facts in the fact tables.
• Developed mappings to extract data from SQL Server, Oracle, Flat files, DB2, Mainframes and load into Data warehouse using the PowerCenter, power exchange.
• Designed and developed complex ETL mappings making use of transformations like Source
• Qualifier, Expression, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Router, Filter, Aggregator and Sequence Generator transformations.
• Created reusable transformations and mapplets based on the business rules to ease the development.
• Developed mappings to implement type 2 slowly changing dimensions.
• Designed and developed UNIX shell scripts to schedule jobs. Also wrote pre-session and post-session shell scripts
• Used various Informatica Error handling technique to debug failed session.
• Wrote UNIX shell scripts to automate the process of renaming the Flat files with a timestamp extension, Compressing, Archiving, the Workflows, File Manipulations and automatic email notifications to the data owners (Success / Failure) and FTP to the desired locations.
• Collaborated with Informatica Admin in process of Informatica Upgradation from PowerCenter 7.1 to PowerCenter 8.1.
• Developed workflow tasks like reusable Email, Event wait, Timer, Command, Decision Used various debugging techniques to debug the mappings.
• Creating Test cases for Unit Test, System Integration Test and UAT to check the data quality.

Environment: PowerCenter8.1, Oracle9i, SQL Server 2000, SQL,PL/SQL, shell scripts, Mainframe DB2, MS Visio, ERWIN Data Modeling tool, Toad 8.0, Windows 2000,UNIX