Senior Technical Specialist
India
Job Description
Senior Technical Specialist
Bangalore, Karnataka
Job Summary
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 |
Information at a Glance