SSIS Developer
About The Position
Wipro Limited is seeking an SSIS Developer to design, develop, test, deploy, and support complex ETL solutions using SSIS. This role involves developing and optimizing SQL Server stored procedures, functions, views, and queries. The developer will also create and maintain custom SSIS components and integration solutions using C# and .NET, develop Java-based integrations and utilities, and build and maintain PL/SQL packages, procedures, functions, triggers, and performance tuning solutions. The position requires integrating data across various platforms, performing data mapping, transformation, validation, and cleansing, monitoring ETL jobs, troubleshooting data integration failures, and optimizing ETL workflows. Additionally, the role involves managing SQL Server Agent jobs and scheduling processes, collaborating with business analysts, architects, and stakeholders, participating in code reviews, and supporting production deployments.
Requirements
- Microsoft SSIS
- 5-8 Years of experience
Nice To Haves
- Develop Java-based integrations and utilities for data processing and system connectivity.
- Build and maintain PL/SQL packages, procedures, functions, triggers, and performance tuning solutions.
- Integrate data across various platforms including databases, APIs, flat files, XML, JSON, FTP/SFTP, cloud applications, and enterprise systems.
- Perform data mapping, transformation, validation, and cleansing activities.
- Monitor ETL jobs and troubleshoot data integration failures.
- Optimize ETL workflows for performance, scalability, and reliability.
- Manage SQL Server Agent jobs and scheduling processes.
- Work with business analysts, architects, and stakeholders to gather requirements and translate them into technical solutions.
- Participate in code reviews and enforce development standards and best practices.
- Support production deployments and resolve critical data issues.
Responsibilities
- Design, develop, test, deploy, and support complex ETL solutions using SSIS.
- Develop and optimize SQL Server stored procedures, functions, views, and queries.
- Create and maintain custom SSIS components and integration solutions using C# and .NET.
- Develop Java-based integrations and utilities for data processing and system connectivity.
- Build and maintain PL/SQL packages, procedures, functions, triggers, and performance tuning solutions.
- Integrate data across various platforms including databases, APIs, flat files, XML, JSON, FTP/SFTP, cloud applications, and enterprise systems.
- Perform data mapping, transformation, validation, and cleansing activities.
- Monitor ETL jobs and troubleshoot data integration failures.
- Optimize ETL workflows for performance, scalability, and reliability.
- Manage SQL Server Agent jobs and scheduling processes.
- Work with business analysts, architects, and stakeholders to gather requirements and translate them into technical solutions.
- Participate in code reviews and enforce development standards and best practices.
- Support production deployments and resolve critical data issues.
Benefits
- Full range of medical and dental benefits options
- Disability insurance
- Paid time off (inclusive of sick leave)
- Other paid and unpaid leave options
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
No Education Listed
