Data Specialist - R01569890

Brillio 2

Bangalore +1 more

Who this role is best for

Best suited to mid-level professionals with hands-on experience in IICS and Snowflake, working in data warehousing and analytics environments.

Best fit for

Mid-level professionals with 5 to 8 years of hands-on IICS and Snowflake experience
— “at least 5 to 8 years of experience designing, developing, and maintaining data integration and data warehouse solutions using IICS and Snowflake”
Candidates who can demonstrate expertise in complex ETL/ELT pipeline development
— “Develop complex mappings, mapping tasks, taskflows, and reusable components for efficient data movement and transformation”
Individuals who have experience with Snowflake data warehouse architecture and advanced SQL
— “Expertise in Snowflake data warehouse architecture and features including warehouses, stages, streams, tasks, time travel, and zero-copy cloning”

Things to consider

The role requires a significant commitment to maintaining data quality and integrity through transformation and validation processes
— “Perform data transformation, cleansing, validation, and reconciliation to ensure data quality and integrity”
Collaboration with business analysts and data architects is a key expectation
— “Collaborate with business analysts, data architects, QA, and other technical teams to deliver end-to-end data solutions”

How to stand out

Highlight experience in optimizing IICS and Snowflake workflows for performance
— “Implement and optimize data integration workflows with IICS Cloud Data Integration (CDI)”
Showcase your ability to manage complex data loads using SCD and CDC patterns
— “Design and management of incremental and full data loads including SCD and CDC patterns”
Emphasize your track record in troubleshooting ETL failures and performance bottlenecks
— “Troubleshoot ETL failures, data issues, and performance bottlenecks to ensure reliable data operations”
Demonstrate advanced SQL development and stored procedure optimization skills
— “Write and optimize advanced SQL queries and Snowflake stored procedures”

Pace · SteadyCollaboration · HighAutonomy · MediumDecision Impact · TeamLevel · Mid Level

Derived from job-description analysis by Serendipath's career intelligence engine.

What success looks like

successful design and development of ETL/ELT pipelines
implementation of robust data integration workflows
optimization of advanced SQL queries
successful data loading strategies
troubleshooting of ETL failures

Typical background

experience in data integration and data warehousingbackground in ETL/ELT development

Skills & requirements

Required

IICSSnowflakeEtl/elt PipelinesSQLData WarehousingData IntegrationData TransformationData CleansingData ValidationData ReconciliationData QualityData IntegrityData Loading StrategiesIncremental LoadsCDCSCDData OptimizationData Governance

Preferred

AWSAzureCI/CDDevOpsGitJenkinsAzure DevopsPythonScripting LanguagesAutomationVersion ControlLife SciencesPharmaceutical Industry

Stack & domain

IICSSnowflakeSQLInformatica Intelligent Cloud Services (iics)Cloud Data Integration (cdi)Snowflake Data Warehouse ArchitectureAWSAzureAWS S3Azure Blob StorageCI/CDDevOpsPythonGitJenkinsAzure DevopsLife SciencesPharmaceutical IndustryInformatica Cloud Data Integration

About the role

Original posting from Brillio 2 via Lever

Primary Skills:
IICS,Snowflake,SQL
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:
Design, develop, and maintain ETL/ELT pipelines using Informatica Intelligent Cloud Services (IICS) to support scalable data integration processes
Implement and optimize data integration workflows with IICS Cloud Data Integration (CDI), ensuring robust error handling, scheduling, and parameterization
Develop complex mappings, mapping tasks, taskflows, and reusable components for efficient data movement and transformation
Build and maintain Snowflake data warehouse solutions, including databases, schemas, tables, views, and stages to support business analytics
Write and optimize advanced SQL queries and Snowflake stored procedures to enable high-performance data processing and reporting
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
Perform data transformation, cleansing, validation, and reconciliation to ensure data quality and integrity
Troubleshoot ETL failures, data issues, and performance bottlenecks to ensure reliable data operations
Collaborate with business analysts, data architects, QA, and other technical teams to deliver end-to-end data solutions and support production deployments.
Required Skills:
Hands-on experience with Informatica Intelligent Cloud Services (IICS) and Cloud Data Integration (CDI)
Expertise in Snowflake data warehouse architecture and features including warehouses, stages, streams, tasks, time travel, and zero-copy cloning
Advanced SQL development and query optimization
Proficiency in ETL/ELT development and data warehousing concepts
Experience developing mappings, mapping tasks, and taskflows in IICS
Implementation of parameterization and error handling in ETL pipelines
Scheduling and automation of data integration workflows
Design and management of incremental and full data loads including SCD and CDC patterns.
Preferred Skills:
Experience with AWS or Azure cloud services for data integration and storage
Knowledge of AWS S3 or Azure Blob Storage for data ingestion
Familiarity with CI/CD and DevOps practices for ETL pipeline deployment
Proficiency in Python or scripting languages for automation
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:
Bachelor's degree in Computer Science, Information Technology, Engineering, or a closely related discipline
Certification in Snowflake or Informatica Cloud Data Integration (preferred)
Certification in AWS or Azure cloud platforms (preferred)

Source: Brillio 2 careers (Lever)