Senior Data Engineer - R01569889

Brillio-2

Bengaluru

On-site

INR 1,200,000 - 1,800,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Brillio-2 in Bengaluru is seeking a Senior Data Engineer to design and build scalable data pipelines using Snowflake, IICS/CDI, and cloud services for analytics across business units.

You will optimize ETL/ELT processes, implement CDC and SCD patterns, develop advanced SQL and Snowflake objects, and collaborate with data architects, QA, and analysts to deliver reliable data solutions.

Qualifications

  • Experience designing, developing, and maintaining data integration and data warehouse solutions.
  • Hands-on with Informatica Intelligent Cloud Services (IICS) and Cloud Data Integration.
  • Strong Snowflake data warehouse knowledge including warehouses, stages, streams, tasks and time travel.
  • Advanced SQL development and query optimization.
  • Experience with incremental loads, CDC and SCD patterns (Type 1/Type 2).
  • ETL/ELT development experience and data warehousing concepts.
  • Ability to design mappings, mapping tasks, and taskflows in IICS.

Responsibilities

  • Design, develop, and maintain ETL/ELT pipelines using IICS to support scalable data integration.
  • Implement and optimize data workflows with IICS CDI, with error handling and scheduling.
  • Develop complex mappings, tasks, and reusable components for data movement.
  • Build and maintain Snowflake data warehouse objects to support analytics.
  • Write and optimize advanced SQL queries and Snowflake stored procedures.
  • Implement data loading strategies from diverse sources into Snowflake (CDC, SCD).
  • Transform, cleanse, validate, and reconcile data to ensure quality and integrity.
  • Troubleshoot ETL failures and performance bottlenecks; collaborate with teams.
  • Partner with analysts, data architects, and QA to deliver end-to-end data solutions.

Skills

Snowflake
IICS
ETL development
SQL
Python
Data Warehousing
Data Modeling
SCD & CDC
Stored Procedures

Education

Bachelor's degree in CS/IT/Engineering

Tools

IICS/CDI
Snowflake
AWS/Azure

Job description

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)
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Engineer - R01569889
Senior Data Engineer - R01569889

Brillio • Bengaluru

On-site
INR 1,500,000 - 2,100,000
Senior Data Engineer - R01572077
Senior Data Engineer - R01572077

Brillio • Maharashtra

On-site
INR 1,800,000 - 2,600,000
Senior Data Engineer - R01572077
Senior Data Engineer - R01572077

Brillio-2 • Maharashtra

On-site
INR 1,500,000 - 2,100,000
Lead Snowflake Data Engineer
Lead Snowflake Data Engineer

VMC Soft Technologies • Bengaluru Urban

On-site
INR 1,500,000 - 2,700,000
Data Engineer
Data Engineer

Unison Group • Hyderabad

On-site
INR 600,000 - 1,200,000
Sr. Snowflake Data Engineer
Sr. Snowflake Data Engineer

SynapOne • Hyderabad

On-site
INR 1,200,000 - 1,600,000
Snowflake Data Engineer
Snowflake Data Engineer

Fugetron Corporation • Mumbai

Hybrid
INR 1,500,000 - 3,000,000
SENIOR SOFTWARE ENGINEER - Snowflake
SENIOR SOFTWARE ENGINEER - Snowflake

Happiest Minds Technologies • Dadri

On-site
INR 1,800,000 - 3,600,000
Snowflake Data Engineer
Snowflake Data Engineer

PALNI • Hyderabad

On-site
INR 900,000 - 1,500,000
Lead Data Engineer - R01571409
Lead Data Engineer - R01571409

Brillio • Bengaluru

On-site
INR 2,600,000 - 4,200,000