MUFG Global Service (MGS)
Location
Bangalore | India
Job description
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 PowerCenter, Unix Shell Scripts, advanced SQL, and Autosys / Tidal 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.
- Support the Data Quality Program, including the creation and execution of DQ queries using Informatica IDQ and JIRA
- 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.
- 5-8 years of hands-on experience using Informatica, DB2, SQL Server and Unix.
- 2+ years of data integration experience in a lead role, preferably in the financial services industry.
- 4+ 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.
- Experience in Data Modeling using ER Studio Dimensional Modeling , Canonical Modeling
- Strong experience with one or more RDBMS platforms (DB2, Oracle, etc.) and UNIX Scripting is required.
- Knowledge or experience in Informatica Data Quality, 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.
- 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.
Job tags
Salary