Description What you'll do:
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.
What you'll need:
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