At AIA we've started an exciting movement to create a healthier, more sustainable 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 and manage a small / medium d 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.
- 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.
- Ensure that final product meets requirement specifications.
- Follow company and industry defined best practices to ensure smooth and continuous product development operations.
- Develop process improvements that ensure product quality and productivity.
- Communicate product efficiency or enhancement ideas and concepts to Manager.
- Review and recommend changes to current product development processes.
- Maintain expert knowledge on product development procedures.
- 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.
Job Requirements:- Strong experience in PL/SQL in Oracle and MS SQL.
- Informatica ETL hands-on development.
- 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 stakeholders.
- Strong analytical and problem-solving skills.
- Domain proficiency in insurance business and its operations including distribution channels modus operandi is essential.
- Experience in Informatica would be added advantage.
- Able to work independently and highly self-motivated.
- Able to work with peers and other stakeholders, a team player.
#LI-DNI
