Data Mapper (PLSQL)

Full Time
Malaysia
Posted
Job description
Interested candidates may forward CV to: career@gmatechconsulting.com

Job Purpose
The candidate is expected to work on the Regional IFRS17 Programme as a Data Mapper cum
Business Analyst. The Programme is implementing solutions for compliance with the International
Financial Reporting Standards for Insurance Industry which the Company targets to go live in
January 2023 for Singapore & Malaysia entities and 2 years later for Indonesia entities.

The candidate’s key role is to:
  • Work with business stakeholders to gather business requirements / rules
  • Gather data requirements and perform data analysis from source system SMEs
  • Conduct thorough data analysis by writing SQL queries
  • Apply business requirements / rules to source system data, taking into account how systems
generate / update data, to produce mapping documents for ETL / ELT developers
  • Assist project manager by leading prioritization and implementation of change requests /
defect fixes in BAU
The candidate is also expected to follow our Group IT Application Processes, Standards &
Procedures.
The Job

Key responsibilities and duties:
  • Takes accountability in considering business and regulatory compliance risks and takes
appropriate steps to mitigate the risks.
  • Maintains awareness of industry trends on regulatory compliance, emerging threats and
technologies in order to understand the risk and better safeguard the company.
  • Highlights any potential concerns /risks and proactively shares best risk management practices.
  • Facilitate / conduct workshops with business stakeholders to identify project requirements, gather,
analyse and document requirements.
  • Facilitate / conduct workshops with source system and other technical stakeholders to identify
data elements and understand source system behavior.
Produce mapping rules from source system data to target system tables based on workshops with
business and technical stakeholders.
  • Perform thorough data analysis to verify mapping rules correctly transform data from source to
target to meet business requirements / rules by writing SQL queries.
  • Publish ETL / ELT mapping documents that contain mapping rules for developers to build jobs as
well as other artifacts e.g. Data Mapping specification, integration/interface specifications, sitemap
and page-flow, and the usage of UML diagram to detail process and data flows.
  • Support IT and business stakeholders throughout the SDLC: Unit testing, System Integration
Testing (SIT), User Acceptance Testing (UAT) and Production.
  • Develop IFRS17 and contribute towards insurance-specific SME knowledge for group-wide
knowledge management.
  • During project implementation phase, lead implementation of change requests / defect fixes
  • During BAU, leading prioritization and implementation of change requests / defect fixes
Our Requirements
a) Qualifications
  • Degree in Computer Science, Business Information Systems or Finance / Insurance degree
  • Certified Business Analysis (CBAP or equivalent)
  • Certified Agile / Scrum practitioner will be an added advantage
b) Working Experience
  • Minimum 4-5 years working experience in IT preferably in Insurance industry and experience
implementing data warehousing projects for Insurance or Finance
  • Minimum 3 years data mapping experience in Insurance domain and Financial reporting systems
  • Ability to translate business requirements / rules documentation into data requirements and
source-to-target ETL / ELT mappings for developers
  • Strong understanding of AS400 / Oracle legacy insurance systems
  • Proficient in SQL for data analysis of RDBMS and Hadoop
  • Understanding of data models and ETL / ELT processing
  • Familiarity with data model design processes
  • Must be able to provide sample data mapping documents
  • Experience in Data Warehouse a plus
  • Good understanding of IFRS4 or IFRS17 is an advantage
  • Good Insurance domain knowledge and knowledge of insurance products is preferred
c) Competencies
  • Must possess excellent business oriented analytical skills
  • Strong oral and written communication skills
GMA was founded in 2008 with the aim of establishing excellence in Software Development Services. We specialize in assisting companies to build and hire software development teams in Malaysia. GMA provides dedicated groups of highly-skilled and creative programmers for your projects. We deliver custom software and mobile application through flexible onshore and offshore models.

We are a team of highly motivated professionals whose shared passion is to contribute positively and significantly to our clients' business success. Our core values are integrity, teamwork, quality, continuous self improvement, performance driven and open communication.
Bachelor's or Equivalent

dudleyanddudleyllc.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, dudleyanddudleyllc.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, dudleyanddudleyllc.com is the ideal place to find your next job.

Intrested in this job?