company logo

Senior Data Engineer-Data Modeling

Chennai
Bangalore Urban
Hyderabad
Pune Division
Delhi
Gurgaon
Full-Time
Senior: 6 to 10 years
Posted on Nov 07 2024

Text Copied!

Share
Report
Website

About the Job

Skills

Entity-Relationship Diagrams
Database Design
Data Warehousing
Data Architecture
SQL
OLAP
OLTP

Curious about the role? What your typical day would look like?


As a Senior Data Engineer, you will work to solve some of the most complex and captivating data management problems that

would enable them as a data-driven organization; Seamlessly switch between roles of an Individual Contributor, team member,

and Data Modeling Architect as demanded by each project to define, design, and deliver actionable insights.


On a typical day, you might


● Engage the clients & understand the business requirements to translate those into data

models.

● Create and maintain a Logical Data Model (LDM) and Physical Data Model (PDM) by applying

best practices to provide business insights.

● Create and maintain the Source to Target Data Mapping document that includes

documentation of all entities, attributes, data relationships, primary and foreign key

structures, allowed values, codes, business rules, glossary terms, etc.

● Gather and publish Data Dictionaries

● Involve in maintaining data models as well as capturing data models from existing

databases and recording descriptive information.

● Build data warehouse & data marts (on Cloud) while performing data profiling and quality

analysis.

● Use version control to maintain versions of data models.

● Design and develop data extraction and integration code modules.

● Partner with the data engineers to strategize ingestion logic, and consumption patterns.


EXPERTISE AND QUALIFICATIONS


What do we expect?

● 6+ years of experience in Data space.

● Significant experience in one or more RDBMS (Oracle, DB2, and SQL Server)

● Real-time experience working in OLAP & OLTP database models (Dimensional models).

● Comprehensive understanding of Star schema, Snowflake schema, and Data Vault Modelling.

Also, on any ETL tool, Data Governance, and Data quality.

● Eye to analyze data & comfortable with following agile methodology.

● Adept understanding of any of the cloud services is preferred (Azure, AWS & GCP)

About the company

Covenant is a premier Executive Search and Recruitment Firm with 350+ Full-Time Recruitment Specialists with a proven track record of strong delivery across the globe. We are specialists in the arena of Human Capital unmatched in all metrics Head Hunting, Turnaround Time, Unceasing Availability, Cost-Effectiveness, Steadfast Quality of Service - provided by a team of Principal Consultants and Ana ...Show More

Industry

Management Consulting

Company Size

201-500 Employees

Headquarter

Chennai, Tamilnadu

Other open jobs from Covenant Consultants

Data Scientist

Covenant Consultants

LLM
NLP
Gen AI
SQL

+2 More Skills

Chennai
Full-Time
Hybrid
Senior: 6.5 to 9.5 years

Posted on November 16 2024

Data Scientist

Covenant Consultants

Natural Language Processing (NLP)
GenerativeAi
LLM
Statistical Analysis

+4 More Skills

Job Description
As Sr. Engineer Consultant - AI Science you will design, develop and optimize Artificial Intelligence, SLM/LLM solutions to diverse real-world problems and implement cutting-edge generative artificial intelligence models and systems. This role includes a combination of implementing new algorithms, SLM/LLMs, performance/accuracy tuning and analysis, defining APIs, and analyzing functionality coverage to build larger, coherent toolsets and libr

Chennai
Full-Time
Senior: 7 to 10 years
₹ 15L - ₹ 29L (Per Year)

Posted on November 16 2024

Data Engineer

Covenant Consultants

Azure Databricks
Databricks
Pyspark
SQL

+2 More Skills

Company Overview
Hiring for a global analytics services and solutions company. We are one of the fastest growing private companies in the country for three straight years according to the Inc. 5000 and we continue to set ourselves apart from our competitors by attracting the greatest talent in the data analytics and data science space. Our capabilities range from Data Visualization, Data Management to Advanced analytics, Big Data and Machine Learning. Our uniqueness is

Chennai
Full-Time
Senior: 3 to 14 years

Posted on November 09 2024

Data Management and BI role for Top US Bank

Covenant Consultants

Business Intelligence Tools
Data Visualization
Data Governance
Data Analysis

+4 More Skills

Hi Folks!!
We are hiring for Big US Based Bank

Chennai
Full-Time
Senior: 8 to 12 years

Posted on November 07 2024

GCP Data Engineer

Covenant Consultants

Google Cloud Platform (GCP)
Hadoop
scala
GCP Engineer

+2 More Skills

Company Overview
Covenant Consultants is a leading Executive Search and Recruitment Firm with vast expertise across diverse industry practices. With over 350 full-time specialists, the firm is renowned for headhunting excellence, swift turnaround, cost-effectiveness, and unwavering service quality. Headquartered in Chennai, Tamilnadu, Covenant Consultants is dedicated to fostering long-term partnerships founded on trust, integrity, and a commitment to excellence.

Chennai
Full-Time
Hybrid
Senior: 7 to 10 years

Posted on December 04 2024

Powered By

Expertia Logo