Etl developer Jobs in Markham, ON

Do you have 10+ years experience in data warehousing design and development with focus on extracting, transforming data coming from various data sources and loading into star/snowflake schemas? Do you have 10+ years experience in building mappings and workflows using Informatica PowerCenter and Intelligent Data Management Cloud? If so, this would be a great opportunity for you!

Our client is looking for a Senior Software Developer - ETL for a 12 month contract in North York.

This is an onsite role.

Rate: $555.49 - $591.05



Advantages
• Earn a competitive rate within the industry.

• Location: Onsite role.

• Potential for extension.



Responsibilities
· Support the Business Intelligence and Business Analytics (BIBA) Unit in developing and implementing the technical solutions needed for data acquisition as well as providing operational support ensuring that any technical glitch is quickly addressed.

· Design technical solutions for data acquisition and storage into our centralized data repository.

· Develop ETL scripts, design data-driven logic and conduct unit testing .

· Conduct database modeling and design as to improve overall performance.

· Produce design artifacts and documentation which will allow future support of the implemented solutions.

· Investigate and resolve incidents and identify whether the problem is caused by the data loading code or is due to bad data received from the data provider.

· Execute service requests related to routine and ad-hoc data loads.

· Provide the data quality check and report on the data quality issue.

· Ensure that data collected is in a format which is easy consumable by the business users from Digital and Analytics Strategy Division.

· Re-engineer ETL processes as to make them suitable for Informatica IDMC migration.



Qualifications
MUST HAVES:

• 10+ years experience in data warehousing design and development with focus on extracting, transforming data coming from various data sources and loading into star/snowflake schemas

• 10+ years experience in design, build, automate and optimize complex data ETL/ELT processes

• 10+ years experience in building mappings and workflows using Informatica PowerCenter and Intelligent Data Management Cloud

• Working experience with cloud data warehouse solutions such as Amazon Redshift.



Summary
If you are interested in the Senior Software Developer - ETL in North York, please apply online at www.randstad.ca. Qualified candidates will be contacted.



Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.