Python/Snowflake Developer

Hiring

EXL

Gurugram · IndiaFull-time· 7d ago

Experience

3–8 yrs

Work Type

Full-time

Domain

Property & Casualty (P&C) insurance

Core SkillsMust Have

PythonSnowflakeSQLCTEsWindow functionsQuery performance tuningStored proceduresETL/ELTData integrationData validationData reconciliationData modelingRelational databasesData quality controlsData profiling

What You'll Do

1Develop, enhance, and maintain data solutions using Python and Snowflake

2Support P&C insurance data platforms including policy, claims, billing, underwriting, and exposure datasets

3Build and maintain data ingestion, transformation, and validation processes

4Develop Python scripts for data extraction, processing, automation, and operational support

5Write and optimize complex SQL queries, stored procedures, and Snowflake objects

6Perform data analysis, reconciliation, and root-cause investigation for data issues

7Monitor data pipelines and resolve production incidents related to data availability, quality, and accuracy

8Create automated checks and controls to improve data quality and reliability

9Work with business users, analysts, actuaries, and technology teams to understand data requirements

10Support reporting and analytics teams by delivering accurate and timely datasets

11Perform data profiling, mapping, and validation across source and target systems

12Troubleshoot ETL/ELT failures and coordinate fixes with upstream/downstream teams

13Document data processes, technical solutions, and support procedures

14Participate in Agile ceremonies, code reviews, testing, and deployment activities

Requirements

EducationBachelor's degree in Computer Science, Engineering, Information Systems, or related field

Nice to HaveOptional

dbtAirflow

Domain

Property & Casualty (P&C) insurance

Industry

Property & Casualty (P&C) insurance