Job
Description
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. Job Description 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)
