SUMMARY:

• 13+ years of professional IT experience in database development and data warehousing.
• Expertise in ETL Informatica PowerCenter in all phases of Analysis, Design, Development, Implementation and support of Data Warehousing applications using Informatica10.x/ 9.x/8.x/7.x (Designer, Repository Manager, Workflow Manager and Work Flow Monitor).
• Experienced in integration of various data sources like Oracle 11g,10g/9i/8i,Teradata V15, MS SQL Server 2005/2000, XML files, DB2, Flat files, XML, SQL, PL/SQL, Erwin 4.0/3.5, SQL Developer, TOAD, Stored procedures, heterogeneous sources into staging area and different target databases
• Experienced populating data onto AMAZON S3 and REDSHIFT.
• Knowledge about Informatica Data Quality, Informatica MDM and Informatica Power exchange
• Extensive experience in Data Warehousing with OLTP and OLAP.
• Experienced in developing logical and physical models and implementing them in Oracle.
• Experienced in creating entity relational and dimensional relational data models with Kimball Methodology (Star schema and Snowflake schema architectures, Fact/dimension tables).
• Experienced in creating the Workflows, Worklets, Mappings, Mapplets, Reusable transformations and scheduling the Workflows and sessions using Informatica PowerCenter.
• Strong data modeling experience using Star/Snowflake schemas, Re - engineering, Dimensional Data modeling, Fact and Dimension tables, Physical and logical data modeling.
• Experienced in Informatica mapping specification documentation, tuning mappings to increase performance, proficient in creating and scheduling workflows and expertise in Automation of ETL processes with scheduling tools such as AutoSys and Control-M.
• Experienced in the development, modification and testing of Unix Shell scripts.
• Experienced in Performance Tuning, identifying and resolving performance bottlenecks at various levels Performance tuning at Mapping, Session and database level.
• Advanced knowledge of Oracle PL/SQL programming, stored procedures and functions, cursors and tuning the SQL query.
• Experienced in the Development, Implementation of Database/Data Warehousing /Client/Server /Legacy applications and implementation of various Mainframe and Informatica applications for using Data Extraction, Data Transformation, Data Loading and Data Analysis.
• Performed Testing at various levels including Unit Testing, UAT.
• Experienced in Automotive, healthcare, petroleum, networking and entertainment industry.
• Outstanding communication and interpersonal skills, ability to learn quickly grasp new concepts, both technical and business related and utilize as needed. Active participation in Knowledge Transfer and Documentation.

TECHNICAL SKILLS:

ETL Informatica: Informatica PowerCenter 10.2,10.1.1,9.6.1/8.x/7.x, Repository Admin Console, Repository Manager, Designer, Workflow Manager, Workflow Monitor, Talend6.5

Data Modeling Tools: Dimensional Data Modeling, Data Modeling, Star Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling

Databases: Oracle 10g/11g/9i, MS SQL 200x, MS SQL Server 2012/2008/2005/7.0, DB2, Teradata V13

Languages: SQL, PL/SQL, Unix, XML Files, Flat files, Stored Procedure, C, C++

Operating Systems: Windows 7/95/98/XP, Unix, Linux

Application Tools: MS Office (Word, Excel, PowerPoint), HTML,PUTTY, JIRA, WINSCP

Scheduling Tools: AutoSys, Control-M

PROFESSIONAL EXPERIENCE:

Confidential, Alpharetta, GA

Sr. ETL Informatica Developer

Responsibilities:

• Interacted with Business user to understand the requirements.
• Created technical specification documents based on the requirements.
• Prepared ETL standards, Naming conventions and wrote mapping documentation.
• Analyzed Designed, Tested, Implemented and supported ETL processes for Stage, DW and DM.
• Worked on data extraction, Transformation and loading data from various sources like Oracle, DB2 and Flat files.
• Created mappings to load the data using different transformations like Look up (connected and unconnected), Normalizer, Expression, Java Transformation, Aggregator, Update Strategy, Union, Sequence Generator, Joiner, Filter, Update Strategy, Rank and Router transformations.
• Used Change Data Capture (CDC) to simplify ETL in data warehouse applications.
• Implemented slowly changing dimensions (SCD) Type 1 and Type 2.
• Improved session Performance by enabling property incremental aggregation to load incremental data into target table
• Migrated the code from Dev to QA and then from QA to Prod.
• Migrated the mapping from IDQ to Informatica Power center by doing export and import as XML file.
• Populate data onto Amazon S3 and Redshift tables.
• Used PMCMD command to automate the Power Center sessions and workflows through UNIX.
• Supported the jobs in production environment.
• Modified existing mappings for enhancements of new business requirements.
• Involved in the Upgrade of Informatica 10.1. to 10.2

