AzureDataEngineerandSSIS

**This role is for one of the Weekday's clients** Min Experience: 5+ years Location: Bengaluru, Pune, Hyderabad JobType: full-time **Requirements** **Primary Duties and Responsibilities:** * Over 5 years of experience in SQL Server ETL development utilizing SSIS, Azure Data Factory, and Azure Databricks, with strong expertise in ETL, data warehousing, and T-SQL. * Comprehensive understanding of data warehouse and data mart architectures, including the Kimball methodology. * More than 5 years of practical experience in building large-scale databases. * Designing, developing, and deploying efficient and reliable data pipelines for data movement and transformation. * Wide-ranging knowledge and hands-on experience in data modeling, data management, ETL, and business intelligence (BI). * Expertise in building enterprise data warehouses incorporating table partitioning, encryption, and data compression techniques. * Experience with cloud migration initiatives. * Conduct ongoing monitoring, automation, and optimization of reports and BI solutions. * Collaborate with BI management to identify and resolve data-related challenges. * Partner with business units to define and document requirements for new metrics and reports. * Participate in process evaluations and improvements. * Provide analysis and resolve issues reported by business stakeholders. * Engage in the design and delivery of cubes, dashboards, and a variety of self-service BI solutions. **Other:** * Ensure adherence to established documentation standards and best practices. * Maintain strong business functional knowledge alongside up-to-date expertise in automated technologies and tools. * Comply with all policies and procedures related to confidential information, including internal and restricted data. **Qualifications:** **Required** * Minimum 7 years of experience as a Data Engineer on Enterprise Data Warehousing (DWH) and Business Intelligence (BI) projects, both on-premises and cloud (Azure), with at least