Job Description

We are M&G Global Services Private Limited (formerly known as 10FA India Private Limited, and prior to that Prudential Global Services Private Limited). We are a fully owned subsidiary of the M&G plc group of companies, operating as a Global Capability Centre providing a range of value adding services to the Group since 2003. At M&G our purpose is to give everyone real confidence to put their money to work. As an international savings and investments business with roots stretching back more than 170 years, we offer a range of financial products and services through Asset Management, Life and Wealth. All three operating segments work together to deliver attractive financial outcomes for our clients, and superior shareholder returns.M&G Global Services has rapidly transformed itself into a powerhouse of capability that is playing an important role in M&G plcs ambition to be the best loved and most successful savings and investments company in the world.Our diversified service offerings extending from Digital Services (Digital Engineering, AI, Advanced Analytics, RPA, and BI & Insights), Business Transformation, Management Consulting & Strategy, Finance, Actuarial, Quants, Research, Information Technology, Customer Service, Risk & Compliance and Audit provide our people with exciting career growth opportunities. Through our behaviours of telling it like it is, owning it now, and moving it forward together with care and integrity; we are creating an exceptional place to work for exceptional talent.Senior Lead ETL EngineerAt M&G we are on a very exciting digital transformation journey towards a more agile, customer-centric and digital-first way of working. We have lots to improve and plenty of interesting challenges we\'d like you to get involved in.We are on a journey to reinvent how people think about their financial future. Making conversations around retirement easier and more relevant, offering diversified products, rethinking and improving the end-to-end experience for our customers and using technology to effectively engage with them in real time and help them make better decisions about their finances.The journey has started already, are you ready to join us? We need the best digital minds onboard in order to achieve our goal. We are looking for a Senior Lead ETL Engineer to join our Studio working in a Feature Team delivering change across our marketing technology estate. The role will be based out of our Engineering Hub in India and working in close collaboration with our UK colleagues in the Studio.We promote a supportive, diversified, international environment with an engineering culture we're proud of. We encourage personal growth and invest in open-minded engineers keen on learning, who continuously try to make things better.You should apply if:

• You have good engineering experience in the relevant technologies.
• You want to take a key role on our teams and help us deliver awesome business features
• You have been working in teams on large projects, actively writing code through the whole stack.
• You understand Agile practices like Scrum, Kanban and DevOps and have practical experience of at least one.
• You enjoy collaborating closely with other members of a cross-functional team to deliver features.
• You care deeply about improving security and code quality and progressing collective best practices.
• You want to actively engage with our engineering community on defining standards and guidelines
• You love learning and enjoy playing with new tech as well as exploring areas that you might not have experience with yet.
• You are versatile when finding solutions and good at walking people through them.
• You are proactive and a team player - both within your feature team, and in the wider development team. You have experience working with other developers, reviewing PRs, discussing tools, offering feedback and collaborating with colleagues to create the best outcome.

Accountabilities:

• Project Delivery: Ensure the timely and accurate delivery of projects involving Azure Data Factory and Informatica implementations, meeting both external and internal quality standards.
• Code Quality: Maintain high standards of code quality through code reviews, automated testing, and adherence to best practices and coding guidelines.
• System Performance: Monitor and optimize the performance, scalability, and reliability of applications built on Azure Data Factory and Informatica technologies.
• Documentation: Create and maintain comprehensive documentation for Azure Data Factory and Informatica solutions, including system designs.
• Compliance and Security: Ensure that all Azure Data Factory and Informatica implementations comply with industry standards, security protocols, and regulatory requirements.
• Innovation: Stay updated with the latest developments in Azure Data Factory and Informatica, industry trends, and emerging technologies to drive continuous improvement and innovation within projects.
• Stakeholder Satisfaction: Ensure high levels of stakeholder satisfaction by delivering solutions that meet or exceed their expectations.

Responsibilities:

• Azure Data Factory Development: Design, develop, and deploy applications using Azure Data Factory and Informatica to meet business requirements.
• Collaboration: Work closely with product owners, tech leads and other development team members to deliver cohesive and comprehensive digital solutions.
• Troubleshooting: Diagnose and resolve technical issues related to ETL implementations, providing timely support and fixes.
• Testing and Quality Assurance: Develop and execute unit tests and integration tests to ensure the reliability and quality of the delivered solutions.
• Mentorship: Mentor junior developers and contribute to their professional development through knowledge sharing and technical guidance.
• Configuration Management: Manage and configure ETL instances.
• Continuous Improvement: Proactively identify areas for improvement within the development process, recommending and implementing enhancements to optimise efficiency and effectiveness.

Knowledge & Skills:

• Must be an expert in these:

• Azure Data Factory
• Informatica PowerCenter
• Informatica Intelligent Cloud Services
• Change Data Capture
• Data Quality
• Oracle DBMS
• PL/SQL
• Unix scripting
• Maestro
• Strong experience in version control and build/deploy pipelines
• Sonarqube and Checkmarx for static code analysis and security scanning
• Able to use team collaboration tools - Teams, Jira, Confluence, etc.

Experience:

• At least 10 years experience in relevant technologies delivering quality software solutions. ETL technologies are a Must Have for this role, so Azure Data Factory, Informatica, Oracle DBMS, PL/SQL, Unix scripting with additional relevant technical skills desirable.
• Experience acting as a subject matter expert on Azure Data Factory and Informatica and related technologies
• DevOps engineering experience to transform, optimise and integrate our DevOps processes including automated CI/CD DevOps pipelines to get code through test environments and to production
• Experience working in fast paced agile environments and understand agile/scrum project planning, execution and risk management
• Solid knowledge of design patterns and refactoring concepts
• Practical expertise in performance tuning and optimization, bottleneck problem analysis
• Stay current on industry trends and best practices in Azure Data Factory, Informatica, Oracle DBMS and related technologies
• Ability to come up with creative solutions for ambiguous problems and learn quickly
• Experience contributing to, and achieving, continuous improvement goals
• Working with third party suppliers

Don\'t worry if you don\'t know everything, we're happy to train people on the technologies you\'ll need in the job.People who work at M&G agree that ours is a great place to work with a brilliant team spirit. Its also an innovative, high-performing, commercial environment thats totally focused on customers. Youll receive a competitive salary and reward package. And in a fast-changing world, youll join an organisation thats leading the way in helping customers achieve their long-term financial goals.M&G is committed to a diverse and inclusive workplace. Our role as an employer is very simple - to provide the right environment for talented people to do their best work, by respecting, understanding and valuing individual differences.We welcome applications from individuals who have taken an extended career break, and we are willing to consider flexible working arrangements for all our roles.We have a diverse workforce and an inclusive culture at M&G Global Services, regardless of gender, ethnicity, age, sexual orientation, nationality, disability or long term condition, we are looking to attract, promote and retain exceptional people. We also welcome those who take part in military service and those returning from career breaks.

M&G