Working within an agile team, the ETL Developer is responsible for developing and maintaining robust ETL processes to facilitate the efficient extraction, transformation, and loading of data from various sources into our data warehouse or other target systems in the ongoing development and enhancement of our client’s data systems.
Key Responsibilities and Accountabilities
- Communicate with business analysts and SME’s to define, understand and document business requirements.
- Design, code and document complex programs and scripts from agreed specifications, using agreed standards and tools, delivering well-engineered results.
- Identify and manage risks that are likely to affect delivery of system releases.
- Develop estimates of effort and duration for development tasks, monitor own progress and continually improve estimating accuracy.
- Report on progress, anomalies, risks and issues associated with allocated development tasks.
- Contribute technical expertise to requirements analysis to enhance the quality of solution design and to improving solution processes within the organisation.
- Data Analytics
- Assesses the availability and usability of data and determines the most appropriate technique for analysis in consultation with senior colleagues.
- Prepares data for analysis (cleansing and transformation).
- Manipulates, explores and models data using programming languages and complex techniques in consultation with senior colleagues.
- Simplifies and summarises data / information. And draws out key insights for stakeholders.
- Communicates insights in a clear & concise manner in a range of formats for both technical & non-technical audiences.
- Data Extraction & Analysis
- Work with comprehensive data assets, and Apply advanced querying techniques.
- Access, query, interrogate and manipulate large and / or complex data sets, such as hierarchical data structures, survey data, data marts and data lakes.
- Follows data privacy and security protocols.
- Identifies and resolves data-related challenges and discrepancies.
- Maintains detailed documentation of data access processes, query logic, and derivations.
- Summarises data and creates complex reports.
Skills and Experience required
- Proven experience as an ETL developer using DataStage, SQL, TOAD/DB Visualiser and DWH.
- Knowledge of RDBMS databases such as DB2, data modelling and experience in dimensional modelling.
- Knowledge of DataStage Administrator components and experience using JIRA in an Agile environment.
- Proven experience in the planning and execution of projects.
- Relevant qualification in information management, ICT, IT or related discipline.
Please APPLY NOW for our immediate consideration, or you can call Jodeane Cabral on 08 8112 7418 for a confidential chat about the role and how your skills and experience might be a great fit!
