DATA LABS >> Data Modeler – Erwin Database

ProBiz Advisor
  • Post Date: July 12, 2019
  • Apply Before: March 30, 2020
  • Applications 0
  • Views 57
Job Overview

Roles and responsibilities 


Qualifications : 


- Significant proven experience in applying rigorous data management principles and industry standard development approach to model complex and high-volume data assets to build, maintain conceptual, logical, and physical data models 


- Demonstrable experience using data modeling tools - e.g., ErWin 


- Evaluate existing data models and physical databases for variances and discrepancies 


- Experience with managing meta data for data models 


- Experience with large-scale, Hadoop big data methods, such as Spark, Scala, NiFi, 


- Demonstrable experience in developing, publishing, and maintaining all documentation for data models 


- Work with Business Analysts, Data Architects, Software developers, DBAs to achieve project objectives - delivery dates, cost objectives, quality objectives, business customer satisfaction objectives, etc. 


- Create entity-relationship diagrams for relational systems and dimensional diagrams for the existing and proposed Data Warehouse, Data Marts and data cubes 


- Define ownership, obtain approvals, and communicate data models to Technology teams. Ensure consistent enterprise view and usage of data assets across the global functions and standards 


- Provide architectural expertise in Data warehouse construction and engineering, data source identification, engineering and migration on latest DB technologies - MemSQL, Sybase IQ, NoSQL 


- Provide feedback to Business Intelligence project and management team in order to improve data acquisition (structured and unstructured), warehousing methodologies and tools 


- Experience in Agile development processes 


- Ability to independently learn new technologies and data related approaches 


- Effective writing and presentation skills 


Job Profile : Technical Skills 


- Data Modeling concepts (Advanced Level) 


- ErWin, DB/MS SQLServer, MemSQL, NoSQL experience is must. 


- Modeling experience across large volume based (Tb/Petabytes) environments 


- Over-All understanding of Database space (Databases, Data Warehouses, Reporting, Analytics) 


- Open to learn new technologies in-line with organizational needs / direction 


- Experience with the technologies in the Hadoop ecosystem like Hadoop, HDFS, Spark, and Hive. Additional skillset of MapReduce and Pig is plus 


- Well versed with Data Modeling platforms like Erwin, ER STUDIO etc. 


- Strong skills in Entity Relationship Modeling (ERWin modeling software preferred) 


- Good knowledge about Database Designing / Administration, Advanced Data Modeling for Star Schema design 


- Good understanding of Normalized / Denormalized / Star / Snowflake design concepts 


- SQL query development for investigation and analysis 


- Experience with Data Profiling Tools and BI tools like MicroStrategy will be plus 


Salary : At Par with Industry 


Must-Have Skills : ERWIN, Database



Contact No:

022 6060 6144

Job Detail
  • Offerd Salary₹20,000 - ₹30,000
  • Career LevelOfficer
  • Experience3 Years
  • GenderMale / Female
  • INDUSTRYDevelopment
  • QualificationCertificate
Shortlist Never pay anyone for job application test or interview.