We are looking for SSIS Developer having experience in maintaining ETL solutions using Microsoft SQL Server Integration Services (SSIS).The candidate should have extensive hands-on experience in data migration, data transformation, and integration workflows between multiple systems, including preferred exposure to Oracle Cloud Infrastructure (OCI) of Resources Required : 2 (1 resource with 5+ years exp and 1 resource with 3+ years exp).Please find the below JD for data migration role requirement.We are looking for a highly skilled and experienced Senior SSIS Developer to design, develop, deploy, and maintain ETL solutions using Microsoft SQL Server Integration Services (SSIS).The candidate should have extensive hands-on experience in data migration, data transformation, and integration workflows between multiple systems, including preferred exposure to Oracle Cloud Infrastructure (OCI).
Job Location :
Corporate Office, Gurgaon.
Key Responsibilities
- Design, develop, and maintain complex SSIS packages for ETL processes across different environments.
- Perform end-to-end data migration from legacy systems to modern platforms, ensuring data
quality, integrity, and performance.
- Work closely with business analysts and data architects to understand data integration requirements.
- Optimize ETL workflows for performance and reliability, including incremental loads, batch processing, and error handling.
- Schedule and automate SSIS packages using SQL Server Agent or other tools.
- Conduct root cause analysis and provide solutions for data-related issues in production
systems.
- Develop and maintain technical documentation, including data mapping, transformation logic, and process flow diagrams.
- Support integration of data between on-premises systems and Oracle Cloud (OCI) using SSIS and/or other middleware tools.
- Participate in code reviews, unit testing, and deployment support.
Education :
Bachelors degree in Computer Science, Information Technology, or related field (or equivalent practical experience).
Required Skills
- 3-7 years of hands-on experience in developing SSIS packages for complex ETL workflows.
- Strong SQL/T-SQL skills for querying, data manipulation, and performance tuning.
- Solid understanding of data migration principles, including historical data load, data
validation, and reconciliation techniques.
- Experience in working with various source/target systems like flat files, Excel, Oracle, DB2, SQL Server, etc.
- Good knowledge of job scheduling and automation techniques.
Preferred Skills
- Exposure or working experience with Oracle Cloud Infrastructure (OCI) especially in data transfer, integration, and schema migration.
- Familiarity with on-premises-to-cloud and cloud-to-cloud data integration patterns.
- Knowledge of Azure Data Factory, Informatica, or other ETL tools is a plus.
- Experience in .NET or C# for custom script components in SSIS is advantageous.
- Understanding of data warehousing and data lake concepts.
(ref:hirist.tech)