Datastage Developer Resume

OBJECTIVE:

Seeking a challenging position in Data Warehouse Development and Design scenario that utilizes the acquired knowledge and experience for the growth of the organization and provides an opportunity for professional growth.

SUMMARY:

Having 4.5 years of total experience as ETL Developer,3 years of experience as Datastage Developer and 1.5 years experience in Abinitio.
Proficient in the Design and Development of process required Extracting, Transform, and Load data and Data warehousing modeling.
Having fair knowledge on SDLC.
Good understanding Business rules associated with the ETL processes.
Involved in DWH Extraction,Data Integration, Transformation, and Loading processes(ETL).
Having Excellent analytical, logical, and Programming skills.
A team player with good inter - personal skills and high level of energy and enthusiasm.

TECHNICAL SKILLS:

ETL: DataStage 8.1 PX,Abinitio

RDBMS: DB2,Oracle9i(SQL,PL/SQL)

Languages: C,C++

Operating System: Windows XP/NT/2000,Unix

PROFESSIONAL EXPERIENCE:

Confidential

Datastage Developer

Responsibilities:

To analyze Mapping document provided by Client.
Develop the jobs based on Mapping document.
Loading the rejected data into audit table for validating.
Perform unit testing of the jobs and preparing Unit test case for the jobs.
Monitor testing progress .
Gather new requirements and perform job change if there is any change request .
Updating the mapping document if any change occurs to meta data or any mapping rule changed.

Environment: ETL DataStage 8.1 Px, Data integration,DB2,Putty,SAP,WinSCP

Confidential

ETL Developer

Responsibilities:

To analyze FS provided by Functional Team add comments and discuss with them regarding FS .
Develop the jobs based on FS .
Analyze rejected records in Jobs.
Perform unit and Integration testing of jobs .
Coordinate with other teams and among team during test execution .
Monitor testing progress .
Follow up with functional team to validate an error report .
Gather new requirements and perform job change if there is any change request .
Export and import the jobs from one environment to different environment of datastage test those jobs and run them .
Check the load ready file structure which should same as LSMW structure of an object .
Generate Load ready file to be Loaded in SAP.
Load generated Load Ready File in SAP.
Analyze SAP error report with Functional team for Validation .
Wave - 1 SAP Data Migration for Global Implementation of SAP for Confidential

Environment: ETL DataStage 8.1 Px, Data integration, DB2,Putty,SAP,WinSCP

Confidential

Datastage Developer

Responsibilities:

Design, build, and deploy a new global SAP system throughout all 37 countries in which Confidential operates
Manage portions of the Confidential procurement and finance business processes
Provide application support in the Confidential production environment
Provide IT operation support for Confidential data centers, networks, and service desk.
Rationalize and transition all of Confidential 's legacy systems into the new systems landscape.
To analyze FS provided by Functional Team add comments and discuss with them regarding FS .
Develop the jobs based on FS .
Analyze rejected records in Jobs.
Perform unit and Integration testing of jobs .
Coordinate with other teams and among team during test execution .
Monitor testing progress .
Provide error report to Functional team .
Follow up with functional team to validate an error report .
Gather new requirements and perform job change if there is any change request .
Export and import the jobs from one environment to different environment: of datastage test those jobs and run them .
Check the load ready file structure which should same as LSMW structure of an object .
Generate Load ready file to be Loaded in SAP.
Load generated Load Ready File in SAP.
Analyze SAP error report with Functional team for Validation .

Confidential

ETL Developer

Environment: Abinitio, Unix, Oracle, Sybase, Autosys, .NET 3.5, Virtual Ticket,Resolve IT,Putty,SQL 2008,SQL Developer,Visual Studio .Net3.5

Responsibilities:

Monitoring Autosys scheduled jobs.
Fixing the failure jobs by taking appropriate action .
Generating Reports using SQL and ORACLE Developer.
Performing holiday processing.
Performing health check for the ISG distributed applications.
Following up with vendors for the feed files if not available.
Following up with client as per escalation process for the production job failures.
Performing weekend and month end activities.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship