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