1.Work closely with the project team to develop and validate the data engineering applications under the guidance of the DATA Product Manager
2 Assist with the design and maintenance of data engineering pipelines as well as the associated authorization that meet business, technical and security requirements, using the established processes and available tools on the Authority’s Enterprise Data Analytics Platform, within the stipulated time frame and allocated effort
3 Implement the data engineering pipelines in accordance with the design specifications and work closely with the data engineering team to extract, transform and load the required data from the source systems into the data store.
4 Develop the extract, transform and load tasks in Informatica software in accordance with the design specifications.
5 Ensure optimal design of the data engineering pipeline with due consideration for security control measures and system performanceOFFICIAL (CLOSED)
6 Provide and maintain documentations according to the Authority’s Quality Management System (QMS) guidelines
7 Work closely with relevant technical teams (e.g. Enterprise Data Analytics Platform team, etc.) during development, system integration and user acceptance testing, implementing code changes if required
8 Rectify any issues that are surfaced during the required vulnerability assessments and code quality inspections, where applicable
9 Facilitate the conduct of user acceptance tests and conduct end user training sessions
10 Provide on-site support to troubleshoot any problems
Educational Qualification
Relevant educational credentials in a quantitative discipline (e.g. statistics, computer science, data analytics, operations research, or robotics) or equivalent practical experience
- Minimum two (2) years of experience in designing and developing applications using Informatica.
- Minimum one (1) year of data manipulation experience in SQL.
- Experience in dimensional modelling, data warehousing techniques (e.g. data cleansing, merging and other data manipulation tasks) would be advantageous.
- Knowledge of methodology and techniques in software testing, and techniques in security vulnerability assessment and testing would be advantageous.
- Possesses good planning and coordination skills with strong ability to work independently, efficiently and as a team, manage timelines and expectations, and is responsible and conscientious in producing high quality deliverables (which mimimally include documentation, presentations, and prototypes).
- Possesses strong writing, verbal communication and presentation skills.
At least two (2) years hands-on experience in developing data pipelines, and has completed at least one (1) medium scale analytics project implementation.
Preferably have completed at least (1) project using Scrum or equivalent Agile development framework