Imagine CommunicationsRemote
Data Warehouse Engineer
United States
Full-time
4 hours ago
H1B Sponsor Likely
Key skills
PythonSQLPowerShellETLELTData EngineeringData WarehousingAnalyticsSnowflakedbtAWSAzureOracleGitHubVersion ControlSource ControlERPCI/CD
About this role
Imagine Communications is a leading provider of media software and networking solutions, serving over 3,000 customers globally. They are seeking a hands-on Data Engineer with strong experience in Snowflake and Informatica Intelligent Cloud Services to build, optimize, and support scalable data pipelines and analytics-ready data models.
Responsibilities:
- Design, develop, and maintain ELT data pipelines in Snowflake
- Design and 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
Requirements:
- 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)
- Design, develop, and maintain ELT data pipelines in Snowflake
- Design and 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
- Python or scripting experience for automation
- Experience with dbt or other ELT frameworks
- Exposure to AWS or Azure cloud platforms
- Familiarity with data governance, auditing, and monitoring, Oracle Fusion Cloud ERP or any other ERP system