OBJECTIVE

Over 7years of experience in designing, developing, testing and implementing Extraction, Transformation, and Load ETL techniques on multiple database platforms and operating system environments.

Summary

• Experience in analysis, design, development and implementation of Data warehouses, Data marts and Decision Support Systems DSS involving RDBMS like Oracle, and MS SQL server.
• Experience in various stages of System Development Life Cycle including Design, Development, Maintenance and Testing in Pharmaceutical, Insurance, Finance and Healthcare sectors
• Managed data extraction for ETL Data warehouse and applied the transformation rules as necessary for data consistency
• Excellent understanding on full software development life cycle SDLC of ETL process including requirement analysis, design, development, support of testing and migration to production.
• Extensively used ETL methodology for supporting of Extract, Transform, and Load environment using Informatica Power Center.
• Experienced in implementing the business rules by creating transformations Expression, Aggregate, Unconnected and Connected Lookup, Router, Update Strategy, Filter, Joiner, Union, SCD's Type1,Type2,Type3 , and developing Mappings.
• Good understanding of Data warehousing concepts and Dimensional modeling Star schema and Snowflake schema .
• Extensively worked on Data Extraction, Transformation, Loading with Oracle, SQL Server, Flat File and DB2 using Informatica Power Center 9.x/8.x/7.x/ 6.x.
• Proficient in coding with SQL, PL/SQL Procedures, Functions, Triggers, Packages using TOAD, SQL PLUS and iSQL Plus as an interface with the database.
• Extensively worked on Performance Tuning of mappings and sessions.
• Experience with UNIX shell script for Automation of ETL Data transfer need.
• Expertise in implementing complex business rules using different transformation, mapplets and worklets.
• Experience in logical/physical data models and Forward/Reverse Engineering using ERwin.
• Hands on experience in identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions.
• Experience on Debugger to validate the mappings and gain troubleshooting information about data and error conditions.
• Designed and published visually rich and intuitively interactive Tableau workbooks and dashboards for executive decision making.
• Good experience in shell scripts for Informatica pre post session operations.
• Excellent analytical, problem solving skills and a motivated team player with excellent inter-personal skills and familiar with offshore and multi-site development.

Technical Skills

Professional Experience

Confidential

Role: ETL Developer

Responsibilities:

• Performance tuning done by executing the execution plan of long running queries. Also created partitions on the basis of transaction data to improve performance.
• Experience in writing shell scripts to automate and schedule data ingestion. Good Shell scripting experience.
• Actively involved in designing, developing types of transformations in mappings, mapplets using Informatica and loading the data into data warehouse tables.
• Interacted with business community and gathered requirements based on changing needs. Incorporated identified factors into Informatica mappings to build Data Warehouse.
• Developed mappings to extract data from flat file and load into Data warehouse using the Mapping Designer.
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Warehouse.
• Developed Slowly Changing Dimensions for Type 1 SCD and Type 2 SCD
• Written Queries, procedures, created Indexes, primary keys and data bases testing.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
• Designed reusable transformations and shortcuts to share different mappings
• Developed, tested Store procedures, Functions and packages in PL/SQL for Data ETL
• Developed shell scripts for job scheduling and logging.
• Identified sources, targets, mappings and sessions and tuned them to improve performance
• Actively participated in data base testing like checking the constraints, correctness of the data, stored procedures, field size validation, etc
• Used command line mode to embed pmcmd commands in to shell scripts and used pmcmd, pmrep commands in Interactive mode to access repository and workflows.

Environment:Oracle,InformaticaPower Center 9.5.1, Informatica Data Quality 9.5.1, UNIX, PL/SQL, Windows 7, ERWIN, Toad.

Confidential

Role: Informatica Developer

Responsibilities:

• Created Dimension Tables and Fact Tables based on the warehouse design.
• Involved in creating Logical and Physical design of databases using Erwin.
• Participated in build of the Data Warehouse, which includes the Design of Data mart using Star Schema.
• Created ETL detail design document and ETL standards document.
• Created Repository using Informatica Power Center Repository Manager.
• Extracted data form flat files and oracle database, applied business logic to load them in the central oracle database.
• Involved in Extraction, Transformation and Loading ETL Process.
• Created necessary Repositories to handle the metadata in the ETL process
• Worked extensively with complex mappings using expressions, aggregators, filters, lookup and procedures to develop and feed in Data Warehouse.
• Worked on Mapplets, shortcuts and reusable transformations
• Informatica Workflow Manager used to create Workflows, database connections, sessions, and batches to run the mappings.
• Created reusable transformations and Mapplets and used them in mappings.
• Worked on SQL queries and tuned them to improve performance.
• Extensively used Shell scripts to automate the Pre-Session and Post-Sessions processes.
• Performed data manipulation using basic functions and Informatica Transformations.
• Designed developed reports, Drilldown reports using Business Objects Reporter.
• Designed reports with Slice and Dice Drill down operations.

Environment: Informatica Power Center 9.1.5, Informatica Power Exchange, Oracle 11g, PL/SQL, SQL Server, DB2, , Clear Case, Erwin, Business Objects Info view, Windows, UNIX.

Confidential

Role: Informatica Developer

Responsibilities:

