ETL Developer & Data Warehouse Specialist

Muscat, Muscat, OMAN, Oman

Full Time

Mid Level

Location: Onsite – Oman
Experience: 7+ Years
Employment Type: Full-time

About the Role

KalSoft is seeking an experienced ETL Developer & Data Warehouse Specialist to join our team in Oman. The ideal candidate will possess strong expertise in SQL Server Administration, Database Development, Data Warehousing, ETL processes, Business Intelligence solutions, and enterprise reporting systems. The candidate will be responsible for designing, developing, optimizing, and maintaining scalable data integration solutions and data warehouse environments while ensuring high performance, availability, and data quality.

Key Responsibilities

Data Warehouse & Data Modeling

Design, develop, and maintain enterprise Data Warehouse and Data Mart solutions.
Gather business requirements and translate them into scalable data models.
Design and implement dimensional models using Star Schema and Snowflake Schema methodologies.
Ensure data consistency, integrity, and quality across data warehouse environments.

ETL Development & Data Integration

Design, develop, and maintain ETL processes using SQL Server Integration Services (SSIS).
Create mappings and workflows utilizing SSIS transformations including OLE DB Command, Conditional Split, Lookup, Aggregate, Multicast, Derived Column, and related components.
Design dynamic SSIS packages for cross-platform data migration and integration.
Develop robust ETL solutions for data extraction, transformation, validation, cleansing, and loading.
Archive and manage data files across multiple relational database platforms.
Monitor, troubleshoot, and optimize ETL workflows to improve performance and reliability.

Database Development & Administration

Develop and maintain complex SQL queries, stored procedures, views, triggers, and user-defined functions.
Write and optimize SQL scripts for Microsoft SQL Server and Oracle databases.
Perform SQL Server administration tasks including backup, restore, maintenance plans, log management, and performance monitoring.
Execute database maintenance operations and ensure optimal system performance.
Implement automation for SQL Server administrative tasks.

Business Intelligence & Analytics

Design and manage SQL Server Analysis Services (SSAS) cubes, partitions, aggregations, and storage structures.
Develop MDX queries, calculations, and reports.
Build and maintain data mining models and analytical solutions.
Support reporting and analytics initiatives using SQL Server BI technologies.

High Availability & Disaster Recovery

Implement and support High Availability (HA) and Disaster Recovery (DR) solutions for database and BI environments.
Conduct backup validation, recovery testing, and disaster recovery exercises.
Ensure business continuity and system resilience through proactive monitoring and planning.

Performance Optimization & Support

Analyze and resolve database and ETL performance bottlenecks.
Monitor system resources, database growth, and workload performance.
Optimize queries, indexes, ETL packages, and reporting processes.
Troubleshoot production issues and provide timely resolution.
Maintain technical documentation and adhere to organizational standards and best practices.

Requirements

Bachelor's degree in Software Engineering, Computer Science, Information Technology, or a related field.
Minimum 7+ years of hands-on experience in SQL Server Administration and Development.
Minimum 3+ years of extensive experience with SQL Server Integration Services (SSIS).
Minimum 2+ years of experience with SQL Server Analysis Services (SSAS), including storage, partitions, aggregations, MDX, and data mining models.
Minimum 3+ years of experience in Data Modeling using Star Schema and Snowflake Schema.
Minimum 2+ years of experience implementing High Availability and Disaster Recovery solutions.
Minimum 4+ years of experience writing and optimizing complex SQL queries for Microsoft SQL Server and Oracle databases.
Minimum 2+ years of experience with SQL Server automation processes including backup, restore, maintenance, and log management.
Strong understanding of Data Warehousing concepts, ETL methodologies, and Business Intelligence solutions.
Excellent analytical, troubleshooting, problem-solving, and communication skills.
Strong attention to detail and ability to work in a fast-paced environment.

Preferred Qualifications

Microsoft Certifications in SQL Server, Business Intelligence, Data Science, or related technologies.
Experience working with large-scale enterprise data warehouse environments.
Exposure to advanced reporting and analytics solutions.
Experience supporting mission-critical business applications and enterprise BI platforms.

Key Technologies

Microsoft SQL Server
SQL Server Integration Services (SSIS)
SQL Server Analysis Services (SSAS)
SQL Server Reporting Services (SSRS)
Oracle Database
T-SQL
MDX
Data Warehousing
ETL Development
Data Modeling (Star Schema & Snowflake Schema)
High Availability & Disaster Recovery
Database Administration
Performance Tuning & Optimization
Business Intelligence Solutions

Apply for this position

Required*

First Name*

Last Name*

Email Address*

Phone*

Address

Resume*

We've received your resume. Click here to update it.

Attach resume or Paste resume

Attach resume as .pdf, .doc, .docx, .odt, .txt, or .rtf (limit 5MB) or Paste resume

Paste your resume here or Attach resume file

Are you residing in Oman?*

Which Oman City are you based in?*

What is your current notice period?*

Could you please share your current monthly salary package in OMR?*

Could you please share your expected salary package for this position in OMR?*

Do you have a valid passport?*

Please note this is a full-time, 1-year contractual opportunity based in Oman. Are you willing to proceed?*

This position offers a single-status work visa only at least for the first two years of service, do you wish to proceed with your application?*

Do you have experience in banking, financial services, or the investment domain?*

Do you have hands-on experience in Data Warehouse design, development, and maintenance?*

How many years of experience do you have in ETL Development?*

How many years of experience do you have with Microsoft SQL Server?*

Do you have hands-on experience with SSIS (SQL Server Integration Services)?*

Do you have experience developing and maintaining reports using SSRS (SQL Server Reporting Services)?*

Have you worked on enterprise-level ETL and Data Warehouse projects involving large datasets and performance optimization?*

Do you Speak in English?*

Human Check*

Submit Application