Job Description
Job Description – Data Engineer
nExperience: 5–7 Years
nRole: Sr. Data Engineer
nDepartment: Data Engineering / Product Engineering
nRole Overview
nWe are looking for an experienced Data Engineer with 5–7 years of hands-on experience in ETL/ELT, database engineering, Big Data processing, and complex bi-directional data integrations. The candidate should have strong SQL and database expertise, experience working with large datasets, and the ability to design, develop, optimize, and support reliable data pipelines in production environments.
nKey Responsibilities
n
- n
- Design, develop, and maintain scalable ETL/ELT pipelines for batch and near-real-time data processing.n
- Build data integrations using REST APIs, SFTP, files, webhooks, and database-to-database interfaces.n
- Develop and support bi-directional data integrations between applications, databases, and external enterprise systems.n
- Implement data synchronization, incremental processing, reconciliation, error handling, retries, and duplicate/missing-data prevention.n




- Develop complex SQL queries, stored procedures, functions, views, and data transformations.n
- Work extensively with PostgreSQL and SQL Server; exposure to MongoDB is preferred.n
- Perform database and query performance tuning, including execution-plan analysis, indexing, joins, partitioning, locking/blocking, and long-running query optimization.n
- Work with large datasets and distributed processing frameworks; optimize data processing for scalability and performance.n
- Implement data validation, quality checks, logging, auditing, and monitoring for critical pipelines.n
- Troubleshoot production ETL, database, integration, and data-quality issues and perform root-cause analysis.n
- Collaborate with application, product, DBA, DevOps, and client teams to resolve end-to-end data issues.n

nRequired Technical Skills
nMust Have:
n
- n
- 5–7 years of Data Engineering / ETL experiencen
- Solid SQL and Py

📌 Sr Data Engineer (Noida)
🏢 Smart Energy Water
📍 Noida