• Worked with Source Analyzer, Data warehousing designer, Mapping Designer Mapplet, and Transformations.
• Created Informatica mappings with various transformations to build business rules to load data and to transform the existing processes that were using Java into Informatica processes.
• Created various transformations like Joiner, Aggregate, Expression, Lookup, Filter, Union, Update Strategy, Stored Procedures, and Router etc. and Fine-tuned the mappings for optimal performance.
• Created Data Breakpoints and Error Breakpoints for debugging the mappings using Debugger Wizard.
• Created Informatica mappings for data conversion processes and scheduled the processes to run on every Sunday until the data is converted.
• Used Mapping Designer to join tables from various databases like Oracle, SQL Server and DB2.
• Worked with the Informatica Scheduler for scheduling the delta loads and master loads.
• Extensively used SQL Override, Sorter, and Filter in the Source Qualifier Transformation.
• Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.
• Implemented various new components like increasing the DTM Buffer Size, Database Estimation, Incremental Loading, Incremental aggregation, Validation Techniques, and load efficiency.
• Extensively used Triggers, Stored Procedures and Functions in Interaction with backend database using PL/SQL.
• For better performance, created pipeline partitions, SQL Override in source qualifier.
• Worked extensively with the business intelligence team to incorporate any changes that they need in the delivered files
• Adopted Agile/Extreme programming practices with the objective to increase client value code reviews to ensure consistency and quality.

Environment: Informatica Power Center 9.0.1/ 8.6.1, Erwin 7.1, MS SQL server 2005/2008, Oracle 11g/10g, DB2, Unix, Windows XP, Autosys

Confidential

Informatica Developer

Responsibilities:

• Worked with Business analysts and the DBA for requirements gathering, business analysis and designing and participated document review meetings.
• Involved in the team during the entire ETL process and development of data marts using Informatica PowerCenter 8.6.1.
• Implemented Slowly Changing Dimensions methodology Type-II and I to keep track of historical data.
• Designed and developed Star Schema and created Fact and Dimension Tables for the Warehouse using Erwin
• Extracted the data from Oracle11g/10g, XML, Flat files load the data in to Oracle data warehouse.
• Worked on Informatica Power Center tools - Source Analyzer, Target designer, Mapping Designer, WorkflowManager, Mapplet Designer and Transformation Developer.
• Used Informatica Designer to create mappings using different transformations to move data to a Data Warehouse. Developed complex mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Source Qualifier, Expression, Lookup, Aggregator, Update Strategy, Joiner, and Rank.
• Responsible for creating different sessions and workflows to load the data to Data Warehouse using Informatica Workflow Manager.
• Created Reusable transformation and Mapplet based on the business rules to easy the development process and responsible for document the changes.
• Maintained and modified mappings as per changing reporting requirements.
• Extensively worked on the performance tuning of the Mappings as well as the sessions.
• Checked Sessions and error logs to troubleshoot problems and also used Debugger for complex Problem troubleshooting
• Developed Informatica mappings/sessions/workflows for ETL processing and used UnixShellScripts for smooth application interfacing.
• Involved in identifying the bottlenecks in Sources, Targets Mappings and accordingly optimized them.
• Developed Segment Value Detail, Work Order Detail and OGA Repositories RPD by importing metadata into Physical Layer, applied Business rules in the Business Modeling and Mapping layer and created customized user views in the Presentation layer
• Involved in Unit and System testing of developed mappings.
• Written Detail design documentation to describe program development, logic, coding, testing, changes and corrections.

Environment:Informatica Power Center 8.6.1/8.1.1, Oracle 10g, TOAD 10.1 for Oracle, DB2, Flat Files, PL/SQL, ERWIN 7.3, Windows 2000, UNIX shell scripting, Autosys

Confidential

Role: ETL Developer

Responsibilities:

• Worked with business analysts for requirement gathering, business analysis, and testing and project- coordination.
• Responsible for development, support and maintenance of the ETL Extract, Transform and Load processes using Informatica Power Center.
• Developed an ETL Informatica mapping in order to load data into staging area. Extracted from flat files and databases and loaded into Oracle 10g target database.
• Designed Mapping document, which is a guideline to ETL Coding.
• Created mappings using the transformations like Source Qualifier, Aggregator, Expression, Look Up, Router, Filter, Update Strategy, Joiner, Sequence Generators and Stored Procedure
• Worked with various Informatica Power Center tools Source Analyzer, Target designer, Mapping Designer Mapplet, Transformations.
• Used Slowly Changing Dimension Mappings of type I.
• Created reusable transformations and Mapplets and used them in complex mappings.
• Wrote Stored Programs Procedures Functions to do Data Transformations and integrate them with Informatica programs and the existing application.
• Used Workflow Manager for Creating, Validating, Testing and Running the sequential and concurrent Batches and Sessions, scheduled them to run at a specified time.
• Used mapping Parameters and Variables.
• Worked on Parameterize of all variables, connections at all levels in Window NT.
• Created Sessions, Worklets and Workflows for carrying out test loads.
• Analyzed Session log files to resolve errors in mapping and managed session configuration.
• Created, configured, scheduled and monitored the sessions and workflows on the basis of run on demand, run on time using Informatica Power Center Workflow Manager.
• Involved in migrating the ETL application from development environment to testing environment.
• Documented and presented the production/support documents for the components developed, when handing-over the application to the production support team.
• Prepared ETL standards, Naming conventions and wrote ETL flow documentation for Stage and ODS.
• Experienced in writing complex reporting using sql performance tuning and providing operational support for OLTP and OLAP applications.

Environment:Informatica Power Center 7.1, Oracle10g, SQL Server 2008, TOAD, Linux, Windows XP.