Primary Skills : 1. Hands-on experience with large-scale data migration projects, including legacy-to-Siebel CRM migrations using Siebel EIM. 2. Experienced in Siebel EIM and configuring IFB files to load large volume data into Siebel base tables. 3. Proven expertise in developing and managing ETL processes for complex data transformation and migration tasks. 4. Deep experience with Siebel EIM component, IFB file configuration. 5. In-depth understanding of Siebel party model, Master and Transactional data structures. 6. Proficiency in advanced SQL, PLSQL for data manipulation. 7. Experience in migration tasks automation using Shell Scripting. 8. Strong problem-solving and troubleshooting skills to identify and resolve migration challenges 9. Debugging skill to analyze EIM table failed records. 10. Performance tunning of SQL, PLSQL scripts to execute large volume of data transformation and target system load in minimal time. 11. Experience in Telecom domain. 12. Strong communication andclient-facing skills. Responsibilities : 1. Define staging schema structure ad map data attributes between legacy, staging and target system. 2. Define mapping between Siebel EIM and base tables. 3. Create / Write ETL scripts(Extract transform Load) to read data from source and load data to destination 4. Design and write Data Cleansing and deduplication scripts. 5. Write transformation logic for data transformation. 6. Write error handling scripts to handle exception / missing values and incorporate them into the scripts 7. Write scripts to validate transformed, migrated data accuracy. 8. Write and execute reconciliation scripts post migration to compare source and target data. 9. Conduct performance testing and optimize system downtime during cutover activities. 10. Generate periodic migration reports with detailed analysis of progress and data quality.RTH-Y. - U2XJGL