Data Controls Engineer
- Bangalore, Karnataka
- Permanent
- Full-time
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.
Position Title: Data Controls EngineerLocation: BengaluruJob ProfilePosition detailsData Integration / ETL Developer with hands-on experience in designing and implementing data warehouses, data lakes, and data marts for large financial institutions using Python, Informatica, and related database technologies such as DB2, Oracle. In this role you will focus on enabling data aggregation controls from disparate sources or systems. Responsibilities include implementing data control checks writing testing scripts; performing quality control on data and data storage; identifying or developing control standards to funnel data into a single platform; Familiarity withdata architecture, data integration, data governance, and data lineage concepts; Experience working in Agile environments, working with Agile teams and JIRARoles and Responsibilities:
- Data Reconciliation: Assist in comparing and reconciling data from various sources using reconciliation tools and software.
- Data Validation: Conduct basic data validation and verification activities to ensure the accuracy of data sets.
- Error Identification: Help identify discrepancies, errors, or anomalies in data and collaborate with senior specialists to address and resolve issues.
- Documentation: Maintain accurate records of data reconciliation processes, findings, and resolutions.
- Reporting: Assist in preparing reports summarizing data reconciliation results.
- Data Cleansing: Support data cleansing efforts by working with data owners and teams to correct and clean data as necessary.
- Learning and Development: Continuously learn about data reconciliation tools and best practices, seeking guidance and mentorship from senior team members.
- Bachelor's degree in Finance, Accounting, Data Science, Information Technology, or a related field.
- 3+ years of Data Analysis, prior experience working with industry best practices is preferred.
- Experienced in data warehouse and data integration projects
- Hands-on expertise in developing ETL (Extract, Transform and Load) mappings and workflows using Informatica is preferred.
- Expertise in relational and dimensional databases like UDB DB2, Oracle, and SQL Server.
- Unix shell/Python scripting experience.
- Batch Scheduling tools experience and knowledge
- Core Java experience and knowledge
- Excellent problem-solving skills.
- Strong attention to detail and a willingness to learn.
- Strong communication skills to collaborate with team members.
- Ability to work under supervision and meet deadlines.
- Eagerness to develop skills in data reconciliation and data quality management.