Informatica Developer

Sarathbabu Email: **********@*****.*** Cell: 703-***-****

PROFESSIONAL SUMMARY:

Over 12 years of experience in managing the Application Software development, Maintenance and

•

Production Support

Over 8 years of experience with Informatica Power Center/Power Exchange 9.x/8.x/7.x & Informatica

•

IDQ/IDE ( Data Quality) for developing Data warehousing, Conversion, Migrations & Integration projects.

Experienced with all phases of Software Development Life Cycle (SDLC) such as developing, testing,

•

migrating, administrating, and production supporting on various platforms like UNIX, Window XP/7.

Experience in the concepts of building Fact Tables, Dimensional Tables, handling Slowly Changing Dimensions

•

and Surrogate Keys.

Experience in OLAP tools such as Business Objects, Crystal Reports (Designer and Reporter).

•

Working experience on JIRA to monitor, track and fix bugs and defects on the workflows.

•

Involved in Unit Testing, Integration testing and QA Validation.

•

Excellent communication skills with strong work ethics and have consistently demonstrated strong

•

teamwork.

Able to work effectively at all organizational levels and have an ability to manage rapid changes.

•

Good Knowledge of DQ standard, Data Profiling guide lines and best practices

•

Working experience on JIRA to monitor, track and fix bugs and defects on the workflows.

•

EDUCATION

Masters in Computer Science, INDIA ( 1997- 1999)

•

TECHNICAL ENVIRONMENT:

ETL Informatica Power Center 9.5/9.1/8.6/8.1/7.1/6.2,Power Mart 6.2/5.1.2/5.0,Power

Exchange – SAP 9.5/9.1/8.6, Data Quality 9.5/9.1

Databases Oracle 11i/10g/9i/8i/7i, MS SQL Server 6.5/7.0.2000, MS Access 7.0/2000, Teradata

LANGUAGES/WEB: PL/SQL, SQL*Plus, Java, Perl, Shell Scripting, Unix K Shell Scripting.

Operating System Microsoft Windows XP/2000/NT, Linux, IBM AIX, UNIX.

Tools FileMozilla, UltraEdit and Tidal Scheduler

PROFESSIONAL EXPERIENCE:

Informatica Consultant

Title

Devon Energy

Client

Work Location Oklahoma City

June 2013 to Till Date

Duration

Informatica 9.x Hot fix 3, Toad 9.7, Oracle 11i,,SQL server, Flat files, SQL/PLSQL, UNIX

Environment

shell scripting, Windows XP, Tidal 5.X

• Working with PowerCenter client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet

Designer and Transformation Developer.

• Designed and developed standard re usable mapping, transformation logic and processes in Informatica for

implementing business rules and standardization of source data from multiple systems into the data warehouse.

• Used ETL to extract and load data from Finance tables and flat files to Oracle.

• Used Lookup Transformation to access data from tables, which are not the source for mapping and also used

Unconnected Lookup to improve performance.

• Designing tables, primary and foreign keys to enforce referential integrity, design views, writing stored

procedures, packages and functions.

• Involved in Design and complex Business Rules which could not be enforced by Integrity Rules

• Designed the ETL processes using Informatica tool to load data from Legacy systems into the target Oracle

database.

• Developed mappings in Informatica Powercenter to load the data from various sources.

• Used Informatica power exchange to change data capture option to capture the updates to the existing data.

Title Informatica Analyst

Costco /Accenture

Client

Seattle, WA

Work Location

Duration October 2012 to June 2013

Informatica 9.1.0 Hot fix 3, Toad 9.7, Oracle 11i, SQL server, Flat files, SQL/PLSQL, UNIX

Environment

shell scripting, Windows XP.

Responsibilities:

• Working with PowerCenter client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet

Designer and Transformation Developer.

• Designed and developed standard re usable mapping, transformation logic and processes in Informatica for

implementing business rules and standardization of source data from multiple systems into the data warehouse.

• Used ETL to extract and load data from Finance tables and flat files to Oracle.

• Created complex Informatica mappings to load the data mart and monitored them. The mappings involved

extensive use of transformation like Filter, Router, Expression, and Sequence Generator.

