Data Modeler / GC or USC only / 10+ years only

Data Modeler / GC or USC only / 10+ years only

Location: Remote – some light travel possible (quarterly)

Position: Data Modeler – 2 main areas of work (current state and target state)

Terms: 6m+ – (USC/GC)

Team: Enterprise Applications Architecture

Interview Process: 2 interviews – screen with Mike.  Then a panel.

 

Need copies of photo Id and 2 references

 

Current Project: Current state reverse engineering model systems

 

Current state reverse engineering model systems

Future state they are building new databases.  Moving to microservices

architecture and need to take the business requirements to design the databases for relational databases and data warehouses.

 

Technical Skills:

 

Currently using Toad, but they just need experience with a modeling tool

Spreadsheets for data dictionaries

Take the tables and drag them around into a model that makes sense

 

Hands-on writing queries digging into the database

 

SQL

NoSQL

Oracle

Data warehousing

Great communicators – they will need to define requirements with the business and technical teams

Eventually want to standup a data repository

Multiple modeling tools and hands-on experience most important

 

Questions from hiring manager:

 

    • What data modeling tools have you used?  Describe the databases you have designed.  Were they relational databases?  Have they reverse engineered data models from a database?  What were some of the challenges?
    • Describe your experience writing SQL queries.    Can you write a complex SELECT statement?  Have they generated DDL from a data model to create a database?

 

 

Best Regards,

 

Ravi Chand

Recruiting Consultant

 

mobilePhone

972-392-5974 | 972-934-5200(103)

emailAddress

[email protected],

address

5208 Windsor Ln, Copper Canyon, Texas, 75077

linkedin

Disclaimer: We respect your online privacy. This e-mail message, including any attachments, is for the sole use of the intended recipient/recipients and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. If you have received this mail in error or prefer not to receive such emails in the future or To Unsubscribe please reply to [email protected] We are sorry for the inconvenience.

 

0 0 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Most Voted
Newest Oldest
Inline Feedbacks
View all comments