Data Warehouse Architect
Location: Toronto, ON (Hybrid - 4 days onsite a week)
Full time
Domain: Banking
Job Description
· 10+ years of experience in Data Discovery & Analysis, Data Quality and Data Integration2.
· 7+ years of experience in designinig and building realtime, near realtime and batch data processing Pipelines
· Worked on the data migration data warehousing projects on cloud mainly Azure
· Should be able to debug and understand existing ETL and write new ETL’s pipelines
· Hands-on experience with data ingestion and data transformations using Azure Data Factory, DataBricks, Synapse and other Azure services
· Good understanding of data governance framework and tools
· Experience in building architecture frameworks, debugging the data pipelines for performance issues and providing the solution for the same
· Experience in building metadata driven pipelines
· Good understanding and hands on experience on some of the Azure components related to data (DataBricks, Data Lake, Purview, Synapse)
· Understanding of the Power B I to create visualizations
· Good to have an experience in Python/PySpark
· Writing high-performance, reliable and maintainable code with modern data tools
· Strong communication skills