Tesnik Technologies
Job ID: JOB-00059
Compensation
$60 – $65/hr
Accepted work authorization
All work authorizations acceptedThird-party / bench submissions
Accepted (C2C welcome)
IP: Capco
End Client : Freddie Mac
Must Have Skills:
Datastage with Mainframe Knowledge
Python with any AI Experience
"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."