ETL Developer

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

Responsibilities:
Design and implementation of SSIS, and ETL based on business requirements.
Strong problem-solving and analytical skills. Able to understand business requirements and develop SQL Server solutions that work within the technical boundaries. 
Conduct comprehensive data mapping, data analysis, and data modeling to support ETL processes.
Use Python scripting to automate data transformation processes and streamline ETL workflows.
Write SQL and T-SQL scripts/statements to analyze and translate legacy ERP data into new ERP platform.
Collaborate closely with business stakeholders, architects, and development teams to
translate complex business requirements into robust data engineering solutions.
Create, debug, and execute T-SQL scripts and stored procedures that match data mapping specifications.
Create and maintain detailed data flow diagrams, showcasing the logical flow of data throughout the migration process.
Present insights and technical details to both technical and non-technical teams, ensuring transparent communication across all levels.
Perform quality assurance and database validation on all test and live conversions.
Leverage a strong understanding of ERP concepts to ensure seamless data interpretation and migration strategies.
Work with ERP data models, including customers, suppliers, items, and open transactions, ensuring data is accurately migrated into custom ERP systems.
Ability to learn on the fly. Quickly and effectively integrates new information and skills to enhance personal performance or the performance of the organization. Learns from successes and failures, regards all experience as an opportunity to learn and improve.
Creates jobs for batch and real time processing of data from internal and external sources.
Supports software applications/operating systems through data research and debugging.
Participates in the testing process through test review and analysis, test witnessing and certification of data.
Able to communicate with application technical leads and business users.
Ability to roll up sleeves, dig in and figure out complex problems.