Epicareer Might not Working Properly
Learn More
E

SSIS and SQL Server developers with master data conversion(14 years exp is must(Remote))

  • Full Time, remote
  • Enterprise Applications Consulting
  • Remote, United States of America
Salary undisclosed

Checking job availability...

Original
Simplified

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

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
Report this job

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

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
Report this job