Remote Job
Senior ETL Developer (contract)
Tundra Technical Solutions- 5000 - 6000 USD per Month
- Full Time
- Posted : 3 weeks ago
TITLE
DI ETL Developer - Senior
SCOPE
We offer opportunities you won’t find anywhere else. We have developed and supported some of the most extensive and complex IT systems and online, retail and mobile technologies in Canada. We understand our sister companies’ business opportunities and challenges. We use this understanding to develop solutions and services that drive synergies, efficiencies and cost savings across the Group. Our work transforms the Group’s operations and modernizes their business to meet the demands of the evolving mail, courier, and logistics industries.
Our collaborative nature, combined with cross-industry experience, makes us agile and an exceptionally rewarding place to work.
The Data Integration ETL Developer will be joining a diverse agile Product Team dedicated to delivering Data Analytics initiatives. The DI/ETL Developer will develop and unit test ETL processes to interface data from multiple internal and external systems, satisfying data modeling design, overall performance, business requirements, QA, and production support requirements. The DI/ETL Developer will be a great collaborator in a team setting as working alongside Data Architects, Business Intelligence Report Developers, Data Quality Testers and Project managers is essential in meeting tight timelines.
DUTIES
- Load target data bases using complex transformations that come from many systems.
- Monitor loads and troubleshoot any issues that arise.
- Meet with ETL Design and Project Leads to understand business, financial, and operations requirements and systems goals, and identify and resolve systems issues.
- Participate in the design sessions and Code review.
- Collaborate in the planning, design, development, and deployment of new functionality, and enhancements.
- Develop test scenarios and perform in-depth unit tests, including end-user reviews.
- Define ETL job sequence and dependencies including error logging and restart processes as well as develop ETL run book.
- Understand and develop ETL processes based on BRD (Business Requirements Document).
- Participate in our Agile team meetings
DURATION AND POTENTIAL START DATE
ASAP. 9 months (possibility of extension).
Skills And Experiences
Must Have:
- 3 to 5 years of relevant ETL/DI experience.
- 3+ years of development experience using data programming languages such as Python, Pyspark
- 3+ year experience in IBM infosphere tool suite (DataStage & QualityStage).
- 3+ year development with database technologies. 1+ year experience with data warehousing methodologies.
- Teradata experience
Nice To Have
- Cloud Technologies (Azure, AWS…)
- Familiarity with Agile methodology
- Familiarity with JIRA
LOCATION OF WORK
Remote. Once a month mandatory to come onsite – can go to any office.
HOURS OF WORK
37.5 hours per week
Skills
- pyspark
- Python
- ETL
- Agile
- Design
