SUMMARY:

• Over 10+ years of extensive experience in ETL (Extract Transform Load), Data Integration, Data Profiling, Data Mapping, Data Modeling, Data Warehousing using Informatica, Hana and Oracle technologies.
• Experience in providing Business Intelligence solutions in Data warehousing and Decision Support Systems using Informatica PowerCenter 10.4/10.2/10.1/9. 6.1/9.5.1/ 9.1/8. x as ETL tool.
• Work with data analysts and developers, Business Area, and Subject Matter Experts (SME) performing development activities across all phases of project development lifecycle. Apply data warehousing principles and best practices to development activities.
• Have experience in working both offshore/onshore project models helping team to achieve their goals and coached team members on technical tools.
• Data warehouse development experience using CDC tool Informatica PowerExchange 9.5/9.1.
• Proficiency in Informatica PowerCenter and Informatica Master Data Management (MDM).
• Implemented Informatica ETL methodology for designing and developing, extraction, transformation, and load processes.
• Proficient in full life cycle development of Data Warehousing, ETL strategies, reporting and hands on experience in Performance Tuning of sources, targets, transformations, mappings, and sessions using Database Tuning, Partitioning, Index Usage, Aggregate Tables, Session partitioning, Load strategies, commit intervals and transformation tuning.
• Experience in Unit testing, System testing while moving the code from development to production.
• Experience in Data Warehouse/Data Mart Development Life Cycle using Dimensional modeling of STAR schema, Snowflake schema, OLAP, ROLAP, MOLAP, Fact and Dimension tables and Logical& Physical data modeling using ERWIN.
• Experienced in loading data into targets like Flat files, xml files, Oracle, DB2, SQL Server into Data Warehouse/Data Marts using Informatica.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows in all versions of Informatica.
• Extensive experience in Informatica upgrade from 9.6 to 10.1 and to 10.4. Data profiling. Have good understanding on IDQ validations and MDM techniques with the match and merge techniques with the rules and configuration for the survivor / golden record.
• Experience in creating Reusable components like transformation, mapplets and tasks.
• Good knowledge in extracting data from Flat Files, Unstructured data, xml formats and PDF format files and transforming and loading into Oracle database, flat file JMS Queue, COBOL files and vice versa.
• Experience in developing Shell scripts on UNIX and experience with UNIX command line.
• Assign work and provide technical oversight to onshore and offshore developers.
• Good experience in documenting the ETL process flow for better maintenance and analyzing the process flow.
• Demonstrated ability to take initiatives, grasp and expand on ideas, tackle and follow through difficult assignments in the fast - pace and changing environment.
• Independent yet team oriented with excellent analytical, problem solving, multi-tasking and oral and written communication skills.
• Experienced in methodologies likeAgile-SCRUMandWaterfall Model.

TECHNICAL SKILLS:

ETL Technology & Data Warehouse: Informatica PowerCenter 10.4/10.2/10.1/9. 6.1/9.5.1/9.0.1/8. x, Power Exchange 10.4/10.2/10.1/9. x/8.6, IDQ, Informatica Master Data Management (MDM), Informatica B2B, Multidimensional Model Design, Star Schema Development, IDQ

Star: Schema Modeling, Snowflake Modeling, MS Visio, Erwin

Databases: Oracle 12c/11g/10g, MS SQL Server 2014/2012/2008, MS Access, SAP, Sybase, DB2, MySQL, Teradata 13/V2R6. SAP HANA

Programming: C, C#, C++, SQL, PL/SQL, ANSI SQL, T-SQL, SQL*Plus 3.3/8.0, HTML, UNIX shell Scripting, VB Scripting.

Environment: s: Windows 98/NT/2000/XP, UNIX, LINUX, MS-DOS 6.22

Applications: MS Office, MS Project, FrontPage, Toad 9.2/8.6

SDLC Methodologies: Agile, Waterfall

PROFESSIONAL EXPERIENCE:

Confidential | Houston, TX

Senior ETL Consultant

Responsibilities:

