Company Profile:

About Sun Life Global Solutions With 32 years of operations in the Philippines and 17 years in India, 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. Join the Sun Life family & make bright career choices.

Job description:

Looking for immediate joiner

 

Roles & Responsibilities 

 

• Collaboration & coordination with multiple business partners. 

• Develop pipelines to ingest data from different sources such as Database, delimited files etc, do complex transformation and loading data into the S3. 

• Develop Glue mapping and create Glue data catalogue. 

• Implementation of Athena. 

• Can optimize Informatica for performance improvements. 

• SQLs capability for data analysis. 

• Able to handle the end-to-end ETL or ELT pipeline solely. 

• Ensuring the work is delivered on time and with quality. 

 

Requirements

 • Extensive practical experience in Information Technology and software development projects of with at least 5+ years of experience in developing data warehouse systems. 

• Extensive experience in on cloud data technologies – in particular on AWS.

 • Strong understanding of ETL and data warehouse concepts processes and best practices. • Good understanding of Big data and cloud technologies 

• Possess a combination of solid business knowledge and technical expertise with strong communication skills. 

• Demonstrate excellent analytical and logical thinking. •

 Good verbal & written communication skills and ability to work independently as well as in a team environment providing structure in ambiguous situation.