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 robust expertise in ETL development, data warehousing, performance optimization, production support, and solution architecture, while also driving automation and continuous improvement initiatives.
Competencies/Skills: Individual Contributor Competencies
Skills:
Core Technical 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,

📌 Senior Engineer (Gurugram)
🏢 Guardian Life Insurance
📍 Gurugram