Job Description
Role: Senior ETL DeveloperLocation: Markham, ON-HybridDuration: 6+ MonthsJob Description:Monitor Month End & Pre-Month End Cycles in accordance with the business requirementsUnderstand the relationship between data and business outcomes and can focus on long term strategies for dataParticipate in special projects and ad hoc analyses as necessary.Improve ETL performance for enterprise data warehouse system to shorten batch run completion time. Performance improvement from better table/index design and ETL code design.Maintain build and release plans for new functionality and enhancements.Establish and manage procedures for reviewing, estimating, and accepting development work requests on BAU Requests or ProjectsMust be able to identify any gaps in the business requirement and assist Business Analyst to rectify the gapsIntroduce and enforce effective software development practices, coding standards and methodologies aimed at controlling costs and delivering quality solutions on a timely basis while building a strong well-motivated development teamSupport high level end-to-end architecture design from business requirement for ODS/Enterprise data warehouse type systemsMaintain reconciliation procedure (between systems) to facilitate audit trailUse appropriate ETL tools (Informatica, PL/SQL, Unix shell scripting) to facilitate efficient data transformationBe proficient in the use of dynamic SQL when data transformation logic is table driven or via configuration fileImprove ETL performance for ODS and enterprise data warehouse system to shorten batch run completion time. Performance improvement from better table/index design and ETL code design.Lead and champion the continuous development of the Systems Analysis function, promoting and enhancing the Systems Analysis tools/templates, techniques and approaches within the organization.Work with subcontractors and Project Managers to ensure completion of agreed activities.Remain abreast of relevant technology developments.May act as the scrum master in a pod when working with Agile MethodologyAdhere to Agile and development best practices.Perform analysis and defect and issue triage during project development.Zortech Solutions
Apply
Go Back