IP: Capco
End Client : Freddie Mac
"Skills Needed: +8 years in IBM DataStage development and engineering, building ETL workflows, strong expertise in SQL, UNIX/Linux, Shell Scripting for automation and operation support, metadata and XML logic, translate ETL in to data platforms such as Snowflake, AWS, or Collibra, AI assisted development, automation tools, etc
What We're Looking For
6+ years of hands-on experience with IBM DataStage development.
Proven experience building end-to-end ETL workflows, including extraction, transformation, and load processes.
Strong expertise in SQL, including complex joins, subqueries, window functions, and performance tuning.
Solid knowledge of UNIX/Linux fundamentals, including file systems, permissions, and process management.
Hands-on experience with shell scripting (bash/ksh) for job automation and operational support.
Experience working with DataStage job metadata and XML transition logic.
Ability to analyze and translate legacy ETL logic into modern data platforms such as Snowflake, AWS-native services, or data governance tools like Collibra.
Familiarity with AI-assisted development or automation tools used to understand, parse, or accelerate ETL modernization efforts.
Strong understanding of data warehousing concepts, ETL best practices, and data quality frameworks.
Excellent analytical, problem-solving, and communication skills.
Bonus Points For
Experience with Collibra or other enterprise metadata and data governance platforms.
Familiarity with AI-assisted development tools that support code analysis, metadata interpretation, or ETL modernization.
Experience supporting enterprise cloud migration or large-scale modernization programs.
Knowledge of CI/CD pipelines and DevOps practices for data engineering.
Experience working within financial services or other highly regulated industries."