SUMMARY

• Over 7+ years of extensive experience in Data Warehousing and Business Intelligence with emphasis on requirement analysis, design, development, testing, deployment and release management.
• Strong experience in Data movement solutions, worked extensively in development and migration projects using various versions of Informatica.
• Experience in Extraction, Transformation and Loading (ETL) processes for data Integration, data mapping and data conversion from various sources like Oracle, Teradata, SQL Server and Flat files using Informatica Power Center.
• Responsible for the development, implementation and support of ETL processes for large scale data warehouses.
• Extensive experience in ETL design, development and maintenance using Oracle SQL, PL/SQL, SQL Loader, Informatica Power Center v 5.x/6.x/7.x/8.x/9.x.
• Experience in testing the Business Intelligence applications developed in Qlikview.
• Well versed in developing thecomplex SQL queries, unions and multiple table joins and experience with Views.
• Experience in database programming inPL/SQL(Stored Procedures, Triggers and Packages).
• Excellent knowledge and experience in data warehouse development life cycle, dimensional modeling, implementation of STAR, Snowflake schemas and slowly changing dimensions.
• Worked with SCD (Slowly Changing Dimensions) Type 1, 2 and 3.
• Experience in implementing business rules by creating optimized and efficient mappings.
• Experience in identifying and eliminating bottlenecks to increase performance of mappings and sessions.
• Hands on experience with SQL / PL SQL and UNIX shell scripting.
• Providing 24/7 data warehouse production support in time pressured business environments.
• Enormous experience in Onsite - Offshore Model.
• Worked with Waterfall & Agile SDLC methodologies.
• Excellent communication, documentation and presentation skills using Microsoft Word, Excel, PowerPoint and Visio.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center (PWC) 9.5.1/8.x/7.xPower Exchange (PWX), Data Explorer (IDE), Data Quality (IDQ), SSIS, DataStage, Pentaho, Talend, BigData, Apache Hadoop, HDFS, MapReduce.

Databases: Oracle 11g/10g/9i/8i, Teradata, SQL Server, DB2, MS Access.

Schedulers: Tivoli Work Scheduler (TWS), AutoSys, Crontab.

Tools: MS Office (Word, Excel, Access, Visio, PowerPoint), ERWin, PVCS, SCM.

Languages: SQL, PL/SQL, C, C++, Java, XML, UNIX Shell Scripting

Platforms: Windows, UNIX, Mainframes.

PROFESSIONAL EXPERIENCE

Confidential, St louis, MO

Senior ETL Consultant

Responsibilities:

• Analyzed the business requirements and functional specifications.
• Extracted data from Oracle database and spreadsheets and staged into a single place and applied business logic to load them in the central Oracle database.
• Used Informatica Power Center 8.x for extraction, transformation and load (ETL) of data.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
• Developed complex mappings in Informatica to load the data from various sources.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Parameterized the mappings and increased the re-usability.
• Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
• Created procedures to truncate data in the target before the session run.
• Extensively used Toad utility for executing SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.
• Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time.
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Created a list of the inconsistencies in the data load on the client side so as to review and correct the issues on their side.
• Created the ETL exception reports and validation reports after the data is loaded into the warehouse database.
• Created Test cases for the mappings developed and then created integration Testing Document.Followed Informatica recommendations, methodologies and best practices.

Environment: Informatica Power Center 8.6.1/8.x, Sun Solaris, Oracle 10g, Scripting (Shell), Remedy.

Confidential, Phoenix, Arizona

Senior ETL Consultant

Responsibilities:

