Senior ETL Developer

Job Description :

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