remote
Sr Snowflake/DWH/ETL Informatica Consultant - Hermitage Info Tech Llc
Software Engineer
Senior consultant with 7+ years in data engineering, specializing in Snowflake, data warehousing, and Informatica ETL. Expert in database design, role management, and performance optimization for production environments.
About the role
Key Responsibilities
- Design, develop, and maintain Snowflake data warehouses for large-scale analytics workloads.
- Build and optimize ETL pipelines using Informatica, ensuring data quality and reliability.
- Manage database objects, schemas, roles, and granular access controls in Snowflake.
- Collaborate with data scientists and business stakeholders to translate requirements into scalable data solutions.
- Monitor performance, troubleshoot issues, and implement tuning strategies to meet SLAs.
Requirements
- 7+ years of experience in data engineering or data warehousing.
- 5+ years of hands‑on Snowflake production experience.
- Proficiency with Informatica PowerCenter or similar ETL tools.
- Strong SQL skills and experience with data modeling best practices.
- Excellent problem‑solving abilities and a proactive, collaborative mindset.