SUMMARY

• Over 4 years of strong experience in Analysis, Design and Development of Business Intelligence Solutions in Data Warehousing using Informatica PowerCenter 9.5/9.1/8.6 as an ETL tool on Windows and UNIX based operating systems.
• Have developed complex ETL solutions using the Informatica Powercenter utilities Workflow Manager, Workflow Monitor, Repository Manager & Designer (Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, and Transformation Developer)
• Significant experience with Data Extraction, Transformation and Loading (ETL) from disparate data sources such as multiple relational databases and also worked on integrating data from flat files, CSV files and XML files into a common reporting and analytical data model.
• Strong understanding of RDBMS concepts and experience in writing PL/SQL and SQL statements in databases.
• Highly proficient in the integration of various data sources involving multiple relational databases like Oracle, MS SQL Server, Teradata, DB2 and non - relational sources like COBOL Files and Flat File.
• Strong understanding of the principles of DW using fact tables, dimension tables and star/snowflake schema modeling.
• Developed complex mappings in Informatica using various transformations Joiner, Aggregator, Update Strategy, Rank, Router, Lookup - Connected & Unconnected, Sequence Generator, Filter, Sorter, Stored Procedure transformation etc.
• Developed slowly changing dimension (SCD) mappings using type-I, type-II, and type-III methods.
• Experience in Trouble shooting and implementing Performance tuning at various levels such as Source, Target, Mapping, Session and System in ETL Process. Have heavily worked on performance tuning long running Informatica mappings using Pushdown optimization and session partitioning.

TECHNICAL SKILLS

ETL/Middleware Tools: Informatica Power Center 9.5.1/9.1.1/8.6.1

Data Modelling: Dimensional Data Modelling, Star Join Schema Modelling, Snow-Flake Modelling, Fact and Dimension tables, Physical and Logical Data Modelling.

RDBMS: Oracle 11g/10g/9i, Netezza, Teradata, DB2, MySql, MS Access.

Programming Skills: SQL, Oracle PL/SQL, Unix Shell Scripting, HTML, DHTML, XML, Java, .Net

Tools: TOAD, SQL Plus, SQL*Loader, Teradata SQL Assistant.

Operating Systems: Windows 8/7/XP Unix-AIX.

PROFESSIONAL EXPERIENCE

ETL/Reporting Developer

Confidential, Richmond, VA

Responsibilities:

• Worked with Informatica Designer, Repository Manager, Repository Server, Workflow Manager/Server Manager and Workflow Monitor.
• Used transformations like Joiner, Expression, Connected and Unconnected lookups, Filters, Aggregator, Store Procedure, Rank, Update Strategy, Router and Sequence generator.
• Documented the developed code, run the sessions and workflows, while keeping track of source and target row count.
• Heavily used the Teradata utilities like MLOAD, FLOAD, TPUMP, FASTEXPORT, TPT and BTEQ for improving the load performance in Teradata.
• Created workflows containing command, email, session, decision and a wide variety of tasks.
• Created mapping document on the approach to be used for the migration of feed generation logic using Informatica Power Exchange and Informatica PowerCenter
• Analysed business requirements and prepped the design documents.
• Reviewed the design and requirements documents with architects and business analysts to finalize the design.
• Created Database Design Document for SQL server Database tables which will be further used by DBA’s to create the tables.
• Performed Unit and regression testing for the Application.
• Handled User Acceptance Testing (UAT) with the downstream feed users for validation of feeds.
• Developed the manual test cases based on the test scenarios.
• Tested the behaviour of Dashboards and reports.
• The test cases were executed and results logged in MS excel

Environment: Informatica PowerCenter 9.5.1, Oracle 11g, SQL server 2012, XML files, Sql developer, PL/SQL, Teradata, Unix.

ETL Informatica Developer

Confidential

Responsibilities:

• Involved in translating business requirements to integrate into existing Datamart design.
• Developed ETL jobs to extract information from Enterprise Data Warehouse.
• Extensively used ETL to load data from different relational databases, XML and flat files.
• Used ETL, Informatica Repository Manager to create repositories and users and to give permissions to users.
• Debugged the mappings extensively, hard coding the test data ids to test the logics going instance by instance.
• Performed various transformations, aggregations and ranking routines on the data to be stored in the application reporting mart.
• Handle the Migration process from Development, Test and Production Environments.
• Implemented Type 2 slowly changing dimensions to maintain dimension history and Tuned the Mappings for Optimum Performance.
• Used ETL, Informatica Designer to design mappings and coded it using reusable mapplets.
• Developed workflow sequences to control the execution sequence of various jobs and to email support personnel.
• Involved in unit testing and documenting the jobs and work flows.
• Set Standards for Naming Conventions and Best Practices for Informatica Mapping Development.
• Used database objects like Sequence generators and Stored Procedures for accomplishing the Complex logical situations.
• Created various UNIX shell scripts for Job automation of data loads.
• Worked on all phases of SDLC from requirement, design, and development and testing.
• Created mappings, which include the Error Handling Logic being implemented to create an error, ok flags and an error message depending on the source data and the lookup outputs.
• Extensively involved in the analysis and tuning of the application code (SQL).Involved in unit testing and system integration testing and preparing Unit Test Plan (UTP) and System Test Plan (STP) documents.
• Worked on Change Requests (CR) while integration testing and UAT are in progress.

Environment: Informatica Powercenter 8.6, Business Objects 6.5.1, Oracle 9i, SQL*Plus, Toad, Windows 2000, SQL Server 2000, PL/SQL, UNIX.