Lead Data Engineer

• 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.

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.