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 qualified 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.

Skills:- SQL, Python, ETL, Data warehouse architecture, Data modeling, Snow flake schema, Apache Airflow, Amazon Web Services (AWS) and Amazon S3

📌 Data Integration Developer (Bengaluru)
🏢 Neuvamacro Technology
📍 Bengaluru