The Hollister Group - Boston, MA

posted about 1 month ago

Full-time - Mid Level
Boston, MA

About the position

The Hollister Group, a leading women-owned staffing firm in the Boston area, is seeking an ETL Developer to join our Technology Staffing team. This role is crucial for connecting top-tier talent with opportunities that align with their skills and ambitions. As an ETL Developer, you will work closely with business users to identify and clarify ETL requirements and business rules, ensuring that the data processes are efficient and effective. You will be responsible for designing, optimizing, implementing, and troubleshooting ETL processes, which are vital for the smooth operation of data management within the organization. In this position, you will create and execute unit test plans based on system and validation requirements, ensuring that all ETL-related work is documented according to standard methodologies. This includes maintaining existing code, fixing bugs as needed, and managing the timely loading and validation of data according to set deadlines. You will also ensure the smooth functioning of development, staging, and production environments, which is essential for maintaining data integrity and availability. The ideal candidate will have a strong background in ETL development, particularly with Informatica, and will possess the skills necessary to handle complex database queries and procedures. This role offers an exciting opportunity to contribute to a dynamic team and make a significant impact on the data processes within the organization.

Responsibilities

  • Work with business users to identify and clarify ETL requirements and business rules
  • Design, optimize, implement, and troubleshoot ETL processes
  • Create and execute unit test plans based on system and validation requirements
  • Document all ETL-related work per standard methodology including specifications for new and existing operational turnover/support
  • Maintain existing code and fix bugs as needed
  • Manage timely loading/validation of data according to set deadlines
  • Ensure smooth functioning of development, staging, and production environments

Requirements

  • 2+ years of ETL developer experience and Informatica experience (SSIS, DTS) required
  • Experience developing ETL processes using Informatica, ETL control tables, error logging, auditing, data quality, etc.
  • Experience with MSSQL 2000 DBMS and above with ability to understand and develop DTS/SSIS
  • Some Unix/Linux scripting experience
  • Strong database development skills such as complex SQL queries and complex store procedures in Oracle and SQL Server
  • Understanding of reusability, parameterization, workflow design, etc.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service