Data Engineer - Snowflake DB

Position : Snowflake DE Location : Pune, Gurgaon Experience : 6-9 Years Clairvoyant is a global technology consulting and services company founded in 2012, headquartered in Chandler, US, and have delivery centers across the globe. We help organizations maximize the value of data by providing data engineering, analytics, machine learning, and user experience consulting and development projects to multiple Fortune 500 clients. Clairvoyant clients rely on its deep vertical knowledge and best-in-class services to drive revenue growth, boost operational efficiencies, and manage risk and compliance. Our team of experts with direct industry experience in data engineering, analytics, machine learning, and user experience has your back every step of the way. "Our Values: Passion, Continuous Learning, Adaptability, Teamwork, Customer Centricity, Reliability" Essential Skills/Basic Qualifications : - Hands on Experience in developing, testing and maintaining applications on AWS Cloud. - Candidate should have 6 years of experience on the relevant Technologies. - Strong hold on AWS Data Analytics Technology Stack (Glue, S3, Lambda, Lake formation, Athena) - Design and implement scalable and efficient data transformation/storage solutions using Snowflake. - Experience in Data ingestion to Snowflake for different storage format such Parquet, Iceberg,JSON, CSV etc - Experience in using Orchestration tools such as Apache Airflow or Snowflake Tasks - Experience in using DBT (Data Build Tool) with snowflake for ELT pipeline development. - Experience in Writing advanced SQL and PL SQL programs. - Hands On Experience for building reusable components using Snowflake and AWS Tools/Technology - Knowledge on python, Spark and Hadoop is must. - Should have worked at least on two major project implementations. - Exposure to data governance or lineage tools such as Immuta and Alation is added advantage. Desirable skills/Preferred Qualifications : - Ability to engage with Stakeholders, elicit requirements/ user stories and translate requirements into ETL components - Ability to understand the infrastructure setup and be able to provide solutions either individually or working with teams. - Good knowledge of Data Marts and Data Warehousing concepts. - Resource should possess good analytical and Interpersonal skills. - Implement Cloud based Enterprise data warehouse with multiple data platform along with Snowflake and NoSQL environment to build data movement strategy. Education : Bachelor's degree in Computer Science, Software Engineering, MIS or equivalent combination of education and experience Every individual comes with a different set of skills and qualities so even if you don't tick all the boxes for the role today, we urge you to apply as there might be a suitable/unique role for you tomorrow (ref:hirist.tech)

Location: India, IN

Posted Date: 4/25/2024