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,
|
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.