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