Environment: Informatica Power Center 10.2, 10.1.1,9.6.1,Microsoft SQL server Studio, Oracle,DB2,IDQ, Winscp,AWS, AMAZON S3, REDSHIFT

Confidential, Atlanta, GA

Sr. Informatica Developer

Responsibilities:

• Designed and developed ETL process using Informatica tool.
• Worked with various Active transformations in Informatica Power Center like Filter Transformation, Aggregator Transformation, Joiner Transformation, Rank Transformation, Router Transformation, Sorter Transformation, Source Qualifier, and Update Strategy Transformation.
• Worked with various Passive transformations in Informatica Power Center like Expression Transformation, Sequence Generator, and Lookup Transformation
• Worked with Task Developer, Worklets Designer, and Workflow Designer in the Workflow Manager. Responsible for extracting data from Oracle and Flat files. Responsible for Performance Tuning in Informatica Power Center.
• Worked with both Connected and Un-Connected Lookups.
• Made use of sorted input option for the performance tuning of aggregator transformation.
• Used SQL Override function in Source Qualifier Transformation.
• Used Normal Join, Full Outer Join, Detail Outer Join, and Master Outer Join in the Joiner Transformation.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Center Designer.
• Imported various heterogeneous files using Informatica Power Center Source Analyzer.
• Developed several reusable transformations and Mapplets that were used in other mappings.
• Prepared Technical Design documents and Test cases. Implemented various Performance Tuning techniques.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used Informatica scheduler to schedule jobs.
• Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.
• Performed unit testing at various levels of the ETL and actively involved in team Peer reviews.

Environment: Informatica power Center 9.1(Repository Manager, Designer, Workflow Manager, and Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer), Oracle 10g, SQL, PL/SQL, Flat Files, Star Team

Confidential, Atlanta, GA

Sr. Informatica /Teradata Developer

Responsibilities:

• Involved in Business Users Meetings to understand their requirements.
• Worked on Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
• Created new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, DB2, Teradata and Flat files.
• Developed mappings to load the data using different transformations like Look up (connected and unconnected), Normalizer, Expression, Java Transformation, Aggregator, Update Strategy, Union, Sequence Generator, Joiner, Filter, Update Strategy, Rank and Router transformations.
• Implemented slowly changing dimensions (SCD) Type 1 and Type 2.
• Developed SCD 2 mapping to load into staging tables and then to Dimensions and Facts for star schema model.
• Developed Workflows and Worklets using Workflow manager and also monitored the results using workflow monitor.
• Created scripts for loading the data into the base tables in EDW using Fast Load, MultiLoad and BTEQ utilities of Teradata.
• Loaded data in to the Teradata tables using Teradata Utilities Bteq, Fast Load, Multi Load, and Fast Export, TPT.
• Migrated data with the help of Teradata Fast Export, Insert/ Select, flat files from one system to another.
• Performed Unit Testing and involved in the UAT.
• Created end-to-end mapping document for the ETL process and unit test cases.
• Used Control-m to automate and schedule the jobs.
• Migrated the code from Dev to QA and then from QA to Prod.
• Implemented various Performance Tuning techniques.

Environment: Informatica power Center 10,9.6.1,Teradata V15, Teradata SQL Assistant, Oracle 11g,DB2 Control-m, ERWIN, Putty, MLOAD, TPUMP, FAST LOAD, FAST EXPORT

Confidential, Bentonville AR

Lead ETL Consultant

Responsibilities:

• Collaborated with project team members in providing design and development guidance, mentoring, best practices.
• Contributed in creation of the BRD/functional and technical design document after having multiple sessions with business users team.
• Performed Verification, Validation, and Transformations on the Input data before loading into target database.
• Involved in designing the process flow for extracting the data across various systems.
• Developed ETL routines using Informatica Power Center and created mappings involving transformations like Lookup, Aggregator, Ranking, Expressions, Mapplets, connected and unconnected stored procedures, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers.
• Extensively used ETL processes to load data from various source systems such as SQL Server, Teradata and Flat Files, XML files into target system SQL Server by applying business logic on transformation mapping for inserting and updating records when loaded.
• Proficient in Performance tuning of multiple Informatica mappings to improve performance as the volume of Internet orders entered the system on a daily basis. The factors involved were PDO (Push down optimization), bulk loading and also adding indexes on the staging tables.
• Using the Power Exchange for Change Data capture (CDC) option to capture the data whenever the inserts, updates, and deletes underlying these events as soon as they occur and transfer in to multiple targets without intermediate queues or staging tables
• Created landing tables, base objects and stage and reference tables. Define foreign key relationships.
• Implemented data extraction, transformation and load processes in a parallel framework.
• Created the Schema file to dynamically pass the metadata in Sequential file stage.
• Created Shared Container to encapsulate the logic that is commonly used across the project.
• Designed and developed Big Data Analytics Platform for processing customer viewing Preferences and unstructured data using Hadoop, Hive and Pig
• Integrated Hadoop with ETL accelerating massive loading of structured and unstructured data
• Familiar with data architecture including data ingestion pipeline design, Hadoop information architecture, data modelling and data mining

