ETL Developer

21 hours ago

Coimbatore, Tamil Nadu, India Connected Value Health Solutions Full time ₹ 1,04,000 - ₹ 1,30,878 per year

ETL Developer

Job Title: ETL Developer FTE

Location: Coimbatore

Start Date: ASAP

Job Summary:

We are looking for an experienced ETL Developer with strong expertise in Apache Airflow, Redshift, and SQL-based data pipelines, with upcoming transitions to Snowflake. This is a contract role based in Coimbatore, ideal for professionals who can independently deliver high-quality ETL solutions in a cloud-native, fast-paced environment.

Key Responsibilities:

1. ETL Design and Development:

  • Design and develop scalable and modular ETL pipelines using Apache Airflow, with orchestration and monitoring capabilities.
  • Translate business requirements into robust data transformation pipelines across cloud data platforms.
  • Develop reusable ETL components to support a configuration-driven architecture.

2. Data Integration and Transformation:

  • Integrate data from multiple sources: Redshift, flat files, APIs, Excel, and relational databases.
  • Implement transformation logic such as cleansing, standardization, enrichment, and deduplication.
  • Manage incremental and full loads, along with SCD handling strategies.

3. SQL and Database Development:

  • Write performant SQL queries for data staging and transformation within Redshift and Snowflake.
  • Utilize joins, window functions, and aggregations effectively.
  • Ensure indexing and query tuning for high-performance workloads.

4. Performance Tuning:

  • Optimize data pipelines and orchestrations for large-scale data volumes.
  • Tune SQL queries and monitor execution plans.
  • Implement best practices in distributed data processing and cloud-native optimizations.

5. Error Handling and Logging:

  • Implement robust error handling and logging in Airflow DAGs.
  • Enable retry logic, alerting mechanisms, and failure notifications.

6. Testing and Quality Assurance:

  • Conduct unit and integration testing of ETL jobs.
  • Validate data outputs against business rules and source systems.
  • Support QA during UAT cycles and help resolve data defects.

7. Deployment and Scheduling:

  • Deploy pipelines using Git-based CI/CD practices.
  • Schedule and monitor DAGs using Apache Airflow and integrated tools.
  • Troubleshoot failures and ensure data pipeline reliability.

8. Documentation and Maintenance:

  • Document data flows, DAG configurations, transformation logic, and operational procedures.
  • Maintain change logs and update job dependency charts.

9. Collaboration and Communication:

  • Work closely with data architects, analysts, and BI teams to define and fulfill data needs.
  • Participate in stand-ups, sprint planning, and post-deployment reviews.

10. Compliance and Best Practices:

  • Ensure ETL processes adhere to data security, governance, and privacy regulations (HIPAA, GDPR, etc.).
  • Follow naming conventions, version control standards, and deployment protocols.

Required Skills & Experience:

  • 3–6 years of hands-on experience in ETL development.
  • Proven experience with Apache Airflow, Amazon Redshift, and strong SQL.
  • Strong understanding of data warehousing concepts and cloud-based data ecosystems.
  • Familiarity with handling flat files, APIs, and external sources.
  • Experience with job orchestration, error handling, and scalable transformation patterns.
  • Ability to work independently and meet deadlines.

Preferred Skills:

  • Exposure to Snowflake or plans to migrate to Snowflake platforms.
  • Experience in healthcare, life sciences, or regulated environments is a plus.
  • Familiarity with Azure Data Factory, Power BI, or other cloud BI tools.
  • Knowledge of Git, Azure DevOps, or other version control and CI/CD platforms.

Role & responsibilities

