Opens LinkedIn
- Employment type
- Contract
- Experience level
- Senior · 5+ years
- Posting language
- English
- Working hours
- 40 hours per week
- Office presence
- 4 days per week
- Seniority
- Not Applicable
- Application method
- Direct apply is available
Job summary
Design, develop, and support IBM DataStage ETL workflows and Python-based data pipelines for banking systems, including data ingestion, transformation, validation, and reporting. Optimize SQL and database objects, ensure data quality and regulatory compliance, and support production operations in collaboration with business, architecture, and compliance teams.
Job details
Role: Datastage Developer Location: Toronto, ON Work Mode: Hybrid (4 Days WFO) Hiring Mode: 6-12 months Contract with extension possible Pay: CAD 55-60/Hr. Description: Experienced Python DataStage Developer responsible for designing| developing| and maintaining ETL/data integration solutions for banking applications. The role involves building scalable data pipelines| automating data processing| supporting regulatory and financial reporting| and ensuring data quality across enterprise systems. Experience with IBM DataStage| Python| SQL| and banking data is essential. Enterprise profiles also emphasize ETL development| data transformation| SQL optimization| and banking domain expertise. Responsibilities: Design| develop| and support ETL workflows using IBM DataStage. Develop Python scripts for data ingestion| transformation| validation| and automation. Create and optimize SQL queries| stored procedures| and database objects. Integrate data from multiple banking systems| including core banking| payments| loans| and regulatory reporting platforms. Perform data quality checks| reconciliation| and troubleshooting of production issues. Collaborate with business analysts| architects| and compliance teams to deliver data solutions. Support batch processing| incident management| and change management activities.Ensure adherence to banking security| governance| and regulatory standards. Required Skills: Strong experience with IBM DataStage ETL development. Proficiency in Python| SQL| and Unix/Linux scripting. Knowledge of Data Warehousing| ETL concepts| and Data Modeling. Experience with Oracle| DB2| Snowflake| or similar databases. Understanding of SDLC| Agile methodologies| and version control tools (Git).
What you’ll do
Design, develop, and support IBM DataStage ETL workflows and Python-based data pipelines for banking systems, including data ingestion, transformation, validation, and reporting. Optimize SQL and database objects, ensure data quality and regulatory compliance, and support production operations in collaboration with business, architecture, and compliance teams.
Requirements
Requires strong IBM DataStage ETL development experience, proficiency in Python, SQL, and Unix/Linux scripting, and knowledge of data warehousing and data modeling. Candidates should have experience with Oracle, DB2, Snowflake, or similar databases, plus familiarity with banking data, SDLC, Agile, and Git.
Listed skills
- SQL · Preferred
- Oracle · Preferred
- Git · Preferred
- Python · Preferred
Other relevant skills
Identified from the job description. Confirm important requirements above.
- IBM DataStage
- Python
- SQL
- Unix/Linux Scripting
- ETL Development
- Data Integration
- Data Warehousing
- Data Modeling
- Oracle
- DB2
- Snowflake
- Banking Data
- Data Quality
- Git
- Agile Methodologies
- SDLC
Job areas
- Data & Analytics
- Technology
- Software
- Finance & Accounting
More jobs from LanceSoft, Inc.
WebMethods Developer
- On-site
- Toronto, ON
- Posted Oct 9, 2026
Terraform Developer
- Hybrid
- Halifax, NS
- Posted Oct 8, 2026
Business Analyst
- Hybrid
- Regina, SK
- Posted Oct 8, 2026
CIAM Delivery Manager
- On-site
- Toronto, ON
- Posted Oct 4, 2026
