DB2 Developer – Fraud/AML Application at Capgemini
Toronto, ON, Canada -
Full Time


Start Date

Immediate

Expiry Date

30 Jun, 25

Salary

29.59

Posted On

31 Mar, 25

Experience

8 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

No

Skills

Data Modeling, Retirement Benefits, Database Design, Performance Tuning, Aml, Architecture, Computer Science, Soft Skills, Devops, Stored Procedures, Bash, Procedure Creation, Access, Scripting, Automation, Damage, Fraud Detection, Azure, Powershell, Interpersonal Skills

Industry

Information Technology/IT

Description

DB2 Developer – Fraud/AML Application (Contract)
Toronto, ON, Canada (On-site)
Contract (9 months 8 days)
Published 5 days ago
SQL, data modeling, stored procedures, ETL
DB2, Oracle, PL/SQL, performance tuning, database design
AWS, Azure, or GCP
Fraud detection, Anti - Money Laundering (AML), banking systems
Cloud database integration, CI/CD practices

TECHNICAL SKILLS:

  • 5–8 years of hands-on experience with DB2 and Oracle development.
  • Proficient in PL/SQL, stored procedure creation, and SQL performance tuning.
  • Strong knowledge of database design, architecture, and data modeling.
  • Experience with cloud-based database platforms (AWS, Azure, or GCP).
  • Proficient in scripting: Unix Shell, Bash, and PowerShell.
  • Familiarity with DevOps tools and methodologies (CI/CD, automation pipelines).
  • Knowledge of data warehousing and big data technologies.

SOFT SKILLS:

  • Strong analytical and problem-solving abilities.
  • Excellent communication and interpersonal skills.
  • Team-oriented with the ability to work independently and manage multiple priorities.

EDUCATION:

  • Bachelor’s degree in Computer Science, Engineering, or related field.

SKILLS SUMMARY:

Core Expertise: DB2, Oracle, PL/SQL, performance tuning, database design
Scripting & Automation: Unix Shell, Bash, PowerShell
Cloud & DevOps: Cloud database integration, CI/CD practices
Tools & Technologies: SQL, data modeling, stored procedures, ETL
Domain Knowledge: Fraud detection, Anti-Money Laundering (AML), banking systems
Soft Skills: Communication, analytical thinking, collaboration
The pay range that the employer in good faith reasonably expects to pay for this position is $29.59/hour - $46.23/hour. Our benefits include medical, dental, vision and retirement benefits. Applications will be accepted on an ongoing basis. Tundra Technical Solutions is among North America’s leading providers of Staffing and Consulting Services. Our success and our clients’ success are built on a foundation of service excellence. We are an equal opportunity employer, and we do not discriminate on the basis of race, religion, color, national origin, sex, sexual orientation, age, veteran status, disability, genetic information, or other applicable legally protected characteristic. Qualified applicants with arrest or conviction records will be considered for employment in accordance with applicable law, including the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act. Unincorporated LA County workers: we reasonably believe that criminal history may have a direct, adverse and negative relationship with the following job duties, potentially resulting in the withdrawal of a conditional offer of employment: client provided property, including hardware (both of which may include data) entrusted to you from theft, loss or damage; return all portable client computer hardware in your possession (including the data contained therein) upon completion of the assignment, and; maintain the confidentiality of client proprietary, confidential, or non-public information. In addition, job duties require access to secure and protected client information technology systems and related data security obligations.

Responsibilities
  • Design and develop efficient and scalable database solutions using DB2 and Oracle for fraud detection and AML systems.
  • Write, maintain, and optimize PL/SQL and stored procedures for high-performance transaction processing.
  • Analyze data models, design database schemas, and define data dictionaries to support system integration and analytics.
  • Perform database performance tuning, query optimization, and troubleshooting.
  • Develop and maintain Unix Shell, Bash, and PowerShell scripts for automation and system integration.
  • Collaborate with cross-functional teams to integrate database components into broader application architecture.
  • Implement and support cloud-based database technologies and ensure compatibility with on-premise systems.
  • Participate in data migration, transformation, and loading activities (ETL) as required.
  • DevOps practices for continuous integration and delivery of database components.
  • Document processes and provide support for deployment and post-implementation activities.
Loading...