SSIS Lead

Wipro

5 - 10 years

Bengaluru

Posted: 4/15/2025

Job Description

Please find below the technical skills for SSIS requirement:

 

  • SSIS (SQL Server Integration Services): Proficiency in designing, developing, and maintaining SSIS packages for data integration and transformation.
  • SQL: Strong knowledge of SQL for writing complex queries, stored procedures, functions, and triggers.
  • ETL Processes: Experience with ETL (Extract, Transform, Load) processes, including data extraction from various sources, data transformation, and data loading into target systems.
  • Database Management: Understanding of database design, normalization, indexing, and performance tuning.
  • Data Warehousing: Familiarity with data warehousing concepts and methodologies.

Job Description

Role Purpose

The purpose of the role is to support process delivery by ensuring daily performance of the Production Specialists, resolve technical escalations and develop technical capability within the Production Specialists.  
 

͏

Please find below the technical skills for SSIS requirement:

 

  • SSIS (SQL Server Integration Services): Proficiency in designing, developing, and maintaining SSIS packages for data integration and transformation.
  • SQL: Strong knowledge of SQL for writing complex queries, stored procedures, functions, and triggers.
  • ETL Processes: Experience with ETL (Extract, Transform, Load) processes, including data extraction from various sources, data transformation, and data loading into target systems.
  • Database Management: Understanding of database design, normalization, indexing, and performance tuning.
  • Data Warehousing: Familiarity with data warehousing concepts and methodologies.

͏

  • Handle technical escalations through effective diagnosis and troubleshooting of client queries
    • Manage and resolve technical roadblocks/ escalations as per SLA and quality requirements 
    • If unable to resolve the issues, timely escalate the issues to TA & SES
    • Provide product support and resolution to clients by performing a question diagnosis while guiding users through step-by-step solutions
    • Troubleshoot all client queries in a user-friendly, courteous and professional manner
    • Offer alternative solutions to clients (where appropriate) with the objective of retaining customers’ and clients’ business
    • Organize ideas and effectively communicate oral messages appropriate to listeners and situations
    • Follow up and make scheduled call backs to customers to record feedback and ensure compliance to contract SLA’s

͏

  • Build people capability to ensure operational excellence and maintain superior customer service levels of the existing account/client
    • Mentor and guide Production Specialists on improving technical knowledge
    • Collate trainings to be conducted as triage to bridge the skill gaps identified through interviews with the Production Specialist 
    • Develop and conduct trainings (Triages) within products for production specialist as per target
    • Inform client about the triages being conducted
    • Undertake product trainings to stay current with product features, changes and updates
    • Enroll in product specific and any other trainings per client requirements/recommendations
    • Identify and document most common problems and recommend appropriate resolutions to the team
    • Update job knowledge by participating in self learning opportunities and maintaining personal networks

͏

Deliver

No Performance Parameter Measure
1 Process No. of cases resolved per day, compliance to process and quality standards, meeting process level SLAs, Pulse score, Customer feedback, NSAT/ ESAT
2 Team Management Productivity, efficiency, absenteeism
3 Capability development Triages completed, Technical Test performance

 

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. Come to Wipro. Realize your ambitions. Applications from people with disabilities are explicitly welcome.

About Company

Wipro Limited is a global information technology, consulting, and business process services company based in India. Founded in 1945, Wipro provides a wide range of services, including software development, IT infrastructure management, and business consulting. The company serves various industries, such as banking, healthcare, and manufacturing, and is known for its focus on innovation and sustainability. With a presence in over 50 countries, Wipro is recognized for its commitment to quality and customer satisfaction.

Services you might be interested in

One-Shot Campaign

Reach out to ideal employees in one shot!

The intelligent campaign for reaching out to the ideal audience to whom you can ask for help (guidance or referral).