Senior Data Engineer (ETL Developer)

Tbwa Chiat/Day Inc; Canada; On-site; CAD 60,000 - 80,000; Full time

Job summary

An established industry player is on the lookout for a Senior ETL Developer to lead the migration of legacy ETL processes to modern frameworks. This role involves designing complex data feeds and applications using Java and Apache Camel, while ensuring seamless integration and efficient data processing. The ideal candidate will possess a strong background in software development, particularly in ETL processes, and will thrive in a collaborative environment. Join a dynamic team committed to digital transformation and innovation, where your expertise will drive significant impact and contribute to the evolution of data management solutions.

Qualifications

• Extensive experience in Java development and ETL processes.
• Strong skills in SQL and database design.

Responsibilities

• Design and develop complex Java-based applications.
• Collaborate with teams to resolve software issues.

Skills

Problem-solving skills

Analytical skills

Communication skills

Education

Bachelor's degree in Computer Science

Relevant work experience

Tools

Java

Apache Camel

Spring framework

Docker

Kafka

SQL

GitHub

Maven

Azure DevOps

Ansible

Job description

We are seeking a highly experienced Senior ETL Developer who will be responsible for designing and implementing complex Data ETL feeds to replace existing data feeds on a legacy ETL platform. The ideal candidate will have hands-on experience in developing enterprise-level ETL data feeds and possess excellent problem-solving skills. Our client is looking to decommission an existing legacy ETL platform; this person will be focused on migrating all the existing ETL jobs from this platform into Java and Apache Camel framework.

Who we are at Exadel

Exadel is a global software consulting and development company that partners with organizations to help them become digital leaders in their industries. We look beyond the code to understand the impact our clients want to make and help them get from ideation to development and outcomes. We accelerate the results of digital transformations through an open, collaborative approach combined with our deep experience across industries, business processes, and technologies.

Exadel Financial Services is the financial arm of our organization, specializing in banking, capital markets strategy, and technology consulting. Exadel is committed to service excellence and being a great place to work.

Location

Qualifications

• Bachelor's degree in Computer Science, Software Engineering or relevant work experience
• Experience with containerization using Docker (i.e. OpenShift/AWS ECS Fargate, etc.)
• Extensive experience in development using Java, Spring framework, and Apache Camel/Spring Batch for developing complex applications
• Experience in implementing real-time data processing using Kafka, AWS SNS/SQS
• Strong skills in SQL, including experience in database schema design, stored procedures, and SQL queries. Experience using Relational Database (i.e. SQL Server, Oracle, PostgreSQL, etc.)
• Experience in developing ETL jobs on Cast Iron, DataStage, Informatica, etc. ETL platforms
• Proficiency in using DevOps/CI/CD systems such as GitHub, Maven, Azure DevOps, Ansible, etc.
• Strong analytical and problem-solving skills
• Excellent written and verbal communication skills

Nice to Have

• SalesForce Integration
• Python
• AWS data-related services/components (i.e. S3, RDS, Glue, etc.)

Responsibilities

• Design and develop complex Java-based applications using Spring framework, Apache Camel, Kafka, and SQL, etc.
• Work collaboratively with cross-functional teams to identify and resolve complex software issues
• Write clean, well-designed, and maintainable code
• Develop and maintain efficient and secure database schemas, stored procedures, and SQL queries
• Develop and maintain data transformation logic using Apache Camel
• Participate in code reviews and ensure code quality, performance, and security standards are met
• Stay up to date with the latest industry trends, technologies, and best practices related to Java development and related frameworks

Legal Disclaimers

• Exadel is an Equal Opportunity Employer – Minority / Women / Disability / Veteran / Gender Identity / Sexual Orientation / Age
• Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions
• Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties, or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice