Skills

Communication Python Data Governance Workday Test Training Databases Organization AWS

Job Specifications

Job Description:

On behalf of our public sector client, Affinity is looking for an ETL Developer to convert ETL jobs in Informatica PowerCenter to IDMC. Source is Workday, destination is Oracle database. Also, create new integrations and ETL jobs for multiple data sources to create datasets (in Oracle, within AWS) for a Faculty.

Responsibilities:

Work with Enterprise Data Governance and the Data Warehouse team to plan and document the technical migration path for ETL’s. This includes critical data elements, including business use, ownership, data lineage and business rules (calculated fields).
Work closely with data analysts, report owners, data stewards, and data governance teams to help align dataset requirements.
Develop integration plans and system test plans, overseeing testing of new or modified applications and ensures data and applications meet specifications.
Work closely with other data developers, Architects, Cybersecurity, and DBAs to ensure that designs are incorporated into current Technical Specifications as required, and that those specifications are updated as changes occur.
Work with data architect to align with and maintain data models for the data warehouse.
Create ETL job design based on current and evolving infrastructure, and present for peer reviews before implementing.
Conduct testing and validation of data when ETL changes are directly or indirectly applied to data warehouses.
Participate in project planning and implementation.
Documents design, including ETL job details, and table structure changes. Ensures documentation of functions and changes to new or modified modules.
Act as a resource and subject matter expert to business partners to ensure alignment between business unit-level procedures and enterprise reporting.
Maintain positive relationships regarding UDAP matters with relevant cross-functional business partners, providing input and feedback on changing data elements and policies.
Assists in the creation and presentation of business cases.

Qualifications:

Has 5+ years experience coding in IDMC, for a medium or large organization, including designing, developing and implementing ETL jobs. Experience in Informatica PowerCenter is also a strong asset.
Very strong understanding of data modeling, data profiling and data quality concepts and techniques.
Very strong understanding of database design, and data warehouse architectures.
Very strong skills with Oracle and other relational databases.
In-depth knowledge of Workday and AWS.
An understanding of API’s and leading data integration technologies is an asset.
AI and Python training/experience an asset.
Higher Ed experience preferred.
Exceptional written and oral communication skills, including the ability to present ideas and suggestions clearly and effectively.

Affinity Earn:

Know someone who’s great for this, or any of our open roles? Earn up to $4,000/year for each successful referral through Affinity Earn. You can also earn up to $50,000 for helping us find new clients. Learn about our referral program at https://affinity-group.ca/earn/ or browse our jobs & follow us at https://www.linkedin.com/company/affinity-staffing/jobs/

About Affinity:

Affinity Group is a technology and business consulting and services company. We believe in creating long term relationships between clients and consultants that foster a mutually beneficial partnership. Affinity is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. All employment is decided on the basis of qualifications, merit and business need.

For more information on Affinity, please visit www.affinity-group.ca

Job Number: 13054

About the Company

Welcome to Affinity Group -- your trusted partner in business and technology consulting. As a carbon-neutral company certified by ClimatePartner and recognized by the Globe and Mail as one of Canada's fastest-growing companies, we are dedicated to delivering an unrivalled experience for our employees, consultants, and clients. Professional Excellence Across Disciplines: - Cyber Security Solutions: Protecting your operations with cutting-edge security measures. - Data Analytics and Business Intelligence: Transforming data in... Know more