Data Engineer Job in A Client of Freshersworld at Hisar

Responsible to review and analysis of business requirements and designing technical mapping document

Design and develop the data marts as per the business requirements

Maintain and create ETL/ELT pipelines into Azure Data Factory

Maintain and create TSQL codes for managing snapshot/aggregate tables.

Fix data and code issues in Enterprise Data warehouse.

Create and Maintain the documentation on Database objects, Pipelines, and Datamart.

Help build defining best practices & processes

Collaborate on Data warehouse architecture and technical design discussions

Participate in code reviews and technical design discussions.

Provide status reports to the higher management

Maintain Service Levels and department goals for problem resolution.

2 experience in Azure Synapse and ADF (Microsoft SQL Datawarehouse).

Understanding of dimensional and relational modeling

Understanding of BI/DW development methodologies (Kimball/Inmon)

Experience in ETL using Azure Data Factory

Hands-on experience with Synapse / Microsoft SQL Datawarehouse

Good exposure to writing complex SQL

Good understanding of DevOps (GIT, Jenkins)

Good understanding of the business process and analyzing underlying data

Commitment to teamwork as a contributor

Experience with an Agile Methodology like Scrum (JIRA)

Exposure in Oracle (SQL PL/SQL) will be a plus