Data Integration Developer

Shift

Second Shift (2:00 PM – 10:00 PM)

Joining

Immediate

About the Role

We are looking for an experienced Data Integration Developer with strong hands-on expertise in SQL, Python, ETL development, Snowflake, and AWS data services.

The ideal candidate should have extensive experience in designing, developing, and maintaining data integration solutions, building data warehouse architectures, and implementing scalable ETL pipelines. Strong SQL development and performance optimization skills are essential for this role.

This is a remote position; however, candidates must be available to visit our Mumbai or Bangalore location for three days during the onboarding process.

Key Responsibilities

SQL Development & Performance Optimization

Develop complex SQL queries, stored procedures, and data transformation logic.

Optimize SQL queries for performance, scalability, and efficiency.

Perform advanced data analysis, validation, and reconciliation.

Troubleshoot complex SQL and data-related issues.

ETL Development & Data Integration

Design, develop, and maintain ETL pipelines and data integration workflows.

Work with SQL and Python for data extraction, transformation, and loading.

Ensure data accuracy, consistency, and integrity across systems.

Identify and resolve data pipeline failures and integration issues.

Data Warehousing & Data Modeling

Design and maintain data warehouse architectures.

Develop data warehouse schemas based on business requirements.

Work on dimensional data modeling, including Facts and Dimensions.

Implement Slowly Changing Dimensions (SCD).

Support data analysis and business information reconciliation.

Snowflake & AWS

Develop and manage data solutions using Snowflake.

Work with AWS services, particularly Amazon S3.

Manage AWS connections and data access configurations.

Build and maintain cloud-based data integration solutions.

Python & Apache Airflow

Develop data processing and automation solutions using Python.

Build, schedule, and monitor workflows using Apache Airflow.

Troubleshoot workflow failures and improve pipeline reliability.

Agile & Development Lifecycle

Participate in Agile development processes, sprint planning, and team discussions.

Contribute throughout all stages of the software development lifecycle.

Collaborate with cross-functional teams to understand business and technical requirements.

Perform root cause analysis and implement appropriate corrective actions.

Required Skills

Advanced SQL – Strong hands-on expertise is mandatory.

Python Development

ETL Development and Data Integration

Snowflake

Apache Airflow

AWS Services, particularly Amazon S3

AWS Connection Management

Data Warehouse Architecture

Data Modeling (Facts & Dimensions)

Slowly Changing Dimensions (SCD)

SQL Query Optimization and Performance Tuning

Data Analysis and Reconciliation

Troubleshooting and Root Cause Analysis

Agile Development Methodologies

Strong understanding of the Software Development Life Cycle (SDLC)

Experience & Qualifications

8–10 years of overall experience in Data Engineering / Data Integration / ETL Development.

Strong professional experience in advanced SQL and Python.

Hands-on experience with Snowflake, Apache Airflow, and AWS.

Proven experience designing and developing data warehouse solutions.

Experience working across the complete product development lifecycle.

Ability to independently troubleshoot complex technical challenges.

Additional Requirements

Immediate joiners preferred.

Must be comfortable working in the second shift (2:00 PM – 10:00 PM).

Position is remote, with a mandatory three-day onboarding visit to Mumbai or Bangalore.

Strong communication, analytical, and problem-solving skills.

Ability to work independently and collaboratively in an Agile environment.