Location
Toronto, Ontario
Duration
06 Months
Introduction
Join our dynamic team as a Senior Informatica ETL Developer, where you will play a pivotal role in designing and implementing ETL solutions to support our data warehousing needs.
Required Skills & Qualifications
- 6-8 years of experience in ETL development.
- Proficiency in Informatica PowerCenter 10.x.
- Strong knowledge of Oracle SQL.
- Experience with designing and building data warehousing objects, such as type-2 dimensions, aggregations, and star schema.
- Ability to perform source system analysis.
- Experience in developing stored procedures, database triggers, and SQL queries.
- Skilled in implementing data partitioning strategies in an Enterprise Data Warehouse environment.
- Experience in working with XMLs, XML parser, Java, and HTTP transformation within Informatica.
- Proficiency in Informatica Data Quality (Analyst and Developer).
Preferred Skills & Qualifications
Experience in loading data from SF Power Exchange to a relational database using Informatica.Knowledge of versioning ETL repositories and supporting code.Experience in tuning SQL code for optimization and implementing best practices.Day-to-Day Responsibilities
Participate in the ETL design of new or changing mappings and workflows with the team.Create ETL mappings, clients, workflows, and worklets using Informatica PowerCenter.Collaborate with DBAs and Data Architects to plan and implement data partitioning strategies.Prepare technical specifications and corresponding documentation.Company Benefits & Culture
Inclusive and diverse work environment.Opportunities for professional growth and development.Supportive team culture focused on collaboration and innovation.For immediate consideration please click APPLY to begin the screening process with Alex.