Role Summary

We are seeking a motivated L1 Data Engineer to support data ingestion, pipeline monitoring, data validation, and operational activities within a healthcare analytics setting. The role involves working with SQL, Snowflake, AWS-based data pipelines, and healthcare datasets while ensuring timely resolution of production issues and maintaining data quality.

Key Responsibilities

Data Pipeline Operations
Monitor and execute Snowflake and AWS-based data pipelines.
Support daily data load activities and validate pipeline execution results.
Ensure successful ingestion of source data into Snowflake layers.
Review pipeline run history, task statuses, and execution logs.

SQL Development & Data Validation
Write and execute SQL queries for data analysis, validation, and troubleshooting.
Perform data reconciliation and quality checks across source and target systems.
Support root cause analysis for data discrepancies and load failures.
Validate fact and dimension table outputs against business requirements.

Snowflake Administration & Support




Execute and monitor Snowflake tasks, stored procedures, and workflows.
Support incremental and full-load processes.
Investigate and resolve Snowflake pipeline failures and data quality issues.
Assist in performance monitoring and basic query optimization.

Data Architecture Understanding
Develop an understanding of end-to-end data flow across Landing, Raw, L1, L2, and L3 layers.
Understand fact/dimension data models and business KPI generation processes.
Work closely with senior engineers to support enhancements and operational activities.

Healthcare Business Knowledge
Gain knowledge of healthcare and pharmaceutical data domains.
Understand healthcare datasets such as sales, patient, provider, product, and market data.
Collaborate with business stakeholders to understand reporting and analytical needs.

Incident Management & Troubleshooting
Perform Level-1 investigation of production

📌 Etl Analyst Hyderabad
🏢 Tech Mahindra
📍 Hyderabad