Summary

• 6 years of IT experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.
• 6 years of proficient experience in different Databases like Oracle, SQL Server, and DB visualizer.
• Extensive experience in Extraction, Transformation and Loading ETL of data from multiple sources into Data warehouse using Informatica.
• 6 years of extensive ETL experience using Informatica Power Center 9.5/9.1/.
• Over 2 years of Experience in Dimensional Data Modeling using Star and Snow Flake Schema using Erwin7.1/4.5.
• Over 1 year of experience in developing real-time data warehouse using Power Exchange.
• Experience in Performance Tuning of sources, targets, mappings, sessions.
• Proficiency in data warehousing techniques for Slowly Changing dimension, Surrogate key assignment and change data capture.
• Experience in Integration of various relational and non-relational sources such as Oracle Tables, SQL Server Tables, MQ Series, Flat files XMLs, .csv, web services, Data Analysis and Modeling.
• Worked on Slowly Changing Dimensions type 1 and type 2 designs and development.
• Experience in Oracle PL/SQL Programming Stored procedures, Triggers, Functions, Packages and tuned queries and VBA, T-SQL and Agile Scrum Methodology.
• Worked on UNIX shell scripting to create job to schedule workflows, trigger various jobs to purge session log, ftp files, archive source files etc.
• Worked with Teradata loading utilities like Multi Load, Fast Load, TPump and BTEQ.
• Good experience in documenting the ETL process flow like ETL designs doc, UTC doc. Create run book for better maintenance and analyzing the production process flow. Have knowledge of Data Stage, DAC and Informatica DVO.
• Demonstrated ability to take initiatives, grasp and expand on ideas, tackle and follow through assignments in the fast-pace and changing environment.
• Independent yet team oriented with excellent analytical, problem solving, multi-tasking, oral and written communication skills.
• Prefer to work as pro-active person and like to help other employees as much as possible.
• Self-starter team player with pleasing personality.
• Adapt to learn new technology and inclined to fast changing Mobile applications.

TECHNICAL SKILLS

• ETL Tools : Informatica Power Center 9.5/9.1/8.x/7.1
• CDC tool : Informatica Power Exchange 9.1/8.6
• Databases : Oracle Exadata/11g/10g/9i, DB2, MS SQL Server 2008/2005, Teradata 13/12 V2R5
• Data modeling tools : ERWIN 7.5/4.x, Microsoft Visio.
• Languages : SQL, PL/SQL, UNIX Shell scripts.
• Development Tools : SQL Plus, TOAD, SQL Navigator, SQL Developer
• Operating Systems : Windows XP/NT, UNIX, LINUX, MS-DOS

PROFESSIONAL SUMMARY:

Sr. Informatica Developer

Responsibilities:

• Develop technical requirement of ETL to transfer data from source files and load the data into the target Database.
• Developed Mappings Workflows as per Business logic, quality and coding standards prescribed for the module.
• Enhanced complex mappings using connected unconnected lookups, Source Qualifier, Router, Filter,
• Expression, Aggregator, Joiner, sequence generator, Update Strategy, SQLT Transformations, mapplets to implement the business logic and load the data incrementally.
• Extracted the data from the flat files into staging area and populated onto Data Warehouse.
• Worked on optimizing the mappings by creating re-usable transformations and Mapplets.
• Handled slowly changing dimensions of Type1, Type2 to populate current and historical data to dimensions and fact tables in the Data Warehouse.
• Analysis of Data Quality to determine cleansing requirements. Responsible for apply the business
• Rules using mappings. Understand the business requirements and implement the same into a functional database design.
• Analyzed the Performance Tuning at the Mapping, Session, and workflow Level to perform and get best output of Data Loads.
• Prepared Unit Test Plan UTP documents for all the test cases for the developed mappings at Stage load and Data warehouse load.
• Worked on various existing mapping to improve the performance and reduce the runtime duration of it.
• Created matrix-sheet of mapping and workflow runtime periods so, can analyze and increase the quality of mapping.
• Worked on Tidal to identify the jobs runtime duration as well as to find out the data caching problems in mappings.
• Created Code review checklist, Technical Design Documents as well as DLD.

Environment: Environment: Informatica Power Center 9.5.1/9.1, SQL Developer 3.2, Oracle 11g, Winscp, Wincvs, Flat files, MS Access, MS Visio, Teradata 14, DB2, UNIX Shell Scripting, PL/SQL, SQL,Toad 7.0, Erwin 7.5.

Confidential

Role: Sr. Informatica Developer

Responsibilities:

• Participated in business analysis, ETL requirements gathering, physical and logical data modeling and documentation.
• Worked as a Scrum Master and manage: Stand-ups, Backlogs, sprint Planning Meetings.
• Doing self and peer review for Informatica and oracle objects.
• Designing the data transformation mappings and data quality verification programs using Informatica and PL/SQL.
• Designed the ETL processes using Informatica to load data from Mainframe DB2, Oracle, SQL Server, Flat Files, XML Files and Excel files to target Teradata warehouse database and testing of data.
• Designed Reusable Transformations, Mapplets, and reusable Tasks and designed Worklets as per the dependencies of various sessions and parent-child tables.
• Worked on performance tuning of Informatica code. Extensively work on customization of cache, partitioning, push down optimization and transformation tuning.
• Investigate, debug and fix problems with Informatica Mappings and Workflows.
• Implemented Slowly Changing Dimensions - Type I II.
• Performing ETL database code migrations across environments.
• Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables.
• Participated in Decision support team to analyze the user requirements and to translate them to technical team for new and change requests.
• Performed unit and integration testing in User Acceptance Test UAT , Operational Acceptance Test OAT , Production Support Environment PSE and Production environments.

