We are seeking a skilled Data Engineer to design, develop, and maintain data pipelines that automate the flow of data from On-prem SQL DB into Azure Synapse, enabling robust reporting and analytics within Power BI.

This role will be crucial in building and optimizing our data infrastructure, ensuring data accuracy, and improving the efficiency of our data processes.

Experience Level : 5-9 yrs of exp

Qualifications : Bachelor's Degree in information technology, computer science, or a related field

Must have skills ( Must have skills in all the below skills 3 to 5 relevant exp is must) :

- Migration : Work on migrating existing ETL processes and objects into Azure synapse which requires building complex optimized stored procedures , functions.

- Develop and maintain data pipelines : Design, implement, and maintain automated data pipelines from On-prem to Azure Synapse using Azure Data Factory

- Performance Optimization : Optimize data pipeline performance by identifying and addressing bottlenecks, improving query efficiency, and implementing best practices for data storage and retrieval in Azure Synapse.

- PL/SQL , database architecture, performance tuning of existing procedures and processes.

- Help automate day to day processes by use of python programming , aware of pandas , numpy libraries

Tasks & responsibilities :

This role will be crucial in building and optimizing our data infrastructure, ensuring data accuracy, and improving the efficiency of our data processes