ETL Developer - Solution Architect

Location: PCS CA~TORONTO

Years of Experience: 10-15 Years

Job Summary: We are seeking an experienced ETL Developer to join our team as a Solution Architect. The ideal candidate will have a strong background in ETL processes and data integration, with a proven track record of designing and implementing robust data solutions. This role requires a strategic thinker who can translate business requirements into technical solutions while ensuring data quality and performance.

Responsibilities

- Design and develop ETL processes to extract, transform, and load data from various sources into data warehouses.
- Collaborate with stakeholders to gather requirements and translate them into technical specifications.
- Architect scalable data solutions that meet business needs and enhance data accessibility.
- Optimize ETL processes for performance and efficiency.
- Ensure data integrity and quality throughout the ETL lifecycle.
- Provide technical leadership and mentorship to junior developers.




- Stay updated with industry trends and best practices in ETL and data architecture.

Mandatory Skills

- Extensive experience with ETL tools (e.g., Informatica, Talend, SSIS).
- Solid SQL skills and experience with relational databases (e.g., Oracle, SQL Server).
- Proven experience in data modeling and database design.
- Ability to analyze complex data sets and troubleshoot ETL issues.
- Excellent communication and collaboration skills.

Preferred Skills

- Experience with cloud-based ETL solutions (e.g., AWS Glue, Azure Data Factory).
- Knowledge of big data technologies (e.g., Hadoop, Spark).
- Familiarity with data governance and data quality frameworks.

Qualifications

- Bachelor's degree in Computer Science, Information Technology, or a related field.
- 10-15 years of experience in ETL development and data architecture.
- Relevant certifications in ETL tools or data management are a plus.

📌 Lead Software Engineer (Toronto)
🏢 Virtusa
📍 Toronto