ETL Developer
UK Visa Sponsorship Analytics
Above analytics are generated algorithmically based on job titles and may not always be the same as the company's job classification. You can also check detailed occupation eligibility, and salary criteria on our UK Visa Eligible Occupations & Salary Thresholds page.
Disclaimer: Hunt UK Visa Sponsors aggregates job listings from publicly available sources, such as search engines, to assist with your job hunting. We do not claim affiliation with Avance Consulting. For the most up-to-date job details, please visit the official website by clicking "Apply Now."
DataStage Developer
Machester, UK (Hybrid Work)
Contract (Inside IR35)
Note : Must be eligible for BPSS !!
Job Description:
---------
Role Description:
Role Overview As a DataStage Developer, you will be responsible for designing, developing, enhancing, and supporting ETL solutions using IBM DataStage. You will work closely with business analysts, data architects, and downstream consumers to deliver reliable, scalable, and high-quality data integration solutions in a regulated banking environment.
Key Responsibilities
Design, develop, and maintain ETL jobs and sequences using IBM DataStage Develop end-to-end data pipelines from source systems to data warehouse / downstream platforms Create and maintain ETL design documents, mapping specifications, and technical documentation Perform data profiling, validation, and reconciliation to ensure data quality Optimize DataStage jobs for performance, scalability, and reliability Troubleshoot and resolve ETL failures, data issues, and production incidents Work closely with DBAs, Unix teams, schedulers (TWS/IWS), and application teams Support batch schedules, deployments, and controlled releases across environments Adhere to banking controls, SDLC, and change management processes
Mandatory Skills
IBM DataStage (11.x preferred) – strong hands-on development experience ETL / Data Warehousing concepts
UNIX / Shell scripting
SQL / PL-SQL
Strong understanding of data models and relational databases
DataStage Technical Expertise
Hands-on experience with: DataStage Parallel Jobs Lookups, Change Capture, Transformer Sequential File, Data Sets Column Generator Database connectors (e.g., Oracle / Teradata / DB2) Job parameterization, shared containers, and reusable components
Good to Have
Banking or Financial Services domain experience Experience with production support and on-call rotations
Exposure to TWS / IWS scheduling
Experience with DataStage upgrades or migrations (e.g., 8.x ? 11.x)
Knowledge of data reconciliation and audit controls Soft Skills Strong analytical and problem-solving skills Ability to work independently in a delivery environment
Good communication skills for stakeholder and offshore/onshore collaboration
Documentation and attention to detail
Mentor junior developers Own complex data domains and critical batch flows Support architectural decisions and performance tuning