ODI Data Engineer

Taguig, National Capital Region

Posted 3 days ago

Company:: Lewis Glanz Consulting
Company Description:: Lewis Glanz Consulting was founded in the year 2010 in the United Kingdom by Oliver Lewis. In the year 2015, LGC expanded its market and began establishing in the Philippines. Starting from two employees, we are now over 80 employees strong, and we are still continuing to grow. Over the years, LGC ensures that we give the best services both to our clients and candidates, and up until now, we continue to give this service to every individual that we engage with.
Contract Type:: Full Time
Experience Required:: 5 to 10 years
Education Level:: Bachelor’s Degree
Gender:: Any
Number of vacancies:: 1

Job Description

Job Responsibilities
• Analyze requirements and perform technical feasibility study/analysis
• Develop integrations in ETL+SQL+Java between source RDBMS and DWH
• Be the point of contact for any production issue or for any technical advice
• Work closely with Ops engineer for interface deployments, PROD Data Analysis, UAT debugging
• Learn new tools and implement them on the interface like Azure DevOps, GIT, Ansible code snippets etc.
• Assist and develop the Deployment Automation Strategies
• Carry out Unit Test and System Integration Testing
• Prepare Regulatory Reports by understanding the asks
• Support audits with documentation/Proofs/run through the code base
• Develop high performance solutions with best practices on tools used
• Complete full test cycle before implementation
• Use CI/CD pipeline to implement the solution
• Communicate with the stakeholders to analyze and understand the need and design the solution accordingly
• Use advanced SQL query language to support stakeholder for Audits / Regulatory request
• Support other squad members whenever needed with your experience and knowledge

Qualifications:
• Must have at least 5 years of experience in data engineering or ETL development using ODI (Oracle Data Integrator) - Profiles with 1-2 years of extensive experience in ODI may be considered
• Must have experience on integrating data using Oracle data integrator (ODI)
• Thorough understanding of data warehousing, data modelling techniques and entity relationship diagram
• Experience on Oracle RDBMS, tables, views, indexing, tuning and data types
• Experience on Oracle SQL Developer or other SQL client tools
• Data Analysis and cleansing techniques
• Advanced skills of SQL (analytical functions etc.) and PLSQL
• Experience on data transformation techniques
• Capable of solving complex problems