Motion Recruitment is looking for a developer for a two-week project to create a robust database seeding solution for our development and testing environments. The task involves writing scripts (in a language of your choice, like Node.js or Python) to populate a PostgreSQL database with realistic and consistent test data. This project is ideal for a junior developer with some backend and database experience who is detail-oriented and can work independently to create a reliable seeding mechanism for our team.

To improve our testing and development processes, we need a standardized way to seed our PostgreSQL database with mock data. This project involves creating scripts that will populate our database schema with thousands of records across multiple tables with relationships.

Project Requirements:

• The seeding scripts should be written in either Node.js (with a library like node-postgres or an ORM) or Python (with a library like psycopg2 or an ORM).
• You will be provided with the complete database schema (SQL file).
• The scripts must generate realistic-looking mock data for various fields (e.g., names, addresses, emails) using a library like Faker.js or Faker.
• The seeder must correctly handle table relationships, ensuring foreign key constraints are met (e.g., creating a user before creating their orders).
• The final solution should be idempotent, meaning it can be run multiple times without creating duplicate data or causing errors. It should clear old data before inserting new data.
• The deliverable is a set of well-organized scripts that can be executed with a single command.

This is a foundational project that will have a big impact on our development team's efficiency. You will be expected to ask clarifying questions about the data models but otherwise drive the project to completion independently over the two-week period.

• Basic experience with either Node.js or Python for scripting.
• Understanding of SQL and relational database concepts (tables, relationships, foreign keys).
• Experience interacting with a PostgreSQL database from a scripting language.
• Familiarity with using data generation libraries (e.g., Faker) is a plus.
• Attention to detail and ability to work with a defined schema.

• Gain practical experience with database management and scripting.
• Work on a project that directly improves a development team's workflow.
• Choose your preferred scripting language (Node.js or Python).
• Flexible, remote, hourly work.