Job Description
About Vericence
Vericence is a digital engineering and technology consulting firm helping enterprises build AI-driven platforms, modernize legacy systems, and scale innovation through cloud, data, and intelligent engineering. We partner with global organizations to deliver high-impact technology solutions and build world-class engineering teams.
Job Summary
We are looking for a skilled Lead Data Engineer with 8-10 years of experience in designing, developing, and maintaining scalable data pipelines and data integration solutions. The ideal candidate should have strong expertise in Python, Oracle Cloud Infrastructure (OCI), and PL/SQL, along with hands-on experience in ETL development, data modeling, and database performance optimization. Experience working with cloud-native data services and large-scale enterprise data platforms is highly preferred.
Key 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.
Required Skills
- 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.
- Knowledge of REST APIs, JSON, XML, and file-based integrations.
- Experience with Git and CI/CD pipelines.
- Strong debugging, analytical, and performance tuning skills.
Preferred Skills
- Experience with Apache Airflow or other workflow orchestration tools.
- Familiarity with Spark or distributed data processing frameworks.
- Experience with Docker and Kubernetes.
- Knowledge of Linux shell scripting.
- Exposure to Oracle Analytics Cloud (OAC), Oracle Integration Cloud (OIC), or Oracle GoldenGate.
- Understanding of data governance and security best practices.
Qualifications
- Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
- Oracle Cloud certifications (OCI Foundations, OCI Data Management, or Oracle Database certifications) are a plus.
Preferred Technologies
- Programming: Python, PL/SQL, SQL
- Cloud: Oracle Cloud Infrastructure (OCI)
- Database: Oracle Database, Autonomous Database
- Data Services: OCI Data Integration, Object Storage, Data Flow
- Version Control: Git
- Operating System: Linux
Tools: Oracle SQL Developer, VS Code, Postman
More Info
Key Skills
About Company
