Data Engineer

Intercontinental Exchange Holdings, Inc.; Hyderabad; On-site; INR 1,800,000 - 2,400,000; Full time

Job summary

Intercontinental Exchange Holdings, Inc. is seeking a Data Engineer for ICE Mortgage Technology in Hyderabad.

You will design and optimize Snowflake-based data warehouses, develop SQL queries and stored procedures, and build robust ETL/ELT pipelines to support analytics and reporting. The role emphasizes collaboration with data engineers, analysts and product owners, and ongoing modernization of legacy systems.

Qualifications

• 5+ years of professional experience in data engineering or database development.
• Strong hands-on experience with writing complex SQL queries and stored procedures.
• Experience with Snowflake objects and performance tuning.
• Proficiency in Python/Shell scripting for data processing.
• Experience configuring external stages to cloud storage and ETL/ELT workflows.
• Familiarity with Agile/Scrum SDLC and version control (Git).
• Excellent communication and ability to work with cross-functional teams.

Responsibilities

• Design and Snowflake-based data warehouse development for new data integration.
• Develop data transformation logic using SQL, Snowflake SPs, and Python scripts.
• Build and maintain robust data pipelines for reporting and analytics.
• Create Snowflake objects (tables, views, streams, tasks, file formats, stages).
• Collaborate with engineers, analysts, and product owners to implement requirements.
• Produce technical design documentation from business needs.
• Develop and review unit tests for SQL scripts and pipelines.
• Document deployment procedures and operational handover; assist monitoring.
• Mentor junior developers if needed and stay updated on Snowflake features.

Skills

SQL queries

Stored procedures

Snowflake

Python scripts

ETL/ELT

Data pipelines

Git

Agile/Scrum SDLC

Cloud storage integration

Education

Bachelor’s Degree

Tools

Snowflake

Git

AWS S3

Azure Blob

Job description

Job Description

Job Purpose

At Intercontinental Exchange (ICE), we engineer technology, exchanges and clearing houses that connect companies around the world to global capital and derivative markets. With a leading-edge approach to developing technology platforms, we have built market infrastructure in all major trading centers, offering customers the ability to manage risk and make informed decisions globally. By leveraging our core strengths in technology, we continue to identify new ways to serve our customers and transform global markets.

AIP Suites (Data Modernization to Snowflake) builds an analytics-ready data architecture where data from source systems such as PDM (Product Data Management) and RDO is ingested into Snowflake for centralized storage and modeling. These models support ICE BI, which consumes Snowflake data for analytics and dashboarding. This design ensures clean separation between raw ingestion, transformation, analytics, and service-based consumption, supporting scalable and future-proof data-driven operations.

ICE Mortgage Technology is seeking a Data Engineer who will be responsible for design and optimize SQL queries, develop stored procedures, and participate in the migration and modernization of legacy applications to support IMT (ICE Mortgage Technology) Products. The candidate should have a strong background in SQL and Stored Procedures

Responsibilities

• Provides Snowflake-based data warehouse design and development for projects involving new data integration, migration, and enhancement of existing pipelines.
• Designs and develops data transformation logic using SQL, Snowflake stored procedures, and Python-based scripts for ETL/ELT workloads.
• Builds and maintains robust data pipelines to support reporting, analytics, and application data needs.
• Creates and maintains Snowflake objects like tables, views, streams, tasks, file formats, and external stages.
• Participates in project meetings with data engineers, analysts, business users, and product owners to understand and implement technical requirements.
• Writes technical design documentation based on business requirements and data architecture principles.
• Develops and/or reviews unit testing protocols for SQL scripts, procedures, and data pipelines using automation frameworks.
• Completes documentation and procedures for pipeline deployment, operational handover, and monitoring.
• May mentor or guide junior developers and data engineers.
• Stays current with Snowflake features, best practices, and industry trends in cloud data platforms.
• Performs additional related duties as assigned.

Knowledge and Experience

• Bachelor’s Degree or the equivalent combination of education, training, or work experience.
• 5+ years of professional experience in data engineering or database development.
• Strong Hands-on experience:
• Writing complex SQL queries and stored procedures
• Database stored procedures, functions, views, and schema design
• Using Streams, Tasks, Time Travel, and Cloning
• Proficiency in database performance tuning and performance optimization — clustering, warehouse sizing, caching, etc.
• Experience configuring external stages to integrate with cloud storage (AWS S3, Azure Blob, etc.).
• Experience writing Python/Shell scripts for data processing (where needed).
• Knowledge on Snowflake and Tidal is an added advantage
• Proficiency in using Git and working within Agile/Scrum SDLC environments.
• Familiarity working in a Software Development Life Cycle (SDLC) leveraging Agile principles.
• Excellent analytical, decision-making, and problem-solving skills.
• Ability to multitask in a fast-paced environment with a focus on timeliness, documentation, and communication with peers and business users.
• Strong verbal and written communication skills to engage both technical and non-technical audiences at various organizational levels.