SSIS and SQL Server developers with master data conversion(14 years exp is must(Remote))
Experience
12-14 years of hands-on experience with customer master data conversion using SSIS and SQL Server , with at least 2 major migration projects in the last 3-4 years.
Experience in designing and implementing real-time customer master data synchronization process between legacy and new ERP.
Collaborate with business stakeholders and leads to understand customer hierarchies, account structures, parent-child relationships of customer accounts and work on various customer models.
Direct experience migrating customer data between ERP systems, preferably in construction, roofing, or related industries.
Proven track record troubleshooting and resolving ETL production issues independently.
Understanding of other technologies like informatica , Azure data factory, python.
Experience designing and implementing ETL solutions using SSIS for bulk loading and processing very large datasets.
Technical Skills
Expert-level ability to design, develop, and optimize ETL packages using both SSIS and Informatica for complex data migration scenarios.
Advanced SQL Server scripting skills with ability to write and troubleshoot complex queries, stored procedures, and functions using T-SQL.
Should be able to diagnose, optimize, and fix performance issues, data quality problems, and failed ETL processes in production environments.
Strong Python programming skills with experience integrating various APIs for data extraction and transformation.
Expertise in comprehensive source-to-target mapping and data profiling techniques to ensure data quality and integrity
Experience developing ETL processes that efficiently handle very large datasets with optimized bulk loading techniques
Experience
12-14 years of hands-on experience with customer master data conversion using SSIS and SQL Server , with at least 2 major migration projects in the last 3-4 years.
Experience in designing and implementing real-time customer master data synchronization process between legacy and new ERP.
Collaborate with business stakeholders and leads to understand customer hierarchies, account structures, parent-child relationships of customer accounts and work on various customer models.
Direct experience migrating customer data between ERP systems, preferably in construction, roofing, or related industries.
Proven track record troubleshooting and resolving ETL production issues independently.
Understanding of other technologies like informatica , Azure data factory, python.
Experience designing and implementing ETL solutions using SSIS for bulk loading and processing very large datasets.
Technical Skills
Expert-level ability to design, develop, and optimize ETL packages using both SSIS and Informatica for complex data migration scenarios.
Advanced SQL Server scripting skills with ability to write and troubleshoot complex queries, stored procedures, and functions using T-SQL.
Should be able to diagnose, optimize, and fix performance issues, data quality problems, and failed ETL processes in production environments.
Strong Python programming skills with experience integrating various APIs for data extraction and transformation.
Expertise in comprehensive source-to-target mapping and data profiling techniques to ensure data quality and integrity
Experience developing ETL processes that efficiently handle very large datasets with optimized bulk loading techniques