Epicareer Might not Working Properly
Learn More
K

Data Conversions, SSIS, SQL Server - ETL Developer

Salary undisclosed

Apply on


Original
Simplified

DIRECT CLIENT

15+ months

100% Remote

Position: ETL Developer (Data Conversions, SSIS, SQL Server, Python, ERP Expertise)

We're seeking a dynamic and detail oriented ETL Developer with hands-on experience in large-scale data conversion projects. This role requires a proactive professional who has led or contributed to two or more recent data migration initiatives, particularly involving Db2 and IBM mainframe systems transitioning into MS SQL Server. The ideal candidate will also have strong ERP expertise, with a comprehensive understanding of ERP data models and concepts, and the ability to efficiently migrate data into a custom ERP system.

Requirements:

  • Data Conversion Expertise: Must have led or been significantly involved in data conversion projects in the last two roles, specifically migrating data from Teradata and IBM mainframe systems into SQL Server.
  • SSIS & SQL Server Mastery: Advanced experience in developing and optimizing SSIS packages, alongside proficiency in MS SQL Server with a focus on complex SQL query writing and database performance tuning. Min 8-10 yrs. of SSIS, ETL & SQL Development. Knowledge of MS SQL Server 2012 or later. Experience with SSRS, SSIS, T-SQL; develop SSIS packages.
  • Python Proficiency: Strong Python skills to automate ETL processes and handle intricate data transformations.
  • Data Mapping & Modeling: Demonstrated experience in conducting detailed data mapping and creating precise data models for migration. Strong Data analysis and data migration script creation experience.
  • Data Flow Diagrams: Ability to craft clear and effective data flow diagrams to illustrate migration and transformation processes.
  • Technical Documentation: Proven track record of writing clear, comprehensive technical design documents that communicate complex technical solutions to both technical and non-technical audiences.
  • ERP Data Expertise: Extensive experience working with ERP data models, with a deep understanding of core ERP entities like customers, suppliers, items, and transactions, and the ability to load data into custom ERP systems.
  • Collaboration & Communication: Exceptional communication skills with the ability to work directly with business users, architects, and cross-functional teams, ensuring alignment and understanding of data solutions.
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