ETL DataStage Developer

Overview

On Site
$50 - $60
Accepts corp to corp applications
Contract - Independent
Contract - W2

Skills

ETL

Job Details

Job Description -

ETL/DataStage Developer ( PV w2 ) Indepenedent candidate only

Client: Freddie Mac

Location: On-site (McLean, VA or Plano, TX)

Assignment Type: Contract-to-Hire (CTH)

Duration: 3 Months (with potential for conversion)

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

Position Overview

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

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

The ideal candidate is a collaborative, agile-minded professional with a passion for data engineering and a commitment to continuous improvement.

Key Responsibilities

  • Design, develop, and maintain ETL solutions using IBM DataStage.
  • Perform root cause analysis and resolve data-related issues.
  • Identify process gaps and implement automation to improve stability and efficiency.
  • Collaborate with agile teams to analyze user stories and deliver high-quality solutions.
  • Modify and maintain DataStage ETL and Unix shell scripts.
  • Provide production support and ensure the reliability of the application.

Required Qualifications

  • Bachelor's degree in Computer Science, Engineering, or equivalent experience.
  • 3+ years of hands-on experience with:
    • IBM DataStage (preferably v11.7)
    • UNIX and shell scripting
    • Control-M
    • SQL (DB2, Sybase, or Oracle)
    • Jira and Bitbucket
  • Strong analytical and problem-solving skills.
  • Excellent communication and collaboration abilities.
  • Experience with Agile development methodologies.
  • Quick learner with a proactive mindset.

Preferred Qualifications

  • Experience with Java or SAS.
  • Background in the mortgage or financial services industry.
  • Familiarity with CI/CD pipelines and DevOps practices.

Interview Process

  • Rounds: 1 (Panel Interview)
  • Duration: 60 minutes
  • Format: Microsoft Teams (Video Required)
  • Submittal Deadline: July 30

Candidate Submission Checklist

Please include the following with each submission:

  • Full Name
  • Date of Birth (MM/DD)
  • Email & Phone Number
  • Reason for Job Search
  • Updated Word Resume
  • Availability

Supplier Vetting Questions (Must be provided & placed on candidate's resume for submittal consideration)

  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 technologies.
  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 requirements. How did you ensure alignment with business goals?
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.

About Tek Inspirations LLC