PROFESSIONAL SUMMARY:

• 7+ years of IT experience in Analysis and Design, Implementation & Testing in Data Warehouses & Data marts with ETL & OLAP Tools using Informatica Power Center v9.x, 8.x, 7.x,6.x Power Exchange 8.x,5.x, SQL Server and Oracle11g/9i/8i.
• Ability to analyze source systems and business requirements, identify and document business rules, design data architecture.
• Extensive Knowledge in Dimensional Data modeling, Star Schema modeling, Snow - Flake modeling, Fact and Dimension tables, Physical and logical data modeling using Erwin data modeling tool.
• Experience in Functional Testing.
• Experience in Performance Tuning of Informatica Power Center ETL jobs, Oracle SQL Queries and store procedures
• Worked for over three years with Informatica Professional Services team at various client locations
• Expert in designing most optimized ETL Mapping using Informatica Power center, Power Exchange
• Strong Experience in writing complex SQL Queries, PL/SQL stored procedures, triggers, creating Tables, Indexes, Views and Materialized Views.
• Good understanding concepts Informatica Power Center 8.6/7.3 using Repository Manager, Designer, Workflow Manager and Workflow Monitor
• Worked on various Domains like Banking, Retail, E-Commerce, Health Care Insurance, Supply Chain, Investments and Pharmacy
• Strong working experience in the Data Analysis, Data Verification and Validation of an ETL Applications using Backend/Database Testing.
• Worked with heterogeneous relational sources like SQL Server, Oracle, MS Access and Teradata
• Experienced in complete Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC) and DEFECT Life Cycle.
• Extensive experience in Functional Testing, Integration Testing, System Testing, Regression Testing, Performance Testing on Warehouse Applications.
• Knowledge of Windows 2000/NT/XP and UNIX operating Systems.
• Excellent problem solving skills with a strong technical background and good interpersonal skills.
• Excellent team player, quick learner, ability to work and deliver under tight deadlines.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.x/8.x/7.x, Power Exchange 9.x/8.x, Talend 6.2

Data Modeling: Dimensional Data Modeling, Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical / Logical Data Modeling

Databases: Oracle 11g/9i/8i, SQL Server 2000, DB2, Teradata

ETL: Informatica Power Center 9.1/8.X/7.x/6.2

Tools: WinSQL

Environment: Windows95/98/2000/XP/2003, Unix 5.2/4.3,HP Quality center

PROFESSIONAL EXPERIENCE:

Confidential, MI

ETL CONSULTANT

Responsibilities:

• Worked with Data mapping team to understand the source to target mapping rules.
• Analyzed the requirements and framed the business logic and implemented it using Informatica.
• Involved in ETL design and documentation.
• 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 of 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 and used Erwin to design the business process, dimensions and measured facts.
• Extracted the data from the flat files and other RDBMS databases into staging area and 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 mapplets to use them in different mappings.
• 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.
• Wrote 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 Power Center 8.6.1, Workflow Manager, Workflow Monitor, Informatica Power Connect / Power Exchange, Data Analyzer 8.1, PL/SQL, Oracle 10g/9i, Erwin, Autosys, SQL Server 2005, Sybase, UNIX AIX, Toad 9.0, Cognos 8.

Confidential, MI

ETL CONSULTANT

Responsibilities:

• Gathered Business requirements by interacting with Business Analyst team and analyzed the requirements to translate into Technical Specifications.
• Created a mapping document as per the requirement in BRD document.
• Extracted the source data from the flat files and other RDBMS databases into staging area and populated onto Data Warehouse.
• Developed complex mappings and reusable transformations and workflows to implement the business logic and load the data incrementally.
• Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables.
• Created and implemented email tasks based on the requirements.
• Created workflow tasks such as session, command and decision and email.
• Documented all the ETL processes infrastructure related documents.
• Worked on Test cases from development side.
• Extensively involved in performance tuning of the ETL process
• Analyzing existing database schemas and designing star schema models to support the users reporting needs and requirements.
• Worked on UNIX commands and created shell scripts and executed from DEV,QA side.
• Created unit test cases and tested the data in target tables.
• Tested the target data against source system tables.
• Tested all the applications and transported the data to the target Warehouse Oracle tables.
• Involved in Team review meetings.
• Worked with On Call support Team.
• Communication with the client for weekly status report.

