This job is closed

We regret to inform you that the job you were interested in has been closed. Although this specific position is no longer available, we encourage you to continue exploring other opportunities on our job board.

Neptune Technology Group - Duluth, GA

posted 15 days ago

Duluth, GA
Computer and Electronic Product Manufacturing

About the position

As an ETL SSIS Software Engineer, you will be responsible for designing, developing, and maintaining ETL processes using SQL Server Integration Services (SSIS) to extract, transform, and load data from various sources into our data warehouse or data lake. This role requires expertise in data integration, SQL, SSIS development, and database concepts. The candidate will work closely with Product Owners to understand business requirements, design efficient ETL solutions, and ensure the reliability and performance of data pipelines.

Responsibilities

  • Understand business requirements and perform technical implementations by leveraging knowledge of enterprise applications and technical expertise.
  • Strong understanding of data warehouse/data lake implementation methodologies/concepts (Ralph Kimball, Bill Inmon, Dimension modelling, etc.).
  • Understand master data management concepts.
  • Design, develop, and maintain ETL processes using SQL Server Integration Services (SSIS) for on-premises and hybrid environments.
  • Develop and optimize SSIS packages for data extraction, transformation, and loading (ETL) from various sources to target databases.
  • Implement error handling, logging, and auditing mechanisms to monitor and troubleshoot SSIS packages for data quality and integrity.
  • Design and implement data integration and orchestration workflows using SSIS.
  • Collaborate with business stakeholders to understand data requirements and translate them into ETL workflows and data mappings.
  • Perform performance tuning and optimization of ETL processes to meet scalability and performance requirements.
  • Document ETL processes, data mappings, technical specifications, and best practices for reference and future maintenance.
  • Stay updated on industry best practices, tools, and technologies related to ETL, data integration, and cloud-based data solutions.
  • Provide end user support, system maintenance/security and incident resolution to ensure stable and resilient business operations of enterprise applications.
  • Ensure enhancements, changes and systems configurations are appropriately documented.
  • Participate in agile team ceremonies including sprint planning, daily stand-ups, backlog grooming, and retrospectives.
  • Maintain professional and technical knowledge by attending educational workshops, reviewing professional publications; develop personal networks, and participate in professional groups.

Requirements

  • Bachelor's degree in business, computer science, or a related field of study, or equivalent experience.
  • SQL Server Certification.
  • Any Cloud DB Certification.
  • 5 + years of relevant experience.

Nice-to-haves

  • Experience with QAD or SAP ERP.
Job Description Matching

Match and compare your resume to any job description

Start Matching
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service