Data Specialist - R01569890

Brillio
Bengaluru
Workplace: HybridFull timeFunction: Software EngineeringExperience: 5-8 yearsEducation: bachelorsSkills: ["Collaboration","Troubleshooting"]

Design, develop, and maintain ETL/ELT pipelines using Informatica Intelligent Cloud Services (IICS) to enable scalable data integration. Build Snowflake data warehouse solutions (warehouses, stages, tables, views) and write optimized SQL and stored procedures for high-performance reporting. Implement CDC, SCD (Type 1/Type 2), incremental/full loads, data quality checks, and robust error handling, while collaborating with analysts, architects, and QA to support production deployments.

Loading

Loading job details...

Preparing the role view and application actions.

FursaFursa
Brillio
Brillio
1 day ago

Data Specialist - R01569890

✓ Verified Job

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

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

Job Summary

Design, develop, and maintain ETL/ELT pipelines using Informatica Intelligent Cloud Services (IICS) to enable scalable data integration. Build Snowflake data warehouse solutions (warehouses, stages, tables, views) and write optimized SQL and stored procedures for high-performance reporting. Implement CDC, SCD (Type 1/Type 2), incremental/full loads, data quality checks, and robust error handling, while collaborating with analysts, architects, and QA to support production deployments.
Location: Bengaluru
Workplace: Hybrid
Employment Type: Full time
Job Function: Software Engineering
Seniority: Mid level

Key Responsibilities

  • •Design, develop, and maintain ETL/ELT pipelines in IICS for scalable data integration.
  • •Implement and optimize IICS Cloud Data Integration workflows with scheduling, parameterization, and error handling.
  • •Create complex IICS mappings, mapping tasks, taskflows, and reusable components for data movement and transformation.
  • •Develop and maintain Snowflake data warehouse objects (databases, schemas, tables, views, and stages) to support analytics.
  • •Write and optimize advanced SQL and Snowflake stored procedures; implement incremental loads, CDC, SCD patterns, and ensure data quality through transformation, cleansing, validation, and reconciliation.

Key Requirements

  • •5 to 8 years designing, developing, and maintaining data integration and data warehouse solutions using IICS and Snowflake.
  • •Hands-on experience with Informatica Intelligent Cloud Services (IICS) and Cloud Data Integration (CDI), including parameterization and error handling.
  • •Expertise in Snowflake data warehouse architecture (warehouses, stages, streams, tasks, time travel, zero-copy cloning).
  • •Advanced SQL development with query optimization and the ability to build/maintain Snowflake stored procedures.
  • •Experience with ETL/ELT patterns and data loading strategies such as incremental loads, CDC, and SCD (Type 1/Type 2), plus mappings, mapping tasks, and taskflows in IICS.
Experience:5-8 years
Education:Bachelor's in Computer Science, Information Technology, Engineering, or a closely related discipline
Skills:CollaborationTroubleshooting
Certifications:Snowflake certificationInformatica Cloud Data Integration certificationAWS certificationAzure certification
Tech Stack:Informatica Intelligent Cloud Services (IICS)Cloud Data Integration (CDI)SnowflakeSQLETLELTCDCSCD Type 1SCD Type 2AWSAzurePythonGitJenkinsAzure DevOpsAWS S3Azure Blob StorageCI/CDDevOpsInformatica Cloud Data Integration (CDI)

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