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.
Since its inception, The Parking Spot has made superior airport parking experiences easy and affordable by focusing on hospitality.... ...mobile) Weekly Schedule: ~ Various Shifts Available: Full-Time, Part-Time and On-Call, Flexible Schedule What We Offer:...
...Night Auditors/Guest Service Agents are responsible for the preparation and disposition of all Night Audit work. Responsible for the... ...and name tag when working (per brand standards). Comply at all times with standards and regulations to encourage safe and efficient...
...to apply! Schedule : Monday -Friday, starting between 3-5AM until the route is finished Pay : Drivers average $80-90k /year Guaranteed minimum of $1,100 /week Daily base pay, plus component pay Paid for every mile driven, stop made, and case delivered...
Join to apply for the ETL and Data Warehouse Test Engineer role at NR Consulting1 month ago Be among the first 25 applicantsJoin to apply for the ETL and Data Warehouse Test Engineer role at NR ConsultingGet AI-powered advice on this job and more exclusive features....
...it were our own. About the Role - As a Regional Inside Sales Representative your primary responsibility will be to research,... ...including 1 week of vacation after 6 months and paid winter break. ~ Summer hours (shortened hours on Fridays). Work Environment...