Sr. ETL Developer/ETL Production Support Resume

SUMMARY

Over 6+ years of IT experience in data warehousing using ETL/BI tools like IBM DataStage. Experience in business requirements gathering, definition and capture metadata for business rules, system analysis, design, development, testing and user training associated with Business Intelligence solutions.
Extensively worked with IBM InfoSphere Information Server DataStage.
Having very good experience in Application management and resolving issues in Production environment.
Worked on DataStage tools - DataStage Designer, DataStageDirector, and DataStage Administrator.
Developed SCDs to populate Type I, Type II, and Type III slowly changing dimension tables from several operational source files.
Experienced in writing Use case documents, Module Specifications, Technical Specifications, translating user requirements to functional specifications.
Excellent knowledge on data dependencies using DataStage and preparing job sequences for the existing jobs to facilitate scheduling of multiple jobs with appropriate trigger activities.
Good understanding of the principles of DW, and dimensional modeling, Star Schema and snowflake schema.
Extensive experience inUnit Testing, Functional Testing, System Testing, Integration Testing, User Acceptance Testing (UAT)andPerformance Testing.
Efficient in integration of various data sources like Teradata, DB2, Oracle, flat files, XML files, Webservices and MS Access into staging area.
Worked on the Autosys R11 to maintain Application.

TECHNICAL SKILLS

ETL Tools: IBM InfoSphere Information Server DataStagev9.1, IBM InfoSphere Information Server DataStage8.5/v8.1, and v7.5PX.

RDBMS: Oracle11g/10g/9i, Teradatav14.0,SQL Server 2005/2012MS - Access.

Operating System: UNIX (AIX 5.2), and Windows NT

Languages: SQL & PL/SQL, HTML, XML, UNIX Shell scripts

Scheduling tools: AutosysR11, Control-M Scheduler.

Other Details: Citrix Server 6p, PVCS, BeyondCompare3, Notepad++

PROFESSIONAL EXPERIENCE

Confidential

Sr. ETL Developer/ETL Production Support

Responsibilities:

The ETL code had been migrated from lower version to upper version.
Worked in Application Maintenance L1, L2, and L3 supports.
Worked with development teams to resolve the critical issues on-time.
Worked closely with Business to analyze complex data issues.
Migrated the older version code to newer version environment and compiled the whole project jobs.
Migrated, and converted the Oracle, MQ series stages into Connector stages by using Migration tool.
Designed and Developed some sample ETL jobs using DataStage by using different types of stages like Sequential file, Transformer, Lookup, Funnel, Copy, Aggregator, MQ series, Teradata, and Oracle enterprise stages and conduct testing.
Implemented the new features of newer version in the existed jobs to simplify the complexity, and to increase the performance.
Coordinated with QC testing team in preparing Test cases and performing the testing for all the Project modules.
Listed out all the Issues, and resolutions while performing testing in Newer version and share with all other teams.

Environment: IBM Infospherev9.1/v8.5, Oracle 10g, SQL Server 2005/2012, UNIX, Windows NT, AutosysR11

Confidential

ETL Production Support

Responsibilities:

Designed dimensional logical model and physical model as per business requirements.
Extensively used Development and Debug stages like Row Generator, Column Generator, Head, and Peek for development and de-bugging purposes.
Created simple as well as complex mappings, Shared Containers, and Local Containers.
Worked in Application Maintenance to take care of issues, and resolved them on-time.
Worked closely with Business to handle, and analyzing the complex data issues.
Documented the critical issues and the resolutions for future reference.
Extensively worked LookUp, Join, Merge, Transformer, Aggregator, and Filter and generated complex Sequences.

Environment: IBM Infospherev8.5/v8.1, Oracle 11g, TOAD, UNIX, Teradatav14.0, AutosysR11

Confidential

ETL Developer

Responsibilities:

Created many ETL jobs using DataStage parallel jobs-Developed jobs using different types of stages like Datasets, Sequential file, Transformer, Lookup, Join, Merge, Aggregator and DB2 Stage using DataStage.
Handled Dependencies(Business and Technical) - Involved in programming iLOG which maintains the Dependencies among Dimensions and Facts.
Prepared Test cases for Unit Testing.
Prepared detailed design and program specification documents based on the High level design document,Functional specification document and BRD.
Involved in testing of various phases like Unit Testing,SIT, and UAT.
Involved in exporting and Importing of the DataStage jobs.

Environment: IBM Infospherev7.5PX, Windows 2000/XP, Oracle9i, Test Director 8.0