₹15L – ₹25L a year estimatetypical for IT Jobs in Bangalore, 256 posts
Posted 2 months ago Last checked 1 hr ago
Free · takes a minute · your resume fills your profile
CoreHRx never asks candidates for money. If anyone does, .
Role at a glance
You will
Design, develop, and maintain ETL/ELT pipelines using Informatica Intelligent Cloud Services (IICS) to support scalable data integration…
Implement and optimize data integration workflows with IICS Cloud Data Integration (CDI), ensuring robust error handling, scheduling, and…
Develop complex mappings, mapping tasks, taskflows, and reusable components for efficient data movement and transformation 4.
Experience
5–8 years
Education
Bachelor's degree
Must-have skills
Data WarehousingELTETLQuery OptimizationSQLSnowflake
Work mode
Hybrid
How well do your skills match this job?
Sign in to see your fit: the skills, experience and location this job asks for, checked against your profile.
Job description
Location: Bangalore, Karnataka, India Department: AI & Data Engineering
Senior Data Engineer
Primary Skills
DataStream, ETL Fundamentals, SQL, SQL (Basic + Advanced), Python, Data Warehousing, Time Travel and Fail Safe, Snowpipe, SnowSQL, Modern Data Platform Fundamentals, Data Modelling Fundamentals, PLSQL, T-SQL, Stored Procedures
Specialization
Snowflake Engineering: Senior Data Engineer
Job requirements
Experience Range: With at least 5 to 8 years of experience designing, developing, and maintaining data integration and data warehouse solutions using IICS and Snowflake Key Responsibilities: 1. Design, develop, and maintain ETL/ELT pipelines using Informatica Intelligent Cloud Services (IICS) to support scalable data integration processes 2. Implement and optimize data integration workflows with IICS Cloud Data Integration (CDI), ensuring robust error handling, scheduling, and parameterization 3. Develop complex mappings, mapping tasks, taskflows, and reusable components for efficient data movement and transformation 4. Build and maintain Snowflake data warehouse solutions, including databases, schemas, tables, views, and stages to support business analytics 5. Write and optimize advanced SQL queries and Snowflake stored procedures to enable high-performance data processing and reporting 6. Implement data loading strategies from diverse source systems into Snowflake, including incremental loads, Change Data Capture (CDC), and Slowly Changing Dimensions (SCD) Type 1/Type 2 7. Perform data transformation, cleansing, validation, and reconciliation to ensure data quality and integrity 8. Troubleshoot ETL failures, data issues, and performance bottlenecks to ensure reliable data operations 9. Collaborate with business analysts, data architects, QA, and other technical teams to deliver end-to-end data solutions and support production deployments Required Skills: 1. Hands-on experience with Informatica Intelligent Cloud Services (IICS) and Cloud Data Integration (CDI) 2. Expertise in Snowflake data warehouse architecture and features including warehouses, stages, streams, tasks, time travel, and zero-copy cloning 3. Advanced SQL development and query optimization 4. Proficiency in ETL/ELT development and data warehousing concepts 5. Experience developing mappings, mapping tasks, and taskflows in IICS 6. Implementation of parameterization and error handling in ETL pipelines 7. Scheduling and automation of data integration workflows 8. Design and management of incremental and full data loads including SCD and CDC patterns Preferred Skills: 1. Experience with AWS or Azure cloud services for data integration and storage 2. Knowledge of AWS S3 or Azure Blob Storage for data ingestion 3. Familiarity with CI/CD and DevOps practices for ETL pipeline deployment 4. Proficiency in Python or scripting languages for automation 5. Experience with version control and automation tools such as Git, Jenkins, or Azure DevOps 6. Domain experience in Life Sciences or Pharmaceutical industry Desired Qualifications: 1. Bachelor's degree in Computer Science, Information Technology, Engineering, or a closely related discipline 2. Certification in Snowflake or Informatica Cloud Data Integration (preferred) 3. Certification in AWS or Azure cloud platforms (preferred)
Key skills
Required
Data WarehousingELTETLQuery OptimizationSQLSnowflake
Most IT Jobs posts in Bangalore ask for 3–6 years of experience (41% of 3850 that say).
Hiring most for IT Jobs in Bangalore
Bosch Group167 open jobs
Trigent Software Private Limited138 open jobs
Brillio116 open jobs
Jobs asking for Data Warehousing in Bangalore also ask for
SQL67%
Python55%
ETL49%
AWS40%
Microsoft Azure37%
From live job posts on CoreHRx, updated 10 Nov 2026. Skill figures count posts that list their skills; salary figures only posts that show a salary.
Questions about this job
What is the salary for this Senior Data Engineer job?
The post does not state the pay. As an estimate, comparable posts on CoreHRx advertise ₹15L – ₹25L a year (typical for IT Jobs in Bangalore, 256 posts).
This guide is for Indian job seekers preparing for SQL rounds in data analyst, data engineer, backend developer and database roles, from freshers to experienced professionals. It has 60 questions in three levels: easy covers joins, grouping and NULLs; medium covers window functions, CTEs, indexes and isolation levels; hard covers locking, MVCC, query tuning and classic puzzles such as login streaks and medians. Answers use ANSI SQL, with MySQL 8 and PostgreSQL notes where the two differ. Write each query against your own sample tables first, then compare your result with the sample answer.
Questions you may be asked
What is the difference between WHERE and HAVING?
What is the difference between DELETE, TRUNCATE and DROP?
What is the difference between an INNER JOIN and a LEFT JOIN?
What is the difference between a primary key and a unique key?
