Professional Summary:

• Over 9 years of IT experience in Analyzing, Developing, Implementing and Supporting Data Warehouses, data marts and data integration projects in Banking, Sales, Insurance and Health care industries
• Strong experience in designing and developing Business Intelligence solutions in Data Warehousing Decision Support Systems using Informatica PowerCenter 9.5/9.0.1/8.6/8.1/7.1, Informatica Data Quality 9.5 and Informatica Cloud.
• Very good experience in Interacting with the Team with Onside-offshore models.
• Experience in handling of various Databases like Oracle, SQL Server, DB2 and Teradata.
• Strong knowledge on Data warehouse concepts and Data modeling techniques like Dimensional Data Modeling Star Snowflake schema , Kimball Inmon methodologies.
• Worked extensively on Slowly Changing Dimension's SCD Type 1 and Type 2 .
• Strong work experience in SQL and PL/SQL.
• Experience in working with UNIX Shell Scripts for scheduling jobs and file validations.
• Experience in third party tools like SQL Developer, TOAD and PUTTY.
• Experience in writing, testing and implementation of the Stored Procedures, Functions and Triggers using Oracle PL/SQL.
• Extensively worked on ETL Informatica Transformations effectively including Source Qualifier, Connected - Unconnected Lookup, Filter, Expression, Router, Normalizer, Joiner, Update, Rank, Aggregator, Stored Procedure, Sorter and Sequence Generator and created complex mappings.
• Expertise in enhancements bug fixes, performance tuning, troubleshooting, impact analysis, Unit testing, Integration Testing, UAT and research skills.
• Knowledge of informatica components required to operate Informatica Data Quality rules.
• Proficient in writing SQL queries using teradata database.
• Extensive experience in generating XML's using informatica.
• Experience working with Informatica Cloud and Informatica Real Time highly valued.
• Excellent Team player and can work on both development and maintenance phases of the project.
• Actively involved and interacted with Business Analysts while preparing technical design document and ensure that it is in sync with Functional Design Specification.
• Documenting the entire process design document, mapping document and the turnover document among others.
• Developed several complex Mappings, Mapplets and Reusable Transformations to facilitate one time, Daily, Monthly and Yearly Loading of Data

Technical Skills:

Confidential

Senior ETL Developer

Description

Confidential of this project is to represent an expansion of the Medicaid and Children's Health Insurance Program CHIP data collected from the various State programs. Confidential data is submitted by the State on a monthly basis in eight 8 files. These eight files represent the following subject areas: eligibles, providers, managed care organizations, third party liability obligations, and four types of claims Prescription, Long Term Care, Inpatient, and Other .

Responsibilities:

• Exensively worked on tuning ETL informatica mappings to increase session performance.
• Modifying the existing Informatica ETL Mappings and Workflows to work with modified database and source structures.
• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
• Created Informatica mappings with SQL Queries and PL/SQL Procedures/Functions to build business rules to load data.
• Developed stored procedures using Dynamic SQL.
• Extensively implemented informatica partitioning techniques like pass through, Hash key and round robin partitioning.
• Implemented Aggregator, Router, Filter, Joiner, Expression, Lookup, Update Strategy, Sequence generator, Transaction control and SQL transformations.
• Implemented Slowly changing dimentions Type1 and Type 2.
• Extensively used Data Assessment, Data Synchronization applications and integrated power center applications with Informatica Cloud.
• Performed data analysis, data profiling, data mappping, data validation using Informatica Analyst Tool.
• Designed and developed ETL and data quality mappings to load data from source systems to ODS using Informatica Developer Tool.
• Responsible for unit testing the ETL code to meet the buisiness requirements.

Environment: Informatica Powercenter 9.5, Informatica Data Quality 9.5, SQL Developer, Oracle database 11g, DB2, Unix

Confidential

Senior Informatica Developer

Confidential is one of the nation's largest insurance companies. It provides healthcare coverage throughout Confidential and offers variety of insurance and insurance related products. The objective is to build an Enterprise Data Warehouse for various groups which are part of Confidential.

Responsibilities:

• Involved in gathering requirements and created design documents and mapping documents.
• Experience in performance tuning of ETL process for high volume, high complex processing and usage of complex SQL queries.
• Extensive experience in generating XML files and sending over to different vendors.
• Used Informatica Power Center for ETL Extraction, Transformation and Loading data from heterogeneous source systems into target database.
• Extensively worked on pulling the data from source MQSeries.
• Used various transformations like Lookup, Filter, SQL, Router, Aggregator, Joiner, Expression, Sequence generator and XML generator in the mappings.
• Developed ETL programs using Informatica to implement the business requirements and implemented various performance tuning techniques.
• Implemented parallelism in loads by partitioning workflows using pass through, key range, round robin and Hash partitioning.
• Extensively worked on DB2 UDB databases.
• Responsible for unit testing and integration testing of informatica mappings and workflows.
• Documented existing mappings as per standards and developed template for mapping specification document.
• Worked with informatica powercenter 9.5 to move data from multiple sources into a common target area such as data marts and datawarehoue.
• Extensively implemented slowly changing dimensions Type 1 and Type 2.
• Developed complex database objects like stored procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Extensively implemented DataQuality rules uisng mappings, workflows in Informatica Developer client.
• Extracted the data from Salesforce application using Informatica Cloud and implemented full load and incremental loads.
• Extensively used informatica debugger to figure out the problems in mappings and also involved in troubleshooting existing ETL bugs.
• Created a list of inconsistencies in the data load on the client side so as to review and correct the issues at their side.
• Created the ETL exception reports and validation reports after the data is loaded into the warehouse database.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.

