Transform XLS Data into SQL
Employer not named by the sourceRemote
Frontier is not the employer and does not collect applications.
About this role
Python, SQL, Database Administration, Database Programming, Data Analysis, Data Integration, ETL, Data Management · I need an experienced data specialist to take an old-format XLS file and move it into my SQL database after applying several transformations. The raw worksheet contains multiple sheets of mixed data types, so before anything is loaded I’ll need column mapping, type casting, and a few calculated fields added (we can review the exact logic together).
Once the transformation rules are approved, please import everything into the live SQL instance and provide: • A repeatable script or ETL package (Python, SSIS, or similar) • A short README explaining how to rerun the job and tweak the mappings • Verification that every record landed in the correct table with accurate data types and relationships
I’ll supply the sample XLS, the current SQL schema, and the transformation notes as soon as we start. Looking forward to a smooth, well-documented import.