SUMMARY

• 7+ years of extensive experience in IT as a PL/SQL, Oracle Developer, Netezza Developer with expertise in Design, Development, Testing, Technical Documentation and Support.
• Strong Data Warehousing ETL experience of using Informatica PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor.
• Understanding of Data warehousing concepts and Dimensional modeling (Star schema and Snowflake schema)
• Experience in working with relational databases such as Oracle and Netezza.
• Worked on Netezza Database objects creation.
• Hands on experience on NZSQL utilities, NZLOAD and control files creation.
• Experience in writing complex SQL queries, Netezza procedures, views etc.
• Well versed in developing various database objects like Packages, Stored Procedures, Functions, Triggers, Tables, Indexes, Constraints, Materialized Views, Analytical and Database collections.
• Created Cursors and Ref Cursors in the PL/SQL Blocks.
• Functions and Query Re-write in Oracle 11g/10g /9i database.
• Used Explain Plan, HINTS for performance tuning of SQL, PL/SQL queries.
• Worked on Dynamic SQL, Exception Handling and Autonomous transactions.
• Well experienced in writing complex views for the reporting team.
• Solid experience in writing complex SQL queries and PL/SQL procedures to extract data from various source tables.
• Proficient in loading data from flat files into database tables using SQL*Loader scripts.
• Involved in SQL tuning.
• Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor), Power Exchange, Power Connect as ETL tool on Oracle, Netezza Databases.
• Having hands-on experience in creating Informatica Mappings, Sessions and Workflows.
• Worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Joiner, Update Strategy, Aggregator, Stored Procedure, Sorter, Sequence Generator, XML Source qualifier, XML Parser, XML generator and Web service consumer.
• Worked extensively with slowly changing dimensions (SCD Type 1,2).
• Extensively worked with Informatica performance tuning involving source level, target level and map level bottlenecks.
• Worked on existing mapping for the performance tuning to reduce the total ETL process time.
• Wrote stored procedures and UNIX scripts as a part of ETL Process.
• Strong experience in providing technical documentation and status reports of the applications as per the requirement.
• Involved in creating detailed Documentation HLD and LLD, which includes all Business requirements and technical specifications, also created Unit Test Plan(UTP) documents.
• Efficient in creating Test cases and performed data validation and process testing for application moving into production.
• Independently perform complex troubleshooting, root-cause analysis and solution development.
• Good communication, interpersonal, analytical skills and strong ability to perform as a part of team.
• Have quickly acquired the additional application skills to complete the Job.

TECHNICAL SKILLS

ETL Tools: Informatica

Development Tools: Oracle developer, Toad, Netezza Aginity workbench

Other tools: Quality Centre (QC), Rational Clear case, Discovery tool

Languages: Oracle, Netezza, Pl/Sql, My Sql

Data Modelling: ERwin Data Modeler, Toad Data Modeler.

O/S: Windows 2000/XP, Windows 7, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Dallas,TX

ETL/ PL-SQL Developer

Responsibilities:

• Involved in writing Packages, Functions, Stored Procedures and Database Triggers.
• Writing PL/SQL code using the technical and functional specifications.
• Designed, Developed and Supported Extraction, Transformation and Load Process (ETL) for data migration with Informatica power center.
• Involved in Data profiling using IDQ.
• Done enhancements for the previous iteration Informatica Mappings to load data from Source systems to Staging tables and then to Data Mart.
• Created SCD1, SCD2 Mappings using CDC and Oracle Procedure.
• Created reusable components for defaulting and checksum generation.
• Involved in creation of views for reporting purpose.
• Involved in Data loading using SQL queries and procedures for reporting team.
• Tracked defects on regular basis and brainstormed offshore team to prevent the re-occurrence of the defects.
• Generated SQL and PL/SQL scripts to install create and drop database objects including Tables, Views, Primary Keys, Indexes, Constraints, Sequences and Synonyms.
• Created stored procedures, functions, packages, database triggers and cursors based on requirement.
• Created SQL*Loader control files for moving the data from flat files to staging area tables.
• Created all database objects like Tables, Views, Sequences, Triggers and Materialized Views.
• Wrote complex SQL queries, Sub queries and nested loops for faster data retrieval.
• Extensively worked through SQLdeveloperand SQL Plus for database development and tuning.
• Developed migration scripts for initial full data loads in Test and Production environments.
• Used bulk collections, indexes, materialized views to improve the query executions.
• Worked in SQL query tuning and performance improvement using Hints, Indexes and Partitions.
• Developed complex queries to retrieve the data.
• Created indexes for faster access of data.
• Documented business rules for writing triggers and constraints, functional and technical design, test cases and user guides.
• Involved in testing all forms, PL/SQL code for logic correction. Performed Unit testing on queries and reports.

