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 reusable ETL components that support modular, configuration-driven architecture.

Data Integration and Transformation :

- Integrate data from multiple heterogeneous sources : SQL Server, flat files, APIs, Excel, etc.

- Implement business rules and data transformations such as cleansing, standardization, enrichment, and deduplication.

- Manage incremental loads, full loads, and slowly changing dimensions (SCD) as required.

SQL and Database Development :

- Write complex T-SQL queries, stored procedures, and functions to support data

transformations and staging logic.

- Perform joins, unions, aggregations, filtering, and windowing operations effectively for data preparation.

- Ensure referential integrity and proper indexing for performance.

Performance Tuning :

- Optimize SSIS packages by tuning buffer sizes, using parallelism, and minimizing unnecessary transformations.

- Tune SQL queries and monitor execution plans for efficient data movement and transformation.

- Implement efficient data loads for high-volume environments.

Error Handling and Logging :

- Develop error-handling mechanisms and event logging in SSIS using Event Handlers and custom logging frameworks.

- Implement restartability, checkpoints, and failure notifications in workflows.

Testing and Quality Assurance :

- Conduct unit and integration testing of ETL pipelines.

- Validate data outputs against source and business rules.

- Support QA teams in user acceptance testing (UAT) and defect resolution.

Deployment and Scheduling :

- Package, deploy, and version SSIS solutions across development, test, and production environments.

- Schedule ETL jobs using SQL Server Agent or enterprise job schedulers (e.g., Control-M, Tidal).

- Monitor and troubleshoot job failures and performance issues.

Documentation and Maintenance :

- Maintain documentation for ETL designs, data flow diagrams, transformation logic, and job schedules.

- Update job dependencies and maintain audit trails for data pipelines.

Collaboration and Communication :

- Collaborate with data architects, business analysts, and reporting teams to understand data needs.

- Provide technical support and feedback during requirements analysis and post deployment support.

- Participate in sprint planning, status reporting, and technical reviews.

Compliance and Best Practices :

- Ensure ETL processes comply with data governance, security, and privacy regulations (HIPAA, GDPR, etc.)

- Follow team coding standards, naming conventions, and deployment protocols.

Required Skills & Experience :

- 4 - 8 years of hands-on experience with ETL development using SSIS.

- Strong SQL Server and T-SQL skills.

- Solid understanding of data warehousing concepts and best practices.

- Experience with flat files, Excel, APIs, or other common data sources.

- Familiarity with job scheduling and monitoring (e.g., SQL Agent).

- Strong analytical and troubleshooting skills.

- Ability to work independently and meet deadlines.

Preferred Skills :

- Exposure to Azure Data Factory or cloud-based ETL tools.

- Experience with Power BI or other reporting platforms.

- Experience in healthcare, finance, or regulated domains is a plus.

- Knowledge of version control tools like Git or Azure DevOps.

(ref:hirist.tech)

  • ETL Developer

    16 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

    15 hours ago

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

    ETL DeveloperJob Title: ETL Developer FTELocation: CoimbatoreStart Date: ASAPJob 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...

  • 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,...

  • 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...