Jobs
Interviews

Posted:1 day ago| Platform: Linkedin logo

Apply

Skills Required

data modeler consulting report etl sql analysis database design inheritance aws technology software development sap power logical profiling nosql

Work Mode

On-site

Job Type

Full Time

Job Description

Data Modeler

Gurugram & Bangalore

Work Mode - Hybrid

Work Type - Permanent


Roles and Responsibilities -


  • Build and maintain out of standards data models to report disparate data sets in a reliable, consistent and interpretable manner.
  • Articulate business requirements and 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.
  • Work with data consumers and data suppliers to understand detailed requirements, and to propose standardized data models.
  • Understanding of Insurance Domain
  • Basic understanding of AWS cloud

Key Qualifications and experience:

  • Extensive practical experience in Information Technology and software development projects of with at least 8+ years of experience in designing Operational data store & data warehouse.
  • Extensive experience in any of Data Modelling tools – Erwin/ SAP power designer etc.
  • 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.
  • Ability to write complex SQL for data transformations and data profiling in source and target systems
  • Basic understanding of SQL vs NoSQL databases.

More Jobs at Bean HR Consulting

Senior Consultant

Gurugram, Haryana, India

7.0 - 7.0 yrs
|

Salary: Not disclosed

Senior Dotnet Developer

Gurugram, Haryana, India

6.0 - 6.0 yrs
|

Salary: Not disclosed

Senior Manager/ Manager-Buying and Merchandising

Mumbai, Maharashtra, India

7.0 - 7.0 yrs
|

Salary: Not disclosed

Senior Specialist- Release Management

Gurugram, Haryana, India

8.0 - 11.0 yrs
|

Salary: Not disclosed

Senior Consultant – Compensation and Rewards

Mumbai, Maharashtra, India

4.0 - 4.0 yrs
|

Salary: Not disclosed

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

Google Play App Store
coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Bean HR Consulting

RecommendedJobs for You

Course5 Intelligence logo

Data Modeler

Course5 Intelligence

Bengaluru

Accenture logo

Data Modeler

Accenture

Noida

The Institute of Clever Stuff logo

Data Modeler

The Institute of Clever Stuff

India

Data Modeler

PwC Acceleration Center India

karnataka

Accenture in India logo

Data Modeler

Accenture in India

Noida, Uttar Pradesh, India

Data Modeler

Accenture

Noida, Uttar Pradesh

Capco logo

Data Modeler

Capco

Kolkata, Mumbai, New Delhi, Hyderabad, Pune, Chennai, Bengaluru

Bean HR Consulting logo

Data Modeler

Bean HR Consulting

Gurugram, Haryana, India

Tata Consultancy Services logo

Data Modeler

Tata Consultancy Services

Hyderabad, Telangana, India

Intelli Search logo

Data Modeler

Intelli Search

Delhi, India