ETL Developer

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 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. What will you do? The Corporate IT team is looking for an experienced Informatica Power center / IICS developer who will bring expertise in development, support and implementation of solutions for the corporate finance chargeback area. The successful candidate will be responsible for development, integration, Operation and project delivery focusing on Chargeback data processing and dependent systems. 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.
• Perform analysis, design and development phases to develop a robust ETL solutions which can best meet the business requirements for investments applications.
• Prepare/Modify design documents (High level design and Detailed design documents) based on business requirements.
• Strong ability to work independently with a bias toward action and results.
• Perform production support activities along with on call support during India daytime.
• Performance Tuning/automation and process improvement.
• 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.
• Self-learner and should take complete ownership of work assignments and ensure the successful E2E delivery.
• Strong analytical ability to understand user requirements.
• Very Good Communication Skill and should be able to work with a large team in Onsite – Offshore model.
• Ensure all written and verbal communication is clear, understandable and audience appropriate.

• A degree in Computer Science, related technology degree, or equivalent experience.
• Minimum 3 to 4.6 years of overall IT experience
• 2+ years of experience on Informatica Power center / IICS
• Strong knowledge of relational databases (Oracle/MS SQL server).