SOLUTION ARCHITECT L1

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

Job summary

Wipro Limited in Toronto, Ontario (Canada) is seeking a Senior Data Engineer to design semantic data models, implement SCD Type 1/2, and optimize Spark SQL workflows.

You will develop PySpark solutions, build ETL/ELT pipelines to Synapse on Azure Databricks with Delta Lake, and collaborate with cross-functional teams to deliver scalable data platforms.

Qualifications

• 8-10 years of experience in data engineering or related field.
• Mandatory Skills: DataBricks - Data Engineering.
• Experience with enterprise data modeling, Spark SQL, and PySpark.

Responsibilities

• Translate business requirements into scalable data models.
• Develop and optimize Spark SQL queries and workflows.
• Ingest, transform data with PySpark.
• Build ETL/ELT pipelines to Synapse using Databricks.
• Collaborate with cross-functional teams and stakeholders.

Skills

Spark SQL

PySpark

Data Modeling

ETL/ELT

Delta Lake

Azure Databricks

SCD Type 1/2

Data Warehousing

Data Engineering

Tools

Azure Databricks

Delta Lake

Synapse

Job description

Wipro Limited (NYSE: WIT, BSE: 507685, NSE: WIPRO) is a leading technology services and consulting company focused on building innovative solutions that address clients’ most complex digital transformation needs. Leveraging our holistic portfolio of capabilities in consulting, design, engineering, and operations, we help clients realize their boldest ambitions and build future-ready, sustainable businesses. With over 230,000 employees and business partners across 65 countries, we deliver on the promise of helping our customers, colleagues, and communities thrive in an ever-changing world. For additional information, visit us at www.wipro.com.

Job Description

• Data Modelling & Architecture
  • 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.
• Data Engineering Skills
  • 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.

• Reasonable accommodation will be provided to all applicants including persons with disabilities, throughout the recruitment and selection process.
• Wipro provides equal opportunities to all and values diversity.