Database Developer

Citigroup Inc.; Mississauga; On-site; CAD 70,000 - 90,000; Full time

Job summary

A leading global financial services company is seeking a Developer for their Data Engineering team in Mississauga. The ideal candidate will have 5-8 years of experience with Java and Apache Spark, responsible for developing and maintaining data solutions while optimizing performance. A bachelor's degree or equivalent is required. This position offers a dynamic work environment focused on innovation and collaboration.

Qualifications

• 5-8 years of relevant experience.
• Strong experience with Java (preferably Java 8++).
• Advanced knowledge of Apache Spark.
• Hands-on experience with JavaCC.
• Proficiency in Hive and Oracle.
• Practical experience with HDFS.

Responsibilities

• Design and implement grammars with JavaCC.
• Build and maintain processors to execute rules.
• Develop and optimize Java integrations with Apache Spark.
• Analyze, interpret, and optimize Spark DAGs.
• Work with Hive and Oracle to extract large datasets.
• Manage data in HDFS for performance and scalability.

Skills

Java

Apache Spark

JavaCC

Hive

Oracle

HDFS

Analytical skills

Problem-solving skills

Education

Bachelor's degree or equivalent experience

Tools

Unix/Linux

Maven

Job description

We are looking for a Developer to join our Data Engineering team. The candidate will be responsible for designing and maintaining grammar using JavaCC, implementing processors and visitors, and developing business rules based on ASTs (Abstract Syntax Trees). This role also involves integrating with Apache Spark applications and working with data stored in Oracle, Hive, and HDFS.

Responsibilities:

• Design and implement grammars with JavaCC and integrate through Visitors.
• Build and maintain processors to execute rules based on ASTs.
• Develop and optimize Java integrations with Apache Spark
• Analyze, interpret, and optimize Spark DAGs to improve job performance and resources usage.
• Work with Hive and Oracle to extract and manipulate large datasets.
• Manage and organize data in HDFS, ensuring performance and scalability.
• Collaborate with team on code reviews, architecture discussions, and continuous improvements.

Qualifications:

• 5-8 years of relevant experience

Required Qualifications:

• Strong experience with Java (preferably Java 8++).
• Advanced knowledge of Apache Spark (DataFrames, job executions, DAG optimizations).
• Hands-on experience with JavaCC (grammar creation, ASTs, visitors).
• Proficiency in Hive and Oracle (queries, large-scale data manipulations).
• Practical experience with HDFS (read/write operations, data organization).
• Strong analytical and problem-solving skills.

Nice to Have:

• Experience in Big Data projects within regulatory or financial reporting contexts.
• Knowledge of distributed ETL and data engineering best practices.
• Experience with Unix/Linux and shell scripting (ksh/bash).
• Familiarity with Maven and CI/CD practices.

Education:

• Bachelor’s degree/University degree or equivalent experience

This job description provides a high-level review of the types of work performed. Other job-related duties may be assigned as required.

Citi is an equal opportunity employer, and qualified candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other characteristic protected by law.

If you are a person with a disability and need a reasonable accommodation to use our search tools and/or apply for a career opportunity review Accessibility at Citi. View Citi’s EEO Policy Statement and the Know Your Rights poster.