Job Description

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