Senior ETL Developer

Job Title : Data Engineer (ETL ODI)

">

We are seeking a seasoned Data Engineer with expertise in designing, developing and maintaining functions and stored procedures using Oracle Data Integrator (ODI).

">

• Design and implement data warehouse schemas based on business requirements.
• Develop and execute SQL scripts for table creation and collaborate with Database Administrators (DBAs) for deployment.
• Analyze various data sources to identify relationships and align them with Business Requirements Documentation (BRD).
• Design and implement Extract, Load, Transform (ELT) processes to load data from source systems into staging and target environments.
• Validate and profile data using Structured Query Language (SQL) and other analytical tools to ensure data accuracy and completeness.
• Apply best practices in data governance, including query optimization, metadata management, and data quality monitoring.
• Demonstrate strong data modeling skills to support scalable and efficient data architecture.
• Utilize Python to automate data collection from APIs, enhancing integration workflows and enabling real-time data ingestion.
• Investigate and resolve data quality issues through detailed analysis and root cause identification.
• Communicate effectively with stakeholders through strong written, verbal and analytical skills.