Environment: Informatica Power Center 9.5, Informatica Data Quality 9.5, Informatica Cloud, SQL Developer, Oracle database 11g, DB2, Sqlserver, Unix, xml

Confidential

Senior Informatica Developer

Description

Confidential is one of the oldest, largest and best-known financial institutions in the world. This firm is built on the foundation of more than 1200 predecessor institutions. This project is all about processing loans and generating XML files to shipping vendors and getting the shipping information from the vendors.

Responsibilities:

• Involved in gathering requirements and created design documents and mapping documents.
• Experience in generating XML's using informatica.
• Worked with analysts, using work sessions, to translating business requirements into technical user specifications, including data, process and interface specifications.
• Perform data validation tests using complex SQL statements.
• Worked on Informatica PowerCenter tools - Designer, Repository Manager, Workflow Manager and Workflow Monitor.
• Responsible to understand the unix shell scripts for loading the files.
• Experience in converting complex PL/SQL programs into informatica mappings.
• Experience in applying labels in informatica and maintaining versions.
• Having excellent knowledge working on oracle database, writing complex SQL scripts and PL/SQL programs.
• Identified performance issues in existing sources, targets and mapping by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
• Extensive experience in loading Teradata tables and writing complex SQL queries.
• Extensively used ETL processes to load data from flat files into the target database by applying business logic on transformation mapping for inserting and updating records when loaded.
• Developed Informatica mappings by usage of Aggregator, SQL Overrides in Lookup, Dynamic Lookup, Source Qualifier and data flow management into multiple targets using Router transformations.
• Implemented change data capture using informatica Power exchange.
• Created Stored Procedures Functions for data transformation purpose.
• Involved in gathering requirements and created design documents and mapping documents.
• Extensive experience working in Fixed income process and sending investor's information to the different vendors.
• As a ETL developer I am responsible for analyzing the informatica code and debugging the issues while loading the data into datawarehouse.
• Experience in working with server migration project.

Environment: Informatica 9.0.1, SQL Developer, sqlserver, Oracle database 11g, Unix, Linux, xml.

Confidential

Role: ETL Developer PL/SQL Developer

Description:

Confidential is one of the largest life insurance companies in the Confidential. The main objective of the project was designing, developing and testing of data warehouse.

Responsibilities:

• Extracted the data from the flat files and Relational databases into staging area and populated into data warehouse using SCD logic to maintain the history.
• Developed number of complex Informatica Mappings, Mapplets and reusable Transformations to implement the business logic and to load the data incrementally.
• Implemented Slowly Changing Dimensions SCDs, Type1and Type 2 .
• Wrote stored procedures in PL/SQL for certain key business requirements.
• Created maintained tables, views, synonyms and indexes from Logical database design document.
• Tested the mappings using the Test Load option Unit Test cases.
• Employed the Source Qualifier, Lookup, Expression, Aggregator, Rank, Sequence and Joiner Transformations in the Mappings to populate data into the target.
• Worked with Oracle, SQL Server and flat file sources.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Provided technical Support in deployment of workflows, worklets and sessions for weekly releases using repository manger.
• Reviewed deliverables and ensure they meet the high quality standards before delivering them to the client team.
• Implemented Performance Tuning for transformations to increase the session performance time.
• Used TOAD 8.0 to analyze the execution of SQL queries for performance tuning purposes.
• Worked extensively on SQL, PL/SQL and UNIX shell scripting.
• Executed workflows using the pmcmd commands.
• Used session and workflow error logs to debug the session and find problems in the mapping.

Environment:

Informatica Power Center 8.1, TOAD, Oracle 10g, OBIEE 10g, SQL, PL/SQL, SQL Plus, UNIX shell scripting, UNIX and Windows XP.

Confidential

Role: ETL Informatica Developer

Description:

• Confidential had developed a central data warehouse for sales. The Data Warehouse development Significantly Confidential Flexibility, Proprietary Competitive Advantage, and Improved Service Levels
• in serving the critical needs of the sales team. Project involved in developing Enterprise Subject
• Data warehouse to implement a centralized database that collects, organizes and stores data from
• different operational data sources to provide a single source of integrated and historic data.

Responsibilities:

• Worked with the business analysts for requirement analysis to implement the ETL process.
• Worked Extensively on Informatica tools Repository Manager, Designer and Work Flow Monitor.
• Worked on the transformations like Lookup, Aggregator, Expression, Router, Filter, Update Strategy, Stored procedure, Sequence Generator.
• Involved in both designing and developing the Data Mart.
• Developed stored procedures according to business scenarios.
• Extracted data from source systems and transformed according to business requirements using Informatica PowerCenter and loaded into Oracle Data
• Involved in unit and system testing.
• Involved in Creating tasks, worklets, workflows to load the data.
• Scheduled, Run and Monitored sessions using workflow manager and workflow monitor.
• Used pmcmd commands for stopping and starting workflows and tasks.
• Having experience in working with offshore team to interact with the customers and gathering requirements.
• Involved in Postproduction support and enhancements.
• Scheduled Workflows using Autosys and korn shell on UNIX.
• Created and Implemented Reusable Sessions like E-mail.

Environment:

Power center 7.1, Oracle 9i, DB2, SQL Server, File files, TOAD, SQL, PL/SQL, Erwin, Cognos, Unix korn shell scripting , Autosys, UNIX and Windows XP.