Lead Software Engineer
- Toronto, ON, Canada
Full-time
Applications open in a new tab.
Job details
- Job type
- Full-time
- Apply by
- Experience
- Years of Experience: 10-15 Years
- Posting language
- English
- Posted
Original job description
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.
- Extensive experience with ETL tools (e.g., Informatica, Talend, SSIS).
- Strong 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.
- 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.
- 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.
More about this job
Responsibilities
Design, develop, and optimize ETL processes and scalable data solutions, ensuring data integrity, quality, accessibility, and performance. Gather stakeholder requirements, translate them into technical specifications, and provide technical leadership and mentorship to junior developers.
Requirements
Requires 10–15 years of ETL development and data architecture experience, a bachelor's degree in Computer Science, Information Technology, or a related field, and strong experience with ETL tools, SQL, relational databases, data modeling, and database design. Candidates should be able to troubleshoot complex ETL issues and communicate effectively; cloud ETL, big data, and data governance experience are preferred.
Skills
- ETL Development
- Data Integration
- Informatica
- Talend
- SSIS
- SQL
- Oracle
- SQL Server
- Data Modeling
- Database Design
- Data Warehousing
- Data Quality
- AWS Glue
- Azure Data Factory
- Hadoop
- Spark
Visa sponsorship
Not detected in the job text
Categories
- Software
- Technology
- Data & Analytics
- Management & Leadership
Keywords
- ETL
- Data Integration
- Solution Architecture
- Informatica
- Talend
- SSIS
- SQL
- Oracle
- SQL Server
- Data Modeling
- Database Design
- Data Warehousing
- Data Quality
- Data Governance
- AWS Glue
- Azure Data Factory
- Hadoop
- Spark
- Cloud-Based ETL
- Data Architecture
- Data Integrity
- Performance Optimization
- Technical Leadership
- Data Management