Summary:

• 6 years of IT experience in Analysis, Design, Development and Deployment of technical solutions to business requirements.
• Extensively worked on Data Warehouse Full Life Cycle Projects for Health Care, Financial, Retail and Insurance industries.
• 6 years of Strong Data Warehousing ETL experience using Informatica Power Center 9.1/9.0/8.6/8.1/8.0/7.1 Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer, Informatica Server, Repository Manager
• Experience in all the phases of ETL such as Extraction, Cleaning, Transformation and Loading using Informatica.
• Experience in using Oracle 11g for performing ETL functions using stored procedures.
• Extensive experience and exposure on several areas of the data warehousing and Business including requirements gathering, data warehouse architecture design, development, quality planning assurance, data analysis and implementation.
• Working knowledge with Informatica CDC for daily loads.
• Excellent understanding of the System Development Life Cycle. Involved in analysis, design, development, testing, implementation, and maintenance of various applications.
• Extracted data from various sources ranging from various RDBMS like Oracle, MS SQL Server, DB2, Teradata and Sybase, and Flat Files to load data into data marts and data warehouse.
• Expertise in working with TOAD for creation of Tables, Materialized views and normal views.
• Proficiency in working with PL/SQL stored procedures, packages, and triggers.
• Actively involved in Performance Tuning, maintaining Staging area, Backup and Recovery process, product support on various platforms.
• Effective implementations of change data capture using Power Exchange for daily loads.
• Performed data quality checks using data quality tools.
• Good experience working with large databases and performance tuning.
• Efficient in Optimizing, Debugging and testing SQL queries and stored procedures.
• Excellent working knowledge of Shell Scripting and job scheduling on platforms like UNIX.
• Able to interact effectively with other members of the Business, Quality Assurance, Users and other teams involved with the System Development Life cycle.
• Excellent analytical, functional, design and development skills with excellent communication skills and the ability to interface with the executives and perform independently as well as team environments.
• Technical Skills:
• Data Warehousing / ETL : Informatica Power Center 9.X/8.X /7.1, Tera Data 14.X/13.X/12.X.
• Database : Oracle 11g/10g/9i/8i, MS SQL Server, Netezza,TeraData.
• Database Tools : TOAD, SQL Navigator.
• Languages : SQL, PL/SQL, HTML, XML
• Operating Systems : IBM Z/OS,Windows 95/98/NT/2000/XP and UNIX

Professional experience:

Confidential

Sr. ETL Developer

Responsibilities:

• Participated in requirement gathering, Business Analysis, user meetings, discussing the issues to be resolved and translating user inputs into ETL design documents.
• Created ER diagram of the data model using Erwin data modeler to transform business rules into logical model.
• Involved in the extraction, transformation and loading of data from source flat files and RDBMS tables to target tables. Created reusable transformations and mapplets and used them in mappings.
• Used Informatica Power Center 9.1/9.01/8.6.1 for extraction, loading and transformation ETL of data in the data warehouse.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter,and Sequence Generator, Update Strategy, SQL, Union, Lookup, Joiner, XML Source Qualifier, Unconnected lookup transformations.
• Implemented the slowly changing dimensions SCD type1 and type2 to maintain current information and history information in the dimension tables.
• Involved in client interaction, analyzing issues with the existing requirements, proposing solutions and implementing the same.
• Optimized the performance of the mappings by various tests on sources, targets and transformations. Identified the Bottlenecks, removed them and implemented performance tuning logic on targets, sources, mapping, sessions to provide maximum efficiency and performance.
• Tuned performance of Informatica sessions for large data files by implementing pipeline Partitioning and increasing block size, data cache size, sequence buffer length, and target based commit interval and resolved bottlenecks.
• Debugging code, testing and validated data after processes are run in development/testing according to business rules.
• Prepared unit test plans and maintained defect logs to resolve issues. Worked with the QA team in order to determine the data validation and performed the data validating at the source and the target database level.
• Hands on experience as an Administrator involving Maintaining the Repository Manager for creating Repositories, user groups, folders and migrating code from Dev to Test, Test to Prod environment.
• Working on data request tickets and assisting business users non technical to understand the quality of the data.

