SUMMARY

• Over 7+ Years of Experience in Design, Development, Implementation of Business applications with Data Warehouse PL/SQL/Data Mart Applications and Client/Server Applications on Windows and Unix platforms using IBM Infosphere DataStage Server/Parallel Extender and Informatica Power Center.
• Experience in developing Parallel jobs using Data stage versions 8.x/7.x
• Experience in Developing ETL Mappings Using Informatica 7.x/8.x
• Experience in Extracting, Transforming, Loading (ETL) and Maintaining of Data Warehouses and Data marts, handling large data loads, automatic error handling, performance tuning for bulk data aggregation in optimized time.
• Extensively made use of Parallel stages like Sequential, Aggregator, Head, Tail, Sort, Lookup, Merge, Join, Change Capture, SCD stage, Peek stages, Dataset, Filter, Enterprise database stages in Parallel Extender job.
• Extensively worked on Job Sequences to control the execution of the job flow using various Activities & Triggers (Conditional and Unconditional) like Job Activity, Email Notification, Sequencer, Routine activity and Exec Command Activities.
• Extensively worked on Lookup, Joiner, Router, Update Strategy, Sequence generator, Union, Expression transformation in Informatica Power Center version 7.x/8.x
• Excellent knowledge in extraction, cleansing and modification of data from/to various Data sources, Flat files from Mainframe Systems and Comma Delimited files (CSV).
• Familiar with Quality Stage 8.1 and Information Analyzer.
• Knowledge in UNIX shells (Pearl and Shell) programming.
• Understanding knowledge with SSAS and Microstrategy.
• Knowledge in Microsoft BI ETL Tool SSIS 2008
• Knowledge in Core Java.
• Knowledge in Netezza.
• Expertise in Korn Shell Scripting.
• Worked with various databases like DB2 UDB, SQLServer, Oracle, ODI, and Flat Files into a staging area.
• Experience in evolving strategies and developing architecture for building a Data warehouse by using data modeling tool Erwin.
• Proficient in writing SQL - PL (DB2) and PL/SQL Stored Procedures & Packages.
• Worked with job scheduler tools Control-M.

TECHNICAL SKILLS

ETL Tools: IBM InfoSphere,Datastage8.5/8.0, Ascential DataStage 7.x, Quality Stage 8.0, Informatica Power center 7.1/8.1/8.6, Microsoft SSIS 2008.

Languages: SQL, C, PL/SQL, Unix Shell Scripting, HTML, XML, MS-Visual Basic

Databases: Oracle 9i/8i, MS SQL Server 2000/7.0, MS Access, UDB DB2 7.x/8.x

Environment: Windows 95, XP, AIX, Unix 5.2

Tools: &Utilities: Toad, PL/SQL Developer

PROFESSIONAL EXPERIENCE

Confidential, ADA, OK

Datastage Lead

Responsibilities:

• Involved in requirement gathering, analysis and study of existing systems.
• Involved in Data Modeling.
• Worked closely with Data Architects.
• Involved in Datastage architecture.
• Design the mapping document for Datastage jobs based on the requirement.
• Involved in estimated the times.
• Involved in performance tuning techniques.
• Leaded a team and acted as single point of contact to the client in delivering the tasks assigned.
• Mentored the Team in understanding the best practices and processes specific to the project
• Extensively used DataStage Designer for developing Parallel jobs and performed complex mappings based on user specifications.
• Used DataStage Designer for Extracting Data, Performing Data Transformations and Aggregate Data and store the data into Flat files.
• Experience in using DataStage Director to Validate, Run, and Schedule and Monitor DataStage jobs in Developing ETL Mappings Using Data stage versions 8.1
• Expertise in Unix shell/Korn Shell programming in AIX 6.1
• Developed jobs in Parallel Extender using different stages like Transformer, Aggregator, Lookup, Source dataset, External Filter, Row generator, Column Generator, Pivot, Join, Merge, Copy and Peek stages.
• Extensively used Parameter sets and Parameter files.
• Developed SCD type 1 and 2 jobs.
• Developed the Dimension and Fact jobs.
• Involved in development of master data solutions.
• Expertise in performance tuning methods.
• Experience in some of the Quality stage stages and Information Analyzer stage.
• Involved in some of the Datastage Administration work.
• Responsible for Production Support to monitoring the jobs.
• Distributed load among different processors by implementing the Partitioning of data in Parallel Extender.
• Used Partition methods and collecting methods for implementing parallel processing.
• Extracted data from DB2 database, transformed data and loaded into Oracle 11g Database.
• Involved in Test case development.

