Data Engineer(Oracle+Informatica)

Bounteous; Bengaluru; Hybrid; INR 2,500,000 - 3,800,000; Full time

Job summary

Bounteous in Bengaluru (EGL) is seeking an experienced Oracle SQL/PLSQL Developer with 5–8 years of hands-on data engineering, ETL/ELT, and AWS-based Oracle environments to design, develop, and optimize enterprise data solutions.

You will build and tune SQL/PLSQL code, implement CI/CD with DevOps, and ensure data quality through testing and validation, collaborating with analytics and engineering teams.

Qualifications

• Strong experience in Oracle SQL and PL/SQL development.
• Expertise in Data Modelling, Database Design, and Data Architecture.
• Hands-on performance tuning of SQL queries, procedures, and objects.
• Experience with ETL/ELT development using Informatica.
• Ability to implement automated testing and data quality validation.
• Familiarity with CI/CD pipelines and DevOps practices.
• Hands-on experience with Oracle databases on AWS.
• Experience with job scheduling/workflow tools like Autosys or Airflow.

Responsibilities

• Develop and maintain complex SQL/PLSQL programs, packages, procedures, and functions.
• Design and optimize data models for transactional and analytical systems.
• Build and support ETL/ELT workflows using Informatica.
• Tune database performance and optimize queries.
• Implement automated testing and data quality validation processes.
• Collaborate with DevOps to establish CI/CD pipelines.
• Support Oracle workloads hosted on AWS and manage batch jobs with Autosys/Airflow.

Skills

Oracle SQL development

PL/SQL development

Data Modelling

Performance Tuning

ETL/ELT development

Test Automation

CI/CD pipelines

AWS Oracle environment

Tools

Informatica

Autosys

Apache Airflow

Git

Job description

Oracle SQL/PLSQL Developer - ETL & Data Engineering

Location: Bengaluru (EGL)
Experience: 5-8 Years
Employment Type: Full-Time

Job Description

We are looking for an experienced Oracle SQL/PLSQL Developer with strong expertise in Data Engineering, ETL/ELT, Performance Tuning, and Test Automation. The ideal candidate should have hands-on experience in designing, developing, optimizing, and supporting enterprise data solutions in an AWS-based Oracle environment.

Must-Have Skills

• Strong experience in Oracle SQL and PL/SQL development
• Expertise in Data Modelling, Database Design, and Data Architecture
• Hands-on experience in Performance Tuning of SQL queries, stored procedures, and database objects
• Strong understanding of OLTP and Data Warehousing concepts
• Experience in ETL/ELT development using Informatica
• Strong experience in Test Automation, Quality Engineering, and Data Validation practices
• Experience with CI/CD pipelines and DevOps practices
• Hands-on experience working with Oracle databases on AWS
• Experience with job scheduling and workflow orchestration tools such as Autosys or Apache Airflow
• Strong troubleshooting, analytical, and problem-solving skills
• Excellent verbal and written communication skills

Good to Have

• Exposure to cloud-native data platforms and automation frameworks
• Experience with version control tools such as Git
• Knowledge of Agile/Scrum methodologies

Key Responsibilities

• Develop and maintain complex SQL and PL/SQL programs, packages, procedures, and functions
• Design and optimize data models for transactional and analytical systems
• Build, enhance, and support ETL/ELT workflows using Informatica
• Perform database performance tuning and query optimization
• Implement automated testing and data quality validation processes
• Collaborate with DevOps teams to establish and maintain CI/CD pipelines
• Support and maintain Oracle workloads hosted on AWS
• Monitor and manage batch jobs using Autosys/Airflow
• Work closely with business and technical stakeholders to deliver high-quality solutions