Job Description
Role Purpose and Overview
The Technical Lead - SSIS at Wipro Technologies will play a pivotal role in overseeing the end-to-end delivery of data integration and transformation projects within the TS - DATA ANALYTICS & AI sector. This role demands a strong technical acumen to lead the performance of Production Specialists, resolve complex technical escalations, and foster the development of technical skills within the team. This leadership position requires a combination of process management, technical expertise, and team collaboration to ensure the consistent and reliable execution of ETL pipelines, data accuracy, and overall project success.
As a key member of the Decision Sciences practice, you will work closely with cross-functional teams to design, develop, and optimize ETL processes, contributing to high-quality data analytics solutions that empower business decisions. This role offers an excellent opportunity to influence data warehousing architecture, enhance operational efficiency, and advance your professional growth in a dynamic and innovative environment.
͏
- Lead and architect scalable ETL solutions utilizing Microsoft SQL Server Integration Services (SSIS) to effectively extract, transform, and load data from various complex source systems.
- Develop, test, and deploy advanced SSIS packages ensuring robust data pipelines that support business intelligence and analytics needs.
- Implement comprehensive error handling, logging mechanisms, and auditing within SSIS packages to maintain transparency, traceability, and reliability of ETL processes.
- Maintain and ensure high standards for data accuracy, completeness, and consistency across multiple data integration pipelines and environments.
- Collaborate with data analysts, architects, and other stakeholders to continuously improve data warehousing solutions by leveraging technologies like SSAS, SSRS, and Power BI.
- Support the team by providing technical guidance, mentoring, and knowledge transfer to build workforce capability and foster a culture of continuous learning.
- Demonstrate proficiency in TSQL and data warehousing principles to design efficient data models and workflows aligning with business requirements.
- Drive best practices in ETL development and data governance ensuring compliance with organizational and industry standards.
͏
Performance Metrics and Deliverables
| No | Performance Parameter | Measurement Criteria |
|---|---|---|
| 1 | Process Excellence | Number of cases resolved daily, strict adherence to defined process and quality standards, consistent achievement of process-level SLAs, positive pulse survey scores, and customer feedback metrics including NSAT and ESAT. |
| 2 | Team Management and Leadership | Monitoring and enhancement of team productivity and efficiency levels, managing absenteeism rates, and fostering a supportive and high-performance team culture. |
| 3 | Capability Development | Completion rate of technical triages, performance scores on technical assessments, and ongoing skill development initiatives within the team. |
͏
Core Competencies
- Client Centricity: Demonstrates a thorough understanding of client needs and delivers tailored solutions that exceed expectations.
- Passion for Results: Exhibits dedication and drive to achieve outstanding outcomes and contributes to organizational success.
- Execution Excellence: Consistently delivers high-quality results within deadlines and maintains high standards of accuracy and reliability.
- Collaborative Working: Builds productive relationships across teams, fostering open communication and mutual respect.
- Learning Agility: Proactively seeks new knowledge and adapts quickly to evolving technologies and methodologies.
- Problem Solving & Decision Making: Applies analytical thinking to identify issues, evaluate alternatives, and implement effective solutions.
- Effective Communication: Articulates technical information clearly and concisely to both technical and non-technical stakeholders.
͏
Mandatory Skills and Experience
- Proven expertise in Microsoft SQL Server Integration Services (SSIS) with substantial hands-on experience designing and managing complex ETL packages.
- Strong command over related Microsoft data platform tools including SSAS (SQL Server Analysis Services), SSRS (SQL Server Reporting Services), and Power BI for analytics and reporting.
- Hands-on experience with TSQL scripting and comprehensive exposure to data warehousing concepts, design, and implementation.
- Demonstrated ability to lead and mentor technical teams, fostering continuous improvement and knowledge sharing.
- Minimum of 5 to 8 years of relevant industry experience, preferably within data analytics, business intelligence, or related technology domains.
About Wipro Technologies
At Wipro Technologies, we are committed to building a modern enterprise grounded in the spirit of continual reinvention. As an end-to-end digital transformation partner, we empower our clients to embrace bold ambitions and navigate the evolving technological landscape. Joining Wipro means becoming part of a culture that values inclusivity, innovation, and purpose-driven work. Here, your career growth is supported by rich opportunities to develop new skills and take ownership of your professional journey. Embark on a rewarding path with us, where your contributions matter and your potential is realized through collaborative, meaningful projects.
Experience: 5-8 Years .
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.