Data Engineering - Solution Designer

Discover your opportunity with Mitsubishi UFJ Financial Group (MUFG), one of the world’s leading financial groups. Across the globe, we’re 150,000 colleagues, striving to make a difference for every client, organization, and community we serve. We stand for our values, building long-term relationships, serving society, and fostering shared and sustainable growth for a better world.

With a vision to be the world’s most trusted financial group, it’s part of our culture to put people first, listen to new and diverse ideas and collaborate toward greater innovation, speed and agility. This means investing in talent, technologies, and tools that empower you to own your career.

Join MUFG, where being inspired is expected and making a meaningful impact is rewarded.

The role is part of Data Engineering and Business Intelligence team  within MUFG EMEA  Technology  which manages the projects related to data applications across MUFG bank systems. We looking for a experienced  designer/ developer with around 10 to 14 years of experience driving different data solutions end to end.

• Design & Development: Design and develop ETL/ELT workflows using Informatica Intelligent Data Management Cloud (IDMC/IICS) and, where necessary, PowerCenter.
• Snowflake Integration: Create and maintain efficient ETL/ELT pipelines, loading data from various sources (APIs, RDBMS, files) into Snowflake for analytics.
• Data Modeling: Implement dimensional data models, including FACT/DIM table design and Star/Snowflake schemas.
• Optimization: Write and tune complex SQL/PL/SQL, optimizing queries and data pipelines for high performance, scalability, and speed.
• Data Integration: Implement Change Data Capture (CDC) and data quality assurance.
• Collaboration: Work with data architects, stakeholders, and data engineering teams to meet business requirements and performance SLAs. 
• Conduct code reviews and ensure the relevant documentation  for the  application are updated as part of the Project.
• Take the ownership of tech debts and prod enhancemnets

• Design and implement data integration solutions, ensuring seamless data flow between various systems and applications. 
• Collaborate with business stakeholders, IT teams, and architects to understand business needs and translate them into technical designs. 
• Stay updated on industry trends and emerging technologies, and explore innovative data solutions.
• Closing of the incidents with good Resolutions notes and  details within SLAs.

• Ensure all activity fully complies with the appropriate policies, procedures and controls
• Strict adherence to change management and privileged production access management processes

• 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.

• Required to have a good understanding of software development methodologies.
• Proven experience designing, delivering, and scaling data-intensive applications.
• Experience working on transformation projects involving introducing new technologies and ways of working within a business. Ability to drive adoption of new data architectures and technologies.
• Ability to clarify and uncover technical requirements, risks, and opportunities with tech leads and collaborators. Experience translating business needs into technical specifications.
• Deep, demonstratable experience delivering with various types of databases and design, including relational databases, NoSQL databases, graph databases, vector stores, and data warehouses, particularly in cloud environments. Experience with data modelling techniques and data warehousing methodologies (e.g., Kimball, Inmon, Data Vault).
• Hands-on experience with cloud data platforms and services (e.g., AWS, Azure, GCP). Familiarity with cloud-native data architectures and technologies.
• Experience with data management tools and processes.

Degree educated and / or equivalent experience

Mitsubishi UFJ Financial Group (MUFG) is an equal opportunity employer. We view our employees as our key assets as they are fundamental to our long-term growth and success. MUFG is committed to hiring based on merit and organsational fit, regardless of race, religion or gender.

• Expertise in cloud-based data platforms Snowflake (preferred), AWS, Azure,Databricks.
• Informatica: Strong hands-on experience with IDMC, Cloud Data Integration (CDI), and IICS.
• Snowflake: Proficiency in Snowflake data modeling, stored procedures, and performance tuning.
• SQL: Advanced SQL and PL/SQL skills.
• ETL Concepts: Strong understanding of dimensional modeling, CDC, and data warehousing principles.
• Cloud & Tools: Familiarity with Azure Data Factory (ADF) and scheduling tools like Control-M.