Senior Python ETL & API Integration Engineer

We are looking for an experienced Python engineer to build and improve data integration pipelines connecting multiple business applications, databases, and external APIs. The work involves maintaining existing integrations, developing new data synchronization workflows, and resolving reliability and performance issues across production systems. Responsibilities - Develop Python-based ETL/ELT pipelines for multi-source data integration. - Build REST API connectors with authentication, pagination, rate limiting, and retry handling. - Implement incremental synchronization, change tracking, and idempotent processing. - Transform and validate data between PostgreSQL, external SaaS APIs, and cloud storage. - Diagnose failed jobs, duplicate records, schema mismatches, and synchronization delays. - Improve pipeline monitoring, error recovery, and operational reliability. - Document integration logic and deployment procedures. Required Experience - Strong Python development experience - PostgreSQL and advanced SQL - REST APIs, OAuth 2.0, and webhooks - Apache Airflow or similar workflow orchestration - Pandas and data transformation workflows - AWS services such as Lambda, S3, and RDS - Production debugging and performance optimization Project Details - Engagement: Hourly, ongoing - Workload: 20–30 hours per week - Duration: 3–6 months - Experience Level: Expert To Apply Briefly describe a production integration you developed involving multiple APIs and databases, including how you handled incremental updates, failures, and data consistency.