Environment: Informatica PowerCenter 9.6.1/9.5.1 (Repository Server, Repository Manager, Designer, Workflow Manager and Workflow Monitor), MDM (Master Data Management), Oracle 11g, Toad, PL/SQL and SQL Server 2008, SQL, UNIX Shell Scripts

Confidential, Tempe, AZ

Sr. Informatica Developer

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse, used Erwin to design the business process, dimensions, and measured facts.
• Created Design documents for better understanding of the process.
• Extracted the data from the flat files and RDBMS database into staging area and PSA then populated onto Data warehouse.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure and Union to develop robust mappings in the Informatica Designer.
• Developed mapping parameters and variables to support SQL override.
• Created Test Cases to perform Unit testing.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used existing ETL standards to develop these mappings.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Extensively used SQL* loader to load data from flat files to the database tables in Oracle.
• Modified existing mappings for enhancements of new business requirements.
• Used Debugger to test the mappings and fixed the bugs.
• Created UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Prepared migration document to move the mappings from development to testing and then to production repositories.

Environment: Informatica PowerCenter 9.6.1, Oracle 11g,TWS,SQL Server 2012, PL/SQL, Teradata V13, Toad, ERwin 3.5, Unix, Perl

Confidential, Indianapolis, IN

Sr.Informatica Developer

Responsibilities:

• Worked on Agile Methodology for this project with multiple sprints.
• Provided support to the QA team for various testing phases of ETL development.
• Analyzed existing Legacy ODS for migration into new environment.
• Scheduled the Workflows to run on a daily and weekly basis using Control-M scheduling tool.
• Developed complex mappings in Informatica using Power Center transformations (Source Qualifier, Joiner, Lookups, Filter, Router, Aggregator, Expression, XML Update and Sequence Generator Transformations), Mapping Parameters/Variables, Parameter files, SQL overrides and Transformation Language. Data profiling the source files and developing data model and mappings for smaller requirements.
• Created target tables in Oracle and Workflows in Informatica to populate the data according to requirements.
• Performed unit testing for developed ETL mappings before deploying to QA.
• Worked on Informatica Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformation Developer
• Created Reusable transformations, Mapplets, Worklets using Transformation Informatica, Mapplet Designer and Worklet Designer.
• Extensively used Pre-SQL and Post-SQL scripts for loading the data into the targets according to the requirement.
• Worked in agile environment meeting all the deliverables within the sprint

Environment: Informatica PowerCenter 9.1,Oracle 11g, DB2, Flat Files, SQL Server, Shell Scripting, SQL, Control-M scheduling tool

Confidential, Lexington, KY

ETL Developer

Responsibilities:

• Designed and developed ETL process using Informatica tool.
• Worked with various Active transformations in Informatica PowerCenter like Filter Transformation, Aggregator Transformation, Joiner Transformation, Rank Transformation, Router Transformation, Sorter Transformation, Source Qualifier, and Update Strategy Transformation.
• Worked with various Passive transformations in Informatica PowerCenter like Expression Transformation, Sequence Generator, and Lookup Transformation
• Worked with Task Developer, Worklet Designer, and Workflow Designer in the Workflow Manager. Responsible for extracting data from Oracle and Flat files. Responsible for Performance Tuning in Informatica PowerCenter.
• Worked with both Connected and Un-Connected Lookups.
• Made use of sorted input option for the performance tuning of aggregator transformation.
• Used SQL Override function in Source Qualifier Transformation.
• Used Normal Join, Full Outer Join, Detail Outer Join, and Master Outer Join in the Joiner Transformation.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica PowerCenter Designer.
• Imported various heterogeneous files using Informatica PowerCenter Source Analyzer.
• Developed several reusable transformations and mapplets that were used in other mappings.
• Prepared Technical Design documents and Test cases. Implemented various Performance Tuning techniques.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used Informatica scheduler to schedule jobs.
• Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.
• Performed unit testing at various levels of the ETL and actively involved in team Peer reviews.

Environment: Informatica PowerCenter 8.x(Repository Manager, Designer, Workflow Manager, and Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer), Oracle 9i, SQL, PL/SQL, Flat Files, Star Team

Confidential, Silver Springs, MD

