We are currently seeking an ETL developer to design, develop, and maintain ETL processes for data integration and transformation.
Job Role: ETL Developer
Job Type: Full -Time/Contract
Location: Toronto, Canada
This is a Hybrid role with 3 days onsite and 2 days remote!
Responsibilities:
· Collaborate with cross-functional teams to gather and analyze requirements for data integration projects.
· Analyze requirements/specifications, architectural/system design documents
· Implement solution using Azure Data Factory (ADF) pipeline and stored procedure, and Informatica Power Centre to populate enterprise data warehouse
· Develop Azure CI/CD pipeline to automate ADF release
· Implement complex data conversion, e.g., binary to character, EBCDIC to UTF
· Implement complex data transformation(s) for derived and calculated values
· Integrate data sets from diverse source systems
· Implement ADF for initial data load and incremental load
· Promote ADF and Informatica ETL/ELT including: Development, Integration Testing, QA, UAT, Production
· Debug ADF pipeline and stored procedure and Informatica workflow to investigate and fix defects
· Optimize performance of ADF pipeline, Azure SQL and Synapse databases, and Informatica workflow
Skills Required:
· SQL competence (query performance tuning, index management, etc.) and a grasp of database structure are required.
· Understanding of data modelling concepts.
· Extensive experience with ETL tools Informatica Power Centre and Microsoft SSIS
· Extensive experience with Azure Data Factory
· High attention to detail
· Passionate about complex data structures and problem solving
If you are a skilled ETL Developer looking for an exciting opportunity to work with cutting-edge technologies in a collaborative environment, we would love to hear from you.
Job Type Full-time Description Position Title: Human Resources Coordinator Function: Administration - Human Resources Status... ...with company policies. Lead and manage the annual internship and summer internship programs, including assisting with recruitment...
Keep 85% of Gross! | No Credit Check | Start SAME DAY! Drive top-of-the-line trucks: Freightliners Cascadia 20232026 Internationals ProStar 20222025 Peterbilts 20232026 What You Get: 85% of gross revenue Weekly take-home: $2,300$3...
...strive to be the BEST at what we do, through integrity, safety, quality, pride, and excellence in customer service. As a Construction Superintendent, youll play a critical role in upholding these values by overseeing on-site construction projects with precision and care...
...Support. The GCC provides CSSP responsibilities and conducts DODIN Operations and DCO Internal Defensive Measures (IDM) to protect the DODIN IAW the DoDM 8530.01 and the DoD Cybersecurity Services Evaluator Scoring Metrics (ESM). These responsibilities are broken into...
...is required. ~ At least 5 years of experience as a Business Analyst. ~5 years of experience with both Agile and Waterfall methodology... ...in documenting requirements including the creation of Epics, Features and User stories is required. ~5 years of experience...