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:
- How long have you worked with DataStage, DB2, SQL, UNIX, and Control-M? In what capacity?
- Describe your approach to designing and implementing an ETL workflow using these tools.
- Have you automated any ETL or batch processes using Unix or Python? Please explain.
- 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.