ETL Developer & Data Warehouse Specialist

Muscat, Muscat, OMAN, Oman

Full Time

Mid Level

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

KalSoft is currently looking for an experienced ETL Developer & Data Warehouse Specialist to join our team. This role is ideal for professionals with strong expertise in Data Warehouse design, ETL development, database administration, data integration, and performance optimization. The ideal candidate should be capable of designing and maintaining enterprise-grade data warehouse solutions, implementing efficient ETL processes, ensuring data quality, and supporting business intelligence and reporting requirements.

Key Responsibilities

Collect Data Mart requirements, analyze business and reporting needs, and design appropriate data models.
Design, develop, maintain, and optimize enterprise Data Warehouse solutions using Microsoft SQL Server.
Develop and implement scalable ETL processes using SSIS and other integration technologies.
Integrate data from multiple source systems into centralized Data Warehouse environments.
Write, optimize, and maintain complex SQL queries, stored procedures, and database scripts for Oracle and Microsoft SQL Server.
Perform data extraction, transformation, cleansing, aggregation, and validation activities.
Implement data quality checks and ensure data consistency, accuracy, and completeness across systems.
Manage and optimize existing reporting structures by standardizing calculations, removing hard-coded values, and consolidating redundant reports.
Monitor ETL jobs and SSIS packages to ensure successful execution and timely data availability.
Review logs, troubleshoot ETL failures, and perform corrective actions to restore operations.
Optimize ETL packages and workflows to improve performance and reduce processing times.
Identify and resolve bottlenecks in large-scale data loading and transformation processes.
Rebuild and reorganize indexes to enhance database and ETL performance.
Monitor database growth and manage partitioning strategies for large datasets.
Monitor CPU, memory, storage, and server performance during ETL execution.
Schedule ETL jobs efficiently to avoid conflicts and maximize resource utilization.
Implement robust error handling, monitoring, and auditing mechanisms.
Maintain metadata repositories and document data lineage, workflows, and dependencies.
Archive and purge historical data in accordance with data retention policies.
Ensure high availability, backup, disaster recovery, and business continuity for database environments.
Maintain and support SQL Server services including SSIS, SSAS, and SSRS.
Perform backup validation and disaster recovery testing on a regular basis.
Implement security controls and conduct periodic access reviews for ETL and database environments.
Maintain version control and change management processes for ETL packages and database objects.
Deliver high-quality documentation and ensure adherence to organizational standards and best practices.

Requirements

Bachelor’s degree in Computer Science, Information Technology, Software Engineering, or a related field.
Minimum 5+ years of experience in ETL development, Data Warehousing, and database management.
Strong hands-on experience with Microsoft SQL Server and T-SQL.
Extensive experience with SQL Server Integration Services (SSIS).
Working knowledge of SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
Experience working with Oracle databases and complex data extraction processes.
Strong understanding of Data Warehouse architecture, Data Marts, dimensional modeling, and ETL methodologies.
Experience in performance tuning, query optimization, and database administration.
Knowledge of backup, recovery, high availability, and disaster recovery solutions.
Experience monitoring and troubleshooting enterprise ETL environments.
Familiarity with data quality management and governance practices.
Experience with version control systems and change management processes.
Strong analytical, problem-solving, and troubleshooting skills.
Excellent communication and documentation skills.
Ability to manage multiple assignments and work effectively in a fast-paced environment.

Preferred Qualifications

Certifications related to Microsoft SQL Server, Data Engineering, Business Intelligence, or Database Administration.
Experience working with large-scale enterprise Data Warehouse environments.
Exposure to cloud-based data platforms and ETL technologies.
Knowledge of Power BI or other business intelligence and reporting tools.
Experience in financial, government, telecom, or enterprise-scale data environments will be considered an added advantage.

Key Technologies

Microsoft SQL Server
SSIS (SQL Server Integration Services)
SSRS (SQL Server Reporting Services)
SSAS (SQL Server Analysis Services)
Oracle Database
T-SQL
Data Warehouse & Data Mart Design
ETL Development & Optimization
Database Performance Tuning
Data Quality Management
High Availability & Disaster Recovery
Version Control & Change Management

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?* Less than 3 years3–5 years5–8 years

How many years of experience do you have with Microsoft SQL Server?* Less than 3 years3–5 years5+ years

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