Senior Data Engineer: OCI & Python ETL Lead

Vericence; United States; Remote; USD 150,000 - 210,000; Full time

Job summary

Vericence is seeking a Lead Data Engineer with 8-10 years of experience to design, develop, and maintain scalable data pipelines and data integration solutions. Proficiency in Python, OCI, and PL/SQL is essential, with hands-on ETL development, data modeling, and performance optimization experience.

Responsibilities include building data ingestion, transformation, and validation processes, writing complex SQL/PLSQL, and ensuring data quality and governance across the platform while collaborating

Qualifications

• 8-10 years of experience in Data Engineering or ETL development.
• Strong programming experience in Python.
• Advanced SQL and PL/SQL development skills.
• Hands-on experience with Oracle Cloud Infrastructure (OCI).
• Experience with Oracle Database (12c/19c), Autonomous Database, and Oracle SQL Developer.
• Strong understanding of ETL/ELT concepts, data warehousing, and dimensional modeling.
• Experience with OCI Data Integration, Object Storage, Data Flow, or related OCI services.

Responsibilities

• Design, develop, and maintain scalable ETL/ELT pipelines using Python and PL/SQL.
• Develop data integration solutions on Oracle Cloud Infrastructure (OCI).
• Build and optimize data ingestion, transformation, and validation processes.
• Write complex SQL and PL/SQL packages, procedures, functions, and triggers for enterprise applications.
• Design and maintain data models to support analytics and operational reporting.
• Optimize SQL queries and database objects for high performance and scalability.
• Work with Oracle Autonomous Database, Oracle Database, and OCI Object Storage.
• Develop data workflows using OCI Data Integration and related cloud services.
• Ensure data quality, integrity, governance, and security across the data platform.
• Troubleshoot production issues, perform root cause analysis, and implement permanent fixes.
• Collaborate with business analysts, application developers, and data architects to gather and implement data requirements.
• Automate operational tasks using Python scripts and cloud-native services.
• Participate in code reviews, documentation, and deployment activities.

Skills

Python programming

SQL

PL/SQL

ETL development

Data modeling

Cloud data services

CI/CD

Debugging & analytics

Team collaboration

Education

Bachelor's degree in Computer Science or related field

Tools

OCI

Oracle Database (12c/19c)

Oracle SQL Developer

Git

CI/CD pipelines

Docker

Kubernetes

VS Code

OCI Data Integration

Object Storage

Data Flow

Job description

Vericence is seeking a Lead Data Engineer with 8-10 years of experience to design, develop, and maintain scalable data pipelines and data integration solutions. Proficiency in Python, OCI, and PL/SQL is essential, with hands-on ETL development, data modeling, and performance optimization experience.

Responsibilities include building data ingestion, transformation, and validation processes, writing complex SQL/PLSQL, and ensuring data quality and governance across the platform while collaborating