Technical Lead – IT
Typical Day in Role:
• Act as a technical lead for the data initiative. Deliverable includes: mapping specification, data model, design, creating complex ELT pipelines, conducting unit tests, deployment using devops.
• Working with the business analysts to translate the business requirements and functional specifications into an application design appropriate to meet the business and operational/IT needs
• Work with Quality Assurance (QA) to code, test, and debug extensions/tools integration services
• Analysis, design and development work on complex data pipelines
• Ensuring compliance with architecture framework and system standards, and Agile Development Methodology
• Software Development Lifecycle (SDLC) end-to-end Agile/scrum and Waterfall methodologies
• Primarily working at data ingestion for batch and real time processing
Candidate Requirements/Must Have Skills:
1) 8+ years’ experience as a developer
2) 5+ years’ designing, building, automating and optimizing complex data ETL/ELT processes
3) 8+ years’ creating data assets (denormalized) from highly normalized Oracle database, and load the data asset to another type of DBMS (MS SQL, PostgreSQL, etc.) using demonstrated advanced SQL skills (PL/SQL, TSQL) as well as performance tuning
4) 5+ years’ scripting languages (Java, Python, Unix shell)
5) 5+ years’ experience with data warehousing design and development with focus on extracting, transforming data coming from various data sources and loading into star/snowflake schemas
Nice-To-Have Skills:
1) Familiar with one or more ETL/ELT tools (DataStage, Talend, NiFi, Spark,)
2) Working knowledge of issue tracking system JIRA, Azure DevOps
3) Using Git hub for version control and data model changes
4) Cloud technologies (Azure, Google, AWS)
5) Oracle Exadata
6) Experience from FI/banking an asset
Soft Skills Required:
• Excellent communication skills
Education:
Post-secondary in computer science, engineering, or related technical field