Experience : 7 to 9 Yrs

Location : Chennai, Tamil Nadu, India

Work Mode : Full-time

Work Timings : 9:00 AM 6:00 PM IST (General shift).

Notice Period : immediate to 15 days , Immediate joiners preferred

Experience Requirements :

Relevant Experience : 5+ years of hands-on experience in ETL development using SQL, SAS, and AWS services (Redshift, S3, EMR) within the healthcare insurance domain.

Role Overview :

We are seeking a highly skilled Lead Software Engineer / ETL Developer with strong expertise in data engineering, AWS cloud services, and healthcare insurance domain knowledge. The ideal candidate will have extensive experience in designing, developing, and optimizing ETL processes, along with strong analytical and communication skills.

Key Responsibilities :

- Design, develop, and maintain scalable ETL pipelines using modern data tools and frameworks.

- Work extensively with SQL, SAS, and cloud-based data platforms.

- Build and optimize data workflows using AWS services such as Redshift, S3, and EMR.

- Perform complex data analysis to support business and reporting requirements.

- Collaborate with cross-functional teams including business stakeholders and data analysts.

- Ensure data quality, integrity, and performance optimization across systems.

- Translate business requirements into technical solutions within the healthcare insurance domain.

Technical Skills :

Must Have :

- 5+ years of ETL/Data Engineering experience

- Strong hands-on experience in SQL and SAS

- Experience with AWS services (Redshift, S3, EMR)

- Experience in Healthcare Insurance domain

- Strong data analysis and problem-solving skills

- Experience with ETL tools (traditional or cloud-based)

- Good communication and stakeholder management skills

Nice to Have :

- Experience beyond 7 years in data engineering

- Exposure to additional programming languages such as Python or Spark

- Experience with other cloud platforms (Azure or GCP)

- Experience in other regulated domains (BFSI, Healthcare, etc.)

- Knowledge of modern data pipeline and orchestration tools (Airflow, etc.)

- Experience working in Agile/Scrum environments

Qualifications :

- Bachelors Degree in Computer Science, Information Technology, or a related field

- 7+ years of overall IT experience with a minimum of 5+ years in ETL/Data Engineering

- Proven expertise in SQL, SAS, and ETL tools

- Hands-on experience with AWS services such as Redshift, S3, and EMR

- Prior experience in the Healthcare Insurance domain

- Strong analytical, problem-solving, and communication skills

Soft Skills & Competencies :

- Strong verbal and written communication skills

- Excellent analytical and critical thinking abilities

- Effective stakeholder management and collaboration

- Ability to work independently and in team environments

- Problem-solving mindset with attention to detail

- Adaptability to fast-paced and dynamic project environments