AddressData Engineer
JOB DESCRIPTIONDescription What you'll do:
Responsible to review and analysis of business requirements and designing technical mapping documentDesign and develop the data marts as per the business requirementsMaintain and create ETL/ELT pipelines into Azure Data FactoryMaintain 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 & processesCollaborate on Data warehouse architecture and technical design discussionsParticipate in code reviews and technical design discussions.Provide status reports to the higher managementMaintain 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 modelingUnderstanding of BI/DW development methodologies (Kimball/Inmon)Experience in ETL using Azure Data FactoryHands-on experience with Synapse / Microsoft SQL DatawarehouseGood exposure to writing complex SQLGood understanding of DevOps (GIT, Jenkins)Good understanding of the business process and analyzing underlying dataCommitment to teamwork as a contributorExperience with an Agile Methodology like Scrum (JIRA)Exposure in Oracle (SQL PL/SQL) will be a plus(Ref:www.freshersworld.com,freshersworld)
