Senior Data Engineer - R01569890

Primary Skills

IICS,Snowflake,SQL

Job requirements

Experience Range

With at least 3 to 5 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)