Environment: IBM Infosphere Data Stage 8.1(Parallel Extender), DB2, Oracle 11g, AIX 6.1.

Confidential, Carlton, Texas

Datastage LEAD

Responsibilities:

• Leaded a team and acted as single point of contact to the client in delivering the tasks assigned.
• Mentored the Team in understanding the best practices and processes specific to the project
• Extensively used DataStage Designer for developing Parallel jobs and performed complex mappings based on user specifications.
• Used DataStage Designer for Extracting Data, Performing Data Transformations and Aggregate Data and store the data into Flat files.
• Experience in using DataStage Director to Validate, Run, and Schedule and Monitor DataStage jobs in Developing ETL Mappings Using Data stage versions 8.1, 8.5
• Tuned Informatica mappings and sessions for better performance using various strategies analysis performed.
• Expertise in Unix shell/Korn Shell programming in AIX 5.2
• Expertise in performance tuning methods.
• Developed jobs in Parallel Extender using different stages like Transformer, Aggregator, Lookup, Source dataset, External Filter, Row generator, Column Generator, Pivot, Join, Merge, Copy and Peek stages.
• Extensively used Parameter sets and Parameter files.
• Experience in change data capture.
• Responsible for Production Support to monitoring the jobs.
• Distributed load among different processors by implementing the Partitioning of data in Parallel Extender.
• Prepared Run books and Implementation plan Documents.
• Writing SQL-PL (DB2) and PL/SQL Stored Procedures & Packages.
• Used Partition methods and collecting methods for implementing parallel processing.
• Extracted data from DB2 database, transformed data and loaded into Oracle warehouse.
• Involved in Test case development.
• Job scheduling using Control-M.

Environment: IBM Infosphere Data Stage 8.1(Parallel Extender), Informatica Power Center 8.6.1, Oracle 11g, DB2, PL/SQL, Windows NT server, AIX 5.2.

Confidential, Dallas, Texas

Datastage Sr. Consultant

Responsibilities:

• Involved in requirement gathering, analysis and study of existing systems.
• Leaded a team and acted as single point of contact to the client in delivering the tasks assigned.
• Mentored the Team in understanding the best practices and processes specific to the project
• Extensively used DataStage Designer for developing Parallel jobs and performed complex mappings based on user specifications.
• Used DataStage Designer for Extracting Data, Performing Data Transformations and Aggregate Data and store the data into Flat files.
• Experience in using DataStage Director to Validate, Run, and Schedule and Monitor DataStage jobs in Developing ETL Mappings Using Data stage versions 8.x/7.x
• Expertise in Unix shell/Korn Shell programming in Unix
• Expertise in performance tuning methods.
• Developed jobs in Parallel Extender using different stages like Transformer, Aggregator, Lookup, Source dataset, External Filter, Row generator, Column Generator, Pivot, Join, Merge, Copy and Peek stages.
• Extensively used Parameter sets and Parameter files.
• Responsible for Production Support to monitoring the jobs.
• Developed jobs for Auditing and Exception capture.
• Distributed load among different processors by implementing the Partitioning of data in Parallel Extender.
• Prepared Run books and Implementation plan Documents.
• Writing SQL-PL (DB2) and PL/SQL Stored Procedures & Packages.
• Used Partition methods and collecting methods for implementing parallel processing.
• Extracted data from DB2 database, transformed data and loaded into Oracle warehouse.
• Involved in Test case development.
• Job scheduling using Control-M.

Environment: IBM Infosphere Data Stage 8.1, 8.5(Parallel Extender), Oracle 11g, DB2, PL/SQL, Windows NT server, UNIX.

Confidential, Dallas, Texas

ETL Developer

Responsibilities:

