Staff Software Engineer - ETL Database Developer

Date: Nov 11, 2024

Location: Pune, MH, IN

Company: HMH

HMH Software Engineering

HMH Software Engineering provides cutting edge, individualized learning experiences to millions of students across the United States.  We are as driven by this mission as we are by continuously improving ourselves and the way we work. Our offices are high energy, collaborative beehives of activity where work is centred on small, autonomous teams that build great software.  We trust each other, hold ourselves and our teammates accountable for results, and improve student outcomes with each release.

At HMH we constantly experiment with new approaches and novel ways of solving problems.  We often succeed and sometimes stumble — either way we learn and move forward with more confidence than we had the day before.  We are as passionate about new technologies and engineering craftsmanship as we are about transforming the EdTech industry itself. If this sounds like you let’s talk. 

 

Responsibilities:

  1. ETL Development:
    • Design, develop, and implement ETL processes using Talend to extract, transform, and load data from various source systems into the Data Warehouse.
    • Collaborate with stakeholders to gather and understand data requirements, ensuring the integrity and accuracy of the data throughout the ETL process.
  1. Database Management:
    • Manage and optimize databases, including MySQL or Aurora DB, to ensure optimal performance and reliability.
    • Work with the Data Warehouse team to maintain and enhance the Redshift Data Warehouse, implementing best practices for data modeling and indexing.
  1. Reporting and Visualization:
    • Utilize Jaspersoft tools to create and maintain reports and dashboards for business users.
    • Collaborate with business analysts to understand reporting requirements and ensure the delivery of accurate and actionable insights.
  1. Performance Tuning:
    • Monitor and optimize ETL processes, database queries, and overall system performance to meet the organization's performance and scalability requirements.
  1. Documentation:
    • Create and maintain technical documentation for ETL processes, database configurations, and reporting solutions.
    • Provide training and support to end-users and other team members on data-related tools and processes.

Qualifications:

  • Bachelor’s degree in computer science, Information Systems, or a related field.
  • 10 years of experience working with ETL tools, with a strong emphasis on Talend.
  • Solid experience with MySQL or Aurora DB and Redshift as a Data Warehouse platform.
  • Proficiency in Jaspersoft tools for creating reports and dashboards.
  • Strong SQL skills for data manipulation, analysis, and troubleshooting.
  • Experience in performance tuning and optimization of ETL processes and databases.
  • Excellent problem-solving and communication skills.
  • Ability to work collaboratively in a team environment.

Preferred Qualifications:

  • Master's degree in a relevant field.
  • Certification in Talend or other relevant ETL tools is good to have.
  • Familiarity with cloud-based data warehouse solutions.
  • Knowledge of data governance and security best practices.