Senior Engineer - IT (ETL)

India; Gurugram District; On-site; INR 1,200,000 - 2,000,000; Full time

Job summary

Guardian Life is seeking a data integration engineer to deliver DWH solutions using Informatica, Databricks, Spark SQL, and PostgreSQL/Oracle. You will design, develop, and optimize ETL pipelines, mentor teammates, and ensure adherence to SDLC, security, and compliance standards.

You will perform data extraction, transformation, and loading, tune queries for performance, support production deployments, and contribute to architecture with a bias toward automation and continuous improvement.

Qualifications

• 4–6 years in BI/DWH development or similar
• Experience delivering DWH solutions with ETL
• Strong knowledge of databases and SQL optimization

Responsibilities

• ETL design, development, and maintenance using Informatica (IICS/IDMC) and Databricks
• Perform ETL from multiple sources for BI/DWH projects
• Develop and optimize SQL, PL/SQL, Spark SQL, Hive, and Presto queries
• Tune ETL performance and ensure data quality and error handling
• Support production deployments and provide Level-2 production support

Skills

ETL Development

PostgreSQL

Oracle

SQL Server

DB2 UDB

Spark SQL

Python

UNIX

Data Warehousing

Data Modeling

Education

B.Tech/ MCA

Job description

Job Description: The role is responsible for delivering Data Warehouse (DWH) solutions using ETL technologies such as Informatica (IICS/IDMC), Databricks, Spark, PostgreSQL, and Oracle. The individual will lead technical design and development activities, support production deployments, mentor team members, and ensure adherence to Guardian's SDLC, security, and compliance standards. The role requires strong expertise in ETL development, data warehousing, performance optimization, production support, and solution architecture, while also driving automation and continuous improvement initiatives.

Competencies / Skills

• ETL Development: Informatica (IICS/IDMC), Databricks
• Database Technologies: PostgreSQL, Oracle, SQL Server, DB2 UDB
• Big Data & Querying: Spark SQL
• Programming & Scripting: Python, UNIX
• Data Engineering: Data Warehousing, Data Modeling

Key Responsibilities

• ETL & Data Engineering Design, develop, and maintain ETL solutions using Informatica (IICS/IDMC), Databricks, and Syncsort.
• Perform data extraction, transformation, and loading activities for BI and Data Warehouse projects.
• Conduct impact analysis and provide effort estimations for ETL enhancements and changes.
• Develop and execute unit test cases for all deliverables.
• Database & Query Development: Develop and optimize SQL, PL/SQL, Spark SQL, Hive, and Presto queries.
• Create and maintain procedures, functions, triggers, constraints, and cursors.
• Perform query tuning and ETL performance optimization.
• Data Warehousing & Architecture: Interpret and work with conceptual, logical, and physical data models.
• Design robust ETL architectures focused on data quality, performance, and error handling.
• Support current-state ("As-Is") architecture and contribute to future-state ("To-Be") architecture design.
• Evaluate new technologies and conduct proof-of-concepts (POCs).
• SDLC & Agile Delivery: Execute all SDLC phases including requirements analysis, design, development, testing, deployment, and support.
• Follow SAFe Agile methodology and Guardian development standards.
• Participate in release planning, deployment, migration, and post-production support.
• Production Support & Incident Management: Provide Level-2 production support and on-call support activities.
• Troubleshoot ETL failures, application defects, and job abends.
• Coordinate with DBA, Network, Storage, Scheduling, and User Administration teams for issue resolution.
• Support warranty and stabilization activities after deployment.

Education and Experience

Education: B.Tech Computers/MCA. Experience: 4 to 6 years in development projects with BI/ DWH background.

Location

This position can be based in any of the following locations: Gurgaon.

We know that people count, and we go above and beyond to prepare them for the life they want to live, focusing on their overall well-being — mind, body, and wallet. As one of the largest mutual insurance companies, we put our customers first. Behind every bright future is a GuardianTM. Learn more about Guardian at guardianlife.com.

Visa Sponsorship: Guardian Life is not currently or in the foreseeable future sponsoring employment-based visas (e.g., such as an H-1B). In order to be a successful applicant, you must be legally authorized to work in the United States, without the need for employer sponsorship/support now or at any time in the future.