Summary: We are seeking a detail-oriented ETL Developer with expertise in data conversion projects, including experience with IBM mainframe systems and SQL Server. The ideal candidate will have deep knowledge of ERP data models and be skilled in developing SSIS packages, writing complex SQL queries, and automating ETL processes using Python.
Position Info
- Title: ETL Developer
- Client: ABC Supply
- Duration: 12+ Months
- Location: BELOIT, WI
- Work Mode: This is remote work for local candidates. When they have job offer, they have to be in BELOIT, WI.
Responsibilities
- Design and implement SSIS-based ETL solutions in alignment with business requirements.
- Conduct data mapping, analysis, and modeling to support ETL processes.
- Automate data transformation processes using Python scripting.
- Write T-SQL scripts to facilitate data migration from legacy ERP systems into new platforms.
- Collaborate with stakeholders to ensure clear communication and alignment on data solutions.
- Create and maintain data flow diagrams illustrating migration processes.
- Perform QA and database validation on both test and live data conversions.
Skills/Qualifications
- 8-10 years of experience in SSIS, ETL, and SQL development.
- Expertise in MS SQL Server, SSIS, T-SQL, and SSRS.
- Proficiency in Python for automating ETL processes.
- Strong experience in data mapping, data modeling, and migration scripting.
- Deep understanding of ERP data models and entities (customers, suppliers, items, transactions).
- Excellent communication and collaboration skills.
- Experience with technical documentation and data flow diagrams.
- Knowledge of Teradata and IBM mainframe systems.
Additional Skills (Good To Have)
- Experience with NiFi, Apache Airflow, Splunk, and Spark.
About Ohm Systems, Inc
Ohm Systems, Inc. specializes in IT and Healthcare staffing services, dedicated to linking highly skilled professionals with our public and private clients across the United States. Our track record showcases our commitment to delivering outstanding staffing and consultancy solutions to our clients. We prioritize diversity and inclusivity and take pride in being an employer that promotes equal opportunities and affirmative action. Our goal is to foster an inclusive work environment that embraces individuals from all backgrounds, irrespective of their gender, race, or orientation.