Environment: Informatica Power Center 8.6.1/9/1 , Informatica power exchange, Oracle 11g/10g, SQL Server 2005/2008,IBM Mainframe, TSQL, MS Excel, Windows XP/2003/2008, CA Scheduler.

Confidential

ETL Developer

Responsibilities:

• Worked with power center tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
• Created metadata queries which would help in restart and to find out any missing link conditions or disabled tasks in a workflow.
• Deployed reusable transformation objects such as mapplets to avoid duplication of metadata, reducing the development time.
• Used Informatica data services to profile and document the structure and quality of all data.
• Extensively used Informatica Transformation like Source Qualifier, Rank, SQL, Router, Filter, Lookup, Joiner, Aggregator, Normalizer, Sorter etc. and all transformation properties.
• Extensively used Various Data Cleansing and Data Conversion Functions in various transformations.
• Experience working with Teradata tools MLOAD, FLOAD, FEXP and BTECH script.
• Translated Business processes into Informatica mappings for building Data marts by using Informatica Designer which populated the Data into the Target Star Schema on Oracle 9i Instance.
• Developed ETL mappings, transformations using Informatica Power center 8.6
• Deployed the Informatica code and worked on code merge between two difference development teams.
• Identified the bottlenecks in the sources, targets, mappings, sessions and resolved the problems.
• Created automated scripts to perform data cleansing and data loading.
• Attended daily status call with internal team and weekly calls with client and updated the status repo rt.
• Created and maintained mappings as needed.
• Developed various shell scripts using Korn Shell to Integrate various components
• Created test cases and pseudo test data to verify accuracy and completeness of ETL process
• Involved in Unit testing, System Integration testing, User Acceptance Testing
• Tested application and implemented into production
• Modified mappings, sessions, workflows as needed to get them to work as designed in upgraded environment.

Environment: Informatica PowerCenter 9.1.0, Power Exchange 9.1.0,Oracle 11g, Toad, HP Quality Center, Tera Data,DB2,Flat Files,unix shell scripting, Netezza, Tidal Scheduler.

Confidential

BIDW ETL Developer

Responsibilities:

• Responsible for reviewing Business Requirement document
• Translated user requirements into system solutions.
• Involved in Logical Data Modeling and Database design.
• Designed and developed Oracle Star Schema Datamart
• Involved in Data Analysis of the OLTP system to identify sources data elements
• Worked with Oracle, Flatfiles,Teradata and SQL Server source systems
• Prepared Technical Specification Document
• Prepared Source to Target ETL mapping Documents
• Designed and developed Informatica Mappings, Reusable Sessions, Worklets, Workflows, Dynamic Parameter files
• Designed and implemented Audit control and Exception control strategies
• Provided solutions for various performance bottle necks in Informatica Mappings
• Designed and Developed Autosys jil scripts to Schedule Informatica workflows
• Developed various shell scripts using Korn Shell to Integrate various components
• Created test cases and pseudo test data to verify accuracy and completeness of ETL process
• Involved in Unit testing, System Integration testing, User Acceptance Testing
• Involved in Informatica Code Migration across various Environments
• Involved in Production Support and Knowledge Transfer sessions

Environment: Informatica Power Center 9.5.1, Informatica power exchange 9.5, Oracle 11G, SQL Server, Flat files, PL/SQL, SQL Plus, TOAD 9.1, UNIX, Shell Scripting, Tivoli, Erwin, Microsoft Visio

Confidential

ETL. Developer

Responsibilities:

• Especially worked on the benefits subject area of PDI project.
• Staged Data from legacy Proclaim IMS system into Oracle 11g Master Tables which involved extracting data from proclaim mainframe JCL and cobol
• Performed CDC capture registrations.
• Assisted in building the ETL source to Target specification documents by understanding the business requirements.
• Developed mappings that perform Extraction, Transformation and load of source data into Derived Masters schema using various power center transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Rank, Joiner, Expression, Stored Procedure, SQL, Normalizer and update strategy to meet business logic in the mappings.
• Created High Level Design document and Low level design document for the projects worked on.
• Worked on code enhancements for the assigned projects.
• Reusable transformations and Mapplets are built wherever redundancy is needed.
• Slowly Changing Dimension Type 2 is implemented to maintain last 3 years of historical data.
• Performance tuning is performed at the Mapping level as well as the Database level to increase the data throughput.
• Designed the Process Control Table that would maintain the status of all the CDC jobs and thereby drive the load of Derived Master Tables.
• Used tasks like Command, Decision, Event Wait, Event Raise, Assignment and Timer in the workflows and worklets to meet business requirements logic effectively.
• Created promotion packages in harvest for the code deployment to higher environments.

Environment: Informatica PowerCenter 9.1.0, Power Exchange 9.1.0,Oracle 11g, Toad, HP Quality Center, Tera Data,DB2, 13.X/12.X, Control M Scheduler.

.

Confidential

ETL Developer

Responsibilities:

• Involved in the process of extracting data from integrated heterogeneous sources and sorting extracted data.
• Performed the preparation of technical design docs, source to target mapping filed to field matrix . Prepared the strategies for performance tuning and reusable components in the Informatica.
• Performed data validation, data reconciliation on the target DB2 Server and source data.
• Created mappings using Informatica, prepared the test cases based on the business requirements and documented them in a specified manner.
• Involved in migration of the Informatica objects between the repositories with deployment groups.
• Designed and developed complex Informatica mappings using expressions, aggregators, filters, lookup and stored procedures to ensure movement of the data between various applications.
• Tuned all the mappings for better performance.
• Error checking and testing of the ETL procedures and programs using Informatica session log and various tracing options
• Implemented the exception handling for trapping various exceptions and reported the various errors.
• Designed and developed Oracle PL/SQL Procedures and wrote SQL, PL/SQL scripts code for extracting data to system

Environment: DB2, Oracle 9i, Informatica 7.2, UNIX.

Confidential

Data Warehouse Developer

Responsibilities:

• Worked with Business analysts for requirement gathering, business analysis, and testing and project- coordination.
• Prepared technical specifications to develop Informatica ETL mappings to load data into various tables confirming to the business rules.
• Created the ER Entity Relationship diagrams maintained corresponding documentation for corporate data dictionary with all attributes, table names and constraints.
• Research Sources and identify necessary Business Components for Analysis.
• Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target Schema Design Star Schema and maintenance.
• Created Informatica mappings as per technical specifications.
• Created different transformations for loading the data into target database.
• Performance tuning of mappings, transformations and sessions to optimize session performance.
• Created snapshot for the transactional tables in distributed databases and also created Triggers, Procedures and Functions for the backend Development.
• Developed Unix Shell Scripts and Stored Procedures to run from the Informatica pre and post sessions to create and drop the indexes to improve the speed of session execution
• Worked on issues with migration from development to testing.
• Carried out ETL Testing using Informatica and PL/SQL.
• Used SQL, PL/SQL to validate the Data going in to the Data Warehouse.

Environment: Oracle 8i, 9i, 10g, Informatica 8.X, Erwin, Windows, UNIX.

Confidential

Database Developer

Responsibilities:

• Extensively involved in requirements gathering and data gathering to support developers in handling the design specification
• Involved in designing and coding of functional specifications for the development of user interfaces
• Created tables, indexes, sequences, constraints and snapshots
• Developed packages, procedures, functions and PL/SQL blocks for data validation
• Developed PL/SQL scripts to validate and load data into interface tables
• Fixed software bugs and interacted with developers to resolve technical issues
• Designed and developed a Generic Billing system for a Telecommunication company
• Responsible for all pre-ETL tasks upon which the Warehouse depends including managing

Environment: Oracle 8i, 9i, SQL, PL/SQL, UNIX and Windows, Korn Shell.