SQL/SSIS and Oracle Developer

We are seeking a highly skilled SSIS / SQL Developer with proven expertise in data migration, particularly in migrating large-scale enterprise data from Oracle to Microsoft SQL Server. The ideal candidate will be responsible for designing, developing, and optimizing ETL pipelines using SQL Server Integration Services (SSIS), writing complex T-SQL queries, and ensuring data integrity throughout the migration lifecycle. KEY RESPONSIBILITIES Design, develop, and maintain robust SSIS packages for ETL workflows, data transformation, and automated data loads. Analyze Oracle database schemas, stored procedures, functions, and packages and re-engineer them in T-SQL for SQL Server compatibility. Develop complex T-SQL queries, stored procedures, views, triggers, and functions to support business logic and reporting requirements. Perform data profiling, cleansing, validation, and reconciliation to ensure accuracy and completeness during migration. Collaborate with business analysts, DBAs, and project managers to gather requirements and translate them into technical solutions. Conduct unit testing, integration testing, and performance tuning of ETL pipelines and SQL scripts. Document migratio…