Job Description

Position: DataStage Developer

Location: Arlington, VA

Duration: Full Time/ Permanent


Job Description:

  • Analyze requirements, provide technical feasibility, and design, develop and enhance DataStage processes
  • Design and develop ETL processes and transform and enhance target systems
  • Migrate DataStage applications, perform DataStage coding, and implement Stored Procedures and functions using PL/SQL
  • Implement partitioning and parallelism and enhance performance. Review code, and write SQL scripts
  • Maintenance, optimization, and support of current ETL designs (Primarily using DataStage), requirements gathering, data modeling, high-level architecture, database structures, methodologies, and data analysis
  • Prepare test data and perform error handling and analysis
  • Use ESP Scheduler to automate DataStage processes, prepare design documents, and support production
  • Work with DataStage, ETL, Informatica, Oracle, SQL, PL/SQL, Json, Erwin, ESP Scheduler, and Cognos



  • 2-5 years’ experience with DataStage including admin and development (all components and stages) using DataStage v9.5+
  • At least 2 years’ experience designing/implementing Star Schema Data Warehousing concepts
  • At least 2 years’ experience in Linux scripting
  • Ability to reverse engineer undocumented and outdated designs and code
  • Developing DataStage jobs and coding to support Business Analytics initiatives
  • Providing Tier III level support for DataStage, Oracle Stored Procedures (11g+) and Unix Scripts
  • Aiding in performance tuning efforts
  • Monitoring the current architecture and daily loads and recommending changes as needed
  • Bachelor’s degree (IT concentration), advanced degree
  • Hands-on experience with NodeJS and Angular is highly desired
  • Oracle Certification is a Plus
More Details
Employment Type: Full Time
Location: Ashburn , VA , United States
Experience Required: Mid-Senior Level
Date Published: 05 Jan 2021
Share Job Opening