7 years of experience on Database warehouse / lake house programming
Experience in implementing at least 2 endtoend data warehouse / data lake projects
Experience in implementing at least 1 Azure Data warehouse / lake house project endtoend
Converted business requirements to concept / technical specification
Worked along with source system experts in finalizing ETL and analytics design
Support data modeler developer in design and development of ETLs
Creation of activity plan as per the agreed concept with timelines
Technical Expertise:
Strong experience with Microsoft Azure components including Azure Data Factory Azure Synapse Azure SQL Database Azure Key Vault MS Fabric Azure DevOps (ADO) and Virtual Networks (VNets).
Expertise in Medallion Architecture for Lakehouses and data modeling in the Gold layer.
Solid understanding of Data Warehouse design principles including star schema snowflake schema and data partitioning.
Rich Experience with MS SQL Database Packages Stored procedure Functions procedures Triggers and data transformation activities using SQL
Good knowledge in SQL loader Data pump and Import/Export utilities
Knowledge on Performance Tuning
Experience with any data visualization or BI tools such as Tableau Power BI
Capacity Planning & Environment Management:
Proven experience in capacity planning environment setup and deployment strategies within Azure.
Familiarity with cloud cloning/copying processes for managing development testing and production environments.
Green Cloud Computing:
Knowledge of green computing principles and a track record of optimizing cloud resources for cost and environmental efficiency.
Interpersonal & Communication Skills:
Ability to work collaboratively with technical and nontechnical teams effectively communicate complex concepts and influence key stakeholders.
Analyze demands and contribute to cost/benefit analysis and estimation
Preferred Qualifications
Certifications:
Azure Solutions Architect Expert or Azure Data Engineer Associate certifications are a plus.
database,tableau,power bi,etl,azure sql database,medallion architecture,azure,azure synapse,azure key vault,virtual networks,lake,ms fabric,azure devops,azure data factory,data visualization,data warehouse design,microsoft azure,data warehouse,sql