ETL Developer

Responsibilities:

• Used Informatica PowerCenter for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
• Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.
• Involved in extracting the data from the Flat Files and Relational databases into staging area.
• Mappings, Sessions, Workflows from Development to Test and then to UAT environment.
• Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a star schema.
• Created events and various tasks in the work flows using workflow manager.
• Tuned ETL procedures to optimize load and query Performance.
• Set up Batches and sessions to schedule the loads at required frequency using Informatica workflow manager and external scheduler. Extensive Data modeling experience using Dimensional Data modeling, Star Schema modeling, Snowflake modeling, and FACT and Dimensions tables.
• Tested the mapplets and mappings as per Quality and Analysis standards before moving to production environment.
• Took part of Informatica administration. Migrated development mappings as well as hot fixes them in production environment.
• Wrote shell scripts for file transfers, file renaming and several other database scripts to be executed from Unix.
• Migrated Informatica Objects using Deployment groups.
• Troubleshot issues in Test and Prod. Did impact analysis and fixed the issues.
• Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
• Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse.

Environment: Informatica PowerCenter 8.6.0/8.6.1, Informatica Power Exchange 8.1, Stored procedures, Pl/SQL, Informatica Data Quality, Unix (Solaris), HP Quality Center

Confidential, Houston, TX

ETL Informatica Developer

Responsibilities:

• Worked with Informatica PowerCenter client tools like Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Extracted data from Oracle, SQL Server database tables and flat files.
• Created Informatica Development Standards. This document describes the general guidelines for Informatica developers, the naming conventions to be used in the Transformations and development and production environment structures.
• Worked in the performance tuning for mappings and ETL procedures at both mapping and session level. Implementing performance tuning the objects to increase the Performance of the loads.
• Worked closely with database administrators and application development team(s) on the design and implementation of the database.
• Participated in weekly end user meetings to discuss data quality, performance issues. Ways to improve data accuracy and new requirements, etc.
• Developed shell scripts in Unix to automate jobs in DEV and QA.
• Worked with various active and passive transformations in Informatica PowerCenter.
• Understood of Software Development Life Cycle (SDLC), involved in various phases like Requirements, Analysis/Design, Development and Testing.
• Worked with Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Developer, and Mapping Designer.
• Worked with Slowly Changing Dimensions Type1, Type2 for Data Loads.
• Handled various loads like Intra Day Loads, Daily Loads, Weekly Loads, Monthly Loads, and Quarterly Loads using Incremental Loading Technique.
• Worked with re-usable objects like Re-Usable Transformation and Mapplets.
• Worked with Incremental Loading using Parameter Files, Mapping Variables and Mapping Parameters.
• Involved in unit testing and writing simple test scripts and eliminating the bottlenecks for optimum performance.
• Involved in error handling using Session Logs, Reject Files, and Session Logs in the Workflow Monitor.
• Developed Unix shell scripts to run the workflows and automated the scripts to run daily loads using Control-M scheduler.
• Worked with the Debugger for handling the data errors in the mapping designer.
• Involved in bug fixes for production issues.

Environment: Informatica PowerCenter 8.x, Oracle Stored Procedures,, SQL Server 2005, Flat Files, Control-M, PL/SQL, Rapid SQL, Quality Center, Unix, Linux

Confidential, NY

Programmer Analyst

Responsibilities:

• Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions and scheduling them to run at specified time.
• Tested the Informatica mappings with manual testing and assisted QA team.
• Used Informatica Designer tools to design the source definition, target definition and transformations to build mappings.
• Studied the existing environment and accumulating the requirements by querying the Clients on various aspects.
• Identified various Data Sources and Development Environment.
• Data modeling and design of data warehouse and data marts in star schema methodology with confirmed and granular dimensions and FACT tables.
• Designed and developed data validation, load processes, test cases, error control routines, audit and log controls using PL/SQL, SQL.
• Used Update strategy and Target load plans to load data into Type-2 /Type1 Dimensions.
• Created and used reusable Mapplets and transformations using Informatica PowerCenter.
• Created different transformations for loading the data into target database using Aggregator, Upgrade strategy, Router, Rank, Sorter, Source Qualifier, Filter, Expression, Look-up, Sequence Generator, Normalizer, Joiner, etc.
• Developed joiner transformation for extracting data from multiple sources.
• Designed and developed pre-session, post-session routines and batch execution routines using Informatica Server to run Informatica sessions.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, testing of Informatica Sessions, and the Target Data.

Environment: Informatica PowerCenter 8.6.1/7.x, Informatica Power Exchange 8.x, MSSQL Server 2005/2008, PL/SQL, Stored Procedures, Informatica Data Quality, Unix (Solaris), HP Quality Center