Lead ETL Informatica Admin [T500-16268]

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

Job Overview :

MUFG Bank is looking for experienced Data Integration Operations Support with a strong background in Data Integration Technologies. The ideal candidate will have a good understanding of data integration and data quality tools from Informatica. Candidate should also have proficiency in AWS services for Data Integration like AWS Glue, AWS Lambda, Step functions etc.

Data Integration Operations Support Engineer Lead :

Platform Management :

• 10+ years of experience in ETL platform administration with experience spread across Informatica PowerCenter and Informatica cloud (IICS) as well as AWS Glue and Snowflake Data Platforms
• 8+ years of experience in dealing with multiple databases DB2, Oracle, Sql Server, etc.
• 4+ years of cloud data platform experience.
• Expertise in Informatica Administration tasks including Installation, Configuration of domains, Code Promotions / Migrations, managing users, groups, associated privileges, performing backups and restore for domain components for Informatica tools.
• Hands-on experience in developing ETL mappings, workflows and providing production support for critical data warehouse environments
• Hands-on experience in administration and supporting Informatica’s PowerCenter, Data Quality, Informatica Webservices, Power Exchange and Informatica Cloud(IDMC) and DVO etc.
• Familiarity with various inter-related tools for version control like Bitbucket, GitHub and scheduling tools like AutoSys.
• Hands-on Experience in setting up the security for Informatica environments / domains
• Hands-on in implementing several reusable scripts which include Informatica service Monitoring, Backups, Generic workflow / task flow start script, server monitoring scripts.
• Hands-on Experience in various performance tuning activities which includes identifying the potential bottle necks and thereby tuning ETL code for best performance.
• Expertise in UNIX shell scripting, communicating with server using pmcmd / pmrep.
• Hands on Experience working with AWS services including Glue, S3, EKS, Data Pipeline, Step functions and establishing connectivity to AWS services like RDS from Informatica, Apache Spark.
• Experience with working on big data processing platforms like Apache Spark, building ETL code using Apache pyspark.
• Familiarity with application support models and working in 24
• 7 support environment using ITIL processes
• Experience in setting up Informatica application Infrastructure like .profiles, parameters, environment variables etc.
• Experience in raising service requests with Informatica for resolving any product related issues
• Hands-on Experience in migrating various complex applications between environments and to Production using Informatica’s deployment groups, folder / XML migration
• Hands-on Experience in creating TNS / ODBC entries and DB2 entries.
• Hands-on Experience in implementing automated reusable scripts across environment which includes - Monitoring of INFA Services, CPU / Memory, volume group / SAN, Network, backups like domain / repository etc.

Collaboration & Teamwork :

Documentation and Support :

Qualification for Data Integration Operations Support Engineer :

Business Acumen :

Financial Services Domain experience - 25%

Data Skills :

Data Warehousing, Data Mesh and Data Lakes, Data Governance - 25%

Tech Skills :

Core Competency in ETL Admin - 25%

Human Skills :

Strong Inter-personal skills + leadership & management skills - 25%