ETL Developer

Job Title: ETL Developer Python & SQL (On-Premise Data Pipeline)

Job Summary:

We are seeking a skilled ETL Developer to design, develop, and maintain on-premise data pipelines. The ideal candidate will have strong experience in Python programming and SQL, with a deep understanding of data extraction, transformation, and loading (ETL) processes. This role will focus on integrating data from multiple sources and ensuring data quality, performance, and reliability without relying on cloud platforms.

Key Responsibilities:

Design and implement scalable ETL pipelines using Python and SQL

Develop connectors/scripts to ingest data from structured and semi-structured sources

Optimize queries and data workflows for performance and reliability

Ensure data validation, quality checks, and logging across the pipeline

Collaborate with business analysts and data stakeholders to understand requirements

Maintain documentation for ETL workflows, schemas, and dependencies

Required Skills:

Proficiency in Python (with experience using libraries like Pandas, SQLAlchemy, etc.)

Strong SQL skills (preferably on platforms like PostgreSQL, MySQL, or Oracle)

Experience building ETL pipelines without cloud-based tools

Knowledge of data integration, transformation logic, and performance tuning

Familiarity with scheduling tools (e.g., cron, Airflow optional if run locally)

Good understanding of file formats like CSV, JSON, XML

Preferred Qualifications:

Experience in shell scripting and working in Linux environments

Exposure to data warehousing concepts

Knowledge of version control tools (e.g., Git)