SQL Developer

What will you do?

The Information Management department has a position available for a Developer: SQL, in the Data Management team, based in Bellville, Cape Town.

JOB DESCRIPTION
Santam is busy establishing a data-lake (Hadoop) and requires SQL developers that can assist with developing complex SQL statements and building ETL processes.  The main focus will be to assist with moving data into the lake, querying data and building of views on the data within the lake. The developer will also be required to support the business in data related issues/queries.

SKILLS & Responsibilities
• Proficient in SQL
• Technical ability in ETL concept, design and development
• Quality Assurance / Testing skills
• Data Modelling skills
• Effective time management skills
• Preferred technical skills:
o Big data/Hadoop technologies (HDFS, Hive, Impala, Spark)
o Databases: Sybase IQ, SQL Server, DB2
o Platforms: Unix, Windows
• Evening and weekend work in response to needs of the systems being supported or ad-hoc project requirements
• after-hours and weekend standby and support
• Required to work within a clearly defined accountability framework
• Knowledge of IT System Development Life Cycles (SDLC) & agile methodologies specifically scrum

What will make you successful in this role?

QUALIFICATIONS AND EXPERIENCE
• Relevant degree/diploma
• Certificate or Diploma in Big data tools from industry recognised training Institution will be an advantage but not essential
• At least 8 years of IT experience in SQL development and testing
• At least 2 years of experience in a Big data environment
• Understanding of business, systems and data analysis
• Experience with investigating data queries and giving feedback
• Exposure to physical database modelling and database design
• Experience in the financial/insurance industry will be an advantage

KNOWLEDGE
• Industry best standards in designing and developing SQL statements
• Trouble shoot failures in data transfer process
• Good Data Warehousing knowledge
• Data modelling knowledge (Dimensional) and an understanding of data
• Sound understanding of technical data linage
• Sound knowledge of IT Systems Development Life Cycles (SDLC), including Agile methodologies
• Knowledge of the following will be an advantage:
o Information & data architecture
o Data Exploitation tools
o Integration
o Pyspark and/or R

COMPETENCIES
• Delivering results and meeting customer expectations
• Critical thinking and Analysing
• Relating and networking
• Applying expertise and technology
• Achieving personal work goals and objectives
• Responsible
• Attention to detail

Knowledge and Skills

Personal Attributes

Build a successful career with us

We’re all about building strong, lasting relationships with our employees. We know that you have hopes for your future – your career, your personal development and of achieving great things. We pride ourselves in helping  our employees to realise their worth. Through its four business clusters – Sanlam Life and Savings, Sanlam Investment Group, Sanlam Emerging Markets, Santam, as well as MiWay and the Group Office – the group provides many opportunities for growth and development.

Core Competencies