• Used Lookup Transformation to access data from tables, which are not the source for mapping and also used

Unconnected Lookup to improve performance.

• Defined Target Load Order Plan and Constraint based loading for loading data correctly into different target

tables.

Title ETL Developer

Client IFC, World Bank Group

Washington DC

Work Location

Duration Aug 2008 to October 2012

Informatica 9.1.0 Hot fix 3, Powercenter 9.1, Informatica Power Exchange, Toad 9.7, Erwin

Environment

4.2/7.x, Oracle 11i,Teradata,SQL server, Flat files, SQL/PLSQL, UNIX shell scripting,

Pearl Scripting, Windows XP.

Responsibilities:

• Worked on complete SDLC from requirement, design, development, testing, training and rollout to the field user

and support for production environment.

• Worked with PowerCenter client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet

Designer and Transformation Developer.

• Designed and developed standard re usable mapping, transformation logic and processes in Informatica for

implementing business rules and standardization of source data from multiple systems into the data warehouse.

• Used ETL to extract and load data from Finance tables and flat files to Oracle.

• Performed Unit testing of the mappings.

• Developed mappings to load data in slowly changing dimensions.

• Performed Performance Tuning of Sessions and Mappings.

• Designed the ETL processes using Informatica tool to load data from Legacy systems into the target Oracle

database.

• Developed mappings in Informatica to load the data from various sources.

• Used Informatica power exchange to change data capture option to capture the updates to the existing data.

• Functional Lead responsible for identifying and documenting system interfaces, data sources and data objects

with existing legacy application.

• Worked on LLD and HLD to document the requirements, logic, analysis involved in the project.

• Worked on JIRA to track and fix bugs in the code by analyzing the logs in Informatica.

• Created Test plans for Unit testing, User Acceptance testing.

Title ETL Developer(Informatica)

Cummins Inc

Client

Work Location Columbus, Indiana

May 2007 to July 2008

Duration

Environment Oracle 10g, Informatica Power Center 8.6/8.1/7.1, Oracle 10g, Sybase, TOAD, UNIX Shell

Scripts, PL/SQL, WinSCP, Putty.

Responsibilities:

• Liaise with business analysts for need Analysis and to define Business and Functional Specifications.

• Worked with heterogeneous sources from various channels like Sybase, Oracle, Flat files.

• Tested the data and data integrity among various sources and targets. Associated with Production support team

in various performances related issues.

• Created/Modified Informatica ETL mappings in various stages folders like Staging area and production area for

development and production environment that transfers data from Sybase, Oracle Source systems to Oracle

Target system.

• Project required extensive use of PL/SQL Features like Collections, Objects, Object Tables and Nested Tables.

• Designing tables, primary and foreign keys to enforce referential integrity, design views, writing stored

procedures, packages and functions.

• Designed the ETL processes using Informatica to load data from Sybase, Oracle, Flat Files, XML Files and

Excel files to target Oracle Data Warehouse.

• Trouble shooting and problem solving applications with Informatica.

ETL Developer(Informatica/Oracle)

Title

Sony BMG

Client

New York

Work Location

March 2005 to April 2007

Duration

Informatica PowerCenter 8.1/7.1, Oracle 10g, UNIX Shell Scripts, PL/SQL

Environment

Responsibilities:

• Worked on complete SDLC from requirement, design, development, testing, training and rollout to the field user

and support for production environment.

• Worked with PowerCenter client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet

Designer and Transformation Developer.

• Designed and developed standard re usable mapping, transformation logic and processes in Informatica for

implementing business rules and standardization of source data from multiple systems into the data warehouse.

• Used ETL to extract and load data from Finance tables and flat files to Oracle.

• Performed Unit testing of the mappings.

• Developed mappings to load data in slowly changing dimensions.

• Performed Performance Tuning of Sessions and Mappings.

• Created and Monitored Workflows using Workflow Manager and Workflow Monitor.

• Created Relational Connections, migrated the Mappings from Development to Testing and Testing to

Production.

Other Projects :

QSI Systems -Developer KPITCummins, Pune, India May 2003 to April 2005

Contact this candidate