Senior Python Developer

Job Title: Python Developer

Location: Remote

Job Type: Full Time

We are looking for individuals experienced in developing ETL tools from scratch. The in-house ETL tool is based coded in Python and you'll create will offer the same functionalities as popular market tools such as Informatica, Oracle Data Integrator, and dbt. Your role is crucial in designing, building, testing and maintaining this efficient ETL tool to support our data warehouse needs.

Key Responsibilities:

1. ETL Tool Development:

Design, develop, and maintain a custom ETL tool in Python using Snowflake as the data warehouse platform.

Implement efficient data loading and transformation.

Ensure data integrity and consistency throughout the ETL workflow.

2. Control-M Job Scheduling:

Create and manage Control-M job schedules for automated ETL processes.

Monitor and troubleshoot job execution, ensuring reliability and on-time delivery.

Implement error handling and recovery strategies.

3. Python Scripting:

Develop Python scripts to enhance ETL tool for automate tasks.

Use Python for data validation, cleansing, and transformation as part of ETL workflows.

4. Documentation:

Document ETL processes, workflows, and job schedules for reference and compliance purposes.

Create and maintain comprehensive documentation of data lineage and transformations.

Qualifications:

Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent experience).

Extensive experience in ETL tool development with a focus on Snowflake.

Proficiency in Control-M for job scheduling and automation.

Strong programming skills in Python for scripting and data manipulation.

Solid SQL and data warehousing knowledge.

Ability to identify and optimize performance bottlenecks.

Excellent problem-solving skills and meticulous attention to detail.

Effective communication and collaboration skills.

Note:

This role is not for ETL logic development using existing tools but specifically for the creation of a custom ETL tool from scratch. If you have the expertise and experience to design and build ETL tools, we encourage you to apply.