We provide IT Staff Augmentation Services!

Datastage Developer Resume

New York, NY

SUMMARY

Information & Data Management professional with more than 6 years of experience within the business data analysis, data migration & system integration capability. My analysis experience has spanned across projects with clientele in Healthcare and Banking clients, and Investment Management

SKILLS:

IBM InfoSphere DataStage 8.7(Designer, Director),Oracle 11g/9iUNIXPUTTYMS AccessMS WordMS Power Point

EXPERIENCE:

DataStage Developer

Confidential, New York, NY

Responsibilities:

  • Use of SQL to profile data and provide data sheets based on the workrequests.
  • Executed DataStage jobs and made sure proper files were beinggenerated in Cognos, also made sure to verify database was loadedcorrectly with the new data.
  • Used DataStage Designer to create the table definitions for the CSV andSequential files, import the table definitions into the repository, import andexport the projects, release and package the jobs.
  • Created ETL processes to extract data from landing Oracle Database,transformed data based on business requirement and load it to the properdatabase table.
  • Executed Sequence Jobs which had restart ability, check points andimplemented proper failure.
  • Designed and developed parallel jobs using DataStage Designer as perthe mapping specifications using appropriate stages.
  • Used DataStage Director and its run - time engine to schedule running thesolution, testing and debugging its components, and monitoring theresulting executable versions.
  • Worked on troubleshooting, performance tuning, performance monitoringand enhancement of DataStage jobs.
  • Performed unit testing and system integration testing in development andUAT environments.
  • Used Cognos tool to verify if the files were generated accurately.

Datastage Developer

Confidential, Malvern, PA

Responsibilities:

  • Recognized business needs, evaluated business and technicalalternatives, suggested solutions and took part in their implementation.
  • Imported metadata from repository, created new job categories
  • Used DataStage Designer to create the table definitions for the CSV andSequential files, import the table definitions into the repository, import andexport the projects, release and package the jobs.
  • Created ETL processes to extract the source data from DB2 Enterprisedatabase
  • Developed job sequences to execute a set of jobs with restart ability,check points and implemented proper failure actions.
  • Used DataStage Director and its run-time engine to schedule running thesolution, testing and debugging its components, and monitoring theresulting executable versions.
  • Worked on troubleshooting, performance tuning, performance monitoringand enhancement of DataStage jobs.
  • Wrote several complex SQL queries to test the ETL process.
  • Worked with Control M for setting up production job cycles for daily,weekly, monthly loads with proper dependencies.
  • Designed and developed parallel jobs using DataStage Designer as perthe mapping specifications using appropriate stages.

Data Integration Developer

Confidential, Lake Forest, CA

Responsibilities:

  • Recognized business needs, evaluated business and technicalalternatives, suggested solutions and took part in their implementation.
  • Perform data cleansing activities based on writing SQL patches,investigating ETL jobs to address data gaps.
  • Imported metadata from repository, created new job categories, routinesand data elements using Datastage Manager.
  • Used DataStage Designer to create the table definitions for the CSV andSequential files, import the table definitions into the repository, import andexport the projects, release and package the jobs.
  • Created ETL processes to extract the source data from the healthcarecompany database and load it into the enterprise-wide data warehouseafter cleansing, transforming and integrating.
  • Used Quality Stage to coordinate the delivery, consistency, removing dataanomalies and spelling errors of the source information.
  • Designed and developed parallel jobs using DataStage Designer as perthe mapping specifications using appropriate stages.
  • Developed job sequences to execute a set of jobs with restart ability,check points and implemented proper failure actions.
  • Used DataStage Director and its run-time engine to schedule running thesolution, testing and debugging its components, and monitoring theresulting executable versions.
  • Worked on troubleshooting, performance tuning, performance monitoringand enhancement of DataStage jobs.
  • Worked with Autosys for setting up production job cycles for daily, weekly,monthly loads with proper dependencies.
  • Performed unit testing and system integration testing in development andUAT environments.
  • Wrote several complex SQL queries to test the ETL process

ETL Developer

Confidential, Mettawa, IL

Responsibilities:

  • Worked as ETL DataStage consultant for a project from design untilproduction and support.
  • Reviewed and validated the existing job code and designed anddeveloped new jobs for the future releases.
  • Worked with offshore developers to co-ordinate the ETL work andrequirements and reviewed the code developed at offshore.
  • Worked on a parallel project for DataStage upgrade from version 7.5 toversion 8.1.
  • Developed UNIX scripts to run the Datastage job and other file validations.
  • Performance tuning of DataStage jobs and the SQL used inside the job.

Hire Now