SUMMARY:

• Over 8.5 years of IT industry experience in Informatica/OWB/PLSQL/SQL Server.
• Worked with various types of sources like (Flat files, Tables (Oracle, SQL Server and MySQL) and External tables.
• Expertise on Slowly Changing Dimensions Type 1, Type 2 and Type 3 for inserting and updating Target tables for maintaining the history.
• Designed and developed complex Informatica mappings using different transformations like Expression, Connected & Unconnected Lookups, Update Strategy, Filter, Router, Sequence Generator, TCL (Transaction control transformation), Sorter, Rank, Normalizer, Mapplet and Aggregator.
• Well acquainted with Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer.
• Created Mapping parameters and mapping variables for incremental load.
• Implemented session partitioning in Informatica to improve the performance.
• Migrated Informatica code (Deployment) to different environments.
• Implemented Informatica development strategies and used Target Load Plan, Constraint based loading, partitioning, performance tuning the existing mappings. Used Debugger to test the mappings and fixed the bugs.
• Witten UNIX Shell Script for moving files to remote location (SFTP), archiving the files (Post load) and for creating source indirect load (preload).
• Written Unix Shell Script for scheduling, restarting Normal and concurrent Workflows. Used UNIX commands like grep, sed, cut, WC, tar, mget and mput.
• Provided production support for the applications that have gone Live.
• Developed PLSQL Stored Procedures, PLSQL Functions and other database objects like External tables, Views, Indexes, DB links, Synonyms and Sequences.
• Used oracle analytic functions like Listagg, Rank, Dense Rank, Row number,
• Pivot and Unpivot. Used WITH clause to simply the complex query.
• Wrote pre-session and post-session PLSQL stored procedures to disable the indexes and enable the indexes and constraints.
• Written Unit Test Cases and Involved in System Integration Testing (SIT).
• Strong analytical skill, able to work independently.
• Work with the business team in the requirements walkthrough for the projects SRS

SKILL SET:

ETL Tools: Informatica power center 8.6.1/9.5.1 , Informatica Power Exchange, Oracle Warehouse Builder (OWB) 11.2, SSIS.

RDBMS: Oracle 10g/11G, Mysql 7.3, SQL Server 2008.

Languages: Unix Shell Scripts, Oracle SQL, Oracle PL/SQL.

Utilities: Toad, SQL Developer, Winscp, SVN Tortoise, Putty, Jira, Toad for Mysql.

Automation Tools/Schedulers: Crontab, Tidal and Informatica scheduler

PROFESSION EXPERIENCE:

Confidential, San Ramon, CA

Environment: Informatica Power centre 9.5.1, Oracle 10g, PL/SQL, JIRA, UNIX

ETL Developer

Responsibilities:

• Modified the existing Informatica mappings and Workflows based on Business Requirements.
• Created new Informatica mappings and Workflows (for ZOOT project) based on Business Requirements.
• Worked on the oracle procedures and UNIX shell scripting.
• Developed stored procedure for creating the DB partitions to load daily data.
• Worked on ETL batch process framework.
• Worked on Informatica health checks (Data validations).
• Written/Modified complex oracle sql queries using the WITH clause, Case for conditional
• Checks, Rank and Dense Rank.
• Worked closely with BSA to created ETL runbook and created implementation plan for Production deployment.
• Fixed special character issues by changing the code pages and fixed the line feed and Carriage return.
• Used various Transformations like Source Qualifier, Lookup Expression, Filter, Router, Connected Stored procedure and Unconnected Stored Procedure, SQL transformation (Script and Query Mode, Mapplet and Update strategy in the Mapping development.
• Used Mapping parameters, Mapplet parameters with (overrideMpltVarWithMapVar) and Without customized Properties and Mapping variables.
• Written Test cases for new code and modified code (including regression testing).

Confidential

Environment: Informatica Power centre 9.5.1, Oracle 10g, PL/SQL, JIRA, UNIX

Sr Informatica Developer

Responsibilities:

• Developed Informatica mappings and Workflows based on user requirements.
• Used mapping parameter and mapping variables to load incremental data.
• Used various Transformations like Source Qualifier, Connected Lookup, Sorter, Rank, Unconnected Lookup, Expression, Filter, Normalizer, Router and Update strategy in the mapping development.
• Created PLSQL stored procedure for implementing business logic using dynamic sqls (Execute Immediate) and list aggregate function.
• Prepared UTC and Test result documents.
• Used Oracle cursors with bulk collect and for all statements to improve the performance.
• Used Shell scripts to run the workflows sequentially.

Confidential

Environment: Oracle Warehouse Builder (OWB) 11.2, Oracle SQL and Oracle PL/SQL, TOAD, OBIEE

ETL Developer

Responsibilities:

• Analyze and enhance the business intelligence and data warehousing system and solve the problems raised by the customer within the time.
• Automate many processes to remove manual dependencies.
• Effectively worked with front end reporting team and with the business users to analyze the problem.
• Supporting and monitoring daily loads and performance issues effectively.
• Monitor help desk queues and resolve tickets.
• An ability to balance multiple time-critical tasks at the same time.
• Validated the data in reports using OBIEE.

Confidential

Environment: Informatica Power centre 8.6.1, Oracle 10g, PL/SQL, Address doctor, UNIX

Informatica Developer

Responsibilities:

• Developed Informatica mappings and Workflows based on user requirements.
• Used mapping parameter to load incremental data.
• Used Delimited Flat files.
• Used various Transformations like Source Qualifier, Connected Lookup, Unconnected Lookup, Expression, Filter, Normalizer, Router and Update strategy in the mapping development.
• Prepared UTC and Test result documents.
• Used Shell scripts to run the workflows sequentially.
• Used Informatica address doctor for address validation.

Confidential

Environment: Informatica Power centre 8.6.1, Oracle 10g, PL/SQL, SVN, UNIX

Informatica Developer

Responsibilities:

• Developed Informatica mappings, Normal Workflows, Concurrent Workflows based on user requirements.
• Involved in preparing Parameter files dynamically for concurrent workflows.
• Used mapping parameter, Mapping Variables, workflow variables, and session parameters.
• Used PLSQL stored procedure using bulk collect for faster retrieval of data.
• Worked on Session, Event Wait, and Event Raise, Command and Decision tasks.
• Used Delimited Flat files (.txt) and Fixed width Flat files.
• Used various Transformations like Source Qualifier, Connected and unconnected Lookup, Aggregator, Expression, Filter, Normalizer, Router, Connected, Unconnected stored procedure, Transaction control and Update strategy in the mapping development.
• Prepared UTC and Test result documents.
• Used Shell scripts to Schedule concurrent workflows, Restart Workflows and Archive files.
• Used SFTP, SCP commands to transfer Files.
• Implemented Pipeline partitioning to improve the Session performance.
• Used analytical functions like Rank and Row number.
• Used stats to increase table performance.
• SVN Tortoise tool to baseline the code.

Confidential

Environment: Informatica Power centre 8.6.1, Oracle 9i, PL/SQL, SQL Server, UNIX

Informatica Developer

Responsibilities:

• Developed Informatica Mappings and Sessions based on user requirements and business rules to load data from source oracle to target SQL Server.
• Worked on various Transformations like Source Qualifier, Connected and unconnected Lookup, Aggregator, Expression, Filter, Joiner, Sequence generator, Router, Union and Update strategy in the mapping development.
• Worked on Session tasks.
• Used Global Session variables to load the data
• Prepared UTC and Test result documents.