**Position: Senior ETL Developer (Datastage/Teradata/Mainframe)**
• *Location : Toronto, Ontario (Hybrid 3 Days)**
• *Position : Full time**
We are seeking an experienced Senior ETL Developer to join our team.
• *Key Responsibilities**:
- Participate in daily stand-ups and all project-related meetings from Data Delivery Squads
- Deliver Impact Analysis and Data Lineage reports.
- Design new ETL jobs (Datastage/ SYSIN) or enhance existing jobs based on project requirements.
- Ensure Job Control Language (JCL) jobs are development ready.
- Complete development testing and necessary documentation.
- Assist the QA team with testing in the QA environment.
- Conduct IST testing and prepare necessary documentation.
- Create or update Technical Design Documents(TDD) as needed.
- Register new JCL names and update the Mainframe Zeke Operation Menu (OMS) as required.
- Collaborate with the project team and production support team for TDD and OMS review meetings.
- Create Change Records for code implementations.
- Monitor job deployments and perform required PIV.
- Prepare handover documents for production support team as required.
• *Must Have skills**:
- 5+ years of Data Warehouse ETL development experience with Datastage, SQL, Stored Procedures, Teradata BTEQ
- 3+ years of Mainframe experience with Job Control Language(JCL), SYSIN, Zeke, DFSort, ICETools, etc.
- Experience with Devops techniques such as GitHub, Jenkins
• *Nice to Have**:
- Hadoop Data Lake (HDFS, Sqoop, Hive, etc
Pay: $90,552.56-$105,167.74 per year
• *Benefits**:
- Dental care
- Life insurance
- Paid time off
Schedule:
- 8 hour shift
• *Experience**:
- datastage: 5 years (required)
- Teradata: 5 years (required)
- Mainframe: 3 years (required)
- Mainframe Zeke Operation Menu (OMS): 2 years (required)
- Language JCL: 1 year (required)
- etl: 8 years (required)
Work Location: In person
