Data Warehouse Architect

No. of Positions : 1 Total Relevant Experience : 10 to 20 Years Education : B.E. / B.Tech / M.E. / M.Tech / M.C.A Computer Science / Information Technology Job Description Technical aspects Must have hands on experience of more than 7 years in data warehouse architecture and business intelligence. Must have experience more than 5 years in ETL development and operations preferrable in Azure/cloud environments. Must have experience more than 5 years in SQL. Must have experience in database management, ETL and reporting. Must understand complex logic & models and must have experience writing queries and procedures Demonstrate sound understanding of applications of data analysis and data science Participate in requirement gathering and implement business value through data initiatives Nice to have experience in optimizing database performance Leadership aspects Must have experience in team management and mentoring the team Must possess technical expertise in leading a data warehouse team Must take the lead in decision making process Have exceptional decision-making skills in case of any complications and complexities related to data warehouse Entrepreneurial aspects Keen to learn and explore new technologies Understand requirements proficiently and execute them Provide end to end technical support and bring solutions for issues Create database diagrams, database design and participate in documentation Required Skills Must have experience in the Azure Data factory Must have sound understanding of SQL and ETL processes Nice to have experience in Databricks, Data Fabric, Synapse & Data Lake Nice to have knowledge about new data/cloud developments and able to implement them in optimized manner Nice to have knowledge/experience in Powershell, UNIX or Python shell scripting skills Nice to have experience with BI tools such as Power BI Must have expertise in prioritizing and executing tasks in an efficient manner, and contribute effectively for team management Experience in agile way of working Active communication with team members and participating in finding solutions for technical issues. Self-motivated and directed, with keen attention to detail No. of Positions : 1 Total Relevant Experience : 10 to 20 Years Education : B.E. / B.Tech / M.E. / M.Tech / M.C.A Computer Science / Information Technology Job Description Technical aspects Must have hands on experience of more than 7 years in data warehouse architecture and business intelligence. Must have experience more than 5 years in ETL development and operations preferrable in Azure/cloud environments. Must have experience more than 5 years in SQL. Must have experience in database management, ETL and reporting. Must understand complex logic & models and must have experience writing queries and procedures Demonstrate sound understanding of applications of data analysis and data science Participate in requirement gathering and implement business value through data initiatives Nice to have experience in optimizing database performance Leadership aspects Must have experience in team management and mentoring the team Must possess technical expertise in leading a data warehouse team Must take the lead in decision making process Have exceptional decision-making skills in case of any complications and complexities related to data warehouse Entrepreneurial aspects Keen to learn and explore new technologies Understand requirements proficiently and execute them Provide end to end technical support and bring solutions for issues Create database diagrams, database design and participate in documentation Required Skills Must have experience in the Azure Data factory Must have sound understanding of SQL and ETL processes Nice to have experience in Databricks, Data Fabric, Synapse & Data Lake Nice to have knowledge about new data/cloud developments and able to implement them in optimized manner Nice to have knowledge/experience in Powershell, UNIX or Python shell scripting skills Nice to have experience with BI tools such as Power BI Must have expertise in prioritizing and executing tasks in an efficient manner, and contribute effectively for team management Experience in agile way of working Active communication with team members and participating in finding solutions for technical issues. Self-motivated and directed, with keen attention to detail