SSIS Developer / ETL Specialist

Req Id: 105924

City: Louisville

State/Province: Kentucky

Posting Start Date: 10/29/25

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:

Job Description

Job Title: SSIS Developer / ETL Specialist

Role Overview

The SSIS Developer will design, develop, and maintain ETL workflows using SQL Server Integration Services (SSIS) to support data integration, transformation, and loading processes for enterprise data solutions.

Key Responsibilities

• ETL Development
• Design and implement complex SSIS packages for data extraction, transformation, and loading (ETL) from multiple sources (DB2, Oracle, Flat Files, XML).
• Utilize advanced SSIS transformations such as Conditional Split, Fuzzy Lookup, For Each Loop, MultiCast, and Script Components for data processing.
• Implement error handling, logging, and checkpoints for robust package execution.
• Performance Optimization
• Tune SSIS packages and SQL queries for optimal performance.
• Apply best practices for SSIS performance, including parallelization, lookup caching, and bulk loading techniques.
• Integration & Scheduling
• Schedule and monitor SSIS packages using SQL Server Agent.
• Configure credentials, proxy accounts, and permissions for secure execution.
• Testing & Troubleshooting
• Perform debugging and troubleshooting of SSIS packages.
• Conduct backend database testing and validate data integrity.
• Collaboration
• Work closely with BI teams to provide data for analytics and reporting.
• Support Power BI and SSRS reporting requirements when needed.

Qualifications

• 3 years of experience in SSIS development and ETL processes.
• Strong knowledge of SQL Server, T-SQL, and database objects (procedures, functions, views).
• Experience with SSIS performance tuning and troubleshooting.
• Familiarity with data warehousing concepts (Star Schema, Fact/Dimension tables).
• Exposure to Power BI and SSRS is a plus.
• Excellent analytical and communication skills.

Preferred Skills

• Knowledge of advanced SSIS components (CDC Splitter, DQS Cleansing, Fuzzy Grouping).
• Experience in handling large datasets and optimizing ETL workflows.
• Understanding of Agile methodologies.

Mandatory Skills: SSIS .

Experience: 5-8 Years .

The expected compensation for this role ranges from $60,000 to $135,000 .

Final compensation will depend on various factors, including your geographical location, minimum wage obligations, skills, and relevant experience. Based on the position, the role is also eligible for Wipro's standard benefits including a full range of medical and dental benefits options, disability insurance, paid time off (inclusive of sick leave), other paid and unpaid leave options.

Applicants are advised that employment in some roles may be conditioned on successful completion of a post-offer drug screening, subject to applicable state law.

Wipro provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws. Applications from veterans and people with disabilities are explicitly welcome.

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.

Client-provided location(s): Louisville, KY

Job ID: Wipro-105924

Employment Type: OTHER

Posted: 2025-10-30T18:40:46