We provide IT Staff Augmentation Services!

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.

Hire Now