Senior Data Engineer to build and maintain ETL pipelines using Python, Shell scripting, and PL/SQL

Our public sector client is seeking a Senior Data Engineer to build and maintain ETL pipelines using Python, Shell scripting, and PL/SQL.

Design, develop, and maintain ETL solutions for integrating complex data sources into Oracle databases and data warehouses. Work with Python, Shell scripting, SQL, and PL/SQL in a Linux/Unix environment.

Contract is from June 1st - March 31st 2027. 35 hours/week. Thursdays onsite. Interviews to occur Thursday and Friday 7/8th May.

Must Haves

• PL/SQL for packages, procedures, and functions
• Python for ETL script development and automation
• Shell scripting in Linux and Unix environments
• SQL for query optimization and ETL workflows
• Experience designing and maintaining ETL pipelines

Nice to Have

• Experience with Oracle databases and data warehouses
• Background collaborating with business analysts and stakeholders
• Knowledge of organizational data security and governance standards

Responsibilities

• Design, develop, and maintain ETL pipelines for Oracle systems
• Build Python-based ETL scripts for data ingestion, validation, and automation
• Create and optimize PL/SQL packages, procedures, and triggers
• Utilize Shell scripting for system-level automation and rapid prototyping
• Perform data profiling, cleansing, and validation
• Optimize SQL queries and ETL workflows for scalability and reliability
• Implement logging, monitoring, and error-handling mechanisms