Company:
Verdant Infotech Solutions
Location: Copper Canyon
Closing Date: 22/10/2024
Hours: Full Time
Type: Permanent
Job Requirements / Description
Data Modeler
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?
|
,
5208 Windsor Ln, Copper Canyon, Texas, 75077
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?
|
,
5208 Windsor Ln, Copper Canyon, Texas, 75077
Share this job
Useful Links