Job Description
ROLE: ETL Developer - 12+ month contract
REPORTS TO: Director of Business Intelligence
LOCATION: Remote / Corporate Office in Richmond Hill (Hybrid)
COMPANY OVERVIEW
Venterra Realty is a well-capitalized, privately held investment and technology company with $4.0+ billion in managed assets and $375+ million in revenues. It owns and operates over 75 multi-unit residential properties in the highest growth cities in the United States.
We are honoured to have received numerous workplace recognitions including Fortune Top 100 Best Medium Workplaces for the past six years in a row and having been named a four-time Glassdoor Best Places to Work winner! Read about all of our awards and accolades here!
We are looking for people who:
Have strong personal values and want to work for a values-based company- Are ambitious and hard working with exceptionally high personal standards
- Embrace problem-solving and learning new skills
- Thrive in a rapidly changing and high growth environment
- Are passionate about driving continuous improvements and the use of technology with data to drive business results
THE OPPORTUNITY
Venterra is searching for a ETL Developer for a 12+ month contract term. This role will be specific to working on ETL jobs in Informatica (IDMC/IICS) related to the company wide initiative to migrate our existing financial system to Oracle Fusion Cloud. This role requires both team collaboration with various stakeholders including the data team, the architecture team and the ability to work on most components of the assigned ETL jobs independently. The ETL Developer role reports to the Director of Business Intelligence.
KEY JOB RESPONSIBILITIES
- Design, develop, and maintain ETL processes using Informatica specifically from Oracle Fusion to a SQL Server database.
- Extract data from various sources, transform it according to business requirements, and load it into target systems efficiently.
- Collaborate with stakeholders to gather requirements and understand data integration needs.
- Perform data profiling and analysis to identify data quality issues and implement data cleansing techniques.
- Optimize ETL workflows and transformations to enhance performance and scalability.
- Troubleshoot and resolve issues related to ETL processes, ensuring data integrity and accuracy.
- Implement data validation checks and ensure compliance with data governance and security standards.
- Create and maintain technical documentation for all work products.
SKILLS AND EXPERIENCE FOR SUCCESS
- Minimum of 3 years of experience as an ETL Developer, with a focus on Informatica PowerCenter.
- Strong understanding of data integration concepts and ETL processes.
- Proficiency in designing, developing, and maintaining ETL workflows using Informatica PowerCenter.
- Solid knowledge of SQL and experience working with relational databases.
- Familiarity with data modeling principles, dimensional modeling, and data warehouse design.
- Experience in troubleshooting ETL issues and errors, with strong problem-solving skills.
- Ability to work independently as well as part of a team.
- Relevant certifications in Informatica PowerCenter (preferred).
- Experience with Oracle Fusion Cloud a plus.
QUALIFICATIONS REQUIRED
- Bachelor's or Master's degree in Computer Science, Information Systems, or a related field.
- Proven ability to quickly learn new applications, processes, and procedures.
- Ability to collaborate in a team environment and exercise independent judgement.
- Must be able to effectively communicate with Senior Management and internal business partners.
Venterra Realty is an equal opportunity employer. Accessibility accommodations are available on request for candidates taking part in all stages of the selection process.
Apply
Go Back