iLink Digital logo

Data Engineer (ETL ODI) - AMS

iLink Digital

5 - 10 years

Bengaluru

Posted:1 day ago

Job Description

We are seeking a skilled and experienced Data Integration Specialist with over 5 years of experience in designing and developing data solutions using Oracle Data Integrator (ODI). The ideal candidate will have strong expertise in data modeling, ETL/ELT processes, and SQL, along with exposure to Python scripting for API-based data ingestion.
Key Responsibilities:
  • Design, develop, and maintain functions and stored procedures using Oracle Data Integrator (ODI).
  • Create and document data warehouse schemas, including fact and dimension tables, 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.
  • Exhibit excellent problem-solving and research capabilities in a fast-paced, data-driven environment.

Skills Required

Analytical Analytical skills Data warehousing Ams Modeling Business Requirements Integration Data architecture

Learn the skills this job asks for

See your skill gap for Data Engineer →

Free courses, interview questions and practice for each skill.

Work Mode

Work from Office

Job Type

Full Time

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
iLink Digital logo
iLink Digital

RecommendedJobs for You

iLink Digital logo

Bengaluru

iLink Digital logo

Bengaluru