Preferred candidate profile

  • ETL Developer

    22 hours ago

    Coimbatore, Tamil Nadu, India Value Health Inc Full time ₹ 1,04,000 - ₹ 1,30,878 per year

    Job Title :ETL Developers.Job Location :Coimbatore.Type :WFO.Job DescriptionKey Responsibilities :ETL Design And DevelopmentDesign and develop efficient, scalable SSIS packages to extract, transform, and load data between systems.Translate business requirements into technical ETL solutions using data flow and control flow logic.Develop reusable ETL...

  • ETL Developer

    7 days ago

    Coimbatore, Tamil Nadu, India Value Health Inc Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    Job Title :ETL Developer with Experience in Airflow , Snowflake & Redshift.Team :Technology.Work Location :Coimbatore.Job SummaryWe are looking for an experienced Senior ETL Developer with strong hands-on expertise in SSIS and SQL Server to join our data engineering team on a contract basis.The selected candidate will be responsible for developing,...

  • ETL Developer

    1 week ago

    Coimbatore, Tamil Nadu, India Value Health Inc Full time

    Job Title : ETL Developer with Experience in Airflow , Snowflake & Redshift.Team : Technology.Work Location : Coimbatore.Job Summary :We are looking for an experienced Senior ETL Developer with strong hands-on expertise in SSIS and SQL Server to join our data engineering team on a contract basis.The selected candidate will be responsible for developing,...

  • ETL Developer

    2 days ago

    Coimbatore, Tamil Nadu, India Value Health Inc Full time

    Job Title : ETL Developers.Job Location : Coimbatore.Type : WFO.Job description :Key Responsibilities : ETL Design and Development :- Design and develop efficient, scalable SSIS packages to extract, transform, and load data between systems.- Translate business requirements into technical ETL solutions using data flow and control flow logic.- Develop...

  • Senior Etl Developer

    7 days ago

    Coimbatore, Tamil Nadu, India Connected Value Health Solutions Full time ₹ 1,04,000 - ₹ 1,30,878 per year

    Sr ETL DeveloperJob Title: Sr ETL DeveloperLocation: CoimbatoreStart Date: ASAPJob Summary:We are looking for an experienced Sr ETL Developer with strong expertise in Apache Airflow, Redshift, and SQL-based data pipelines, with upcoming transitions to Snowflake. This is a contract role based in Coimbatore, ideal for professionals who can independently...

  • ETL Developers with Experience in Airflow

    7 days ago

    Coimbatore, Tamil Nadu, India Value Health Inc Full time ₹ 15,00,000 - ₹ 20,00,000 per year

    Job Title: ETL Developerwith Experience in Airflow , Snowflake & RedshiftTeam: TechnologyWork Location: CoimbatoreJob Summary:We are looking for an experienced Senior ETL Developer with strong hands-on expertise in SSIS and SQL Server to join our data engineering team on a contract basis. The selected candidate will be responsible for developing, optimizing,...

  • ETL Developers with Experience in Airflow

    3 days ago

    Coimbatore, Tamil Nadu, India Value Health Inc Full time

    Job Title: ETL Developers Job Location: Coimbatore Type: WFO Job description Key Responsibilities: 1. ETL Design and Development: Design and develop efficient, scalable SSIS packages to extract, transform, and load data between systems. Translate business requirements into technical ETL solutions using data flow and control flow logic. ...

  • ETL Specialist

    2 weeks ago

    Coimbatore, Tamil Nadu, India beBeeEtl Full time ₹ 90,00,000 - ₹ 1,20,00,000

    We are seeking a skilled ETL professional to join our team as an ETL Developer. This role involves working with Talend Open Studio, BigQuery, PostgreSQL, Python, and GCP.**Job Summary:**We require an experienced developer who can design and optimize complex ETL pipelines using TMC. Additionally, they should be proficient in BigQuery, PostgreSQL, Python, and...

  • ETL Tester

    1 week ago

    Coimbatore, Tamil Nadu, India Qode Full time

    ETL TesterLocation: Chennai, IndiaWorkplace Type: OnsiteAbout the RoleWe are seeking a highly motivated and experienced ETL Tester to join our dynamic team in Chennai. As an ETL Tester, you will be responsible for ensuring the quality and reliability of our data warehousing solutions. You will work closely with developers, data analysts, and other...

  • ETL Specialist

    3 weeks ago

    Coimbatore, Tamil Nadu, India Responsive Full time

    We are seeking a highly skilled ETL Specialist with expertise in building, maintaining, and optimizing data pipelines using Python scripting. The ideal candidate will have experience working in a Linux environment, managing large-scale data ingestion, processing files in S3, and balancing disk space and warehouse storage efficiently. This role will be...