Text Copied!

Senior Data Engineer-Data Modeling

Senior Data Engineer-Data Modeling
55
Applications
Text Copied!
About the Job
Skills
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
Industry
Management Consulting
Company Size
201-500 Employees
Headquarter
Chennai, Tamilnadu
Other open jobs from Covenant Consultants
Data Scientist
Covenant Consultants
+2 More Skills
Posted on November 16 2024
Data Scientist
Covenant Consultants
+4 More Skills
Posted on November 16 2024
Data Engineer
Covenant Consultants
+2 More Skills
Posted on November 09 2024
Data Management and BI role for Top US Bank
Covenant Consultants
+4 More Skills
Posted on November 07 2024
GCP Data Engineer
Covenant Consultants
+2 More Skills
Posted on December 04 2024
Powered By
