Summary:

• Over 6 years of IT experience in Analysis, Development and Testing in Data warehousing and Database related projects.
• 5 years of experience with ETL tool - Informatica PowerCenter 9.x, 8.6 using its clients- Designer, Workflow Manager and Workflow Monitor.
• Experience working with Flat files, Oracle, SQL Server and COBOL files.
• Extensive experience in debugging mappings by analyzing the data flow and evaluating transformations.
• Experience working with Transformations like Source Qualifier, Filter, Lookup connected and unconnected , Expression, Router, Aggregator, Sorter, Normalizer, Joiner, Update Strategy, Stored Procedure, Union, Sequence Generator.
• Experience in Error Handling Options and Techniques in Informatica PowerCenter.
• Worked on Performance Tuning, identifying and resolving performance bottlenecks at various levels like sources, targets, mappings and sessions.
• Usage of Informatica command line utility pmcmd to execute Workflows in non-windows environment.
• Experience in using scheduling tool Informatica Scheduler to automate running of Workflows according to the business needs.
• Experience in basic UNIX operation, Shell Scripting, SQL and PL/SQL.
• Exposure about Slowly Changing Dimension and Change Data Capture concepts.
• Good understanding of Data Modeling Concepts Logical Data Modeling, Physical Data Modeling, Normalization, Dimensional Data modeling with Star schema or Snowflake schema.
• Quick learner with an ability to adapt to various environments and good communication.

Technical Skills:

ETL Tools: Informatica PowerCenter 9.5/9.1/8.6

Work Experience:

Confidential

Informatica Developer

Job Responsibilities:

• Design, Development, Testing and Documentation of the ETL Extract, Transformation Load strategy to populate the Staging area from the various source systems.
• Redesign of some existing Mappings in the system to meet new functionality.
• Design and development of Mappings using Parameters, Variables and Parameter Files.
• Involved in performance tuning by identifying and resolving bottlenecks at source, target and transformations.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
• Worked with DBA to create indexes on tables used in source qualifier SQL query.
• Preparation of unit test cases and its execution.
• Involved in Post-Implementation Production Support and assisted the Production Support Team in resolving issues and bugs.

Environment: Informatica PowerCenter 9.5, UNIX, Oracle 10g, SQL, PL/SQL, Toad for Oracle, putty.

Confidential

ETL Developer

Job Responsibilities:

• Analysis of the source data coming from Oracle, Flat Files and MS SQL Server.
• Performed direct and indirect flat file loading.
• Developed flexible mappings/sessions using Parameters, Variables and Parameter files.
• Optimized performance by tuning the Informatica mappings.
• Performed unit testing and documented the results.
• Worked closely with QA team during the testing phase and fixed bugs that were reported.

Environment: Informatica PowerCenter 9.1, UNIX, Oracle 10g, Toad 9.6, SQL Plus, PL/SQL, Flat files, MS SQL Server.

Confidential

Informatica Developer

Job Responsibilities:

• Sources mapped to External Tables and imported these external tables into Source Analyzer and also in Lookups.
• Developed mappings, sessions and workflows as per the design documents.
• Identified complex joins for the development of Views and invoked these Views in process through mappings.
• Maintained different versions of the mappings, sessions and workflows using Informatica version control mechanism.
• Involved in unit testing and documentation of the ETL process.

Environment: Informatica PowerCenter 8.6, UNIX, Oracle 10g, PLSQL, SQL, SQL Loader, Toad for Oracle.

Confidential

ETL Informatica Developer

Job Responsibilities:

• System Study and Understanding the requirements.
• Imported data from various sources transformed and loaded into Teradata data warehouse TDW using Informatica.
• Developed several reusable transformations and mapplets that were used in other mappings.
• Implemented performance tuning to provide efficiency and performance.
• Involved in the preparation of the Unit test cases and its execution.
• Involved in Creating Parameter files and maintaining the same for all environments DEV, CIT, SIT and UAT .

Environment: Informatica PowerCenter 8.6, Oracle 10g, SQL, Teradata, UNIX, Shell Scripting and Putty

Confidential

Informatica Developer

Job Responsibilities:

• Responsible for developing, support and maintenance for the ETL Extract, Transform and Load processes using Informatica PowerCenter.
• Developed mappings to extract data, transform and load into EDW as per the business requirements.
• Involved in extracting data from Oracle, Flat files and COBOL files.
• Used Workflow Manager for creating, validating, and running the Workflows and Sessions and scheduling them.
• Scheduled Informatica Workflows to execute on a timely basis as per the business requirement.
• Developed stored procedures, cursors, triggers, functions in PL/SQL.

Environment: Informatica PowerCenter 8.6, Flat files, COBOL files, Oracle 10g/9i, SQL, PL/SQL, Toad for Oracle and UNIX.

Confidential

Informatica/Oracle Developer

Job Responsibilities:

• Extracted data from Oracle, Fixed width and Delimited Flat files transformed the data according to the business requirement and then loaded into Oracle database.
• Modified several of the existing mappings and created new mappings based on the user requirement.
• Used debugger to evaluate mappings by analyzing data flow.
• Developed PL/SQL functions for ratio calculations and incorporated these functions in stored procedures to call in mapping to derive the Quantitative calculations.
• Involved in Unit Testing and preparation of necessary documents like Unit Test document.
• Involved in testing support and bug fixes.

Environment: Informatica PowerCenter 8.6, Oracle 9i, PLSQL, SQL and Toad for Oracle.