DE&A - Core - Cloud Data Engineering - Snowflake Data Engineering

The contractors will be required to:

• Assist in migrating existing Snowflake code (converted by SnowConvert) into dbt (data build tool).
• Test and validate the migrated code in Snowflake and dbt for functionality and performance.
• Support the implementation of re-engineered dbt pipelines.
• Migrate data transformation code for downstream reports to dbt.
• Migrate OLAP cubes from SQL Server to Snowflake/dbt.
• Support migration of downstream system integrations to Snowflake/dbt.
• Perform testing and validation for all migrated objects and integrations.
•  

Desired Skills & Experience

• Strong SQL & Python proficiency
• Experience with API integrations
• Experience with Azure Data Factory
• Comprehensive understanding of ELT (Extract, Load, Transform) processes and medallion architecture on big data platforms such as Snowflake, Google BigQuery, Amazon Redshift etc
• Familiarity with dbt and best practices for data modeling and transformation
• Familiarity with CICD/devops for data engineering development
• Experience with dashboarding tools such as Power BI, Looker, Qlik, Quicksight etc
• Knowledge of data warehouse migrations and legacy system transitions

  Advantage Zensar We are a technology consulting and services company with 11, 800+ associates in 33 global locations. More than 130 leading enterprises depend on our expertise to be more disruptive, agile and competitive. We focus on conceptualizing, designing, engineering, marketing, and managing digital products and experiences for high-growth companies looking to disrupt through innovation and velocity.
  Zensar Technologies is an Equal Employment Opportunity (EEO) and Affirmative Action Employer, encouraging diversity in the workplace. Please be assured that we will consider all qualified applicants fairly, regardless of race, creed, color, ancestry, religion, sex, national origin, citizen status, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veterans’ status.
  Zensar is a place where you are free to express yourself in an environment that values individuality, nurtures development and is mindful of wellbeing. We put our people and customers at the center of everything that we do. Our core values include: 
 

• Putting people first
• Client-centricity
• Collaboration

Grow. Own. Achieve. Learn. with Zensar