Job description for Application Analyst (Data ETL) at RiDiK (a Subsidiary of CLPS. Nasdaq: CLPS)
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
Education:
· Bachelors’ Degree in Computer Science or related field.
· At least 8 years’ relevant experience preferably in a Finance Institution.
· 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 to successfully 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
Domain
· Informatica PowerCenter V10+
· Database Hadoop (Hive, Impala, beeline)
· Experian Product – PCCM
· Oracle SQL and PL/SQL
· Shell Scripting
· DevOps
· Control-M
