Key skills
CloudETLInformaticaOraclePythonSQLELTData EngineeringData WarehousingAnalyticsSnowflakeGitHubVersion ControlCI/CD
About this role
Role Overview
- Build, optimize, and support scalable data pipelines and analytics-ready data models
- Design, develop, and maintain ELT data pipelines in Snowflake
- Integrate data from Oracle Fusion Analytics (FAW) into Snowflake using IICS
- Monitor, troubleshoot, and optimize IICS workflows and data pipelines
- Implement CI/CD pipelines for Snowflake and IICS assets
- Write, optimize, and tune complex SQL for data transformations
- Develop Snowflake stored procedures using SQL and Python
- Support multi-environment Snowflake deployments (Dev, QA, Prod)
Requirements
- 6–10+ years of experience in Data Engineering or Data Warehousing
- SnowPro Core Certification
- Strong hands-on experience with Snowflake
- Advanced SQL skills, including query optimization and performance tuning
- Hands-on experience with Informatica Intelligent Cloud Services (IICS) – Mappings / Transformations / Tasks / Taskflows
- Experience implementing CI/CD pipelines for data platforms
- Strong experience using GitHub for version control and deployments
- Solid understanding of ETL and ELT design patterns
- Experience working with structured and semi-structured data (XML/JSON/Parquet)
Tech Stack
- Cloud
- ETL
- Informatica
- Oracle
- Python
- SQL
Benefits
- Medical, Dental, Vision and Life Insurance package
- HSA and 401(k) options with company matching
- Travel insurance
- Employee Wellbeing programs
- EAP and Wellness programs, including LifeSpeak and Vitality
- Volunteer community programs with company support