Previous Job
Previous
Datastage Developer
Ref No.: 19-03673
Location: Charlotte, North Carolina
Position Type:Contract
  • Develop and enhance Datastage ETL jobs for Data warehouse (EDW) applications.
  • Gathering business requirements by interacting with business users and work with business team in identifying the business rules and documenting them.
  • Analyzing the existing Data warehouse applications and documenting the data flow.
  • Analyzing the data in different Data warehouse tables which is in DB2 database and understand the business relations.
  • Create Technical Design document, and Functional Requirement document.
  • Development of Datastage Parallel Jobs, Sequence Jobs, Unix Shell Scripts, and scheduling jobs.
  • Design different interfaces for EDW to receive/send data from/to various systems.
  • Performance tuning of Datastage Jobs by choosing best partitions, stages, and table indexes.
  • Development and performance tuning of DB2 SQL queries for moving data through different EDW layers.
  • Unit Testing of components and documenting results
  • Migrate code to different environments and coordinate wit