Description

Lead technical execution of ETL and reporting processes for Canadian Electronic Funds Exchange and Fintrac regulatory compliance.

Responsibilities

• Build ETL processes to ingest daily EFT files from Royal Bank of Canada into local databases.
• Develop logic to convert transactions from CAD to USD and perform data cleansing.
• Engineer aggregation workflows to group transactions by customer.
• Implement tracking for acknowledgements and automate submissions to Fintrac via SFTP.
• Lead technical delivery for regulatory reporting requirements.

Required Skills

• 8+ years of experience with DataStage.
• Extensive experience building ETL pipelines and reporting workflows.
• Proficiency with database management and integration.
• Experience using SFTP for secure file transmission.
• Strong communication skills for technical leadership.
• Ability to work in EST time zone.

Preferred Skills

• Experience with Canadian regulatory reporting processes (EFT and Fintrac).

Key Skills

Education

Any Graduate