Software Engineer

Datamatics; Bengaluru, Mumbai; Hybrid; INR 1,800,000 - 2,400,000; Full time

Job summary

Datamatics in Bengaluru is seeking an experienced ETL Developer with hands-on IBM DataStage expertise and working knowledge of Talend to design, develop, and optimize ETL workflows for enterprise data integration and data warehousing.

You will work with Oracle/DB2, Unix/Linux, and shell scripting, contribute to production support, performance tuning, and collaborate with analysts, DBAs, and cross-functional teams to maintain robust data pipelines.

Qualifications

• Experience in designing, developing, testing, and maintaining ETL jobs with IBM DataStage.
• Strong understanding of ETL concepts and data warehousing.
• Working knowledge of Talend as a secondary skill.
• Proficient SQL and relational databases (Oracle/DB2).
• Proficiency with Unix/Linux and shell scripting.
• ETL performance tuning and production support.

Responsibilities

• Design, develop, test, and maintain ETL jobs using IBM DataStage.
• Extract, transform, cleanse, and load data into data warehouses.
• Optimize ETL performance and troubleshoot production issues.
• Monitor job execution and implement fixes.
• Collaborate with analysts, DBAs, and stakeholders.
• Support job scheduling, deployment, and batch monitoring.
• Use Talend for secondary ETL development and data integration.

Skills

IBM DataStage

ETL

SQL

Unix/Linux

Shell scripting

Data warehousing

Talend

Tools

Talend

Job description

Job Summary

We are looking for an experienced ETL Developer with strong hands-on expertise in IBM DataStage and working knowledge of Talend. The candidate will be responsible for developing, enhancing, maintaining, and optimizing ETL workflows to support enterprise data integration and data warehousing requirements.

Key Responsibilities

• Design, develop, test, and maintain ETL jobs using IBM DataStage.
• Extract, transform, cleanse, and load data from multiple source systems into target databases and data warehouses.
• Work with DataStage stages such as Transformer, Lookup, Join, Sort, Aggregator, Funnel, Sequential File, and Dataset.
• Develop and maintain parallel jobs and server jobs as required.
• Optimize ETL job performance and troubleshoot production issues.
• Monitor job execution, identify failures, and implement permanent fixes.
• Work with databases such as Oracle and DB2 and write SQL queries.
• Support job scheduling, deployment, production releases, and batch monitoring.
• Use Talend for secondary ETL development and data integration activities.
• Collaborate with business analysts, technical teams, DBAs, and other stakeholders.
• Maintain technical documentation and follow development and production support standards.

Required Technical Skills

• Strong hands-on experience with IBM DataStage.
• Good understanding of ETL concepts, data integration, and data warehousing.
• Working knowledge of Talend as a secondary skill.
• Experience with SQL and relational databases such as Oracle or DB2.
• Knowledge of Unix/Linux and shell scripting.
• Experience in ETL performance tuning, debugging, and production support.

Preferred Skills

• IBM InfoSphere DataStage Parallel Extender.
• DataStage administration and deployment.
• Change Data Capture (CDC).
• Data quality and data governance concepts.
• Experience with enterprise data warehouse environments.