ETL Java developer

Role: ETL Java developer

Term: Full Time

Location: Toronto, ON (hybrid)

Key skills: ETL developer with Java Springboot; MarkitEDM experience preferred but no mandatory; Database/MySQL knowledge and understanding

Role Overview

The ETL & Java Senior Developer will be responsible for designing, developing, and maintaining efficient data integration and management solutions. This role requires proficiency in ETL processes, Java API development, Spring Boot framework, Markit EDM, and MySQL databases. The successful candidate will work closely with business analysts, data architects, and other developers to translate business requirements into technical deliverables, ensuring data integrity, quality, and performance across platforms.

Key Responsibilities

· ETL Development: Design and implement ETL workflows to extract, transform, and load data from diverse sources into target databases or data warehouses. Ensure data pipelines are efficient, scalable, and maintainable.

· Java API Development: Develop, test, and deploy RESTful and SOAP APIs using Java, with a strong focus on using the Spring Boot framework for rapid, production-ready application development.

· Markit EDM Integration: Configure, customize, and maintain Markit EDM (Enterprise Data Management) environments or any similar tools. Build and optimize data models, mappings, and workflows that support data governance, quality, and lineage requirements.

· Database Engineering: Design, implement, and maintain MySQL databases, including schema creation, query optimization, indexing, and troubleshooting performance issues.

· System Architecture: Collaborate with solution architects to design scalable and secure system architectures supporting data integration and API endpoints.

· Testing & Quality Assurance: Develop unit, integration, and regression tests to ensure reliability, accuracy, and performance of code. Participate in code reviews, peer programming, and continuous integration processes.

· Documentation: Create and maintain technical documentation for ETL processes, API specifications, database schemas, and system configurations to facilitate knowledge sharing and onboarding.

· Support & Troubleshooting: Provide ongoing support for data integration solutions, resolve incidents, and proactively monitor system health for continuous improvement.

· Stakeholder Engagement: Work with business stakeholders, analysts, and project managers to clarify requirements, gather feedback, and deliver solutions aligned with business goals.

Required Skills & Experience

· Bachelor's or Master's degree in Computer Science, Information Technology, or a related field.

· 5+ years of hands-on experience in ETL development, preferably using tools such as Informatica, Talend, Apache NiFi, or custom Java ETL solutions.

· Proficiency in Java programming, including experience with Spring Boot for building and deploying microservices and APIs.

· Hands-on experience configuring and using Markit EDM in enterprise data management projects.

· Strong database skills with MySQL, including script writing, query optimization, performance tuning, and troubleshooting.

· Experience designing and implementing RESTful and SOAP APIs, including authentication, authorization, and integration with external systems.

· Understanding of data modeling, data governance, and data quality best practices.

· Familiarity with CI/CD pipelines, version control systems (Git), and agile development practices.

· Excellent problem-solving, analytical, and communication skills.

· Ability to collaborate effectively across cross-functional teams and work independently when required.

Preferred Qualifications

· Experience in the financial services sector or related industry.

· Knowledge of additional RDBMS technologies (e.g., Oracle, SQL Server) and NoSQL databases.

· Experience integrating Markit EDM

· Familiarity with data visualization tools and reporting frameworks.

Certifications in Java, Spring Boot, MySQL, or ETL technologies.

Job Type: Full-time