Data Engineer
Posted Updated
Description
Air Distribution Limited in Pune, India, is seeking a Data Engineer to design, build, and maintain data infrastructure powering reporting and analytics. The role focuses on the Microsoft Azure data ecosystem, including ADF, Azure SQL Database/Synapse, and Data Lake to ingest, transform, and deliver trusted datasets.
You will develop pipelines, optimize SQL, model star and snowflake schemas, and collaborate with finance, supply chain, and operations to deliver scalable solutions and measurable
Design, build, and monitor ADF pipelines, dataflows, and triggers. Write and maintain stored procedures, views, and reporting tables; tune queries. Design star/snowflake schemas for analytics. Analyze cross-system data relationships for unified reporting views. Develop Python scripts for validation and automation. Implement data quality checks and reconciliation processes. Create technical documentation for pipelines, data models, and schedules. Collaborate with finance, supply chain, and operations to deliver scalable solutions. Bachelor’s degree in Computer Science or related field. 5+ years of experience in data engineering, ETL, or database development. Hands-on experience with Azure Data Factory, Azure SQL Database/Synapse, and Azure Data Lake. Advanced SQL development: stored procedures, functions, indexing, performance tuning. Expertise in star and snowflake schema design for analytical models. Familiarity with data governance, security, and Azure best practices. Python scripting for data transformation and automation. Understanding of ETL/ELT patterns and incremental loading.Skills
Sign in to read and join the discussion.