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.