SUMMARY

• Over 5 years of ETL and data integration experience in developing ETL mappings and scripts using Informatica PowerCenter 8.x/9.x
• Experience in working with business analysts to identify study and understand requirements and translated them into ETL code in Requirement Analysis phase.
• Strong knowledge of Entity - Relationship concept, Facts and Dimensions tables, slowly Changing Dimensions and Dimensional Modeling (Star Schema and Snow Flake Schema).
• Experience in integration of various data sources like Oracle, SQL server and non-relational sources like flat files into staging area.
• Experience in creating Reusable Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control).
• Experienced in UNIX work environment, file transfers, job scheduling and error handling.
• Extensively worked on developing and debugging Informatica mappings, mapplets, sessions and workflows.
• Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Worked exclusively on implementing the types of Slowly changing dimensions (SCDs)- Type I II and III indifferent mappings as per the requirements.
• Used the techniques like Incremental aggregation, Incremental load and Constraint based loading for better performance.
• Worked with the flat files in both the direct and indirect methods and also worked with XML files.
• Documenting the mapping process and methodology used to facilitate future development.
• Resolving queries and ensures delivery on-time.
• Excellent analytical and problem solving skills.

TECHNICAL SKILLS

Databases: Oracle 10g/11g, Teradata

ETL Tools: Informatica Power Center 9.x/8.x

Operating Systems: UNIX, Windows

Scheduling Tools: Maestro, ESP, Control-M

Methodology: Agile, Waterfall

Languages: PL/SQL, C, C++

Other Tools: Teradata SQL Assistant, TOAD, SQL Developer

PROFESSIONAL EXPERIENCE

Confidential

ETL Developer

Responsibilities:

• Gather and analyze information on existing business processes in order to make recommendations that seek to improve business systems and processes.
• Created Mapplets, reusable transformations and used them in different mappings
• Created Workflows and used various tasks like Email, Event-wait and Event-raise, Timer, Scheduler, Control, Decision, Session in the workflow manager.
• Made use of Post-Session success and Post-Session failure commands in the Session task to execute scripts needed for clean up and update purposes.
• Identified and tracked the slowly changing dimensions/mini dimensions, heterogeneous Sources and determined the hierarchies in dimensions.
• Used Debugger in Identifying Bugs in Existing Mappings by Analyzing Data Flow, Evaluating Transformations.
• Weekly meeting with the Project Management team and share the Status Report on the weekly basis

Environment: Informatica PowerCenter 9.6.1, UNIX, Toad, Putty, Teradata, Oracle

Confidential

ETL Developer

Responsibilities:

• Analyzing the BRD and HLD and preparing low level design document (Low Technical Specification).
• Extracted source data from Oracle and loaded into Oracle.
• Developing workflows using sessions, command and Email tasks.
• Pre and post session assignment variables were used to pass the variable values from one session to other.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Monitoring the ETL flow and troubleshooting the issues.
• Developed Re-Usable Transformations and Mapplets.
• Taking Care of Pre-Production Activities.

Environment: Informatica PowerCenter 9.5, Oracle, Toad, Putty, Telnet, FTP, Unix, ESP

Confidential

ETL Developer

Responsibilities:

• Interacted with business analysts and translate business requirements into technical specifications.
• Designed and developed end-to- end ETL process from various source systems to staging area, from staging to DataMart.
• Worked on Informatica to extract data from Flat files, Excel files, and MS Access database to load the data into the target database.
• Implemented the Incremental loading of Dimension and Fact tables.
• Created Stored Procedures for data transformation purpose.
• Extensively used Informatica client tools such as Informatica PowerCenter, Workflow Manager, and Workflow Monitor to develop and test ETL processes.
• Created Tasks, Workflows, and Sessions to move the data at specific intervals on demand using Workflow Manager.
• Developed the control files to load various sales data into the system via SQL*Loader.
• Developed Unix Shell scripts for maintaining files.
• Created PL/SQL Stored procedures and implemented them through the Stored Procedure transformation.
• Developed, tested and implemented break/fix change tickets for maintenance.
• Developed the document of the complete ETL process.

Environment: Informatica PowerCenter 9.1, Oracle 8i (SQL/PLSQL), UNIX, Toad, Service Now, UNIX.

Confidential

Associate Developer

Responsibilities:

• Designed, developed Informatica mappings, enabling the extract, transport and loading of the data into target tables.
• Created Workflow, Worklets and Tasks to schedule the loads at required frequency using Workflow Manager.
• Designed and developed Informatica mappings for data loads and data cleansing.
• Created complex mappings using Aggregator, Expression, Joiner transformations including complex lookups, Stored
• Procedures, Update Strategy and others.
• Involved in testing of stored procedures and functions, unit and integrating testing of Informatica sessions, batches and the target data.
• Designed and developed table structures, stored procedures, and functions to implement business rules.
• Extensively involved in migration of ETL environment, database objects and EDW.
• Tested data integrity among various sources, targets and various performance related issues.

Environment: Informatica PowerCenter 8.6.1, UNIX, Toad, Putty, Harvest Version Control, Maestro Scheduling Tool