Environment: Informatica Power Center 9.1, Informatica Power Exchange 9.1, Oracle 11g, UNIX Shell Scripting,

SQL, PL/SQL, TOAD, MS Access, MS Visio, Autosys, Teradata 14, Utilities BTEQ, FLOAD and

TPUMP, Putty, Winscp, DB2 Mainframe, Linux, Basecamp, SCM.

Confidential

Role: ETL Developer

Responsibilities:

• Involved in designing the process for getting the data from various systems to Data Warehousing system.
• Created High Level design doc, ETL design doc and Test Case for unit testing and Integration testing. Also created accurate and detailed requirement specifications documents, user interface guides, and functional specification documents. Handling offshore team.
• Involved in requirement gathering, analysis also data modeling and design of various modules.
• Responsible for studying the existing data warehouse and also working on migrating existing PL/SQL packages, stored procedures to Informatica PowerCenter.
• Working with business and functional teams.
• Jobs for scheduler and to check hanging real-time workflows and Pre-session and Post-session shell scripts, Email tasks and various other applications.
• Developed various Informatica mappings and mapplets using complex transformations like Aggregators, lookups, Filters, Sequence Generator, Normalizer, Update strategy and stored procedure transformations.
• Implemented slowly changing dimension Type 1 and Type 2.
• Involved in Performance tuning and elimination of bottlenecks for better performance.
• Responsible for Creating workflows and worklets. Created Session, Event, Command, Control, Decision and Email tasks in Workflow Manager.
• Developed test case for unit, System integration and User Acceptance testing of ETL Process.
• Creation of different types of reports, such as Master /Detail, Cross Tab and Chart for trend analysis using Business objects.

Environment: Informatica Power Center 9.1, Informatica Power Exchange 9.1, Oracle Exadata, Mainframe, SQL,

PL/SQL, OBIEE 11g, Windows 7, Erwin 7.5, Sun Solaris.

Confidential

Role: ETL Developer

Responsibilities:

• Analyzed functional specifications and identified the source data that needed to be moved to data warehouse.
• Participated in the Design Team and user requirement gathering meetings as offshore team.
• Extracted data from various sources to extract data from flat files, XML, MQ and relational tables for Informatica Power Center.
• Created stored procedures, packages, triggers, tables, views, synonyms, and test data in Oracle
• Used most of the transformations such as the Aggregators, Filters, Routers, Sequence Generator Update Strategy, Rank, Expression, lookups connected and unconnected , Mapping Parameters, Session parameters, Mapping Variables and Session Variables.
• Identified and created various Informatica reusable transformations, UDFs, mapplets, tasks and worklets.
• PL/SQL packages, stored procedures, triggers and functions to Informatica PowerCenter.
• Created Power Exchange Registration for CDC on DB2 mainframe tables, created Data Map to extract data from file on mainframe.
• Wrote the shell scripts to process the jobs for scheduler and to check hanging real-time workflows and Pre-session and Post-session shell scripts, Email tasks and various other applications.
• Worked with different types of partition techniques like key range, pass through, Round Robin and Hash partitioning and implemented slowly changing dimension Type 1 and Type 2 in the logic.
• Fine tuned ETL processes by considering mapping and session performance issues.
• Responsible for Creating workflows and worklets. Created Session, Event, Command, Control, Decision and Email tasks in Workflow Manager.
• Extracted source data from Oracle, Flat files using Informatica, and loaded into target Database.
• Involved in Unit testing, User Acceptance testing to check whether the data is loading into target.

Environment: Informatica Power Center 8.6, Informatica PowerExchange 8.6. DB2 Mainframe, Oracle 10g,

MS SQL server 2000, UNIX, and Windows XP, SQL/PL SQL, Teradata 12

Confidential

Role: ETL Developer

Responsibilities:

• Created requirement specifications documents, user interface guides, and functional specification documents, ETL technical specifications document and test case.
• Worked with offshore team.
• Extraction, Transformation and Loading of the data using Informatica.
• Designed the target load process based on the requirements documents.
• Enhancing the existing mappings where in the changes is made to the existing mappings.
• Testing and debugging the Enhanced mappings.
• Develop Mappings and Workflows to generate staging files.
• Develop Mappings and Workflows to load the data into Oracle tables.
• Developed various transformations like Source Qualifier, Update Strategy, Lookup transformation, Expressions and Sequence Generator for loading the data into target table.
• Created Workflows, Tasks, and database connections using Workflow Manager.
• Developed complex Informatica mappings and tuned them for better performance.
• Created sessions and batches to move data at specific intervals on demand using Server Manager.
• Responsibilities include creating the sessions and scheduling the sessions.
• Recovering the failed Sessions and Batches.
• Involving in extracting the data from Oracle and Flat files.
• Implemented performance tuning techniques by identifying and resolving the bottlenecks in source, target, transformations, mappings and sessions to improve performance Understanding the Functional Requirements.
• Extensively worked in the performance tuning for mappings and ETL procedures both at mapping and session level.
• Developing, Testing and debugging the mappings in Informatica. Data validation testing.

Environment: Informatica Power center 8.1, Oracle 10g, Putty, Harvest, Oracle SQL Plus, TOAD, PL/SQL