Job Description

At AIA we\xe2\x80\x99ve started an exciting movement to create a healthier, more sustainable future for everyone.

As pioneering innovators for over 100 years, we\xe2\x80\x99re now transforming our organisation to be faster, simpler and more connected. Because we want to be even better equipped to develop digital solutions and experiences that help more people live Healthier, Longer, Better Lives.

To get there, we need people with tech/digital/analytics expertise and passion to help develop positive, sustainable change through digitally enhanced experiences that will impact the lives of millions of people and create a healthier future for everyone.

If you believe in developing a better tomorrow, read on.

WE ARE LOOKING FOR .....
Experienced ETL Specialist / Lead capable in performing hands-on ETL design and development while providing technical supervision and perform end-to-end technical delivery management.

• Perform requirement gathering and analysis with business stakeholders.
• Perform hands-on ETL solution design, development, test execution and production deployment.
• Lead, provide technical guidance, and manage a small / medium sized team of ETL developers.
• Plan and manage end-to-end delivery and work assignments within the ETL development team.
• Communicate and build strong positive rapport with various business and technology stakeholders.
• Provide BAU support for existing and new data platforms.
• Collect multiple streams of data and decompose them into concise specifications.
• Assist in identifying data quality problems and in determining options for how they will be handled.
• Develop process improvements that ensure product quality and productivity.
• Review and recommend changes to current product development processes.
• Maintain product requirements, technical and functional documentations for release management.
• Analyze and troubleshoot product issues in a timely fashion.
• Understand and evaluate existing SQL and or Data Modeling.
• Design and develop queries for a high-performance environment.
• Develop, manage and maintain data dictionaries, metadata, and process flow documentation.
• Design, develop and implement complete solutions throughout the product life cycles.
• Maintain and manage revisions of code in production, testing and development environments.
• For a data consolidation based project who can provide skills to drive solutions from the requirements phase through delivery, with preferred financial industry experience. The developer will be responsible for delivering high quality solutions that meet design requirements and technical specifications within stipulated timeline.
• Contribute to the specification and software design phases of the software development life cycle and performing and aiding in quality assurance testing, performance testing, troubleshooting application and environment issues, and production support.
• Accountable to development and delivery of solutions that meets and exceeds quality standards.
• Deliver multiple projects on-time, on-budget and with targeted zero defects.
• Coordinate with offshore resources on development projects from requirements through delivery.
• Provide support for Quality Assurance testing.
• Provide support for ETL batch job issues in lower environments and in Production if need arises.
• Provide estimation and coordination of technical activities related to system development.
• Ensure solutions alignment to Enterprise Architecture policies and best practices; ensure that process methodologies are followed in system development.
• Create technical documentation including the Technical Design document.
• Manage day to day technical challenges and communicate to project manager any risks or issues associated with the development activities.
• Participate in Code Reviews and provide inputs on necessary corrections if needed.
• Identify opportunities for system reuse and system simplification.
• Collaborate with IT partners to devise capacity plan and ensure appropriate infrastructure for the end to end system delivery.

• Bachelor\'s Degree in Computer Science, IT or equivalent.
• Minimum 5 - 10 years of ETL design and development and management role.
• Experienced in leading and managing a small / medium sized team of ETL developers.
• Lead and provide technical guidance and supervision to ETL developers.
• Plan and manage end-to-end delivery and work assignments within the ETL development team.
• Excellent skills in Business user engagement and stakeholder management.
• Experienced in engaging business stakeholders for requirement analysis and discussions.
• Strong experience in PL/SQL in Oracle, MS SQL and Informatica ETL.
• Experience in Azure environment (Azure Data Factory, SQL Managed Instance, Synapse, Storage account) and Oracle Golden Gate replication tool would be added advantage.
• Sound experience in execution of IT projects with high level of expertise in system application and technology implementation delivery.
• Strong communication skills with ability to communicate with all levels of stakeholders.
• Strong analytical and problem-solving skills.
• Domain proficiency in insurance business and its operations including distribution channels modus operandi is essential.
• Able to provide second level production support.
• Able to work independently and highly self-motivated.
• Able to work with peers and other stakeholders, a team player.