SOLUTION ARCHITECT L1

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

Job summary

Wipro is seeking an experienced data architect to design solution architectures for cross-system interactions and business logic integration in a Canadian project. You will lead requirements discussions, design scalable data pipelines, and ensure seamless interoperability across multiple applications while leveraging Azure services and evolving analytics capabilities.

The role emphasizes data governance, real-time/near real-time data processing, and delivery of robust reporting via Power BI

Qualifications

• 8+ years of SDLC experience with an Azure-focused background.
• Experience with Azure Data Factory, Databricks, Synapse, and Snowflake.
• Proficient in SQL, Azure SQL Database, and data modeling.
• Experience with Power BI reporting and analytics.

Responsibilities

• Participate in requirement discussions with stakeholders to define needs.
• Create solution architecture designs for cross-system interactions and data integration.
• Assess and support integrations across applications and data pipelines.
• Validate solution components during implementation to ensure correct functionality.
• Identify risks by evaluating system performance of architectural solutions.

Skills

Azure data stack

Data modeling

SQL

Spark

ETL/ELT

Power BI

Tools

Azure Data Factory

Databricks

Snowflake

Synapse Analytics

Job description

Job Description

Job Description

Role Purpose

The purpose of this role is to design solution architecture for cross-system interactions and business logic integration, ensuring seamless interoperability across multiple applications.

Area of Responsibility

Requirement Analysis-Participate in requirement discussions with client stakeholders to define solution and implementation level needs basis the business requirements.

Designing-Create solution architecture designs to meet cross-system interactions and business logic integration requirements, ensuring system cohesion across multiple applications.

Integration assessment and support-Assess and evaluate interactions across multiple applications by evaluating implementation dependencies and integration requirements.

Troubleshooting-Support validation of solution components during implementation and ensures the solution functions as designed.

Risk Analysis and Assessment-Assist in identifying potential risks by evaluating system performance of implemented architectural solutions, to ensure efficient system landscape.

• IT Professional 8+ years of comprehensive experience in the Software Development Life Cycle (SDLC), specializing in Azure stack with a proven track record of leveraging Microsoft Azure/Cloud Services to architect and implement scalable data solutions. Skilled in utilizing SQL Data Warehouse, Azure SQL Server, Snowflake, Azure Data Lake, Azure Blob Storage, Azure Databricks, and Azure Data Factory for efficient data processing, storage, and analytics (power BI)
• Design and implement scalable data pipelines using Azure Data Factory, Azure Databricks, Synapse and Snowflake Analytics.
• Develop data models and optimized data storage solutions using Azure SQL Database, and Azure Data Lake (Blob Storage).
• Experience in Azure fabric frame work (creating lake house, ware houses)
• Experience in working with One lake and delta lake for fabric workspaces.
• Experience in migration of on-premises data warehouse to Snowflake, Azure Synapse Analytics, enhancing data accessibility and reporting capabilities.
• Experience in designing and developing scalable data processing frameworks using Apache Spark, enabling efficient processing and analysis of large datasets in both batch and streaming modes.
• Proficiency in Pyspark, SparkSQL for developing notebooks in Databricks
• Experience in Spark SQL for developing notebooks in synapse.
• Have Worked on Event Hubs for processing streaming data in to Databricks.
• Experience in loading/writing data in to Azure data lake using ADF, Databricks, Synapse Analytics
• Proficiency in writing complex SQL queries and stored procedures. Proficient in optimizing data-base performance, ensuring efficient data retrieval, and implementing robust data manipulation logic.
• Proficiency in creating near real-time data pipelines, Enterprise Data Warehouses (EDW), DataMart’s, and audit and control frameworks. Skilled in designing and implementing solutions that ensure data integrity, compliance, and efficient reporting.
• Implemented CI/CD pipelines using Azure DevOps, including automated build, test, and deploy-ment processes.
• Designed and implemented a comprehensive framework of controls for the data governance team, ensuring data adheres to standards of accuracy, completeness, consistency, and compliance.
• Led the design and development of robust data loading frameworks and products, enabling efficient and reliable data ingestion, transformation, and integration across multiple platform

Design and develop dashboards, reports in Power BI tool

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.