Data Architect - Azure Data Warehouse @ Locus It Services

• 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

• Strong 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