• Analyzed and thoroughly studied various data sources and different development environments within the organization.
• Extensively worked on extracting the data from various flat files (fixed width, delimited), applying the business logic and then loading them to the Oracle databases.
• Extensively worked with Source qualifier, Filter, Joiner, Expression, Lookups, Aggregator, Router, Sequence Generator, and Update Strategy.
• Used various Informatica transformations in the development of complex mappings.
• Extracted data from different heterogeneous source systems applied business logic using transformations and loaded to the target systems using Informatica power center.
• Worked closely with business for requirement gathering and to understand the project needs.
• Interacted with environmental team and data architects in design and implementation data models.
• Designed and developed complex mappings to load the Historical, Weekly and Daily files to Oracle database.
• Extensively worked on data conversion and data cleansing.
• Created different move-it jobs to have inbound/outbound transition of files between Client and different vendors.
• Developed UNIX shell scripting, created command task, and email task for providing the pre-session post-session requirements for various informatica jobs.
• Provide database coding to support business applications using T-SQL
• Worked on automation of informatica job flow using autosys boxes/jobs.
• Extensively worked on basic SQL queries such as creating altering Tables, Indexes, Views also worked with PL/SQL stored procedures. Queried various tables to get resultant datasets as per the business requirements.
• Prepared ETL mapping documents explaining complete mapping logic.
• Prepared unit test document and performed unit testing, regression testing.
• Provided QA/UAT support while code promotion and worked with QA’s to resolve any defects if found.
• Worked with different teams as Release Management, DBA, and UNIX team for smooth code promotions.

Environment: Informatica Power Center 9.5.1./ 8.x, Informatica Power Exchange, SQL, Shell Scripting, Tivoli Work Scheduler (TWS).

Confidential, Atlanta, GA

Senior ETL Consultant

Responsibilities:

• Responsible for gathering business requirements and analyzing & developing detailed technical specifications for EDW (Enterprise Data Warehouse).
• ETL Design/Development through Informatica Power Center 9.5.1 version.
• Loaded data into ODS (SCD Type1) and EDW (SCD Type2) making use of various transformation objects in Informatica.
• Involved in creation of Informatica mappings, sessions and workflows using mapping documents.
• Created Mappings / Sessions / Workflows in Informatica Power Center Designer, as per the BRD and STM specifications.
• Imported Mainframe COBOL copybooks as Sources using Informatica Power Exchange.
• Prepared test plans, test scripts, carrying out unit testing, integration testing and system testing without any issues.
• Coordinated and communicated for all approvals with business for smoother PRD implementation.
• Scheduled jobs making use of Tivoli Work Scheduler (TWS).
• Taken care of all EDW component deployments till Production, implemented successfully with in a prior time frame.
• Involved proactively in E2E testing with customer completely from onsite counterpart.
• Monitoring and resolved the bottlenecks in EDW for smoother process.
• Provide 24/7 on-call support whenever necessary.

Environment: Informatica Power Center 9.5.1./ 8.x, Informatica Power Exchange, Sun Solaris, Oracle 11g, Shell Scripting, Tivoli Work Scheduler (TWS), Talend, BigData, Hadoop, HDFS, MapReduce.

Confidential, Lake Forest, IL

Informatica Developer

Responsibilities:

• Created mappings and sessions to implement technical enhancements for data warehouse by extracting data from sources like Oracle and Delimited Flat files.
• Development of ETL using Informatica 8.x
• Applied slowly changing dimensions like Type 1 and 2 effectively to handle the delta Loads.
• Prepared various mappings to load the data into different stages like Landing, Staging & Target tables.
• Used various transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Update Strategy Designing and optimizing the Mapping.
• Developed Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Created various tasks like Session, Command, Timer and Event wait.
• Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.
• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Prepared SQL Queries to validate the data in both source and target databases.
• Worked on TOAD and Oracle SQL Developer to develop queries and create procedures and packages.
• Created Test cases for the mappings developed and then created integration Testing Document.
• Prepared the error handling document to maintain the error handling process.
• Interaction with the Onsite team on a daily basis on the development activities

Environment: Informatica Power Center 8.x, Sun Solaris, Oracle 10g, Scripting (Shell), Remedy.

Confidential

Informatica Tester

Responsibilities:

• Involved in identification of source definitions and target definitions in staging area and data warehouse.
• Create mappings using different sources of Flat file by using Expression, Aggregator, Sequence Generator, Look-up, Joiner, Filter and update strategy transformations are extensively used in the project.
• Resolve Bugs in mapping by debugging the mapping.
• Prepare SQL Queries on data warehouse target tables as a part of testing.
• Manually validating the data warehouse data with source data.

Environment: Informatica Power Center 7.1, Oracle 9i and Windows 2003 Server.