Senior Technical Specialist

The DataStage Engineer is responsible for designing, developing, enhancing, and supporting enterprise data warehouse and data integration solutions in a large-scale banking environment. The engineer will work across ETL development, data modeling, data quality, automation, and production support while ensuring scalability, performance, and regulatory compliance. Experience with IBM DataStage is mandatory.

Key Responsibilities

Design and develop ETL/ELT solutions using IBM DataStage.Build and maintain enterprise data warehouse and data mart solutions.Perform dimensional data modeling (Star Schema, Snowflake Schema, Fact/Dimension design).Develop and optimize complex SQL queries in Oracle, SQL Server, Teradata, or equivalent platforms.Implement data quality controls, reconciliation, validation, and governance standards.Develop Python and Shell scripts for automation and operational support.Perform performance tuning and troubleshooting of DataStage jobs.Integrate deployments with CI/CD pipelines and DevOps practices.Provide production support, monitoring, incident analysis, and problem management.Collaborate with Business Analysts, Architects, Product Owners, and Data Governance teams.Participate in Agile delivery, sprint planning, code reviews, and technical design discussions. Skill Requirements Skill Area Proficiency Required IBM DataStage Expert hands-on development and support Data Warehousing Strong architectural and implementation experience Data Modeling Dimensional, Logical, Physical Data Models

SQL

Advanced SQL, Query Optimization, Performance Tuning ETL/ELT Development End-to-end pipeline development Data Quality DQ Rules, Validation, Reconciliation UNIX/Linux Strong operational and scripting knowledge Python Automation and data engineering scripts DevOps / CI-CD Git, Azure DevOps, Deployment Pipelines Data Governance Metadata, Lineage, Controls Banking Domain Banking data, risk controls, regulatory environment Oracle/Exadata/Teradata Strong database experience

Other Requirements

Skill Area Preferred Experience BigQuery Data Engineering on GCP

DBT

Modern Data Transformation Grafana Monitoring & Observability ELK Stack Logging & Analytics

SODA

Data Quality Framework Cloud Platforms Azure, AWS, GCP IBM Information Governance Catalog Metadata Management Data Lake Modern Data Architecture Test Automation TDD and Validation Frameworks Risk & Compliance Automation Banking Processes