Deputy Manager

Niva Bupa Health Insurance; Gurugram District; On-site; INR 800,000 - 1,200,000; Full time

Job summary

Niva Bupa Health Insurance seeks a Data Engineer to design, develop and optimize ETL/ELT pipelines using Talend Open Studio or Talend Data Integration. You will handle end-to-end data flows and collaborate with analysts and stakeholders in Gurugram.

Responsibilities include data management across sources, data quality assurance, performance tuning and production support for Talend jobs. Strong PL/SQL and warehousing knowledge preferred.

Qualifications

• Talend certification in Data Integration (e.g., Talend Data Integration v7 Certified Developer).
• Bachelor's degree in Computer Science, IT or related field.
• 3–5 years of hands-on experience with Talend Data Integration for ETL/ELT.
• Advanced PL/SQL and database tuning experience (Oracle, SQL Server, PostgreSQL, MySQL).
• Experience with data warehousing concepts and dimensional modeling.
• Strong problem solving, debugging and communication skills.

Responsibilities

• Design, develop and optimize ETL/ELT pipelines using Talend Open Studio or Talend Data Integration.
• Manage data extraction, transformation and loading from diverse sources (SQL, Oracle, flat files, APIs, cloud).
• Transform structured and unstructured data into logical models.
• Ensure data quality, integrity and performance during large-scale integrations.
• Tune Talend jobs for performance and scalability; monitor and troubleshoot.
• Document data mappings, workflows and transformation logic; maintain governance compliance.
• Provide production support for Talend jobs and workflows; implement error handling.

Skills

Talend

SQL

Data warehousing

PL/SQL

Troubleshooting

Education

Bachelor's degree in Computer Science/IT or related field

Tools

Talend Open Studio

Talend Data Integration

Oracle

SQL Server

Job description

• Design, develop and optimized ETL/ELT pipelines: - Utilized Talend to create efficient data work flow that caters to organizational needs end-to-end ETL processes using Talend Open Studio or Talend Data Integration tools.
• Data Management: - Implement data Extraction, transformation, and loading process from a wide variety of source systems (e.g., SQL,oracle, flat files, APIs, cloud services).
• Should be able to transform structure /unstructured data into logical model
• Data Quality Assurance: - Ensure data accuracy, integrity and performance during large scale integrations
• Ensure data integrity, quality, and compliance with governance standards.
• Performance Tuning: - Optimize Talend jobs for performance and scalability.
• Monitor and troubleshoot existing ETL jobs and resolve issues in a timely manner.
• Implement best practices for data quality, logging, and error handling.
• Handle production support and debugging of Talend jobs and workflows.
• Collaboration: Collaborate with business analysts, other data engineers, and stakeholders to gather requirements and deliver high-quality data solutions.
• Maintain detailed documentation for all ETL processes and data flows.
• Document data mappings, workflows, and transformation logic

Key Requirements – Education & Certificates

• Talend certification (e.g., Talend Data Integration v7 Certified Developer)
• Bachelor’s degree in Computer Science, Information technology or related field

Key Requirements - Experience & Skills

• Strong hands on experience with Talend Data integration for both ETL/ETL (minimum 3-5) years of experience.
• Advance expertise in PL/SQL and experience with data base tuning (Oracle, SQL Server, PostgreSQL, MySQL, etc.).
• Experience with data warehousing concepts and dimensional modeling.
• Excellent problem-solving, debugging, and communication skills.