ETL Developer - Finance IT

E-Solutions
Markham, Ontario, Canada
100K $ / an (estimé)
Temps plein

ETL Developer - Finance IT

Monitor Month End & Pre Month End Cycles in accordance with the business requirements

Understand the relationship between data and business outcomes and can focus on long term strategies for data

Participate 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 Projects

Must be able to identify any gaps in the business requirement and assist Business Analyst to rectify the gaps

Introduce 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 team

Support high level end-to-end architecture design from business requirement for ODS / Enterprise data warehouse type systems

Maintain reconciliation procedure (between systems) to facilitate audit trail

Use appropriate ETL tools (Informatica, PL / SQL, Unix shell scripting) to facilitate efficient data transformation

Be proficient in the use of dynamic SQL when data transformation logic is table driven or via configuration file

Improve 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 Methodology
  • Adhere to Agile and development best practices.
  • Perform analysis and defect and issue triage during project development.
  • Other duties as assigned
  • Il y a plus de 30 jours
Emplois reliés
E-Solutions
Markham, Ontario

Monitor Month End & Pre Month End Cycles in accordance with the business requirements . Maintain reconciliation procedure (between systems) to facilitate audit trail. Use appropriate ETL tools (Informatica, PL/SQL, Unix shell scripting) to facilitate efficient data transformation. Work with subcontr...

Atlantis IT group
Markham, Ontario

Role name: ETL Informatica Developer</b></div> <div><b>Location: Markham, ON | Hybrid</b></div> <div><b>Duration: 12 Months</b></div> <div><br /> Role Description: </div> <div> </div> <div>Test Analyst (...

Marberg Staffing Ltd.
Toronto, Ontario

To work on large scale data review, analysis and reporting project, supporting client ministries on operational issues and ad-hoc requests relating to their data compilation and reporting processes. Build data pipelines, data queries and scripts as required. Experience with large-volume data review ...

Sun Life
Toronto, Ontario

We are looking for an Extract, Transform, and Load (ETL) Developer with a strong technical background and cloud experience to join the Corporate Application Solutions (CAS) team. Provide ongoing support and maintenance of AWS Glue ETL and related integration components, including on-call support on ...

Infotek Consulting Services Inc.
Toronto, Ontario

Business group: Rates Derivatives Technology Group. Gather and understand requirements from our Mexico business and technology groups. Liaise with Mexico technology and business stakeholders to ensure deliverable meets their requirements. ...

S.i. Systems
Toronto, Ontario

Our Concord based Client requires the services of a Senior developer/tech Lead with expertise in SQL, Angular, C#,. Design, Tuning, T-SQL) and using SQL Server Management Studio. Expert in JSON and XML query in SQL. ...

OMERS
Toronto, Ontario

In this role, you will be responsible for supporting investment data and analytics delivery from platform systems to a custom data product solution for end users. You will also be responsible for ensuring day to day data quality in our data and analytic reporting. Work with business stakeholders to ...

Wirehead
Toronto, Ontario

ETL tools such as Microsoft SSIS, stored procedures, T-SQL. Development, Database and ETL experience:. Experience in developing and managing ETL pipelines, jobs, and workflows in Databricks. Experience automating ETL pipelines using Delta Live Tables, including handling Change Data Capture (CDC) for...

Viva Tech Solutions
Toronto, Ontario

Data Warehouse ETL development experience with Datastage, SQL, Stored Procedures, Teradata BTEQ. Design new ETL jobs (Datastage/ SYSIN) or enhance existing jobs based on project requirements. ...

CB Canada
Toronto, Ontario

On behalf of our client in the Banking Sector, PROCOM is looking for a SQL Developer. SQL Developer – Job Description. SQL Developer – Mandatory Skills. SQL Developer - Nice to Have Skills. ...