Senior Data Engineer - R01569889
Core
Design, develop, and maintain ETL/ELT pipelines and Snowflake data warehouse solutions to support scalable data integration and business analytics.
Role type
Senior IC data engineer (Snowflake/IICS)
Builds
ETL/ELT pipelines, data warehouse schemas, tables, views, and stages
Domain
Cloud data engineering, data warehousing
Required skills
Informatica Intelligent Cloud Services (IICS), Snowflake data warehouse architecture, advanced SQL, ETL/ELT development, data modeling, incremental loads, Change Data Capture (CDC), Slowly Changing Dimensions (SCD), error handling, scheduling, automation
Preferred skills
AWS or Azure cloud services, object storage (S3/Blob), CI/CD and DevOps practices, Python scripting, version control (Git, Jenkins, Azure DevOps), Life Sciences or Pharmaceutical domain experience
Technologies
Informatica Intelligent Cloud Services (IICS), Snowflake, SQL, Python, AWS, Azure, Git, Jenkins, Azure DevOps
Responsibilities
Design and develop ETL/ELT pipelines using IICS; Implement and optimize data integration workflows with IICS Cloud Data Integration; Build and maintain Snowflake data warehouse solutions; Write and optimize advanced SQL queries and stored procedures; Implement data loading strategies including incremental loads, CDC, and SCD; Perform data transformation, cleansing, validation, and reconciliation; Troubleshoot ETL failures and performance bottlenecks; Collaborate with business analysts, data architects, and technical teams to deliver end-to-end data solutions
Seniority
Senior, hands-on IC