We need a Python developer for a 1-week project to write a data migration script. You will be responsible for creating a Python script to parse CSV files, clean the data, and import it into a PostgreSQL database. The script must include robust error handling and logging.

We are seeking a Python developer for a very short, focused project. The task is to write a one-time script to migrate data from a legacy CSV-based system into our new PostgreSQL database. The script needs to be robust, handle potential data inconsistencies, and provide clear logging for validation purposes.

Detailed Requirements:

• The script must be written in Python 3.
• It should use standard libraries like csv for reading the source files and psycopg2 or a similar library for database connection.
• The script needs to perform basic data cleaning and transformation (e.g., date formatting, stripping whitespace, handling null values).
• Error handling is crucial. The script should log any rows that fail to import and continue processing the rest of the file.
• A summary report should be generated upon completion, detailing the number of successful imports and failures.

You will be provided with the CSV file structure, the target database schema, and access to a development database for testing. This is a perfect gig for a developer who is proficient in Python and enjoys solving small, well-defined data challenges.

• Strong proficiency in Python scripting.
• Experience with reading and parsing CSV files.
• Familiarity with connecting to and inserting data into a PostgreSQL database from Python.
• Good understanding of data types and basic data transformation techniques.

• Quick project with immediate start.
• Opportunity to work on a critical data migration task.
• Remote flexibility.
• Clear goals and deliverables.