Responsibilities
ROLES & RESPONSIBILITIES
- Strong experience of minimum 5+ years in Snowflake & Snowpipe having over all 9 to 12 years of experience as a data engineer, database developer, or similar role, with a focus on data warehousing and analytics.
- Talend experience is a plus.
- Big data experience with restaurant industry as a plus.
- Optimize Snowflake performance by tuning SQL queries, optimizing data loading processes, and implementing best practices for data modelling and schema design.
- Implement ETL/ELT into Snowflake using tools such as Snowflake's native functionalities, Snowpipe.
- Proficiency in SQL and experience with database technologies such as SQL Server, Oracle, PostgreSQL, or MySQL
- Experience with ETL/ELT tools and methodologies, such as Talend, Informatica, or custom scripting using Python, SQL, or Spark.
- Solid understanding of data warehousing concepts, dimensional modelling, and data integration techniques.
- Implement data governance and security policies within Snowflake, including role-based access control, data encryption, and data masking techniques.
- Troubleshoot and resolve issues related to data quality, data consistency, and data integrity within Snowflake data warehouses.
- Snowflake certification(s) such as SnowPro Core or SnowPro Advanced is a plus.
Experience
Skills
- Primary Skill: Data Engineering
- Sub Skill(s): Data Engineering
- Additional Skill(s): Data Warehouse, Big Data, snowflake, Azure Datalake
About The Company
Infogain is a human-centered digital platform and software engineering company based out of Silicon Valley. We engineer business outcomes for Fortune 500 companies and digital natives in the technology, healthcare, insurance, travel, telecom, and retail & CPG industries using technologies such as cloud, microservices, automation, IoT, and artificial intelligence. We accelerate experience-led transformation in the delivery of digital platforms. Infogain is also a Microsoft (NASDAQ: MSFT) Gold Partner and Azure Expert Managed Services Provider (MSP).
Infogain, an Apax Funds portfolio company, has offices in California, Washington, Texas, the UK, the UAE, and Singapore, with delivery centers in Seattle, Houston, Austin, Krakw, Noida, Gurgaon, Mumbai, Pune, and Bengaluru.
