Data Analytics Senior Integration Data Engineer

IND KCI Medical India Private limited; Bengaluru; Hybrid; INR 1,800,000 - 2,400,000; Full time

Job summary

Solventum is hiring a Senior Integration Data Engineer to own end-to-end ETL pipelines transforming healthcare data into a reliable Snowflake data warehouse. You will design scalable, cloud-native ETL processes using AWS Glue and related tools, implementing data quality checks, and collaborating with data modelers to align with data architecture.

Ideal candidates bring 6+ years in ETL, strong SQL, Python, and Snowflake experience, with hybrid work in Bangalore.

Qualifications

• 6+ years of dedicated ETL development experience.
• 4+ years with at least one major ETL tool (e.g., AWS Glue, Informatica, DataStage, Fivetran).
• 4+ years of experience writing complex SQL for data-intensive applications.
• 1+ years of experience with Snowflake, including Snowpipe and COPY command.

Responsibilities

• Design, develop, and test high-performance and scalable ETL processes to move data from disparate sources into the data warehouse.
• Implement complex data transformations and business logic within the ETL workflows to cleanse, standardize, and enrich the data according to business requirements.
• Take ownership of the end-to-end data pipeline, including monitoring, troubleshooting, and optimizing ETL jobs for performance and reliability.
• Develop and maintain comprehensive documentation for all ETL processes, including data source mapping, transformation rules, and data lineage.
• Collaborate with Data Modelers and Data Architects to understand data structures and ensure ETL processes align with physical data models.
• Implement data quality checks and validation steps within the pipelines to ensure the accuracy and integrity of the data being loaded.
• Work closely with source system owners to understand data formats and ensure seamless data extraction.

Skills

SQL

ETL Development

Snowflake

Python

Data Warehousing

Troubleshooting

Education

Bachelor's degree in CS/Engineering

Tools

AWS Glue

AWS S3

Informatica

HVR

Fivetran

Job description

At Solventum, we improve lives by helping healthcare professionals do their best work. Join a team using innovation and insight to make a real impact on the future of healthcare. All roles listed are with Solventum, and we’re committed to protecting your personal information—learn more in our Privacy Policy: https://www.solventum.com/en-us/home/legal/website-privacy-statement/applicant-privacy/

Job Description: Data Analytics Senior Integration Data Engineer (Solventum) 3M Health Care is now Solventum At Solventum, we enable better, smarter, safer healthcare to improve lives. As a new company with a long legacy of creating breakthrough solutions for our customers’ toughest challenges, we pioneer game‑changing innovations at the intersection of health, material and data science that change patients' lives for the better while enabling healthcare professionals to perform at their best. Because people, and their wellbeing, are at the heart of every scientific advancement we pursue. We partner closely with the brightest minds in healthcare to ensure that every solution we create melds the latest technology with compassion and empathy. Because at Solventum, we never stop solving for you.

The Impact You’ll Make in this Role

As a Senior Integration Data Engineer, you will serve as the technical backbone of our data ecosystem. You will be responsible for the full lifecycle of data integration, transforming raw, disparate healthcare data into a structured, reliable asset within our Snowflake data warehouse. You will leverage AWS Glue, FiveTran and Snowpipes to build scalable, cloud‑native pipelines that empower analytics, drive clinical insights, and support our mission in the healthcare space.

Core Responsibilities

• Design, develop, and test high-performance and scalable ETL processes to move data from disparate sources (including databases, APIs, and flat files) into the data warehouse.
• Implement complex data transformations and business logic within the ETL workflows to cleanse, standardize, and enrich the data according to business requirements.
• Take ownership of the end-to-end data pipeline, including monitoring, troubleshooting, and optimizing ETL jobs for performance and reliability.
• Develop and maintain comprehensive documentation for all ETL processes, including data source mapping, transformation rules, and data lineage.
• Collaborate with Data Modelers and Data Architects to understand data structures and ensure ETL processes align with physical data models.
• Implement data quality checks and validation steps within the pipelines to ensure the accuracy and integrity of the data being loaded.
• Work closely with source system owners to understand data formats and ensure seamless data extraction.

Required Skills and Experiences

• Bachelor's Degree in Engineering or associated field.
• Deep, hands‑on expertise with enterprise-level ETL tools such as AWS Glue, AWS S3, Informatica (IICS/PowerCenter), HVR, or Fivetran.
• Advanced proficiency in SQL, with the ability to write complex queries, stored procedures, and functions for data extraction and manipulation.
• Strong scripting skills in languages like Python, Perl, or Shell scripting to automate workflows and implement custom transformation logic.
• Proven experience building and maintaining ETL solutions in a data warehousing environment.
• Strong understanding of database fundamentals and experience working with various relational databases (e.g., Oracle, SQL Server, Postgres), NoSQL, APIs, SFTPs, etc.
• Exceptional troubleshooting and problem‑solving skills, with a knack for debugging complex data pipeline issues.
• Ability to work independently and manage multiple ETL projects simultaneously.

Minimum Qualifications

• 6+ years of dedicated experience as an ETL Developer or Engineer.
• 4+ years of intensive development experience with at least one major ETL tool (e.g., AWS Glue, Informatica, DataStage, Fivetran).
• 4+ years of experience writing complex SQL for data‑intensive applications.
• Demonstrable experience performance tuning and optimizing long‑running ETL jobs.
• 1+ years of experience with Snowflake, including its data loading features (e.g., Snowpipe, COPY command).

Nice-to-Haves

• Experience with cloud‑native ETL/ELT services like AWS Glue, Azure Data Factory, or Google Dataflow.
• Familiarity with Change Data Capture (CDC) techniques and tools.
• Exposure to big data technologies like Spark or Hadoop.
• Basic understanding of data modeling concepts (e.g., star schema, snowflake schema).

Education

Bachelor’s in Computer Science, Information Systems, Engineering, science discipline, or similar

Work location

Bangalore (Hybrid)

Travel

None

A new healthcare company with a rich history. With more than 70 years of delivering healthcare innovations, we continue to move the industry forward by helping to solve our customers’ biggest challenges. 20,000+ employees worldwide. Solventum relies on the courage and the boundless insights of professionals worldwide to achieve exceptional results for our customers and those who rely on them. Healthcare that leads with heart and humility starts with listening and never finishes, only evolves. As long as healthcare challenges remain unsolved, we will be here, united by empathy and a relentless belief that countless lives are improved through our work. Operations in 38 countries. Driven by our dedication to improved outcomes for all we serve, we break through by making unprecedented connections that impact lives. In more than 300 offices and facilities around the world, we work closely with customers and partners to create positive healthcare outcomes that transcend borders. To realize our shared vision, we harness diverse talents and perspectives from every background to not only address our customers' most urgent priorities but anticipate the needs of the future.