Build, optimize, and support scalable data pipelines and analytics-ready data models
Design and develop ELT data pipelines in Snowflake
Build Informatica IICS mappings for batch, mass ingestion, and incremental data ingestion
Develop and schedule IICS Taskflows for orchestration, dependencies, retries, and error handling
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
Use GitHub for source control, versioning, code reviews, and deployments
Write, optimize, and tune complex SQL for data transformations, CDC, and analytics use cases
Develop Snowflake stored procedures using SQL and Python
Implement incremental and near-real-time data processing using Snowflake Streams and Tasks
Support multi-environment Snowflake deployments (Dev, QA, Prod)
Automate deployment of Snowflake SQL objects, stored procedures using PowerShell
Provide production support, root cause analysis, and performance tuning
Collaborate with data analysts, architects, and business stakeholders
Document technical designs, standards, and operational procedures

6–10+ years of experience in Data Engineering or Data Warehousing
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 in Data integration of Oracle Fusion Analytics (FAW)
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)

Snowflake Developer

Key skills