Senior Informatica Developer

About Us:MUFG Bank, Ltd. is Japan’s premier bank, with a global network spanning in more than 40 markets. Outside of Japan, the bank offers an extensive scope of commercial and investment banking products and services to businesses, governments, and individuals worldwide. MUFG Bank’s parent, Mitsubishi UFJ Financial Group, Inc. (MUFG) is one of the world’s leading financial groups. Headquartered in Tokyo and with over 360 years of history, the Group has about 120,000 employees and offers services including commercial banking, trust banking, securities, credit cards, consumer finance, asset management, and leasing. The Group aims to be the world’s most trusted financial group through close collaboration among our operating companies and flexibly respond to all the financial needs of our customers, serving society, and fostering shared and sustainable growth for a better world. MUFG’s shares trade on the Tokyo, Nagoya, and New York stock exchanges.MUFG Global Service Private Limited:Established in 2020, MUFG Global Service Private Limited (MGS) is 100% subsidiary of MUFG having offices in Bengaluru and Mumbai. MGS India has been set up as a Global Capability Centre / Centre of Excellence to provide support services across various functions such as IT, KYC/ AML, Credit, Operations etc. to MUFG Bank offices globally. MGS India has plans to significantly ramp-up its growth over the next 18-24 months while servicing MUFG’s global network across Americas, EMEA and Asia Pacific.About the Role:Position Title: Senior Informatica DeveloperCorporate Title: AVPReporting to: VPLocation: BengaluruJob Profile:Position details:To perform application development on Data Management Systems across MUFG Bank EMEA and MUS International. The individual is to work as the senior developer for applications within the DEBI (Data Engineering and Business Intelligence) BAU team which develops various applications and manages the project deliveriesRoles and Responsibilities:Delivery:- Perform advanced ETL development activities using Informatica, PL/SQL, Oracle Database tuning, SQL tuning - Oracle and SQL Server experience from the development perspective (database and application). - Develop and enhance ETLs from various sources to Oracle and SQL server data warehouse - Plan and conduct Informatica ETL unit and development tests. - Design, implement, test and maintain ETL components for multiple applications. - Provide post-production application support as required. - Provide data analysis to support new project definition/design to troubleshoot/resolve issues with existing subject areas - Work independently or as part of a team to deliver data warehouse ETL projects - Follow established standards and best practices and provide input for improvement of those processesRisk & Compliance:- Ensure all activity fully complies with the appropriate policies, procedures and controls - Strict adherence to change management and privileged production access management processesCulture and Leadership:- Promote the MUFG values-led culture which is inclusive and diverse. - Promote a dynamic, delivery driven culture that works alongside business units to provide responsive resolutions and value driven solutions.Job Requirements:- The Ideal candidate will be working as part of a team in developing complex ETL codes and we are looking for a person who has strong experience (7+ years) working as part of large-scale teams developing applications. - ETL Tools: Informatica 10.x - Database: Oracle, SQL Server - Batch Job scheduler like Control M (preferred) - Powershell, Plsql, SQL server Stored Procs. - Cloud: Snowflake (good to have) - Versioning And Deployment: GIT, DA - Experience in application development, database development and system support.Functional / Technical Competencies:- Knowledge of the IT infrastructure (for example, hardware, databases, operating systems, local area networks) and the IT applications and service processes used within a Financial Services organization. - Required to have a good understanding of software development methodologies. - Good Data analysis and SQL - Strong analytical and problem solving skills. - Possess good verbal and written communication skills.Personal Requirements:- Strong decision making skills, the ability to demonstrate sound judgement. - A structured and logical approach to work. - Strong problem solving skills. - A creative and innovative approach to work. - Excellent interpersonal skills. - The ability to manage large workloads and tight deadlines. - Excellent attention to detail and accuracy. - A calm approach, with the ability to perform well in a pressurized environment. - Strong numerical skills.Equal Opportunity Employer:The MUFG Group is committed to providing equal employment opportunities to all applicants and employees and does not discriminate on the basis of race, colour, national origin, physical appearance, religion, gender expression, gender identity, sex, age, ancestry, marital status, disability, medical condition, sexual orientation, genetic information, or any other protected status of an individual or that individual's associates or relatives, or any other classification protected by the applicable laws.