SOLUTION ARCHITECT L1

Wipro; Toronto; On-site; CAD 100,000 - 150,000; Full time

Job summary

Wipro in Toronto, Ontario, Canada is seeking an experienced Data Engineer with 8-10 years of hands-on expertise in Spark SQL, PySpark, and Delta Lake to design scalable data models and ETL/ELT pipelines. You will work with Azure Databricks to ingest, transform, and load data into Synapse, collaborating with business stakeholders to deliver trusted analytics.

The role requires strong communication, independence, and problem-solving. Wipro is committed to an inclusive workplace.

Qualifications

• Strong understanding of enterprise data modelling and analytics
• Experience designing dimensional models (star/snowflake)
• Hands-on with Slowly Changing Dimensions (Type 1 & Type 2)
• Ability to translate business requirements into scalable data models

Responsibilities

• Translate business requirements into scalable data models
• Build and optimize ETL/ELT pipelines using Azure Databricks
• Develop and optimize Spark SQL queries and analytics
• Collaborate with cross-functional teams and stakeholders

Skills

Spark SQL

PySpark

Delta Lake

Azure Databricks

Data Modeling

SCD Type 2

Tools

Spark

SQL

ETL/ELT

Job description

Job Description

• Strong understanding of semantic models used in enterprise reporting and analytics.
• Expertise in dimensional modelling, including star and snowflake schema design.
• Practical experience implementing Slowly Changing Dimensions (SCD) Type 1 and Type 2.
• Ability to translate business requirements into scalable data models.
• Advanced Spark SQL
• Proficiency in Spark SQL, including complex joins, aggregations, and transformations.
• Strong command over window functions, ranking functions, and analytical queries.
• Ability to troubleshoot performance issues and optimize Spark SQL queries.
• PySpark Development
• Working knowledge of PySpark for data ingestion, transformation, and workflow orchestration.
• Ability to write and understand basic pyspark functions
• Basic understanding of Spark architecture, including executors, partitions, and caching.
• Experience building ETL/ELT pipelines using Azure Databricks and load to Synapse.
• Familiarity with Delta Lake, data versioning, and ACID transactions.
• Independence & Collaboration
• Ability to work independently with minimal oversight.
• Strong communication skills to collaborate with cross-functional teams and business stakeholders.
• Proactive in identifying issues and proposing data-driven solutions.

Mandatory Skills: DataBricks - Data Engineering .

Experience: 8-10 Years

The expected compensation for this role ranges from CAD 100000 to CAD 150000 .

Reinvent your world. We are building a modern Wipro. We are an end-to-end digital transformation partner with the boldest ambitions. To realize them, we need people inspired by reinvention. Of yourself, your career, and your skills. We want to see the constant evolution of our business and our industry. It has always been in our DNA - as the world around us changes, so do we. Join a business powered by purpose and a place that empowers you to design your own reinvention.

Wipro is committed to creating an accessible, supportive, and inclusive workplace. Reasonable accommodation will be provided to all applicants including persons with disabilities, throughout the recruitment and selection process. Accommodations must be communicated in advance of the application, where possible, and will be reviewed on an individual basis. Wipro provides equal opportunities to all and values diversity.