Backend Data Eng (SQL, Python, PostgreSQL, ETL, Java, Rest API, Spring

Mastek

Chennai

On-site

INR 900,000 - 1,300,000

Full time

5 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Mastek is seeking a Junior or Senior Backend Data Engineer to design, develop, and optimize backend services and data-driven applications. The role focuses on SQL/PostgreSQL, data integration, ETL, and REST API development, with exposure to AI-assisted development workflows.

You will work under senior guidance to build scalable database structures, data pipelines, and microservice-backed APIs using Java 17+ and Spring Boot 3.x, and explore containerization with Docker.

Qualifications

  • Strong foundation in SQL, PostgreSQL, relational database concepts, and data processing.
  • Basic knowledge of Java, Spring Boot, and REST API development.
  • Experience with PostgreSQL or other relational databases.
  • Familiarity with database tools such as pgAdmin or DBeaver.

Responsibilities

  • Design, develop, and maintain relational databases using PostgreSQL.
  • Write, execute, and optimize SQL queries (joins, subqueries, CTEs, window functions).
  • Develop and maintain database schemas, tables, views, indexes, constraints, and relationships.

Skills

SQL fundamentals
PostgreSQL
Java
Spring Boot
REST API development
Data integration
ETL
Git
Agile ceremonies
AI coding assistants

Tools

pgAdmin
DBeaver
JDBC
Hibernate
Spring Data JPA

Job description

Junior or Senior Backend Data Engineer (SQL / PostgreSQL / Data Integration)
About the Role

We are looking for a motivated Data Engineer to join our engineering team and contribute to building, maintaining, and optimizing data-driven applications and backend services.

The ideal candidate should have a strong foundation in SQL, PostgreSQL, relational database concepts, and data processing, along with basic knowledge of Java, Spring Boot, and REST API development.

This role offers an opportunity to work across database engineering, data integration, ETL processes, backend development, and cloud-native applications. Under the mentorship of senior engineers, the candidate will gain hands‑on experience in designing efficient database structures, developing data pipelines, building REST APIs, and integrating databases with backend services.

The candidate will also gain exposure to modern development practices, containerization, testing frameworks, and AI-assisted development workflows.

Key Responsibilities
  • Design, develop, and maintain relational databases, primarily using PostgreSQL.
  • Write, execute, and optimize SQL queries involving joins, subqueries, CTEs, window functions, and aggregate functions.
  • Develop and maintain database schemas, tables, views, indexes, constraints, and relationships.
  • Support data extraction, transformation, and loading (ETL) processes.
  • Perform data cleansing, validation, transformation, and quality checks to ensure data accuracy and consistency.
  • Work with large datasets and perform data manipulation, analysis, and troubleshooting.
  • Develop and maintain stored procedures, functions, and database triggers as required.
  • Identify and troubleshoot database performance issues, including slow-running queries and inefficient database operations.
  • Develop and maintain backend services and REST APIs using Java 17+ and Spring Boot 3.x under senior guidance.
  • Integrate PostgreSQL and other relational databases with Java-based applications using Spring Data JPA, Hibernate, or JDBC.
  • Understand and contribute to microservices architecture, service boundaries, API contracts, and data models.
  • Write clean, maintainable, and testable code following coding standards and SOLID principles.
  • Write and execute unit tests using JUnit and basic integration tests for backend services.
  • Participate in debugging, bug fixing, and root‑cause analysis of application and database‑related issues.
  • Support deployment and release activities, including basic Docker containerization.
  • Use logging and monitoring tools to identify application and database performance issues.
  • Use AI‑assisted development tools such as GitHub Copilot, ChatGPT, and Claude to improve productivity, troubleshoot issues, and support development while reviewing and validating AI‑generated outputs.
  • Use Git for version control and participate in code reviews and collaborative development workflows.
  • Participate in Agile ceremonies, including daily stand‑ups, sprint planning, and retrospectives.
  • Continuously learn and adopt modern data engineering, database, and backend development practices.
Required Qualifications
  • 25 years of relevant experience in data engineering, SQL development, database management, backend development, or related technical projects.
  • Strong understanding of SQL fundamentals, including SELECT, INSERT, UPDATE, DELETE, JOINs, subqueries, CTEs, and aggregate functions.
  • Hands‑on experience with PostgreSQL or other relational database management systems.
  • Good understanding of relational database concepts, including primary keys, foreign keys, constraints, indexes, and relationships.
  • Knowledge of database design, normalization, schema design, and data modelling concepts.
  • Understanding of ETL processes and basic data integration concepts.
  • Ability to perform data validation, cleansing, transformation, and troubleshooting.
  • Basic understanding of database performance optimization and query execution plans.
  • Familiarity with database tools such as pgAdmin, DBeaver, or similar platforms.
  • Understanding of database transactions, ACID properties, and data integrity.
  • Solid understanding of Java fundamentals, including OOP principles, collections, exception handling, and basic multithreading concepts.
  • Basic hands‑on experience with Spring Boot, including REST endpoints, dependency injection, and application configuration.
  • Basic understanding of RESTful API design and microservices concepts.
  • Familiarity with JPA/Hibernate or JDBC for database connectivity and data access.
  • Familiarity with Git for version control, including branching, commits, and pull requests.
  • Basic understanding of Docker and containerization concepts.
  • Basic hands‑on familiarity with AI coding assistants such as GitHub Copilot, ChatGPT, or Claude, with the ability to review and validate AI‑generated code and queries.
  • Strong analytical thinking, problem‑solving abilities, and attention to detail.
  • Good communication skills and ability to collaborate within a team.
Preferred Qualifications
  • Academic, internship, or bootcamp project experience involving SQL, PostgreSQL, Java, Spring Boot, or data engineering.
  • Exposure to Python libraries such as Pandas and NumPy for data manipulation and processing.
  • Familiarity with advanced PostgreSQL features, including JSON/JSONB, stored procedures, functions, and query optimization.
  • Exposure to database migration tools such as Flyway or Liquibase.
  • Basic knowledge of data pipeline development and ETL tools.
  • Familiarity with data warehousing concepts, dimensional modelling, and OLTP/OLAP systems.
  • Basic understanding of cloud database services such as AWS RDS, Azure SQL Database, or Google Cloud SQL.
  • Exposure to Spring Security concepts, including authentication and authorization.
  • Familiarity with testing frameworks such as JUnit and Mockito.
  • Basic understanding of messaging systems such as Apache Kafka or RabbitMQ.
  • Familiarity with Docker, CI/CD pipelines, and basic cloud deployment concepts.
  • Exposure to logging and monitoring tools for application observability.
  • Knowledge of data visualization and reporting tools such as Power BI or Tableau.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Junior Back-end engineer
Junior Back-end engineer

Annova Solutions Corp. • Indore District

On-site
INR 600,000 - 1,000,000
Java Backend Developer (Java17/Microservices/ Spring/CICD/AWS)
Java Backend Developer (Java17/Microservices/ Spring/CICD/AWS)

Mastek • Chennai

On-site
INR 900,000 - 1,300,000
Backend Engineer (Java / Spring Boot)
Backend Engineer (Java / Spring Boot)

Kloudspot • Bengaluru Urban

On-site
INR 600,000 - 900,000
Senior Backend Java Developer - Immediate Joiner
Senior Backend Java Developer - Immediate Joiner

Luxoft India • Dadri

On-site
INR 1,500,000 - 3,500,000
Senior Backend Engineer
Senior Backend Engineer

Good co India • India

Remote
INR 1,200,000 - 2,400,000
Senior Backend Java Developer
Senior Backend Java Developer

DXC Luxoft • Dadri

On-site
INR 2,500,000 - 5,000,000
Senior Backend Java Developer
Senior Backend Java Developer

DXC Luxoft • Gurugram District

On-site
INR 3,500,000 - 6,500,000
Software Engineer II_(Java Backend)
Software Engineer II_(Java Backend)

Precisely • India

On-site
INR 600,000 - 1,200,000
Senior Java Software Engineer
Senior Java Software Engineer

Ajackus • India

On-site
INR 1,500,000 - 2,000,000
Senior backend Java developer - CLM
Senior backend Java developer - CLM

Luxoft • Gurugram District

On-site
INR 2,600,000 - 4,200,000