ABOUT DEVU SOLUTIONS
Our Story
At Devu Solutions, we started as a small team of IT enthusiasts who wanted to help small businesses overcome their technology challenges. Today, we have grown into a leading provider of IT services.
Our Services
We offer a comprehensive range of IT services, including network management, cloud computing, cybersecurity, and more. Our services are designed to help small businesses thrive in today's digital world.
Our Team
Our team of IT professionals is dedicated to providing exceptional service and support to our clients. We have the expertise and experience to solve even the most complex technology challenges.
WE'RE HIRING!
Responsibilities:
- Collaborate with data architects and other stakeholders to design scalable and optimized data warehouse solutions on the Azure platform.
- Develop and maintain data warehouse architectural documentation, including schema designs, data flow diagrams, and integration patterns.
- Move SSIS / ETL Processes and execute SSIS within Azure Data Factory.
- Design the NextGen Data Warehouse using Azure.
- Expertise in using Master Data Management strategies, and designing Data Warehouse structure and schema with Azure Data Services.
- Execute SSIS packages in Azure from SSDT to assess the cloud compatibility of SSIS packages and run them on Azure-SSIS IR within ADF.
- Fix any issues found in IR testing and can migrate all SSIS packages to run in Azure.
- Re-write all SSIS packages into ADF and expand analytics using Azure Synapse and Power BI
- Investigate the use of Azure Fabric for end-to-end data processes from Data Science to Analytics
- Write efficient T-SQL queries for data transformation, extraction, loading, and reporting purposes.
- Implement data partitioning, indexing, and distribution strategies to enhance query performance.
- Integrate data from various sources, both on-premises and in the cloud, into the Azure Data Warehouse using appropriate ETL/ELT techniques.
- Work with data integration tools such as Azure Data Factory or SSIS to automate data pipelines.
- Monitor and analyze query performance and data warehouse health, identifying and resolving bottlenecks and performance issues.
- Optimize query execution plans, indexing strategies, and data distribution to achieve optimal performance.
- Implement security measures to protect sensitive data within the Azure Data Warehouse, following best practices for data encryption, access controls, and data masking.
- Ensure compliance with relevant data privacy and security regulations, such as GDPR or HIPAA.
- Provide training and guidance to junior team members on data warehouse best practices and technologies.
Qualifications:
- Bachelor's or higher degree in Computer Science, Information Technology, or a related field.
- Proven experience in designing, implementing, and optimizing data warehousing solutions using Azure services (Azure Synapse Analytics, Azure Data Factory, Azure SQL Data Warehouse).
- Plan the ETL process for the data warehouse design.
- Choose appropriate Azure data services (Synapse, ADF)
- Create data warehouse operations runbook
