Python/ETL Developer

<p><p><b>About the Role : <br/></b><br/>We are looking for a highly skilled and motivated Python ETL Developer to join our team on a contractual basis.

This is a fully remote role, ideal for an individual who is passionate about working with data, building scalable ETL pipelines, and integrating various data sources.

You will be responsible for building, maintaining, and optimizing ETL workflows to support business intelligence, analytics, and reporting needs.<br/><br/><b>Key Responsibilities : <br/></b><br/>- Design, develop, and maintain robust ETL processes using Python to extract, transform, and load data from diverse sources including APIs, flat files (CSV, JSON), databases, and SFTP.<br/><br/>- Use pandas and other Python libraries to transform raw data into clean, structured datasets suitable for downstream analytics.<br/><br/>- Schedule, monitor, and manage ETL workflows using Apache Airflow; troubleshoot DAG failures and optimize pipeline performance.<br/><br/>- Work closely with data engineers, analysts, and other developers to understand data needs and ensure data consistency and quality.<br/><br/>- Write clean, modular, and reusable code following best practices in software engineering.<br/><br/>- Collaborate using Git for version control and participate in code reviews and peer programming sessions.<br/><br/>- Document ETL processes, workflows, and data flow diagrams to ensure maintainability and knowledge transfer.<br/><br/>- Implement logging, error handling, and data validation to ensure reliability and traceability of ETL processes.<br/><br/><b>Required Skills & Experience : </b><br/><br/>- Bachelors or Masters degree in Computer Science, Information Systems, or a related field.<br/><br/>- 4+ years of hands-on experience in Python development, with at least 2+ years focused on building and managing ETL pipelines.<br/><br/>- Strong experience working with : <br/><br/>a.

Python libraries such as pandas, requests, json, and os.<br/><br/>b.

Data ingestion from APIs, SFTP, and web scraping.<br/><br/>c.

Data transformation and cleaning techniques.<br/><br/>- Experience using Apache Airflow for managing ETL jobs and workflows.<br/><br/>- Solid understanding of modular programming, object-oriented principles, and ability to work with abstracted/shared code.<br/><br/>- Hands-on experience with Git and collaborative software development workflows.<br/><br/>- Familiarity with SQL for querying data and basic relational database concepts.<br/><br/>- Ability to read logs, identify root causes, and troubleshoot ETL failures effectively.<br/><br/>- Strong analytical and problem-solving skills, attention to detail, and ability to work independently in a remote setting.</p><br/></p> (ref:hirist.tech)