Application Analyst & Designer (ETL Datawarehouse)

Key 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

Skills:  

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