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.
...Duke Cannon Supply Co. has become one of the fastest-growing brands in the mens grooming category. Our mission is to better the day of hard-working men, and we fulfill this mission through both the products we build and the conversations we create. We are currently...
Our Optical Cable Corporation, a leader in the Fiber Optic Cable Industry, is seeking a Quality Technician to join their team. As a Quality Technician, you will be part of the quality assurance department supporting various teams. The ideal candidate will have strong attention...
DescriptionVitalant is seeking a Mobile Unit Assistant (Blood Drive Assistant - CDL License preferred) dedicated to making a positive... ...for on-location blood drives, along with blood/blood product delivery/transport to donor centers, labs and mobile blood drives. Every...
BECOME A US FOODS DRIVER!$10,000 Retention BonusThis position will report to Ketchikan... .../Skills/Abilities : Safely drive trucks to customers and meet scheduled customer... ...provided in accordance with certain state and local laws. Compensation depends on relevant...
Job SummaryDo you have aerospace / defense painting experience? Are you looking to advance your career?The Position:~Industrial painting... ..., and PTO.** Please note: This is very different from house/apartment painting, so unfortunately, that experience would not...