ETL Lead

2 weeks ago

Pune Maharashtra India, Maharashtra Nice Software Solutions Pvt. Ltd. Full time

Data Engineering SME – Talend / Datastage / Oracle / Cloudera


Location - DUBAI (ON-SITE)

Experience - 10+ Years


Job Description

We are looking for a highly skilled Data Engineering SME with deep expertise in Talend or Datastage, strong hands-on experience in Oracle or Cloudera/Hadoop ecosystems, and excellent SQL & data engineering skills. The ideal candidate will play a key role in designing, building, optimizing, and supporting enterprise-grade data pipelines and data integration solutions.

Key Responsibilities

Data Engineering & ETL Development

  • Design, develop, and optimize ETL pipelines using Talend or IBM Datastage.
  • Build scalable data integration workflows for batch and real-time data processing.
  • Implement transformation logic, error handling, performance tuning, and reusable ETL frameworks.
  • Drive migration and modernization of existing ETL processes to Talend, Datastage, or Cloudera platforms.

Data Platform Expertise

  • Manage and maintain data workflows on Oracle, Cloudera/Hadoop, or hybrid cloud environments.
  • Work with Oracle PL/SQL, partitions, indexes, stored procedures, and query optimization.
  • Hands-on experience with Hadoop components such as HDFS, Hive, Impala, Spark (optional but preferred).
  • Support end-to-end data lifecycle including ingestion, transformation, storage, and delivery.

SQL & Data Modeling

  • Write advanced SQL for complex transformations, data validation, profiling, and analysis.
  • Build logical and physical data models aligned with business requirements.
  • Perform data quality checks, root cause analysis, and impact assessments.
  • Ensure data accuracy, completeness, and consistency across systems.

Solution Design & SME Role

  • Act as the Subject Matter Expert for all ETL/data engineering design decisions.
  • Provide best practices, standards, and architectural guidance on data integration.
  • Collaborate with cross-functional teams including BI, Analytics, Product, and Platform groups.
  • Review team deliverables and ensure technical quality and performance.
  • Support production systems, troubleshoot failures, and ensure high availability.

Testing & Documentation

  • Conduct end-to-end testing: unit, functional, regression, integration, and performance.
  • Ensure detailed documentation for data flows, mappings, and ETL processes.
  • Create operational guides, SOPs, and knowledge-sharing collateral for the team.

Required Skills & Experience

Technical Skills

  • Talend (preferred) or IBM Datastage – expert-level proficiency.
  • Strong experience in Oracle (PL/SQL, performance tuning) or Cloudera/Hadoop.
  • Deep understanding of ETL frameworks, data warehousing, data pipelines.
  • Strong SQL skills – joins, window functions, analytical queries, optimization.
  • Experience with data modeling, data quality, and metadata management.
  • Familiarity with UNIX/Linux scripting, job scheduling, and automation tools.

Nice-to-Have

  • Exposure to cloud data environments like AWS, Azure, or GCP.
  • Experience with Spark, Kafka, or Python.
  • Knowledge of CI/CD, version control, and DevOps practices.

  • ETL Lead

    2 weeks ago

    Pune, Maharashtra, India Nice Software Solutions Pvt. Ltd. Full time ₹ 12,00,000 - ₹ 24,00,000 per year

    Data Engineering SME – Talend / Datastage / Oracle / ClouderaLocation - DUBAI (ON-SITE)Experience - 10+ YearsJob DescriptionWe are looking for a highly skilledData Engineering SMEwith deep expertise inTalend or Datastage, strong hands-on experience inOracle or Cloudera/Hadoop ecosystems, and excellentSQL & data engineering skills. The ideal candidate will...

  • Senior ETL Developer

    2 weeks ago

    Pune, Maharashtra, India, Maharashtra Luxoft Full time

    Our client is an EU subsidiary of a Global Financial Bank working in multiple markets and asset classes.DWH / ETL developer will work closely with the Development Lead to design, build interfaces and integrate data from a variety from internal and external data sources into the new Enterprise Data Warehouse environment. The ETL Developer will be responsible...

  • ETL Developer

    2 weeks ago

    Pune, Maharashtra, India, Maharashtra Vastika Inc Full time

    Summary We are looking for highly skilled Data Engineers with 3 to 5 years of experience in building and managing advanced data solutions. The ideal candidate should have extensive experience with SQL, Ab-Initio, Teradata and Google Cloud Platform (GCP). Key Responsibilities Be the part of the team towards design, development, and optimization of large-scale...

  • ETL Developer

    2 weeks ago

    Pune, Maharashtra, India, Maharashtra Luxoft Full time

    Project Description:Our client is an EU subsidiary of a Global Financial Bank working in multiple markets and asset classes.DWH / ETL developer will work closely with the Development Lead to design, build interfaces and integrate data from a variety from internal and external data sources into the new Enterprise Data Warehouse environment. The ETL Developer...

  • ETL Developer

    1 week ago

    Pune, Maharashtra, India Luxoft Full time

    Project Description:Our client is an EU subsidiary of a Global Financial Bank working in multiple markets and asset classes.DWH / ETL developer will work closely with the Development Lead to design, build interfaces and integrate data from a variety from internal and external data sources into the new Enterprise Data Warehouse environment. The ETL Developer...

  • Engineering Lead- ETL

    4 days ago

    Pune, Maharashtra, India Barclays Full time

    Join us as an Engineering Lead-ETL at Barclays, where you'll spearhead the evolution of our digital landscape, driving innovation and excellence. You'll harness cutting-edge technology to revolutionize our digital offerings, ensuring unapparelled customer experiences.To be a successful Engineering Lead-ETL, you should have experience with:Ab InitioUnix Shell...

  • Senior Etl Developer

    2 weeks ago

    Pune, Maharashtra, India Luxoft Full time ₹ 7,50,000 - ₹ 11,25,000 per year

    Project DescriptionOur client is an EU subsidiary of a Global Financial Bank working in multiple markets and asset classes.DWH / ETL developer will work closely with the Development Lead to design, build interfaces and integrate data from a variety from internal and external data sources into the new Enterprise Data Warehouse environment. The ETL Developer...

  • ETL & Data Architect

    1 week ago

    Pune, Maharashtra, India Vodafone Full time

    Design and implement ETL processes and data architecture solutions. Develop and enforce data management policies and best practices. Collaborate with stakeholders to define metadata, data models, and integration strategies. Architect solutions using ETL tools like Ab-Initio or equivalent. Ensure alignment with enterprise architecture policies and...

  • Lead -ETL Architect or Data Architect_Pune(10 To 15 year)

    2 days ago

    Pune, Maharashtra, India VOIS Full time

    About this RoleWe are seeking an experienced ETL & Data Architect to lead the design and implementation of scalable data solutions. This role involves working closely with stakeholders to define data models, enforce data management standards, and optimise data storage and processing. The individual will be responsible for architecting solutions using ETL...

  • ETL & Data Architect

    1 week ago

    Pune, Maharashtra, India Vodafone Full time

    Who we areAt Vodafone, we're not just shaping the future of connectivity for our customers – we're shaping the future for everyone who joins our team. When you work with us, you're part of a global mission to connect people, solve complex challenges, and create a sustainable and more inclusive world. If you want to grow your career whilst finding the...