Note: The job is a remote job and is open to candidates in USA. RandomTrees is seeking a Snowflake Data Engineer to design, develop, and support ETL/ELT workflows. The role involves building and maintaining data pipelines, optimizing Snowflake performance, and collaborating with stakeholders to gather requirements.
Responsibilities
- Design, develop, and support ETL/ELT workflows using Informatica Intelligent Cloud Services
- Build and maintain data pipelines that load data into Snowflake
- Develop mappings, mapping tasks, taskflows, and reusable transformations
- Perform data extraction from multiple source systems, including databases, APIs, files, and cloud applications
- Implement data validation, reconciliation, and quality checks
- Optimize Snowflake warehouse performance, storage, and query execution
- Design dimensional and relational data models to support reporting and analytics
- Collaborate with business analysts, data architects, and stakeholders to gather requirements
- Monitor production jobs and resolve ETL failures and performance issues
- Maintain documentation for data flows, mappings, and operational procedures
Skills
- Design, develop, and support ETL/ELT workflows using Informatica Intelligent Cloud Services
- Build and maintain data pipelines that load data into Snowflake
- Develop mappings, mapping tasks, taskflows, and reusable transformations
- Perform data extraction from multiple source systems, including databases, APIs, files, and cloud applications
- Implement data validation, reconciliation, and quality checks
- Optimize Snowflake warehouse performance, storage, and query execution
- Design dimensional and relational data models to support reporting and analytics
- Collaborate with business analysts, data architects, and stakeholders to gather requirements
- Monitor production jobs and resolve ETL failures and performance issues
- Maintain documentation for data flows, mappings, and operational procedures
Company Overview
RandomTrees provide enterprise artificial intelligence solutions. It was founded in 2017, and is headquartered in Houston, Texas, USA, with a workforce of 201-500 employees. Its website is https://www.randomtrees.com/.Company H1B Sponsorship
RandomTrees has a track record of offering H1B sponsorships, with 3 in 2026, 9 in 2025, 14 in 2024, 3 in 2023, 2 in 2022, 2 in 2021. Please note that this does not guarantee sponsorship for this specific role.