Mandatory Skills :

- Azure Data Factory, Azure Logic Apps, MySQL, SQL Server, Shell Scripting

Azure, Data Modelling & Performance Optimization :

- Design and implement scalable data architectures using Microsoft Azure.

- Build and manage data warehouse/Lakehouse solutions with Azure Data Lake Storage.

- Develop conceptual, logical, and physical data models aligned with business needs.

- Implement star and snowflake schemas for efficient analytics and reporting.

- Build and optimize complex stored procedures in Microsoft SQL Server using T-SQL.

- Apply advanced SQL techniques including joins, CTEs, and window functions.

- Optimize query performance using execution plans and query tuning techniques.

- Design indexing strategies (clustered, non-clustered, column store) for performance improvement.

- Implement table partitioning and efficient data distribution for large datasets.

- Optimize ETL/ELT pipelines for scalability, reliability, and cost efficiency.

- Monitor and resolve performance issues such as blocking, deadlocks, and long-running queries.

- Implement Slowly Changing Dimensions (SCD Type 1 & 2) for historical tracking.

- Ensure data quality, governance, validation, and security compliance.

- Develop dashboards and reports using Microsoft Power BI and collaborate with stakeholders.

- Lead and mentor data engineers, driving best practices, code reviews, and architectural decisions.