Analyst Informatica Developer

About Us: MUFG Bank, Ltd. is Japans 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 Banks parent, Mitsubishi UFJ Financial Group, Inc. (MUFG) is one of the worlds 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 worlds 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. MUFGs 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 MUFGs global network across Americas, EMEA and Asia Pacific. About the Role: Position Title: Sr. Software Engineer. Corporate Title: Analyst, Software Engineering Location: MGS - Bengaluru Job Profile Position details: With your deep expertise and proven success using analytical thinking and iterative problem-solving, you have what it takes to manage programs and processes strategically and tactically. Whether balancing the needs of multiple stakeholders or making sound decisions using data, analysis, past experience, and a risk mindset, you will serve as a trusted advisor who routinely solves complex business problems and delivers against milestones. In the process, you will have exciting opportunities to develop your skills, expand your network, and build your career.Roles and Responsibilities: Develop and maintain complex ETL mappings, workflows, and UNIX shell scripts in a Data Warehouse environment, based on technical specifications and other supporting documentation, using Informatica cloud data integration, PowerCenter, Unix Shell Scripts, advanced SQL, and Autosys Enterprise Scheduler. Provide input for the creation of technology related project documents including functional and detailed design documents ensuring that the design meets requirements and is detailed enough to provide to development teams. Participate in the rollout of any changes to the production environment and the setting of new standards using change control, documentation, and full communication with the operations and support. Ensure compliance with technical best practices, standards and policies. Gather / document business requirements, analyzing current technology, data, and processes versus potential to create recommended solutions. Analyze complex cross functional problems, quickly grasp concepts related to industry specific design / development and articulate them concisely to foster project team collaboration. Work with the IT lead and coordinate development, testing, and implementation phases ensuring that all deliverables meet expectations. Work well under pressure and work independently or as part of a team. Resolve production defects within defined SLA. Job Requirements: Bachelors Degree (or foreign equivalent degree) in Information Technology, Information Systems, Computer Science, Software Engineering, or a related field. Experience in the financial services or banking industry is preferred. 4-8 years of hands-on experience using Informatica, DB2, SQL Server and Unix. 5+ years of Informatica ETL experience in both batch and real-time or near real-time data integration. 1+ years of experience in any of the object oriented programming language such as Python, Java preferred. Strong experience with one or more RDBMS platforms (DB2, Oracle, etc.) and UNIX Scripting is required. Knowledge or experience in data modeling and data design of data warehouse, data marts, data lakes is preferable. Understanding of AWS Data Services like RDS, Redshift, S3, Athena, Glue, Kinesis, EMR. Experience with Big Data approaches and technologies including: Hadoop, AWS, Spark, Kafka, Hive is preferable good to have. Excellent meeting facilitation and presentation skills, with best in class customer service orientation and multi-tasking ability. Experience working in Waterfall / Agile development methodologies. A team player with excellent communication skills, logical thinking and analytical skills. Ability to be flexible, decision oriented, and motivated. Ability to manage multiple work streams with conflicting deadlines proactively.