Source description
About the role
Position : SQL Developer Location : Remote Duration : 12 Months Contract Must Have : Minimum of 7 years of experience working with SQL Environment and 4 years using azure cloud and Azure Data factory.
Skills
- Job Summary: We are looking for Sr SQL Developer with Azure data factory experience to join our team. The successful candidate will be responsible for managing and maintaining ETL process in SQL and Azure cloud to develop and maintain reports and dashboards.
Experience with Design, develop, and maintain relational databases Write complex SQL queries and optimize query performance Ensure data integrity, security, and availability Troubleshoot and resolve database issues Work with business stakeholders to understand data requirements and design data solutions Develop and maintain ETL processes to extract, transform, and load data using SSIS Develop and maintain reports and dashboards Monitor and troubleshoot SSIS packages Develop and maintain SSIS package documentation Optimize SSIS package performance Design and develop OLAP cubes and data mining models using SSAS Work with business stakeholders to understand data requirements and design SSAS solutions Optimize SSAS cube performance Troubleshoot and resolve SSAS issues Develop and maintain SSAS cube documentation Collaborate with database developers and administrators to ensure SSAS cubes are integrated with databases Design and develop data pipelines using Azure Data Factory Work with business stakeholders to understand data requirements and design data solutions Monitor and troubleshoot data pipelines Develop and maintain data pipeline documentation Optimize data pipeline performance Collaborate with database developers and administrators to ensure data pipelines are integrated with databases Manage and maintain Oracle Analytics Cloud platform including user management, security, and backups Design and develop custom reports and dashboards using Oracle Analytics Cloud Work with business stakeholders to understand data requirements and design solutions to meet their needs Troubleshoot and resolve issues related to Oracle Analytics Cloud platform Collaborate with IT and business teams to integrate Oracle Analytics Cloud with other systems and data sources Develop and maintain documentation related to Oracle Analytics Cloud platform and custom reports/dashboards Provide training and support to end-users on how to effectively use Oracle Analytics Cloud
More at Thoughtwave Software and Solutions