• Involved in requirement gathering, analysis and study of existing systems.
• Leaded a team and acted as single point of contact to the client in delivering the tasks assigned.
• Mentored the Team in understanding the best practices and processes specific to the project
• Involved in low-level design and developed various jobs and performed data loads and transformations using Informatica Power Center
• Involved in unit, performance, Regression and integration testing of Informatica mappings and prepared Documentation.
• Study of source systems and development of mapping documents and Technical Design Documents.
• Involved in the ETL Development and database management.
• Extensively used DataStage Designer for developing Parallel jobs and performed complex mappings based on user specifications.
• Used DataStage Designer for Extracting Data, Performing Data Transformations and Aggregate Data and store the data into Flat files.
• Experience in using DataStage Director to Validate, Run, and Schedule and Monitor DataStage jobs.
• Extensively used Informatica Designer to create and manipulate source and target definitions, Mappings, mapplets, transformations, re-usable transformations.
• Used various transformations like Expression, Filter, Sorter, Sequence Generator, Aggregator Lookup, Update Strategy, Router, and Joiner.
• Developed standard and re-usable mappings and mapplets using various transformations like Aggregator, joiner, source qualifier, router, lookup Connected/Unconnected, and filter.
• Tuned Informatica mappings and sessions for better performance using various strategies analysis performed.
• Developed jobs in Parallel Extender using different stages like Transformer, Aggregator, Lookup, Source dataset, External Filter, Row generator, Column Generator, Pivot, Join, Merge, Copy and Peek stages.
• Distributed load among different processors by implementing the Partitioning of data in Parallel Extender.
• Used Partition methods and collecting methods for implementing parallel processing.
• Extracted data from DB2 database, transformed data and loaded into Oracle warehouse.
• Written SQL queries to test the Data validity.
• Written PL/SQL Procedures to cleanse the data

Environment: IBM Infosphere Data Stage 8.1(Parallel Extender), Informatica Power center8.1/8.6, Oracle 10g, DB2,PL/SQL, Windows NT server, AIX 5.2.

Confidential

ETL Developer

Responsibilities:

• Analyzing the Requirements specified by the client
• Study of source systems and development of mapping documents and Technical Design Documents.
• Involved in the ETL Development.
• Extensively used DataStage Designer for developing Parallel jobs and performed complex mappings based on user specifications.
• Used DataStage Designer for Extracting Data, Performing Data Transformations and Aggregate Data and store the data into Flat files.
• Experience in using DataStage Director to Validate, Run, and Schedule and Monitor DataStage jobs.
• Designed Error Handling and Unit Testing Strategies.
• Extensively worked on Data Profiling and Data Quality
• Involved in low-level design and developed various jobs and performed data loads and transformations using Informatica Power Center
• Involved in unit, performance, Regression and integration testing of Informatica mappings and prepared Documentation.
• Written SQL queries to test the Data validity and ETL Procedures.
• Written PL/SQL Procedures to cleanse the data

Environment: Intel Pentium O/s: Linux, Windows NT Tools, Database: Oracle 9i, SQL Server 2005, PL/SQL

Confidential

ETL Developer

Responsibilities:

• Analysis of the specifications provided by the client
• Understanding the business logic.
• Preparing the specification document
• Involved in the ETL Development and database management.
• Extensively used Informatica Designer to create and manipulate source and target definitions, Mappings, mapplets, transformations, re-usable transformations.
• Used various transformations like Expression, Filter, Sorter, Sequence Generator, Aggregator Lookup, Update Strategy, Router, and Joiner.
• Developed standard and re-usable mappings and mapplets using various transformations like Aggregator, joiner, source qualifier, router, lookup Connected/Unconnected, and filter.
• Tuned Informatica mappings and sessions for better performance using various strategies analysis performed.
• Extensively used DataStage Designer for developing Parallel jobs and performed complex mappings based on user specifications.
• Used DataStage Designer for Extracting Data, Performing Data Transformations and Aggregate Data and store the data into Flat files.
• Experience in using DataStage Director to Validate, Run, and Schedule and Monitor DataStage jobs.
• Creating the mappings and workflows in DEV Environment.
• Moving the mappings and workflows to test environment.
• Writing the SQL queries to test the Data validity.

Environment: Tools: Informatica 7.X/6.X, Ascential DataStage 7.X, Oracle 9i and Microsoft Visual Source Safe.