Odi Data Engineer

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