Application Analyst & Designer

SAKSOFT PTE LIMITED; Singapore; On-site; SGD 120,000 - 180,000; Full time

Job summary

SAKSOFT PTE LIMITED is seeking an experienced Application Analyst & Designer to lead A&D work for Credit Risk, Basel and iFRS9 applications. You will enhance the Informatica environment, design and deploy complex ETL processes for the Enterprise Data Warehouse and Data Marts, and provide robust operational support for Informatica Metadata Manager.

The role requires 10+ years of relevant experience, strong communication, and ability to collaborate with cross-functional teams to ensure data

Qualifications

• Bachelor's degree in Computer Science or related field required.
• At least 8 years' relevant experience preferably in a Finance Institution.
• Proficiency in Informatica PowerCenter 10.x in an AIX/Solaris environment with AS400/Oracle source and targets.
• Experience on Credit, BASEL & iFRS9 related projects with knowledge of Basel risk variables (EAD, LGD, PD, ECL, RWA).
• Understanding of development lifecycle methodology and ability to deliver Informatica assignments.

Responsibilities

• Work with QR, Biz Users and project Team and Perform A&D work for Credit Risk, Basel and iFRS9 applications and list out the changes needed in these applications due to the change requests.
• Support and enhance existing Informatica environment and develop new, complex ETL processes to support additional design, development and deployment of the Enterprise Data Warehouse, and Data Marts
• Responsible for the operational support of Informatica Metadata Manager including automation, job scheduling, dependencies, monitoring, maintenance, patches, upgrades, security, performance and administration
• Support user acceptance test activities along with code migration, job scheduling activities as per the internal processes
• Work with other data analysts, business users and IT professionals to ensure that data requirements are met with the highest degree of integrity and efficiency
• Ensure that documentation is captured, maintained, understood by and available to business and/or IT partners
• Escalate critical technical issues and potential problems as needed to the Project Manager to address any related issues in advance of deadlines
• Should able to communicate with users and support their queries

Skills

Informatica PowerCenter

Oracle SQL/PLSQL

Shell Scripting

DevOps

Control-M

Hadoop/Hive/Impala

Experian PCCM

Education

Bachelor's degree in Computer Science or related field

Tools

Informatica PowerCenter (10.x)

Control-M

Experian PCCM

Oracle SQL/PLSQL

UNIX (AIX/Solaris)

Job description

Experience: 10+ Years
Role: Application Analyst& Designer

Responsibilities:

• Work with QR , Biz Users and project Team and Perform A&D work for Credit Risk, Basel and iFRS9 applications and list out the changes needed in these applications due to the change requests
• Support and enhance existing Informatica environment and develops new, complex ETL processes to support additional design, development and deployment of the Enterprise Data Warehouse, and Data Marts
• Responsible for the operational support of Informatica Metadata Manager including but not limited to automation, job scheduling, dependencies, monitoring, maintenance, patches, upgrades, security, performance and administration
• Support user acceptance test activities along with code migration, job scheduling activities as per the internal processes
• Work with other data analysts, business users and IT professionals to ensure that data requirements are met with the highest degree of integrity and efficiency
• Ensure that documentation is captured, maintained, understood by and available to business and/or IT partners
• Escalate critical technical issues and potential problems as needed to the Project Manager to address any related issues in advance of deadlines
• Should able to communicate with users and support their queries

Requirements:

Education:

• Bachelors’ Degree in Computer Science or related field.
• At least 8 years’ relevant experience preferably in a Finance Institution.

Essential:

• Proficiency in Informatica Power Center 10.x in an AIX, Solaris environment with AS400/Oracle source and targets.
• Experience on Credit , BASEL & iFRS9 related projects and should have knowledge on Basel risk variables like EAD, LGD, PD, ECL, RWA etc
• Understanding of development lifecycle methodology and ability tosuccessfully deliver Informatica assignments.
• Knowledge in Unix scripting would be an added advantage
• Exposure in database tuning would be an advantage
• Knowledge in Experian PCCM product is an added advantage
• Good communication

Key Domain/ Technical Skills:

(Indicate up to 3 areas)

• Informatica PowerCenter V10+
• Database Hadoop (Hive, Impala, beeline)
• Experian Product – PCCM
• Oracle SQL and PL/SQL
• Shell Scripting
• DevOps
• Control-M