Datastage Consultant

3 days ago


Bengaluru Chennai Gurugram, India Tredence Full time ₹ 15,00,000 - ₹ 25,00,000 per year

Role & responsibilities

We are looking for a Senior Consultant with deep expertise in Snowflake and IBM DataStage to lead critical components of our data modernization efforts. This role involves designing migration strategies, refactoring complex ETL logic, and mentoring junior team members while ensuring high-quality delivery of Snowflake-based solutions.

Key Responsibilities:

  • Lead the migration of complex ETL workflows and business rules from IBM DataStage to Snowflake SQL.
  • Design and implement reusable frameworks for data ingestion, transformation, and orchestration.
  • Refactor internal DataStage components such as job control logic, parameter sets, and error handling into Snowflake-native solutions.
  • Optimize Snowflake performance using clustering, partitioning, and query tuning techniques.
  • Collaborate with architects, business analysts, and QA teams to ensure alignment and quality.
  • Mentor consultants and junior engineers on best practices and technical standards.

Preferred candidate profile


• Strong hands-on experience with Snowflake and IBM DataStage.


• Expertise in SQL, data modeling, and performance optimization.


• Experience in cloud platforms and modern data orchestration tools.


• Excellent problem-solving and communication skills.

Preferred Qualifications:


• Snowflake certification(s).


• Experience with dbt, Airflow, or Talend.


• Exposure to data governance and metadata management tools


  • Datastage Consultant

    2 weeks ago


    Chennai, India Wenger & Watson Full time

    JD for Datastage Must have Skills- IBM DataStage, SQLGood to have- Unix, US Healthcare & Insurance. Detailed Job Description- 1.Relevant experience in designing and development of ETL artefacts using IBM DataStage. 2.Strong business analysis and requirement definition background in Data Integration (ETL). 3.Strong SQL/Database concepts. 4.Excellent oral...


  • Bengaluru, India Tredence Inc. Full time

    Job Summary:We are looking for a Senior Consultant with deep expertise in Snowflake and IBM DataStage to lead critical components of our data modernization efforts. This role involves designing migration strategies, refactoring complex ETL logic, and mentoring junior team members while ensuring high-quality delivery of Snowflake-based solutions.Key...


  • Bengaluru, India Tredence Inc. Full time

    Job Summary:We are looking for a Senior Consultant with deep expertise in Snowflake and IBM DataStage to lead critical components of our data modernization efforts. This role involves designing migration strategies, refactoring complex ETL logic, and mentoring junior team members while ensuring high-quality delivery of Snowflake-based solutions.Key...

  • Staff Consultant

    2 weeks ago


    Chennai, Bengaluru, India Oracle Full time

    Job Description Job Description: DataStage Developer Role Overview: We are seeking a highly skilled DataStage Developer with strong hands-on experience in SQL, PL/SQL, and DataStage projects. The ideal candidate will design, implement, and optimize ETL processes to meet evolving business needs. Prior experience in FCCM or any other AML projects is a...


  • Bengaluru, India Tredence Inc. Full time

    Job Summary:We are looking for a Senior Consultant with deep expertise in Snowflake and IBM DataStage to lead critical components of our data modernization efforts. This role involves designing migration strategies, refactoring complex ETL logic, and mentoring junior team members while ensuring high-quality delivery of Snowflake-based solutions.Key...


  • Bengaluru, India Tredence Inc. Full time

    Job Summary:We are looking for a Senior Consultant with deep expertise in Snowflake and IBM DataStage to lead critical components of our data modernization efforts. This role involves designing migration strategies, refactoring complex ETL logic, and mentoring junior team members while ensuring high-quality delivery of Snowflake-based solutions.Key...


  • Bengaluru, India Tredence Inc. Full time

    Job Summary: We are looking for a Senior Consultant with deep expertise in Snowflake and IBM DataStage to lead critical components of our data modernization efforts. This role involves designing migration strategies, refactoring complex ETL logic, and mentoring junior team members while ensuring high-quality delivery of Snowflake-based solutions. Key...


  • Bengaluru, India Tredence Inc. Full time

    Job Summary:We are looking for a Senior Consultant with deep expertise in Snowflake and IBM DataStage to lead critical components of our data modernization efforts. This role involves designing migration strategies, refactoring complex ETL logic, and mentoring junior team members while ensuring high-quality delivery of Snowflake-based solutions.Key...


  • Bengaluru, Karnataka, India Wenger & Watson Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    JD for DatastageMust have Skills- IBM DataStage, SQLGood to have- Unix, US Healthcare & Insurance. Detailed Job Description- 1.Relevant experience in designing and development of ETL artefacts using IBM DataStage. 2.Strong business analysis and requirement definition background in Data Integration (ETL). 3.Strong SQL/Database concepts. 4.Excellent oral...


  • Bengaluru, India Tredence Inc. Full time

    Job Summary: We are looking for a Senior Consultant with deep expertise in Snowflake and IBM DataStage to lead critical components of our data modernization efforts. This role involves designing migration strategies, refactoring complex ETL logic, and mentoring junior team members while ensuring high-quality delivery of Snowflake-based solutions. Key...