Microsoft BI Developer

You will be working as a Microsoft BI Developer at KalSoft in Oman. Your role will involve designing, developing, optimizing, and maintaining scalable data integration solutions and data warehouse environments to ensure high performance, availability, and data quality. Key Responsibilities: - Design and create mappings using SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregate, Multicast, Derived Column, etc. - Design dynamic SSIS packages for cross-platform data migration, validation, and data archiving across different RDBMS - Develop complex stored procedures and user-defined functions for SSIS packages and SQL scripts - Design and implement ETL and Data Integration processes using SSIS for Data Warehouse reporting - Develop SSAS solutions including storage, partitions, aggregations, MDX calculations, and data mining models - Support BI reporting using SQL and MDX queries - Ensure data modeling using Star Schema and Snowflake Schema - Implement and support HA/DR solutions for BI environments - Monitor, troubleshoot, and optimize SQL Server performance and ETL workflows - Perform SQL Server maintenance and automation tasks (backup, restore, log management, etc.) Qualifications Required: - Degree in Software Engineering or similar field - Microsoft Certifications for SQL Server, Business Intelligence, Data Science - Total 7+ years of hands-on experience in SQL Server Administration and Development including SSIS, SSRS, and SSAS - 3+ years of extensive experience with SSIS tool suite - 2+ years of experience in SSAS (storage, partitions, aggregations, MDX, data mining models) - 3+ years of experience in data modeling using Snowflake and Star schemas - 2+ years of experience with High Availability and Disaster Recovery in BI environments - 4+ years of experience writing complex SQL queries (MS SQL Server and Oracle) - 2+ years of experience with SQL Server automation (backup, restore, log cleaning, etc.) - 2+ years of experience with SQL Server maintenance operations If there are any additional details of the company in the job description, they have been omitted for brevity. You will be working as a Microsoft BI Developer at KalSoft in Oman. Your role will involve designing, developing, optimizing, and maintaining scalable data integration solutions and data warehouse environments to ensure high performance, availability, and data quality. Key Responsibilities: - Design and create mappings using SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregate, Multicast, Derived Column, etc. - Design dynamic SSIS packages for cross-platform data migration, validation, and data archiving across different RDBMS - Develop complex stored procedures and user-defined functions for SSIS packages and SQL scripts - Design and implement ETL and Data Integration processes using SSIS for Data Warehouse reporting - Develop SSAS solutions including storage, partitions, aggregations, MDX calculations, and data mining models - Support BI reporting using SQL and MDX queries - Ensure data modeling using Star Schema and Snowflake Schema - Implement and support HA/DR solutions for BI environments - Monitor, troubleshoot, and optimize SQL Server performance and ETL workflows - Perform SQL Server maintenance and automation tasks (backup, restore, log management, etc.) Qualifications Required: - Degree in Software Engineering or similar field - Microsoft Certifications for SQL Server, Business Intelligence, Data Science - Total 7+ years of hands-on experience in SQL Server Administration and Development including SSIS, SSRS, and SSAS - 3+ years of extensive experience with SSIS tool suite - 2+ years of experience in SSAS (storage, partitions, aggregations, MDX, data mining models) - 3+ years of experience in data modeling using Snowflake and Star schemas - 2+ years of experience with High Availability and Disaster Recovery in BI environments - 4+ years of experience writing complex SQL queries (MS SQL Server and Oracle) - 2+ years of experience with SQL Server automation (backup, restore, log cleaning, etc.) - 2+ years of experience with SQL Server maintenance operations If there are any additional details of the company in the job description, they have been omitted for brevity.