Job description

- Convert business requirements to concept/ technical specification

- Work along with source system experts in finalizing ETL and report design

- Data modelling in preparing the data/ dimensional models in Azure Data lake

- Coordinate with central team to replicate tables from source system to data lake

- Support data modeler developer in design and development in MS SQL

- Creation of activity plan as per the agreed concept with timelines

- Design, Develop and Deploy solution

- Support customers during the stabilization phase

- Collaborate with key stakeholders to analyze demands and contribute to cost/benefit analysis and estimation

Required Profile

- 8+ years of experience on Database warehouse programming

- Experience in implementing at least 3 end-to-end data warehouse projects





- Experience in implementing at least 1 Azure Data warehouse project end-to-end

- Rich Experience in with MS SQL Database Packages, Stored procedure, Functions , procedures, Triggers and data transformation activities using SQL

- Experience on dimensional modelling and Data warehousing concepts

- Solid expertise on RDBMS fundamentals

- Good knowledge in SQL loader, Data pump and Import/Export utilities

- Knowledge on Performance Tuning for Oracle RDBMS

- Good oral communication skill

- Experience in building applications with Data Vault 2.0

- Experience with any data visualization or BI tools such as Tableau, PowerBI

- Experience in any ETL tools

📌 Data Architect - Azure Data Warehouse (India)
🏢 Locus IT Services
📍 India