PURPOSE
Manage Extract, Transform and Load process on data
pipelines.
Develop ETL job pipeline using ETL tools.
Maintain ETL job scheduling and housekeeping for
optimal load.
Identify gaps in ETL job pipeline. Perform data
normalization to smoothen data processing pipeline.
Wide exposure to various databases technology and
automation.
KEY ACCOUNTABILITIES
Design, develop, document and implement end-to-end
data pipelines and data integration processes, both batch
and real-time. This include data analysis, data profiling,
data cleansing, data lineage, data mapping, data
transformation, developing ETL / ELT jobs and workflows,
and deployment of data solutions.
Monitor, recommend, develop and implement ways to
improve data quality including reliability, efficiency and
cleanliness, and to optimize and fine-tune ETL / ELT
processes.
Recommend, execute and deliver best practices in data
management and data lifecycle processes, including
modular development of ETL / ELT processes, coding and configuration standards, error handling and notification
standards, auditing standards, and data archival
standards.
Prepare test data, assist to create and execute test plans,
test cases and test scripts.
Collaborate with Data Architect, Data Modeler, IT team
members, SMEs, vendors and internal business
stakeholders, to understand data needs, gather
requirements and implement data solutions to deliver
business goals.
BAU support for any data issues and change requests,
document all investigations, findings, recommendations
and resolutions.
QUALIFICATIONS / EXPERIENCE
5+ years' working experience in ETL
Preferably with 2 years' work experience in insurance
industry
Required hands-on experience on IBM DataStage or
relevant ETL softwares.
Strong communication skills, including prioritizing,
problem solving and interpersonal relationship building
Proven time management cum organization skills (must
be able to prioritize workload and meet deadlines).
