ETL Developer Intern

About the role

The Wellness Pet Company is seeking a Boomi ETL Developer intern to develop, implement, and support reporting, analytics, and business intelligence solutions for all functional areas at Wellness Pet using the Boomi integration tool.

Responsibilities

• Develop ETL pipelines to acquire and load data from internal and external data sources into a data warehouse using Boomi or Microsoft SSIS.
• Design and develop ETL processes using Boomi.
• Profile data sources to understand the quality and integrity of data sources.
• Conduct unit testing and troubleshooting processes.
• Provide ongoing support for ETL processes.
• Work with the Wellness BI Team on data extraction/modification requirements.
• Provide ongoing support and maintenance of ETL processes.
• Aid in database management and optimization.

Data Management and Quality

• Manage data extraction, transformation, and loading processes.
• Implement data quality checks to ensure accuracy and integrity.
• Maintain and monitor data pipeline performance.

Requirements

• 2-3 years of experience in ETL development with Boomi or any other ETL tool.
• Understanding of SQL Server or Oracle database designs, development, and optimization.
• Possess working knowledge of SQL or PL/SQL.
• Basic understanding of Data Warehousing concepts.
• Adept at developing stored procedures (PL-SQL, T-SQL), functions, queries, and views.
• Experience working with ERP and CRM systems.
• Strong problem-solving and analytical skills.

Qualifications

• Basic knowledge of programming languages: Java, .Net.
• Able to interact effectively with business users to decipher business and technical requirements.

Benefits

The annual salary range for this position is $31.25 to $33.65 an hour, based on a full-time work schedule, anticipated responsibilities, market benchmarks, and organizational equity. Compensation may vary within that pay range depending on the selected candidates professional background, experience, operational needs, and other considerations permitted by law.

Schedule

This individual will work in-office Monday through Thursday each week, and remotely on Fridays. Team members must reside within or be willing to relocate to a commutable distance from our Burlington office.

Skills

• Experience with Boomi or similar ETL tools.
• Understanding of SQL Server or Oracle database designs, development, and optimization.
• Knowledge of SQL or PL/SQL.
• Basic understanding of Data Warehousing concepts.
• Ability to develop stored procedures (PL-SQL, T-SQL), functions, queries, and views.
• Experience with ERP and CRM systems.
• Strong problem-solving and analytical skills.

Benefits

As an equal opportunity employer, the Wellness Pet Company fosters an inclusive work environment and is committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, or veteran status.