Senior ETL Developer needed at Discovery Limited

Key Purpose

• Construction of complex Business intelligence assets based on specifications produced by BI Architects and System Analysts, including mentoring and supporting junior developers.

Key Outputs

• Translates and not limited to, the Source to Target Mappings into executable code without errors.
• Finds effective software solutions to technical issues.
• Ensure that the application performs the functions as required by business.
• Releases source code with zero defects.
• Actively coach other developers during the code review process to understand and apply the Business Intelligence coding standards whilst ensures that business objectives are reflected in the technical processes in which they manage.
• Respond to incidents escalated by the support teams. 
• Conduct unit testing, and fix any defects found.
• Review error logs and provide systems/BI analysts with updates on fixes found in testing.
• Consult and assist the system/BI analysts in reviewing defects found in testing.
• Perform standby as required and handle any defects as raised in the production process.
• Workshop solutions with System Analysts to compile relevant technical specifications
• Maintain all code and resolve morning batch failures within SLA’s. 
• Review ETL architecture and amend changes to production systems.

Personal Attributes and Skills  

Knowledge:

• Processes: SDLC, ITIL (Incident, Change, Release, Problem Management)
• Technologies:  SQL-Server, Oracle, T/SQL and PL/SQL, SSIS, SSAS
• Other: Software architecture, facilitating JAD sessions, data modelling techniques
• Health Insurance knowledge (advantageous)
• Excellent understanding of batch execution relating to Production databases
• Practical experience on developing Type 2 and type 3 dimensions, with waterline and catch-up functionality
• Strong ability to build Metadata into all packages and code developments.
• Maintain the development, QA and production environment waterlines.
• Monitoring dead times within the production system and apply solutions within the week.
• Participate in design reviews and code reviews
• Understanding archiving strategies within the production system.
• Make amendments to existing code and complete the delivery into production – rerun the affected artefacts and downstream dependencies.
• Develop Microsoft SSIS packages

Technical skills

• MS SSIS, SSAS, SSRS
• Database and stored procedure optimization techniques
• Hardware and resource management
• Project Management
• Dimension modelling star-schema design
• Solution Architecture on Sql server, Oracle and Netezza
• Software development and testing
• Excellent knowledge of SQL constructs, collections and variables.
• Excellent T-Sql knowledge

Behavioural skills

• Result Orientation
• Change Readiness
• Time Management
• Communication (written, verbal and listening)
• Creativeness
• Innovation

Education and Experience

Education:

• Essential: Tertiary degree (B. Engineer, B. Com, BSC)
• MOF or equivalent contemporary development methodology.

Minimum Required Experience:

• 10 to 15 years’ experience in software development for large commercial entities.
• At least 10 years’ experience in Datawarehouse code development.
• Understanding of Integrated star schemes