ETL Developer
Location Address: Scarborough once covid restrictions lifted
Contract Duration: End of fiscal year (Possibility for extension or conversion)
Number of Positions: 1
Schedule Hours: 9am – 5pm
Story Behind the Need
Business group: Data & Transaction Revolving Credit, Data & Transaction, Cloud Data & Transactions
Project: Customer Information Systems
Typical Day in Role
– Write well designed, testable, efficient code by using best ETL software development practices
– Attend daily stand ups and follow scrum internally
– Gather and refine specifications and requirements based on technical needs
– Participate in all aspects of a systems development life cycle within the development team (Analysis, Design, Development, Test, QAT, Implementation and Production Support).
– Analyze data requirements and identify data sources and requirements for data migrations, data conversion and data loads into various target applications / repositories
– Technical Documentation, including application, security and end to end solution design and operational support documentation
¬- Act as a subject matter expert in design and development with a comprehensive/detailed understanding of the functional and non-functional aspects of the solution.
– Contribute for a high-performance team culture
Candidate Requirements/Must Have Skills:
1) 7+ years of hands-on experience in ETL integrations both Batch and Realtime
2) 7+ years of experience with ETL tools like Iway/Talend/Informatica Power center
3) 7+ Years of Strong experience in SQL, data modelling, stored procedure, Query writing, optimization of SQL and Performance tuning using IBM DB2/ Oracle databases
4) Experienced in data mapping artifacts, executing jobs using modern data-streaming platforms – preferably Apache Kafka or Talend.
Nice-To-Have Skills:
– Experience in Customer Information System is asset
– 5+ years of Experience in Java/J2ee, Soap/REST webservices
– 5+ years of Experience in Python Scripting
– Experience in Reporting tools like Power BI, CDM and Tableau is an asset
5) Experience working on UNIX, Windows and Linux Operating Systems
– Proficient in integration design patterns, best practices, integration / ETL tools
– Excellent team player by working with cross-departmental business & IT stakeholders, ability to manage the priorities
– Experience implementing ETL systems automation with CI/CD, Job scheduling etc.
Soft Skills:
– adapts easily, is naturally motivated, and wants to make an immediate impact
– strong communication skills – both written and verbal, and is comfortable with interacting with various stakeholders like business experts, scrum master, and middle tier developers, etc.
– Able to speak in layman’s terms, including distilling and communicating technical details to non-technical roles
– strong analytical and problem-solving skills; proactive in solving both current and potential issues
– Excellent communication and presentation skills (written/verbal)
Degrees or certifications:
– Bachelor's degree in a technical field such as computer science, computer engineering or related field required
– ETL certifications are preferred
Candidate Review & Selection
2 rounds : Hiring manager interview and tech round.
Interviews to take place asap