• Worked on complete (SDLC) from Extraction, Transformation and Loading of data using Informatica PowerCenter.
• Prepared the required application design documents based on functionality required Designed the ETL processes to load data from Oracle, Flat Files (Fixed Width), and Excel files to staging database and from staging to the target Oracle Data Warehouse database.
• Used session parameters, Mapping variable/parameters and created parameter files for imparting flexible runs of workflows based on changing variable values.
• Improved the performance of the mappings by moving the filter transformations early into the transformation pipeline, performing the filtering at Source Qualifier for relational databases and selecting the table with fewer rows as master table in joiner transformations.
• Implemented data cleansing and maintained proper normalization of enterprise data to support decision making and reporting.
• Scheduled Informatica jobs using UC4 and monitored those jobs in daily basis for smooth and error free running.
• Involved in Data Extraction from Oracle and Flat Files using SQL Loader Designed and developed mappings using Informatica PowerCenter.
• Involve in writing and modifying UNIX shell scripts.
• Worked with Agile Methodology
• Assisted in migration from SAP BusinessObjects 3.x to 4.x platform, providing guidance on sizing, load balance, systematic deployment, and scale-up options.

Confidential | NM

ETL Informatica Developer

Responsibilities:

• Design Develop and Implementation of ETL jobs to load internal and external data into data mart.
• Develop and modify ETL jobs to meet monthly and quarterly report needs.
• Extracted data from different sources like flat file, oracle, Hana, SQL Server and transformed data into required format to load into Data warehouse for reporting purpose.
• Analyzed source data, extracted, transformed, and loaded data in to target data warehouse based on the requirement specification using Informatica PowerCenter.
• Production Support has been done to resolve the ongoing issues and troubleshoot the problems.
• Involved to design Drafted schema and participated in Designing logical and physical data model using ERWIN.
• Involved in testing the SAP BOreports by writing complex SQL queries. Validating the data files from source to make sure correct data has been captured to be loaded to target tables.
• Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.
• Architected automated batch jobs to create, encrypt, and transfer data extracts using Unix Shell Scripting

Confidential

Process Lead/ ETL

Responsibilities:

• Interpreted and comprehend business/data requirements from upstream processes.
• Created and documented source-to-target mappings and ETL specifications Performed Root cause analysis and resolved complex issues.
• Worked with various heterogeneous sources such as Oracle10g, Teradata and Flat Files to load the data into the target Oracle data warehouse.
• Involved in preparation of Test Cases and Executing the Test Cases UAT Tool Involved in System Testing, Regression Testing, and Security Testing.
• Developed standards and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, sorter, union, and filter.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads, and process flow of the mappings.
• Created and Executed UNIX shell scripts and PL/SQL procedures, Pre-session and Post- Session Scripts to ensure timely, accurate processing and ensure balancing of job run.
• Extensively involved in Informatica PowerCenter upgrade from version 9.x to version 10. x.
• Created Data Models for enterprise-wide data analytics solutions, from which the various HANA Views and Business Objects Universes were developed.

Confidential

Senior Process Associate

Responsibilities:

• Created Workflows, Tasks, database connections using Workflow Manager Developed complex Informatica mappings and tuned them for better performance Created sessions and batches to move data at specific intervals & on demand using Server Manager.
• Preparation of Test Cases and Executing the Test Cases UAT Tool Involved in System Testing, Regression Testing, Security Testing.
• Created debugging sessions before the session to validate the transformations and used existing mappings in debug mode extensively for error identification by creating break points and monitoring the debug monitor.
• Created complex mappings in PowerCenter Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Rank, Joiner and Stored procedure transformations.
• Designed and Customized data models for Data Mart supporting data from multiple sources on real time.
• Analyzed various reports generated by SAP BO.
• Involved in testing the SAP BOreports by writing complex SQL queries. Validating the data files from source to make sure correct data has been captured to be loaded to target table.
• Involved in writing UNIX shell scripts for Informatica ETL tool to fire off services and sessions.

Confidential

Process Associate

Responsibilities:

• Requirement gathering and Business Analysis.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Reviewed source systems and proposed data acquisition strategy.
• Involved all phases of the project life cycle such as analysis, design, coding, testing, production, and post-production.
• Documented technical requirement specifications and detailed designs for ETL processes of moderate and high complexity.