OVERVIEW OF THE DEPARTMENT/SECTION:
AMD DEBI is part of MUFG EMEA Technology. The department manages various data related applications and projects related to the MUFG Bank and Securites in EMEA.
MAIN PURPOSE OF THE ROLE:
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 6 to 10 years of experience driving different data solutions end to end.
KEY RESPONSIBILITIES:
Delivery:
Design & Development:
- Design and develop ETL/ELT workflows using Informatica Intelligent Data Management Cloud (IDMC/IICS) and, where necessary, PowerCenter.
AI SDLC:
- Use AI in SDLC to develop mappings using copilots or agents. Adapt to trends to improve the delivery or the code.
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 enhancements
- 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.
Risk & Compliance:
- Ensure all activity fully complies with the appropriate policies, procedures and controls
- Strict adherence to change management and privileged production access management processes
Culture 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.
WORK EXPERIENCE:
- 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.
SKILLS AND EXPERIENCE:
Functional / Technical Competencies:
- 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.
Education / Qualifications:
- Degree educated and / or equivalent experience.
PERSONAL REQUIREMENTS:
- Excellent communication skills
- Results driven, with a strong sense of accountability
- A proactive, motivated approach.
- Ability to communicate effectively with senior management and convey technical information to non-technical audience.
PERFORMANCE AND DUTIES:
- As duties and responsibilities change, the job description will be reviewed and emended in consultation with the role holder. The role holder will carry out other duties as are within the scope, spirit and purpose of the role as requested by their line manager or Department Head.