Role - Data Architect / Data Modeler
Exp - 12 to 16 Yrs
Locations - Chennai, Hyderabad, Bengaluru, Delhi, Pune
Position - Permanent
Curious about the role? What your typical day would look like ?
As a Senior Data Engineer, you will work to solve some of the organizational 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 lead 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.
- Contribute to Data Modeling accelerators
- 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.
- Use the Data Modelling tool to create appropriate data models.
- Contribute to building data warehouse & data marts (on Cloud) while performing data profiling and quality analysis.
- Use version control to maintain versions of data models.
- Collaborate with Data Engineers to design and develop data extraction and integration code modules.
- Partner with the data engineers to strategize ingestion logic and consumption patterns.
Must have skills : - Strong SQL
- Strong Data Warehousing skills
- ER / Relational / Dimensional Data Modeling
- Data Vault Modeling
- OLAP, OLTP
- Schemas & Data Marts
Good to have skills :
Data VaultERwin / ER StudioCloud Platforms (AWS or Azure)(ref : hirist.tech)