ETL and SAS DI Coding Developer

ETL (Extract Transform Load) developer with extensive SAS DI expertise to design and develop ETL applications and jobs in the Data Warehouse environments, leveraging Agile Ways of Working to deliver iterative and high-quality solutions. With a proactive and can-do attitude, the developer will design, create, and maintain SAS DI applications in diverse environments, ensuring alignment with business goals and high-quality standards. Developer should also provide mentoring and coaching to Junior Developers.

Deliverables

The Deliverables for the ETL and SAS Coding Developer include, but are not limited to the following:

• Extensive knowledge in Database technologies, preferable Oracle and related RDBMS. Advantage to have PL/SQL knowledge.

• Desirable experience in IBM LSF, Control-M or related scheduling Tools.

• Provide the technical design, implementation, testing, and compliance for identified solutions.

• Design and implement ETL scripts and data warehouse solutions.

• Collaborate on warehouse and reporting design.

• Collaborate with business teams in an Agile environment to understand and refine business processes, ensuring alignment with iterative development cycles.

• In conjunction with the development team, ensure quality standards are adhered to during development and implementation.

• Document the architectural design and production support processes in relevant artefacts.

• Maintain a clear understanding of the overall application architecture and ensure that this understanding is conveyed to and maintained current with all team members.

• Interpret the technical specifications of Solutions.

• Ensure that security, auditability and data integrity issues are covered in the design of the application.

• Proactively recommend changes to development and system standards, fostering a culture of continuous improvement and adaptability.

• Provide guidance and direction to other developers on application standards and use of development tools.

• Ensure processes are in place to control development quality. This includes responsibility for thorough and comprehensive unit and system testing.

• Work with the Data Warehouse Production Team for job migration, optimisation and scheduling.

• Co-ordinate handover and production scheduling and validation

Required skills and experience

• Bachelor's degree in IT; or equivalent experience.

• programming experience in SAS DI.

• data warehousing experience.

• experience in software applications analysis, design,

Candidate Profile

 

ETL (Extract Transform Load) developer with extensive SAS DI expertise to design and develop ETL applications and jobs in the Data Warehouse environments, leveraging Agile Ways of Working to deliver iterative and high-quality solutions. With a proactive and can-do attitude, the developer will design, create, and maintain SAS DI applications in diverse environments, ensuring alignment with business goals and high-quality standards. Developer should also provide mentoring and coaching to Junior Developers.