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

Requirements:

• 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