Imagine Communications

Grow your reach and revenue

Snowflake Developer

Software EngineerSoftware EngineerFull TimeRemoteTeam 1,001-5,000H1B SponsorCompany SiteLinkedIn

Location

Florida + 6 moreAll locations: Florida, Illinois, Ohio, Minnesota, Missouri, Texas, Virginia

Posted

34 days ago

Salary

Not specified

Bachelor Degree6 yrs expEnglishCloudETLInformaticaOraclePythonSQL

Job Description

• 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

Job 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)

Benefits

  • Generous Medical, Dental, Vision and Life Insurance package
  • HSA and 401(k) options with company matching
  • Travel insurance
  • Access to EAP and Wellness programs
  • Volunteer community pay program

Related Job Pages