ETL/DataStage Developer - CTH on W2 - McLean, VA or Plano, TX must be local to either TX or VA - Posted by Tauqeer

Overview

On Site
$52
Contract - W2
Contract - 3 Month(s)
No Travel Required

Skills

IBM DB2
IBM InfoSphere DataStage
Oracle
Unix
Java
DataStage
ETL
Extract
Transform
Load
Jira
BMC Control-M
SQL
Python

Job Details

Work Authorization: Must be eligible to work in the U.S. without sponsorship. W-2 only no C2C candidates.

Must-Have Qualifications

  • Minimum 3 years of experience with:
  • IBM DataStage (preferably version 11.7)
  • UNIX and shell scripting
  • Control-M
  • DB2, Sybase, or Oracle SQL
  • Jira and Bitbucket

Schedule & Timeline

  • Work Schedule:Standard business hours
  • Submittal Deadline:July 10
  • Interview Format:1 round, 60-minute panel via MS Teams (video required)
  • Interview Dates:Targeting July 15 16

Supplier Vetting Questions

Candidates must include answers to the following on their resumes to be considered:

  1. How long have you worked with DataStage, DB2, SQL, UNIX, and Control-M? In what capacity?
  2. Describe your approach to designing and implementing an ETL workflow using these tools.
  3. Have you automated any ETL or batch processes using Unix or Python? Please explain.
  4. Share an example of adapting your technical approach to meet changing business needs. How did you ensure alignment across DataStage workflows, SQL queries, and Control-M schedules?

Position Summary: ETL/DataStage Developer

Freddie Mac is seeking a skilled ETL/DataStage Developer to join the Enterprise BTO team within the Information Technology division.

This role involves designing and developing enhancements to software applications using IBM DataStage (11.x), addressing data issues, and driving process improvements.

You ll work closely with a collaborative, agile team of tech-savvy professionals.

Responsibilities

  • Design and implement ETL solutions using DataStage
  • Troubleshoot and resolve data issues
  • Identify process gaps and automate manual tasks
  • Analyze user stories and develop solutions aligned with business and architectural goals
  • Modify and maintain DataStage ETL and Unix jobs
  • Provide production support for applications

Basic Requirements

  • Bachelor s degree in Computer Science, Engineering, or equivalent experience
  • 4 5 years of hands-on experience with:
  • DataStage (ETL), preferably version 11.7
  • UNIX, shell scripting
  • Control-M
  • DB2, Sybase, or Oracle SQL
  • Jira and Bitbucket
  • Strong analytical and troubleshooting skills
  • Excellent communication and collaboration abilities
  • Agile development experience
  • Quick learner with a proactive mindset

Preferred Skills

  • Experience with Java or SAS
  • Background in the mortgage industry
  • Agile team experience
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.