ETL Datastage Developer

Technology Ventures; McLean (VA); On-site; USD 110,000 - 140,000; Full time

Job summary

Technology Ventures in McLean, VA is seeking an experienced ETL developer to design and optimize DataStage-based data integration solutions. You will work with UNIX scripting, SQL databases, and Jira to deliver reliable data pipelines and timely reporting.

Responsibilities include root cause analysis, process improvement, and collaboration with agile teams. Strong analytical skills, attention to detail, and effective communication are essential for success.

Qualifications

• Bachelor’s degree or equivalent experience.
• 5+ years of DataStage experience (preferably 11.7).
• Experience with UNIX, shell scripting, and SQL.
• Experience with Jira and Bitbucket.
• Excellent communication and teamwork.

Responsibilities

• Develop effective solutions to new and existing data reporting requirements and data issues primarily using DataStage.
• Perform root cause analysis and address existing issues.
• Find gaps in the existing processes, automate manual tasks and provide stability to the applications.
• Participate in analysis of agile user stories; develop solution based on business requirements and architecture, prototype if necessary, unit test and deploy quality solutions.
• Perform analysis and make code changes to the DataStage ETL and Unix jobs.
• Support applications in production.

Skills

Analytical skills

Problem solving

Communication skills

Team player

Education

Bachelor's degree in Computer Science or Engineering or equivalent

Tools

DataStage

UNIX

Control-M

DB2

Sybase

Oracle SQL

Jira

Bitbucket

Job description

Must Have Qualifications: Candidates must have 5+ years of relevant experience, including strong experience in DataStage (preferably version 11.7 or newer), Shell scripting, databases. Jira required. Strong analytical and development skills are essential.

Responsibilities

• Develop effective solutions to new and existing data reporting requirements and data issues primarily using DataStage.
• Perform root cause analysis and address existing issues.
• Find gaps in the existing processes, constantly improve the processes/procedures, automate manual tasks and provide stability to the applications.
• Participate in analysis of agile user stories; participate in and develop solution based on business requirements and architecture, prototype if necessary, unit test and deploy quality solutions.
• Perform analysis and make code changes to the DataStage ETL and Unix jobs.
• Support applications in production.

Basic Requirements

• Bachelor’s degree in Computer Science or Engineering or equivalent working experience
• At least 5+ years of experience in DataStage (ETL) preferably 11.7, UNIX, shell scripting, Control-M and db2/Sybase/Oracle SQL, Jira, Bitbucket skills.
• Strong analytical and development skills required to troubleshoot issues and develop effective solutions.
• Team player with positive attitude.
• Innovative in providing solutions and likes to take on challenges with calculated risks.
• Strive to constantly improve the application development processes and tools.
• Experience in all aspects of system development life cycle methodologies including agile development
• Quick learner of new technologies and tools.
• Excellent verbal and written communication skills. Ability to communicate effectively with team members, stakeholders, and management on both the business and IT sides.

Preferred Skills

• Working experience in Java, SAS and Control-M