ETL / Data Integration Developer

ETL / Data Integration Developer

Key Responsibilities

• Design, develop, maintain, and optimize ETL processes and data flows between systems and databases
• Write and execute advanced SQL queries, including complex joins, subqueries, aggregations, and data transformations
• Build data mapping, cleansing, validation, and enrichment processes across multiple data sources
• Develop and manage Apache NiFi flows for data ingestion, processing, and routing
• Integrate data between systems using Oracle, ClickHouse, and external data sources
• Work closely with system analysts, QA, front-end teams, and business stakeholders
• Troubleshoot issues, improve performance, and support ongoing data processes, including periodic on-call rotations

Mandatory Requirements

• At least 1 year of experience in ETL development or Data Integration processes - Must
• Solid experience working with Linux environments and CLI - Must
• Strong SQL skills, including complex joins, subqueries, aggregations, and transformations - Must
• Hands-on experience with Apache NiFi and data flow development - Must
• Experience working with ClickHouse
• Experience with relational databases, with strong preference for Oracle - Must
• Experience with Data Integration platforms, MFT systems, or large-scale data transfer processes - Must
• Proficiency in PL/SQL, including stored procedures, functions, triggers, and complex queries - Must
• Experience in SQL query and data pipeline performance optimization - Must