Sr. Data Stage Developer Resume

SUMMARY

Have 5 + years of IT experience in Data Warehousing application development and full life cycle implementations including analysis, design, development, testing, deployment, post - production support/maintenance, documentation, and end-user training
Possess competent communication skills as demonstrated in various client facing roles
Strong work experience on IBM InfoSphere Information Server 9.1, DataStage 8.x., DataStage 7.5.x, Unix Shell Scripting, Scheduling tools like Control M and Autosys, Oracle, ETL Testing and DB2
Knowledge in designing Star Schema and Snowflake Schema
Familiar with OLAP Tool like Business Objects

TECHNICAL SKILLS

Operating Systems: Win NT / 9x, MSDos, Unix

Languages: SQL

Database: Oracle

ETL Tools: DataStage8.7

OLAP Tools: Business Objects

PROFESSIONAL EXPERIENCE

Confidential

Sr. Data Stage Developer

Environment: DataStage8.7, Oracle, UNIX

Responsibilities:

Involved in requirements gathering, designing of ETL - DataStage PX jobs for ETL end to process flow
Involved in the Analysis of the functional side of the project by interacting with functional experts to design and write technical specifications
Provided estimates for ETL development effort and regularly updated senior management regarding the progress
Responsible for creating DataStage Detailed Platform Application Design document.
Designing Various DataStage jobs and perform Unit test.
Deploying code from Development to UAT and Production
Generated batch and individual XML output files with new XML stage
Used XML assembly stages like Re-group, V-Pivot, H-Join, Switch, XML Composer and sort
Responsible for handling UAT tickets
Extensively interacted with client/offshore team to resolve technical and infrastructural issues
Preparing unit test plan and unit testing the interface
Build common logging and exception of jobs used across.
Used stages like Lookup, Join, Transformer, Aggregator, Data Set, Copy, Peek, Sequential file and Sequencers stages.
Jobs are sequenced using job sequence and loaded with conditional loading
Scheduled ETL jobs in autosys, JIL scripts

Confidential

Sr. Data Stage Developer

Environment: DataStage8.1, Oracle, Unix

Responsibilities:

To understand and analyze the data so as to identify the dimensions, facts and also the relationship between them
Creating the Dimensions, Facts Data as per the Source to Target Mapping and Business rule
To design and develop jobs according to Business rules using the Datastage ETL tool
Prepared unit test plan for various jobs
Impact analysis on different jobs

Confidential

DataStage Developer

Environment: DataStage, DB2, Unix

Responsibilities: