Software Development Engineer

Transformcap; Hyderabad; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

Health Catalyst seeks a Software Development Engineer (SDE) in Hyderabad to design, build, and optimize scalable data pipelines and cloud-based integration solutions. The role emphasizes SQL, Python, ETL/ELT concepts, and cloud services.

You will contribute to Snowflake data warehousing and stream-driven architectures, collaborating across teams to deliver measurable healthcare improvements. The position requires hands-on experience with AWS services, Snowflake, Kafka, and Airflow, along with

Qualifications

• 2–4 years of experience in software development, data engineering, or related roles.
• Strong understanding of ETL/ELT processes and data warehousing concepts.
• Hands-on knowledge of AWS Glue, AWS Lambda, AWS SNS, AWS S3.
• Working knowledge of Kafka (basic to medium level).
• Proficiency in SQL and Python.
• Fundamentals of Snowflake: RBAC, ABAC, Snowpipes, Dynamic Tables.
• Experience with Airflow for workflow orchestration.

Responsibilities

• Design, develop, and maintain ETL/ELT pipelines for large-scale data ingestion, transformation, and loading.
• Build and optimize data warehouse solutions in Snowflake for analytics and reporting use cases.
• Work with AWS services including AWS Glue, AWS Lambda, AWS SNS, AWS S3.
• Develop and manage event-driven and streaming workflows using Kafka (basic to medium level).
• Ensure data quality, consistency, and operational reliability across pipelines.
• Collaborate with cross-functional teams to gather requirements and implement practical technical solutions.

Skills

SQL

Python

ETL/ELT

Snowflake

AWS

Kafka

Airflow

Data warehousing

Cloud data engineering

Education

Bachelor's degree in Computer Science/IT/Engineering

Tools

AWS Glue

AWS Lambda

AWS SNS

AWS S3

Job description

Join one of the nation's leading and most impactful health care performance improvement companies. Over the years, Health Catalyst has achieved and documented clinical, operational, and financial improvements for many of the nation's leading healthcare organizations. We are also increasingly serving international markets. Our mission is to be the catalyst for massive, measurable, data-informed healthcare improvement through:

• Data: integrate data in a flexible, open & scalable platform to power healthcare's digital transformation
• Analytics: deliver analytic applications & services that generate insight on how to measurably improve
• Expertise: provide clinical, financial & operational experts who enable & accelerate improvement
• Engagement: attract, develop and retain world-class team members by being a best place to work

Software Development Engineer (SDE)

Role Overview

We are seeking a motivated and detail-oriented Software Development Engineer with 2–4 years of experience in ETL/ELT, data warehousing, and cloud data engineering. The ideal candidate should have hands-on experience in building and supporting scalable data pipelines and cloud-based integration solutions across modern data platforms.

This role requires a strong foundation in SQL, Python, ETL/ELT concepts, and cloud services, along with the ability to work collaboratively in a fast-paced engineering environment.

Key Responsibilities

• Design, develop, and maintain ETL/ELT pipelines for large-scale data ingestion, transformation, and loading
• Build and optimize data warehouse solutions in Snowflake for analytics and reporting use cases
• Work with AWS services including:
  • AWS Glue
  • AWS Lambda
  • AWS SNS
  • AWS S3
• Support integration with additional cloud technologies and data platforms as needed
• Develop and manage event-driven and streaming workflows using Kafka (basic to medium level)
• Implement and maintain Snowflake capabilities such as:
  • RBAC and ABAC
  • Snowpipes
  • Dynamic Tables
  • Write efficient SQL queries for transformation, validation, and analytics
  • Develop Python-based automation scripts and data processing logic
  • Build and orchestrate workflows using Airflow /Step Functions
  • Ensure data quality, consistency, and operational reliability across pipelines
  • Troubleshoot production issues and improve system performance, scalability, and maintainability
  • Collaborate with cross-functional teams to gather requirements and implement practical technical solutions
  • Document data architecture, process flows, and operational procedures

Required Skills

• 2–4 years of experience in software development, data engineering, or related roles
• Strong understanding of ETL/ELT processes and data warehousing concepts
• Hands-on knowledge of:
  • AWS Glue
  • AWS Lambda
  • AWS SNS
  • AWS S3
• Working knowledge of Kafka (basic to medium level)
• Proficiency in SQL and Python
• Fundamentals of Snowflake:
  • RBAC
  • ABAC
  • Snowpipes
  • Dynamic Tables
• Experience with Airflow for workflow orchestration
• Basic to moderate exposure to other cloud technologies and services
• Strong analytical, debugging, and problem-solving abilities
• Strong critical thinking and a team-first mindset

Desired Skills (Not Mandatory)

• Familiarity with Pentaho for ETL/data integration workflows
• Exposure to additional cloud services such as:
  • AWS EMR
  • Redshift
  • Athena
  • Step Functions
  • IAM / CloudWatch / EventBridge
• Familiarity with distributed systems, data lakes, and streaming architectures
• Understanding of data governance, security, and access controls in cloud environments

Behavioral Competencies

• Team player with strong collaboration skills
• Ownership mindset and attention to detail
• Ability to learn new technologies quickly
• Strong communication and documentation skills
• Capable of working in a fast-paced, agile environment

Educational Qualification

• Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field

The above statements describe the general nature and level of work being performed in this job function. They are not intended to be an exhaustive list of all duties, and indeed additional responsibilities may be assigned by Health Catalyst.

Studies show that candidates from underrepresented groups are less likely to apply for roles if they don’t have 100% of the qualifications shown in the job posting. While each of our roles have core requirements, please thoughtfully consider your skills and experience and decide if you are interested in the position. If you feel you may be a good fit for the role, even if you don’t meet all of the qualifications, we hope you will apply. If you feel you are lacking the core requirements for this position, we encourage you to continue exploring our careers page for other roles for which you may be a better fit.

At Health Catalyst, we appreciate the opportunity to benefit from the diverse backgrounds and experiences of others. Because of our deep commitment to respect every individual, Health Catalyst is an equal opportunity employer.