you will lead the design, development, and implementation of robust ETL (Extract, Transform, Load) processes using Microsoft SQL Server Integration Services (SSIS). This role involves working with large-scale financial data, ensuring data integrity, and enabling reliable reporting and analytics for business decision-making.
Key Responsibilities:
- Lead the end-to-end design, development, and deployment of SSIS packages for data integration and warehouse projects.
- Collaborate with data architects, business analysts, and application teams to gather and refine ETL requirements.
- Develop and maintain complex T-SQL scripts, stored procedures, and functions to support transformation logic.
- Ensure strong data quality controls, error handling, and performance optimization within ETL processes.
- Manage and mentor a team of SSIS developers, providing technical guidance, code reviews, and best practices.
- Coordinate with the DBA and infrastructure teams to monitor performance, resolve bottlenecks, and maintain high system availability.
- Implement automation and scheduling using SQL Agent or third-party tools.
- Create and maintain technical documentation and data flow diagrams.
- Support data migration, consolidation, and compliance initiatives as per FNB’s security and regulatory standards (
Required Skills and Qualifications:
- 8+ years of experience with SSIS and SQL Server in a data integration or BI environment.
- Expertise in data warehousing design principles, dimensional modeling, and performance tuning.
- Proven ability to handle large financial datasets and maintain data confidentiality.
- Strong knowledge of T-SQL, indexing, and stored procedure optimization.
- Experience leading teams in Agile or Scrum environments.
- Familiarity with CI/CD practices and tools such as Azure DevOps or Git.
- Excellent analytical thinking, communication, and leadership abilities.