Delivery Project Lead- Snowflake Engineer

Role description Position Title- Snowflake Engineer Job Location- Calgary-AB/Toronto, ON Job Summary - A Snowflake Engineer to manage a project for one of our biggest clients in Logistic domain. The Individual should be passionate about technology, experienced in developing and managing cutting edge technology applications. Years of experience needed -5-8 years Technical Skills: Good Handon experience on Snowflake with strong programming experience in SQL. Competence in Snowflake data engineering components such as Snowpipe, Tasks, UDF's and Dynamic Tables, experience in python Handson experience in databases, stored procedures, optimizations of huge data In-depth knowledge of ingestion techniques, data cleaning, de-dupe, partitioning. Knowledge of multi-layer data architectures (e.g. bronze, silver, gold) Experience in streaming / real-time / event driven data platforms. Create and maintain optimal data pipelines, using the most appropriate features within Snowflake. Implement data pipelines utilizing industry standards around IaC, CICD and automated testing. Collaborate with stakeholders to understand data & non-functional requirements. Assemble large, complex data sets that meet functional as well as non-functional business requirements. Collaborate with the team on building data models and schema design. Implement data quality checks and data governance standards. Build the infrastructure required for optimal extraction, transformation, and loading of data. Consult with product, engineering, and business stakeholders to understand business problems and identify the best way to deliver a solution - educating stakeholders about options where required. Prepare high-level ETL mapping specifications. Test data pipelines and perform bug fixes. Develop best practices for database design and development activities. Actively participate in agile and design meetings to drive the technical outcomes. Certifications Needed : Any relevant certification would be added advantage About Mphasis Mphasis applies next-generation technology to help enterprises transform businesses globally. Customer centricity is foundational to Mphasis and is reflected in the Mphasis' Front2Back Transformation approach. Front2Back uses the exponential power of cloud and cognitive to provide hyper-personalized (C=X2C2TM=1) digital experience to clients and their end customers. Mphasis' Service Transformation approach helps 'shrink the core' through the application of digital technologies across legacy environments within an enterprise, enabling businesses to stay ahead in a changing world. Mphasis' core reference architectures and tools, speed and innovation with domain expertise and specialization are key to building strong relationships with marquee clients. Equal Opportunity Employer: Mphasis is an equal opportunity/affirmative action employer. We provide equal employment opportunities to applicants and existing associates and evaluate qualified candidates without regard to race, gender, national origin, ancestry, age, color, religious creed, marital status, genetic information, sexual orientation, gender identity, gender expression, sex (including pregnancy, breast feeding and related medical conditions), mental or physical disability, medical conditions military and veteran status or any other status or condition protected by applicable federal, state, or local laws, governmental regulations and executive orders. View the EEO in the law poster , view the EEO in the law supplement . To view the pay transparency nondiscrimination provision please click and to view the E-Verify posting click . Mphasis is committed to providing reasonable accommodations to individuals with disabilities. If you need a reasonable accommodation because of disability to search and apply for a career opportunity, please send an email to and let us know your contact information and the nature of your request. Other details Deputation Location : CA~Alberta~Calgary