Must Have Technical/Functional Skills
Experience
7+ years of IBM DataStage development experience.
3+ years leading or coordinating offshore development teams.
Experience working in large enterprise environments.
Experience supporting production applications.
Technical Skills
IBM DataStage
Parallel Jobs
Sequence Jobs
Shared Containers
Parameter Sets
DataStage Administration
Performance Tuning
Production Support
Databases
SQL Server
PostgreSQL
Advanced SQL Development
Query Optimization
Scripting & Automation
Unix/Linux Shell Scripting
Python
REST API and JSON integration expertise Data Management
Data Warehousing
Data Modeling Concepts
Data Quality Controls
Data Mapping
Data Lineage Development Tools
Roles & Responsibilities
Job Description:
We are seeking a highly experienced IBM DataStage ETL Developer to support enterprise data integration initiatives within a fast-paced financial services environment. This role requires a hands-on technical leader who can independently design, develop, and support complex ETL solutions while coordinating with business partners and offshore development resources.
The ideal candidate will have deep expertise in IBM DataStage, SQL, data warehousing, and production support. This individual must be capable of translating business requirements into technical solutions, driving delivery, conducting code reviews, and ensuring high-quality ETL development across both onshore and offshore teams.
Key Responsibilities
Technical Leadership
Serve as a key resource for DataStage development efforts.
Help lead and coordinate offshore developers to ensure timely delivery.
Review technical designs, ETL jobs, and code submissions.
Provide technical guidance and mentoring to junior developers.
Participate in architecture discussions and solution design reviews.
Hands-On Development
Design, develop, enhance, and maintain IBM DataStage ETL processes.
Develop complex data integration solutions involving multiple source and target systems
Design and develop API-based integrations using REST services.
Read, parse, transform, and load JSON payloads using DataStage to support business requirements.
Create reusable ETL components and frameworks.
Implement data validation, auditing, reconciliation, and error-handling capabilities.
Support production deployments and post-implementation activities.
Database & Data Warehousing
Develop and optimize complex SQL queries and stored procedures.
Partner with data architects and business analysts to define source-to-target mappings.
Support data warehouse, reporting, and analytics solutions.
Perform data analysis and troubleshooting activities.
Offshore Team Coordination
Manage day-to-day activities of offshore development resources.
Assign work, review deliverables, and monitor progress.
Conduct code reviews and enforce development standards.
Facilitate knowledge transfer and production support handoffs.
Agile Delivery
Participate in Agile ceremonies and sprint planning.
Provide effort estimates and technical impact assessments.
Manage work using JIRA and Agile processes.
Support release planning and implementation activities.
Coordinate testing and defect remediation activities.
Required Skills & Qualifications
JIRA
Git
Bitbucket
Ansible
Preferred Qualifications
Financial Services or Banking experience.
Experience working with regulatory, risk, compliance, or privacy-related data.
Experience with enterprise release management and change control processes.
Prior experience leading distributed development teams.
Excellent verbal and written communication skills.
Ability to work directly with business partners, architects, QA teams, and offshore developers
Key Success Criteria
The successful candidate will:
Operate independently with minimal supervision.
Deliver high-quality DataStage solutions from design through production implementation.
Effectively lead offshore resources and ensure delivery commitments are met.
Quickly troubleshoot and resolve production issues.
Partner effectively with business, architecture, QA, and support teams.
Drive on-time delivery while adhering to enterprise development standards.