Location: Islamabad
Job Type: Full-Time
Experience Level: 5 - 7 Years
Industry: Banking / Financial Services (Preferred)
We are seeking a highly skilled Data Engineer with deep expertise in SQL Server performance optimization, high-volume ETL operations, and large-scale data processing. The ideal candidate will have hands-on experience managing complex data ecosystems, optimizing long-running jobs, and ensuring robust, efficient, and scalable ETL pipelines. Experience in financial systems or large MIS/reporting environments will be a strong plus.
Key Responsibilities
Design, develop, and optimize SQL Server queries, indexes, partitions, and overall database performance.
Perform SQL Server performance tuning to support high-volume OLTP and OLAP workloads.
Optimize and maintain ETL batch jobs, ensuring efficient execution and minimal downtime.
Handle large-volume data loads, ensuring reliability, consistency, and performance across data pipelines.
Troubleshoot and resolve long-running or failing ETL jobs, bottlenecks, and inefficiencies.
Develop and maintain CDC (Change Data Capture)-based incremental data models.
Manage end-to-end ETL processes, including scheduling, orchestration, monitoring, and debugging.
Work with SQL CLR functions and assemblies, including reviewing, debugging, updating, and replacing them when necessary.
Collaborate closely with BI, Data Analytics, and Application teams to support data integration requirements.
Ensure data quality, consistency, and compliance across all integrated systems.
Required Skills & Expertise
Strong hands-on experience with SQL Server (performance tuning, indexing, partitioning, query optimization).
Deep understanding of ETL frameworks, including batch processing and incremental loads.
Experience managing large ETL architectures with complex dependencies.
Strong knowledge of CDC and incremental data movement strategies.
Expertise in working with large OLTP and OLAP environments.
Experience with SQL CLR functions and assemblies (reading, debugging, modifying).
Strong troubleshooting skills for long-running processes, query slowness, and data pipeline issues.
Preferred Experience
Experience in the banking or financial domain (T24 or similar core banking systems).
Hands-on experience working with heavy reporting or MIS environments with demanding data refresh cycles.
Exposure to large-scale ETL ecosystems involving 500+ tables or high-volume enterprise data models.
Soft Skills
Strong problem-solving and analytical abilities.
Effective communication and collaboration skills.
Ability to work independently in high-pressure, data-intensive environments.
Attention to detail with a commitment to data accuracy and quality.
Top Skills
What We Do
Datamatics Technologies (DMT) was established in Dubai. We specialize in providing onsite and offshore professional services, covering the full spectrum of Data Analytics and Data Science domains.
Our experience of working with diverse industry sectors such as Telecoms, Finance, Government and Manufacturing, across multiple regions enables us to engage and deliver for our clients with confidence.
We can offer our full portfolio of services through resource augmentation, managed services, both on T&M or fixed price financial arrangements. Through our end-to-end managed services offering we enable our clients to cut down costs, increase profitability and focus on value addition to their core business activities.
Our project and delivery management team are certified in Agile, PMI and ITIL to ensure the planning and execution are carried out using industry best practices.
We are working with our clients across Middle East and Africa Region.
