Lead Data Engineer

Job Description

We are seeking an experienced Data Engineer/Lead Data Engineer/Data Engineering Specialist for Oracle + GCP to design, build, and optimize scalable, high-performance data platforms. The ideal candidate will have strong expertise in ETL/ELT frameworks, OIC, and Google Cloud Platform (GCP), and will work closely with business and technical teams to deliver reliable, secure, and analytics-ready data solutions.

A typical day for a Data Engineer involves a mix of technical and collaborative tasks.

The main responsibilities include:

• Integration Development: Designing and building integrations using OIC's visual interface. This involves configuring connections, defining data mappings, and orchestrating complex business processes.
• API Management: Creating, managing, and optimizing APIs (Application Programming Interfaces) to facilitate secure and reliable data exchange.
• Troubleshooting and Support: Monitoring integration performance, identifying and resolving technical issues, and providing ongoing support for deployed integrations to ensure data integrity.
• Collaboration: Working with business analysts and architects to gather requirements, translating them into technical specifications, and collaborating with cross-functional teams to deliver effective solutions.
• Documentation: Maintaining comprehensive documentation of all integration designs, processes, and workflows for future reference and maintenance.
• Best Practices: Adhering to industry standards and best practices for integration development and security.
• Implement data validation, data cleansing, and data quality controls to ensure accurate and reliable datasets.

Qualifications

Technical Skills:

• Proven experience with OIC: Hands-on experience developing integrations is essential.
• Strong Data Modeling skills (conceptual, logical, physical)
• Proficiency in SQL and Python
• Experience with Google BigQuery (GBQ) or Oracle 23ai
• Experience with Apache Airflow / GCP Cloud Composer / OCP Scheduler
• Database skills: Familiarity with SQL and PL/SQL.
• Deployment and testing: Experience with the full software development lifecycle, including testing and deployment processes.

Qualifications and Soft Skills:

• 10-13 years of experience is required.
• Proficiency in Oracle Database (SQL, PL/SQL) and related tools (e.g., SQL Developer).
• Strong knowledge of at least one of the Oracle ERP module, i.e. Financials, Procurement, Inventory, Order Management.
• Knowledge of cloud technologies and Oracle Cloud Infrastructure (OCI) or Oracle Goldengate is a plus.
• Strong analytical and problem-solving skills to address complex business and technical challenges.
• Excellent communication and interpersonal skills to collaborate with cross-functional teams and stakeholders.
• Ability to work independently and manage multiple priorities in a fast-paced environment.
• Detail-oriented with a focus on delivering high-quality, error-free solutions.
• Problem-Solving: Strong analytical and problem-solving abilities, with a proactive approach to addressing challenges.
• Cultural Awareness: Ability to work effectively in a multicultural environment and manage teams across different time zones.

Preferred Qualifications:

• Oracle certifications, i.e. Oracle Certified Professional (OCP)
• Knowledge of DevOps practices, including version control (e.g., Git), CI/CD pipelines, and automated testing.
• Familiarity with Agile or Scrum project management methodologies.
• Familiarity with OpenAI prompt engineering and Machine Learning / LLM concepts
• Knowledge of DBT