Developer – ETL

Developer – ETL

ProViso Consulting

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:

• 7+ years of hands-on experience in ETL integrations both Batch and Realtime
• 7+ years of experience with ETL tools like Iway/Talend/Informatica Power center
• 7+ Years of Strong experience in SQL, data modelling, stored procedure, Query writing, optimization of SQL and Performance tuning using IBM DB2/ Oracle databases
• 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
• 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

Job Details



9 Months



Latest Blogs

© 2020 ProViso Consulting - Toronto Recruitment and Staffing Agency

Send this to a friend