Data Stage Developer

Datamatics; Bengaluru, Mumbai; Hybrid; INR 900,000 - 1,500,000; Full time

Job summary

Datamatics is seeking an ETL Developer to design, develop, test, and maintain ETL jobs using IBM InfoSphere DataStage and Talend in Bengaluru. You will build workflows across multiple source systems, optimize SQL queries, and ensure data quality.

The role involves collaboration with business analysts, data architects, and QA teams, along with documentation and governance adherence. Experience with data warehousing concepts, dimensional modeling, and production support is expected, with strong

Qualifications

• Experience designing and implementing ETL pipelines.
• Strong knowledge of data warehousing and data modeling.
• Ability to troubleshoot ETL jobs and optimize performance.

Responsibilities

• Design, develop, test, and maintain ETL jobs using IBM InfoSphere DataStage and Talend.
• Develop ETL workflows for data extraction, transformation, loading, and integration from multiple source systems.
• Create and optimize complex SQL queries, stored procedures, and database operations.
• Work with relational databases such as Oracle, SQL Server, DB2, or PostgreSQL.
• Develop and maintain reusable ETL components, job sequences, transformations, and workflows.
• Perform data cleansing, data validation, reconciliation, and quality checks.
• Troubleshoot ETL failures and optimize performance.
• Collaborate with analysts and QA to ensure data integrity.
• Prepare mapping documents and unit test cases.

Skills

SQL proficiency

Data warehousing concepts

Analytical and problem-solving

Communication skills

Tools

IBM InfoSphere DataStage

Talend Data Integration

Job description

Key Responsibilities

• Design, develop, test, and maintain ETL jobs using IBM InfoSphere DataStage and Talend.
• Develop ETL workflows for data extraction, transformation, loading, and integration from multiple source systems.
• Create and optimize complex SQL queries, stored procedures, and database operations.
• Work with relational databases such as Oracle, SQL Server, DB2, or PostgreSQL.
• Develop and maintain reusable ETL components, job sequences, transformations, and workflows.
• Perform data cleansing, data validation, reconciliation, and quality checks.
• Troubleshoot ETL job failures, identify root causes, and implement corrective actions.
• Optimize ETL job performance and improve data processing efficiency.
• Work with data warehouse concepts, dimensional modeling, and data integration frameworks.
• Support data migration, production deployments, and ongoing maintenance activities.
• Collaborate with business analysts, data architects, QA teams, and other developers.
• Prepare technical documentation, mapping documents, and unit test cases.
• Follow data governance, security, and development standards.

Required Skills

• Strong hands-on experience with IBM InfoSphere DataStage.
• Practical experience with Talend Data Integration / Talend ETL.
• Good knowledge of ETL design, development, and troubleshooting.
• Strong SQL skills, including joins, subqueries, aggregations, and query optimization.
• Experience with relational databases such as Oracle, DB2, SQL Server, or PostgreSQL.
• Understanding of data warehousing, data modeling, and data integration concepts.
• Experience with data validation, reconciliation, and performance tuning.
• Knowledge of job scheduling, dependency management, and production support.
• Ability to analyze technical requirements and translate them into ETL solutions.
• Strong analytical, problem-solving, and communication skills.