Senior Data Engineer - R01569889

Brillio
Bengaluru
Workplace: HybridFull timeFunction: Solutions Engineering & Sales EngineeringExperience: 5-8 yearsEducation: bachelorsSkills: []

Design, develop, and maintain ETL/ELT pipelines using Informatica IICS/Cloud Data Integration, with robust error handling, scheduling, and parameterization. Build and operate Snowflake data warehouse solutions (databases, schemas, tables, views, stages), writing optimized SQL and Snowflake stored procedures. Implement incremental loads, CDC, and SCD patterns, ensure data quality through validation and reconciliation, and troubleshoot pipeline failures while collaborating with analysts, architects, QA, and engineering teams.

Loading

Loading job details...

Preparing the role view and application actions.

FursaFursa
Brillio
Brillio
6 days ago

Senior Data Engineer - R01569889

✓ Verified Job

Canonical indexed version, validated from employer's careers page.

Source: Company careers pageValidated by: Fursa AI
Last checked: 2 hours agoStatus: Live

Job Summary

Design, develop, and maintain ETL/ELT pipelines using Informatica IICS/Cloud Data Integration, with robust error handling, scheduling, and parameterization. Build and operate Snowflake data warehouse solutions (databases, schemas, tables, views, stages), writing optimized SQL and Snowflake stored procedures. Implement incremental loads, CDC, and SCD patterns, ensure data quality through validation and reconciliation, and troubleshoot pipeline failures while collaborating with analysts, architects, QA, and engineering teams.
Location: Bengaluru
Workplace: Hybrid
Employment Type: Full time
Job Function: Solutions Engineering & Sales Engineering
Seniority: Mid level

Key Responsibilities

  • •Design, develop, and maintain ETL/ELT pipelines using Informatica IICS to support scalable data integration.
  • •Implement and optimize data integration workflows (CDI/IICS Cloud Data Integration), ensuring error handling, scheduling, and parameterization.
  • •Develop complex IICS mappings, mapping tasks, taskflows, and reusable components for data movement and transformation.
  • •Build and maintain Snowflake data warehouse solutions (databases, schemas, tables, views, stages) to support analytics.
  • •Write and optimize advanced SQL and Snowflake stored procedures; implement incremental loads, CDC, and SCD (Type 1/Type 2) patterns while validating, troubleshooting, and supporting production deployments.

Key Requirements

  • •5 to 8 years designing, developing, and maintaining data integration and data warehouse solutions.
  • •Hands-on experience with Informatica Intelligent Cloud Services (IICS) and Cloud Data Integration (CDI/IICS Cloud Data Integration).
  • •Expertise in Snowflake data warehouse architecture and features (warehouses, stages, streams, tasks, time travel, zero-copy cloning).
  • •Advanced SQL development and query optimization, including Snowflake stored procedures.
  • •Experience building ETL/ELT mappings and taskflows in IICS, including parameterization and error handling.
Experience:5-8 years
Education:Bachelor's in Computer Science, Information Technology, Engineering, or a closely related discipline
Certifications:Snowflake certificationInformatica Cloud Data Integration certificationAWS certificationAzure certification
Tech Stack:Informatica Intelligent Cloud Services (IICS)Cloud Data Integration (CDI)Informatica Cloud Data Integration (CDI)SnowflakeSQLPythonAWSAzureAWS S3Azure Blob StorageCI/CDDevOpsGitJenkinsAzure DevOpsETL/ELTData WarehousingChange Data Capture (CDC)Slowly Changing Dimensions (SCD)SQL (Basic + Advanced)

Company Brief

Brillio
Provides digital transformation and IT consulting services, including cloud migration, analytics, digital engineering, and managed services to accelerate business outcomes for enterprises across industries.
Industry: Consulting
Company Size: Enterprise (1,001+ employees)
Growth: Established Company
Funding: Private Equity Backed
Headquarters: Santa Clara, United States
Founded: 2014
WebsiteLinkedIn