Environment: Informatica 9.6, Oracle 11g

Confidential, Jacksonville,FL

ETL Developer

Responsibilities:

• Designed the detail design documents based on the Transformation rules to load the data from source to the Target.
• Developed Informatica Mappings to load data from Source systems to Staging tables and then to Data Mart.
• Created SCD1, SCD2 Mappings using CDC and Oracle Procedure.
• Created reusable components for defaulting and checksum generation.
• Extensively used Transformation Language functions in the mappings to produce the desired results
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Created procedures for calculation of Total commission per individual, Bonus Rewards and used in the stored procedure Transformation.
• Created Unit testing approach document and test scenarios document.
• Developed detailed Test cases for all Informatica mappings.
• Implemented autosys job for Daily/weekly/monthly load of data.
• Involved in creation of views for reporting purpose.
• Involved in Data loading using SQL queries and procedures for reporting team.
• Tracked defects on regular basis and brainstormed offshore team to prevent the re-occurrence of the defects.
• Interacted with data analyst/QA teams on client side to get resolution/validate the issues.
• Work on tickets and provide the analysis and fix, for the immediate results of technical issues related to commissions to agents.
• Involved in peer review of code/UTPs delivered by offshore.
• Took the responsibility in assigning the tasks to the team members and getting them finished.

Environment: Informatica 9.6.1, Oracle 11g

Confidential

ETL Developer

Responsibilities:

• Involved in ETL development for new/enhancement components and prepared respective supporting documents.
• Designed, Developed and Supported Extraction, Transformation and Load Process (ETL) for data migration with Informatica power center.
• Used XML source qualifier and XML parser transformations to parse the data and load into staging tables.
• Involved in extracting the data from the Flat Files and Relational databases into staging area.
• Written stored procedures for validating the customers using KYC norms and used them in transformations.
• Developed mappings/sessions using Informatica Power Center for initial loading and incremental loading.
• Used web service transformations for currency conversions.
• Developed Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
• Created mappings, which involved Slowly Changing Dimensions.

Environment: Informatica 9.6, Oracle 10g

Confidential

PL/SQL Developer

Responsibilities:

• Developed scripts in oracle to load the data from source to target and executed them by creating packages in SSIS.
• Tuning the SQL queries, which are taking long time to load data into target tables.
• Developed detailed Test cases for all plsql procedures.
• Involved in deploying the code to TEST/QA/PROD and supported QA/UAT issues within no time.
• Tracked defects on regular basis and fixed them without leading to new issues.
• Interacted with data mappers on the client side to get resolution/validate the issues while doing analysis.
• Attending the on-shore team calls on daily basis.
• Involved in peer review of code/UTPs delivered by offshore.
• Helping the team members whenever they struck while doing coding and fixing the defects.
• KT sessions given to the new team members joined in the team.

Environment: Oracle database

Confidential

Netezza Developer

Responsibilities:

• Developed procedures in Netezza to load the data from source to target in the current iteration.
• Developed database objects including tables, views, sequences.
• Created procedures to develop functionality.
• Created NZLOAD utility to load data from files into temporary staging tables.
• Created NZLOAD control files to load different data sets.
• Developed detailed Test cases for all Netezza procedures.
• Created NZSQL utilities to load into files when required.
• Involved in deploying the code to TEST/QA/PROD and supported QA/UAT issues within no time.
• Tracked defects on regular basis and fixed them without leading to new issues.
• Interacted with data mappers on the client side to get resolution/validate the issues while doing analysis.
• Involved in peer review of code/UTPs delivered by offshore.
• Helping the team members whenever they struck while doing coding and fixing the defects.
• KT sessions given to the new team members joined in the team.

Environment: Netezza database

Confidential

ETL Developer

Responsibilities:

• Designed, Developed and Supported Extraction, Transformation and Load Process (ETL) for data migration with Informatica power center.
• Involved in extracting the data from the Flat Files and Relational databases into staging area.
• Developed mappings/sessions using Informatica Power Center for initial loading and incremental loading.
• Developed Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
• Created mappings, which involved Slowly Changing Dimensions.
• Created procedures for calculation of Loan Total Repayments, Bonus Rewards and used in the stored procedure Transformation.

Environment: Informatica 8.6, Oracle 10g