Environment: Informatica Power Center 9.0, Oracle 11g, UNIX, SQL Server 2008.

Confidential, MI

Application Developer (Informatica)

Responsibilities:

• Collaborate with assigned business unit clients and information technology staff to deliver effective and innovative business technology solutions using the Extraction, Transformation and loading tool, Informatica.
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• Performing ETL & database code migrations across environments.
• Documented all the ETL processes infrastructure related documents.
• Analyzing existing database schemas and designing star schema models to support the users reporting needs and requirements.
• Tested all the applications and transported the data to the target Warehouse Oracle tables.
• Extensively involved in performance tuning of the ETL process by determining the bottlenecks at various points like targets, sources, mappings, sessions or systems. This led to a better session performance.
• Analyzing existing database schemas and designing star schema models to support the users reporting needs and requirements.
• Tested the target data against source system tables by writing Some QA Procedures.
• Tested all the applications and transported the data to the target Warehouse Oracle tables.
• Involved in weekly status meetings.

Environment: Informatica Power Center 9.0, Oracle 11g, UNIX,HP QA.

Confidential, TX

ETL CONSULTANT

Responsibilities:

• Gathered Business requirements by interacting with Business Analyst team and analyzed the requirements to translate into Technical Specifications.
• Identified the bottlenecks in the sources, targets, mappings, sessions and resolved the problems.
• Developed Mappings,Workflows,Sessions and executed the flow.
• Created automated scripts to perform data cleansing and data loading.
• Performed complex defect fixes in various environments like UAT, SIT etc to ensure the proper delivery of the developed jobs into the production environment.
• Handled some of the data issues in the jobs, during the release of the project to send the correct data to the business users.
• Responsible to write complex SQL queries and PL/SQL procedures to perform database operations according to business requirements.
• Worked with the testers closely in determining both medium and high severity defects, that would potentially affect the downstream systems before the release of the project, and also fixed the defects before moving the jobs into production.
• Document all ETL related work per company's methodology.
• Attended production implementation calls and co-ordinated with the build engineers during migration of the code and was highly acknowledged.
• Developed .sql files in unix box for creating and dropping staging tables.
• Prepared estimates and tracked each and every tasks and strictly adhered to the estimated deadlines.
• Extensive knowledge in promoting packages (code) across development, test, preproduction and production environment using tools like Computer Associate Harvest package.
• Co-ordinated with Off-Shore team in INDIA.
• Extensive knowledge in promoting packages (code) across development, test, preproduction and production
• Preparation of Test Data/Unit Testing /Integrated testing and generated various test cases.
• Involved in different Team review meetings.
• Worked along with UNIX team for writing UNIX shell scripts to customize the server scheduling jobs.
• Communication with the client for weekly status report

Environment: Informatica Power Center 8.1, Unix Shell scripting, Oracle, SQL, PLSQL, flat files, Mainframes.

Confidential, MI

IT Consultant

Responsibilities:

• Designed and configured new ETL architecture & infrastructure
• Installed Informatica Applications.
• Designed ETL migration strategies.
• Tested and modified Oracle PLSQL Scripts after database upgrade.
• Developed UNIX shell scripts for regular log files cleanup, command line execution of Informatica jobs and archive the inbound files.
• Created Test plan and test cases and worked in quality center.
• Worked with developers ran the scripts in quality center.
• Documented all the ETL processes infrastructure related documents.

Environment: Informatica Power Center 9, Oracle 11g, UNIX