Data Modeler

2 days ago

bangalore, India Sun Life Full time

Who we are?

Sun Life is a leading financial services company with 157 years of history 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.


Sun Life Global Solutions (SLGS)

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.


Qualification


  • A University degree/ Post Graduation in Computer Science / Mathematics
  • 5+ Years of experience in data modeling, designing Operational data store and data warehouse.
  • Extensive experience in any of Data Modelling tools – Erwin/ SAP power designer.
  • Strong understanding of ETL and data warehouse concepts processes and best practices.
  • Proficient in Data Modelling including conceptual, logical and physical data modelling for both OLTP and OLAP.
  • Knowledge of relational database like Oracle, PostgreSQL or MS SQL Server.
  • Ability to write complex SQL for data transformations and data profiling in source and target systems
  • Possess a combination of solid business knowledge and technical expertise with strong communication skill.
  • Demonstrate excellent analytical and logical thinking.
  • Strong problem-solving capabilities; ability to come up with solutions for complex business problem
  • Solid experience with Data Warehouse and BI systems
  • Extensive experience for collecting business requirements from customers, and transform the requirements into DB data processes and database schema.


Roles and Responsibility


  • Build and maintain out of standards data models to report disparate data sets in a reliable, consistent and interpretable manner.
  • Gather, distil and harmonize data requirements and to design coherent Conceptual, logical and physical data models and associated physical feed formats to support these data flows.
  • Articulate business requirements to build source-to-target mappings having complex ETL transformation.
  • Write complex SQL statements and profile source data to validate data transformations.
  • Contribute to requirement analysis and database design - Transactional and Dimensional data modelling. Normalize/ De-normalize data structures, introduce hierarchies and inheritance wherever required in existing/ new data models.
  • Knowledge on IFRS standard for insurance domain
  • Acts as a bridge between development and business team to support the successful delivery of the development and testing phases of Agile development cycle
  • Effectively elicits, analyzes, verifies, and communicates requirements including business, functional, and nonfunctional requirements.
  • Analyzing insurance IT systems or databases to find the story within the data and then communicating results to senior stakeholders

  • Data Modeler

    5 months ago

    bangalore, India Idyllic Services Pvt. Ltd. Full time

    JOB TITLE: Data ModelerSUMMARY : Are you a strong Data Modeler with Financial Services experience looking to make a strategic impact? We're seeking a talented individual to translate business requirements into data models, participate in mapping processes, and ensure data integrity within the Banking and Financial Markets context.Responsibilities:Translate...

  • Data Modeler

    2 weeks ago

    Bangalore, India Fractal Full time

    Data Modeler Responsibilities • Participate in requirements definition, analysis and the design of logical and physical data models for Dimensional Data Model, NoSQL or Graph Data Model • Leading data discovery discussions with Business in JAD sessions and map the business requirements to logical and physical data modeling solutions. • Conduct...

  • Data Modeler

    1 day ago

    bangalore, India Tata Consultancy Services Full time

    Experience-6 to 10 years Location-benagluru, chennai, hyderabad, pune, kolkata, Delhi,Indore,mumbai Roles and responsibilities: 5+ years of proven working experience as a data modeler 2. Dimensional Data Modeling experience 3.Strong analytical skills with the ability to collect, organise, analyse, and disseminate significant amounts of information with...

  • Data Modeler

    3 weeks ago

    bangalore, India GyanSys Inc. Full time

    Gyansys is Looking for Data Modelling & Data Warehouse Consultant with 5 years of experience for Bangalore joining, Hybrid. Notice Period: Upto 30 days.Good Understanding to Datamodel ConceptsGood Hand on the DataHands on any DAta Modelling Tools, preferrably SAP Power DesignerMaintain logical and physical data models along with accurate metadata.Solution...

  • Data Modeler

    2 weeks ago

    Bangalore, India Idyllic Services Pvt. Ltd. Full time

    JOB TITLE: Data Modeler SUMMARY : Are you a strong Data Modeler with Financial Services experience looking to make a strategic impact? We're seeking a talented individual to translate business requirements into data models, participate in mapping processes, and ensure data integrity within the Banking and Financial Markets context. ...

  • Data Modeler

    5 days ago

    bangalore, India Tata Consultancy Services Full time

    Experience-6 to 10 yearsLocation-benagluru, chennai, hyderabad, pune, kolkata, Delhi,Indore,mumbaiRoles and responsibilities:5+ years of proven working experience as a data modeler 2. Dimensional Data Modeling experience 3.Strong analytical skills with the ability to collect, organise, analyse, and disseminate significant amounts of information with...

  • Data Modeler

    2 days ago

    bangalore, India Tata Consultancy Services Full time

    Experience-6 to 10 yearsLocation-benagluru, chennai, hyderabad, pune, kolkata, Delhi,Indore,mumbaiRoles and responsibilities:5+ years of proven working experience as a data modeler 2. Dimensional Data Modeling experience 3.Strong analytical skills with the ability to collect, organise, analyse, and disseminate significant amounts of information with...

  • Data Modeler

    5 days ago

    bangalore, India Tata Consultancy Services Full time

    Experience-6 to 10 years Location-benagluru, chennai, hyderabad, pune, kolkata, Delhi,Indore,mumbai Roles and responsibilities: 5+ years of proven working experience as a data modeler 2. Dimensional Data Modeling experience 3.Strong analytical skills with the ability to collect, organise, analyse, and disseminate significant amounts of information with...

  • Data Modeler

    1 day ago

    bangalore, India Synechron Full time

    Good day, We have an immediate opportunity for Data Modeler Job Title: Data Modeler Location: Bengaluru Experience Required: 7+Years. Notice Period: up-to 30 days About Company: At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver...

  • Data Modeler

    1 day ago

    bangalore, India Synechron Full time

    Good day, We have an immediate opportunity for Data Modeler Job Title: Data Modeler Location: Bengaluru Experience Required: 7+Years. Notice Period: up-to 30 days About Company: At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver...

  • Data Modeler

    3 weeks ago

    bangalore, India Synechron Full time

    Good day,We have an immediate opportunity for Data ModelerJob Title: Data ModelerLocation: BengaluruExperience Required: 7+Years.Notice Period: up-to 30 daysAbout Company:At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver...

  • Data Modeler

    2 weeks ago

    Bangalore, India Synechron Full time

    Good day, We have an immediate opportunity for Data Modeler Job Title: Data Modeler Location: Bengaluru Experience Required: 7+Years. Notice Period: up-to 30 days About Company: At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative...

  • Data Modeler

    3 weeks ago

    bangalore, India Synechron Full time

    Good day, We have an immediate opportunity for Data Modeler Job Title: Data Modeler Location: Bengaluru Experience Required: 7+Years. Notice Period: up-to 30 days About Company: At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver...

  • Data Modeler

    2 days ago

    bangalore, India Synechron Full time

    Good day,We have an immediate opportunity for Data ModelerJob Title: Data ModelerLocation: BengaluruExperience Required: 7+Years.Notice Period: up-to 30 daysAbout Company:At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading...

  • Data Modeler

    3 weeks ago

    bangalore, India Sun Life Full time

    Who we are?Sun Life is a leading financial services company with 157 years of history 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,...

  • Data Modeler

    2 days ago

    bangalore, India Sun Life Full time

    Who we are?Sun Life is a leading financial services company with 157 years of history 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,...

  • Data Modeler

    2 days ago

    Bangalore Urban, India Tata Consultancy Services Full time

    Greetings from Tata Consultancy Services!!We are hiring for Data ModelerRequired Skillset: Dimensional ModelingExperience :6-10 yearsLocation : Noida/Bangalore/Kolkata/Pune/Mumbai/Indore/Chennai/HyderabadJob Description:1. 5+ years of proven working experience as a data modeler2. Dimensional Data Modeling experience3. Strong analytical skills with the...

  • Data Modeler

    1 hour ago

    Bangalore Urban, India Tata Consultancy Services Full time

    Greetings from Tata Consultancy Services!! We are hiring for Data Modeler Required Skillset: Dimensional Modeling Experience :6-10 years Location : Noida/Bangalore/Kolkata/Pune/Mumbai/Indore/Chennai/Hyderabad Job Description: 1. 5+ years of proven working experience as a data modeler 2. Dimensional Data Modeling experience 3. Strong analytical skills...

  • Data Modeler

    1 month ago

    Bangalore Urban, India NexionPro Services Full time

    Job DescriptionThe data modeler designs, implements, and documents data architecture and data modeling solutions, which include the use of relational, dimensional, and NoSQL databases. These solutions support enterprise information management, business intelligence, machine learning, data science, and other business interests.The successful candidate will:-...

  • Data Modeler

    1 month ago

    Bangalore Urban, India NexionPro Services Full time

    Job Description The data modeler designs, implements, and documents data architecture and data modeling solutions, which include the use of relational, dimensional, and NoSQL databases. These solutions support enterprise information management, business intelligence, machine learning, data science, and other business interests. The successful candidate will:...