ETL Informatica Developer

Job description

You are as unique as your background, experience and point of view. Here, you’ll be encouraged, empowered and challenged to be your best self. You'll work with dynamic colleagues - experts in their fields - who are eager to share their knowledge with you. Your leaders will inspire and help you reach your potential and soar to new heights. Every day, you'll have new and exciting opportunities to make life brighter for our Clients - who are at the heart of everything we do. At Sun Life, we're driven by our Purpose: helping our Clients achieve lifetime financial security and live healthier lives. Our values shape how we work: caring, authentic, bold, inspiring, and impactful. When you join Sun Life, you'll work with passionate colleagues and empowering leaders who support your growth and celebrate your contributions, so you can make a meaningful difference in our Clients' lives. Discover how you can make a difference in the lives of individuals, families and communities around the world. Job Description: Are you ready to shine? At Sun Life, we empower you to be your most brilliant self. Who we are? Sun Life is a leading financial services company with history of 150+ years that helps our clients achieve lifetime financial security and live healthier lives. We serve millions in Canada, the U.S., Asia, the U.K., and other parts of the world. We have a network of Sun Life advisors, third-party partners, and other distributors. Through them, we’re helping set our clients free to live their lives their way, from now through retirement. We’re working hard to support their wellness and health management goals, too. That way, they can enjoy what matters most to them. And that’s anything from running a marathon to helping their grandchildren learn to ride a bike. To do this, we offer a broad range of protection and wealth products and services to individuals, businesses, and institutions, including: Insurance. Life, health, wellness, disability, critical illness, stop-loss, and long-term care insurance. Investments. Mutual funds, segregated funds, annuities, and guaranteed investment products Advice. Financial planning and retirement planning services Asset management. Pooled funds, institutional portfolios, and pension funds With innovative technology, a strong distribution network and long-standing relationships with some of the world’s largest employers, we are today providing financial security to millions of people globally. Sun Life is a leading financial services company that helps our clients achieve lifetime financial security and live healthier lives, with strong insurance, asset management, investments, and financial advice portfolios. At Sun Life, our asset management business draws on the talent and experience of professionals from around the globe. Sun Life Global Solutions (SLGS) Established in the Philippines in 1991 and in India in 2006, Sun Life Global Solutions, (formerly Asia Service Centres), a microcosm of Sun Life, is poised to harness the regions’ potential in a significant way - from India and the Philippines to the world. We are architecting and executing a BOLDER vision: being a Digital and Innovation Hub, shaping the Business, driving Transformation and superior Client experience by providing expert Technology, Business and Knowledge Services and advanced Solutions. We help our clients achieve lifetime financial security and live healthier lives – our core purpose and mission. Drawing on our collaborative and inclusive culture, we are reckoned as a ‘Great Place to Work’, ‘Top 100 Best Places to Work for Women’ and stand among the ‘Top 11 Global Business Services Companies’ across India and the Philippines. The technology function at Sun Life Global Solutions is geared towards growing our existing business, deepening our client understanding, managing new-age technology systems, and demonstrating thought leadership. We are committed to building greater domain expertise and engineering ability, delivering end to end solutions for our clients, and taking a lead in intelligent automation. Tech services at Sun Life Global Solutions have evolved in areas such as application development and management, Support, Testing, Digital, Data Engineering and Analytics, Infrastructure Services and Project Management. We are constantly expanding our strength in Information technology and are looking for fresh talents who can bring ideas and values aligning with our Digital strategy. Our Client Impact strategy is motivated by the need to create an inclusive culture, empowered by highly engaged people. We are entering a new world that focuses on doing purpose driven work. The kind that fills your day with excitement and determination, because when you love what you do, it never feels like work. We want to create an environment where you feel empowered to act and are surrounded by people who challenge you, support you and inspire you to become the best version of yourself. As an employer, we not only want to attract top talent, but we want you to have the best Sun Life Experience. We strive to Shine Together, Make Life Brighter & Shape the Future! What will you do? The ETL Developer will be responsible for Working with the Subject Matter Experts and Business Analysts to grasp the best knowledge of existing/ new SLF investment product architecture and implement new features in the scope of the project and other project deliverables. Design, Development, Testing and Support of Informatica based ETL Applications, using existing and emerging technology platforms. The person will be exposed to a variety of assignments, responding to new business service requests/assignments, problem solving, maintaining stability and performing technical implementations. Partner with SME’s, Developers and other stakeholders. Your scope of work/Key responsibilities: Understand the project scope, identify activities/ tasks, task level estimates, schedule, dependencies, risks and provide inputs to Program Lead for review. Develop an ETL solution which can best meet the business requirements for investments applications. Analyze the data sources, be it a RDBMS or XLSX, CSV file or any other data source. Understanding of scheduling tools. Prepare/Modify design documents (High level design and Detailed design documents) based on business requirements. Suggest changes in design on technical grounds. Work on the functional and technical upgrades of the application Coordinate delivery of the assigned tasks with the onshore Partners or/and Business Analyst. Ensure timely notification and escalation of possible issues/problems, options and recommendations for prompt resolution Follow development standards to ensure that code is clear, efficient, logical and easily maintainable. Create and maintain application documentation like Network diagrams, Technical project handbook, technical data mapping doc, unit test documents, implementation plan. Ensure SLF Information Security Policies and General Computing Control is compiled to in all situations. Take complete ownership of work assignments and ensure the successful completion of assigned tasks. Ensure all written and verbal communication is clear, understandable and audience appropriate Key Qualifications and experience: Bachelor's/Master's degree in Computer Science, IT or related discipline. Minimum 1 to 3 years of overall IT experience. 1-3 years of working knowledge of of ETL (Informatica PowerCenter/ IDMC), relational databases Good to have knowledge/experience for AWS Skills like Glue, S3, EMR, Lambda, Step function etc. Good to have knowledge/ experience of scheduling tools like Autosys, Zeke etc. Good to have experience in DevOps tools - as Jenkins, Ansible and CDD etc. Good to have Industry knowledge of the Insurance industry with proven experience across multiple clients. Technical Credentials: Strong knowledge of ETL (Informatica PowerCenter / IDMC) and relational databases. Primary Location: Gurugram Job Category: IT - Application Development Posting End Date: 27/09/2026