Manager: ETL Development at Postbank (SOC) Ltd

Purpose of the Job:

The Manager: ETL Development will be responsible for analysing the business requirements, design, develop and implement highly efficient, highly scalable ETL processes.

Job Responsibilities:

Financial Operational:

• Evaluate and design data collection, data staging, data movement, analytics delivery, data quality and archiving strategies
• Perform tests and validate all data flows and prepare all ETL processes according to business requirements and incorporate all business requirements into all design specifications
• Provides/reviews detailed technical specifications and ETL documentations required in each phase of the SDLC, and complies to internal standards and guidelines
• Identify opportunities to optimize the ETL environment, implement monitoring, quality and validation processes to ensure data accuracy and integrity
• Implements all ETL procedures for all new projects and maintain effective awareness of all production activities according to required standards and provide support to all existing applications
• Perform root cause analysis on all processes and resolve all production issues and validate all data and perform routine tests on databases and provide support to all ETL applications
• Monitor all business requirements and validate all designs and schedule all ETL processes and prepare documents for all data flow diagrams
• Provides 24x7 post-implementation supports, responds to problem quickly and provide both short and long term resolutions
• Provides end-users supports including business queries and requests

Internal Relationships:

• Head of Data Management and Business Intelligence (BI) Postbank Information Technology department
• Customer Service department
• Product department
• Finance department
• Risk department
• Payments department
• Human Resource

External Relationships:

• Group Information Technology

Qualifications and Experience:

• Bachelor’s degree in Information Technology, Telecommunications, Computer Science or related field or Equivalent Qualification
• 4+ years IT experience, with both hands-on and lead experience in providing ETL solutions
• 5+ years of consulting experience (client facing) related to ETL/Data Warehouse implementation projects. Experiences need to include data mapping, ETL development and, testing, and database design (for operational systems, data warehouses and data marts)

Knowledge and understanding of:

• Technically strong in ETL concept, design and development using tools like Data Stage, Sunopsis and database utilities (Oracle and Teradata)
• Possession of the following technical skills:
• ETL Tools such as Datastage
• Databases & Utilities such as NCR Teradata & utilities, Oracle, PL/SQL, SQL Loader
• Platforms such as NCR/AIX Unix and shell scripting
• Interface Tools such as Connect Direct, Secured FTP, DB2 Connect
• Jobs Schedulers such as Control-M

Skills and Attributes:

• Good organizational, oral and written communication skills
• Good business application skills (e.g., Microsoft Outlook)
• Strong problem solving skills
• Ability to meet project objectives, tracking of status and reviewing deliverables at every stage of the SDLC
• Ability to identify required tasks and accurately determine needed resources and timeframes to complete a project and enhancements
• Ability to work in a team environment yet be self-directed, proactive and action-oriented
• Ability to take high-level instruction, work independently and take initiative