Specialist Data Integration at CRDB Bank Tanzania

Reporting Line

MANAGER DATA ARCHITECTURE AND INTEGRATION

Location

Tanzania Head Office

Department

DATA MANAGEMENT OFFICE

Number of openings

1

Job Purpose

The Specialist, Data Integration is responsible for designing, developing and continuously improving secure, reliable and scalable data integration solutions that enable timely, accurate and controlled movement of data across CRDB’s source systems, governed data platforms and authorized consumers. The role delivers batch, ETL/ELT, change data capture, streaming, manage file exchange and approved data API integrations in line with the Bank’s architecture, security, data governance and service standards. The role, it provides Level 2 and Level 3 support for complex or recurring integration failures, leads root-cause analysis and implements permanent corrective solutions. Routine production monitoring, scheduled reruns and first-line recovery remain with Data Operations unless otherwise assigned through the approved service model. 

Principle Responsibilities

• Design, develop and unit-test batch ETL/ELT, CDC and streaming pipelines (e.g., ODI, Oracle GoldenGate, Kafka, NiFi, Informatica or lakehouse-native tools) from source to staging, warehouse, data marts and lakehouse, following approved architecture, naming conventions and idempotent-load standards. 
• Onboard new data sources through the data source registration process: analyse source structures, agree extraction method and schedule with System Custodians, and produce source-to-target mappings and interface specifications. 
• Monitor daily loads, replication and streaming lag; resolve failed jobs within agreed SLAs; manage reruns and backfills with full audit trail; and drive permanent fixes so the Bank depends less on manual intervention. 
• Lead root-cause analysis for recurring integration incidents (e.g., broken connections, schema drift, constraint violations, Kafka/OGG lag, stuck extractions) and track corrective actions to closure with DICT and vendors. 

• Build reconciliation and validation controls into every pipeline (row counts, hash/control totals, null, uniqueness and referential checks, schema-drift alerts), and quarantine and escalate failed data per the data quality SOP. 
• Tune extraction and load performance (incremental loads, partitioning, parallelism, query optimisation) with DBAs to meet batch windows and real-time latency targets as volumes grow. 
• Build and maintain governed APIs, file and message interfaces for internal consumers, regulators (e.g., RTSIS) and approved third parties, with security, versioning and service levels defined. 
• Apply least-privilege service accounts, encryption in transit, masking of personal data in non-production, and segregation between development, UAT and production, in line with Information Security policy and the Personal Data Protection Act 2022. 
• Deliver all changes through version control, UAT and change management; maintain run-books, interface catalogues and technical documentation; and supply integration metadata and lineage to the Master Data & Metadata Unit. 
• Contribute to DMP/lakehouse migration, ODI and legacy interface rationalization and MDM synchronization (inbound CDC, outbound golden-record publication), and take over knowledge from vendors and implementation partners. 

Qualifications Required

• Bachelors degree in Computer Science, Information Technology, Software Engineering, Information Systems, or a related field.
• Professional certifications such as Oracle (ODI/GoldenGate/Database), Confluent Kafka, Informatica, Databricks/Cloudera or cloud data engineering certifications, Certified Data Management Professional (CDMP), or DCAM certification are an added advantage.
• Minimum of 3 years of experience in data integration, data engineering, ETL/ELT development, API integration, or enterprise data management within a complex technology environment.
• Knowledge of T24 core banking data structures, Bank of Tanzania regulatory reporting requirements (including RTSIS), Personal Data Protection Act 2022, and ITIL incident, problem, and change management practices is an added advantage.
• Strong knowledge of DAMA-DMBOK2 Data Integration & Interoperability, Data Architecture, Data Modelling, Data Quality, Data Security, Metadata Management, and EDM Council DCAM data and technology architecture capabilities.
• Knowledge of integration architectures and patterns, including batch ETL/ELT, CDC/replication, event streaming, publish-subscribe, APIs/REST, file transfer, hub-and-spoke and point-to-point designs, as well as data warehouse, lakehouse, and dimensional modelling concepts.
• Advanced SQL and PL/SQL development and performance tuning on Oracle (Exadata) and SQL Server.
• Hands-on experience with ETL/ELT, replication and streaming technologies such as Oracle Data Integrator, Oracle GoldenGate, Informatica, SSIS, Apache Kafka and NiFi.
• Proficiency in Python, Shell scripting, and data processing automation tools; experience with Spark/PySpark is an added advantage.

• Experience with API design and integration (REST, JSON/XML), job scheduling/orchestration, version control (Git), and CI/CD practices for data pipelines.
• Strong analytical, troubleshooting, documentation, and communication skills, with the ability to explain technical concepts and issues to business and management stakeholders..

CRDB Commitment

CRDB Bank is dedicated to upholding Sustainability and ESG practices and encourage applicants who share this commitment. The Bank also promotes an inclusive workplace, hence applications from women and individual with disabilities are encouraged.

It is important to note that CRDB Bank does not charge any fees for the application or recruitment process, and any requests for payment should be disregarded as they do not represent the bank’s practices.

Only Shortlisted Candidates will be Contacted.

Deadline

2026-11-09

Employment Terms

PERMANENT