ETL Developer Job at CloudVital, Canada

amlkRmRPcCtpQlM5THJtSU1PcDI0S2V6dmc9PQ==
  • CloudVital
  • Canada

Job Description

Job Description

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 Tags

Full time, Contract work, Remote job,

Similar Jobs

University of Vermont Health - Champlain Valley Physicians H...

Registered Respiratory Therapist - Respiratory Therapy Job at University of Vermont Health - Champlain Valley Physicians H...

 ...available over two years for student loan reimbursement for a 2-year commitment. Certain terms and conditions apply to both offerings. RELOCATION: Relocation package is available to qualified applicants. Additional terms and conditions apply. LEARN MORE:... 

Accel Therapies

Clinical Supervisor, BCBA - Up to 5K Sign on Bonus Job at Accel Therapies

 ...role offers a center-based schedule with some remote work, competitive salary plus bonuses, and a supportive...  ...Location: Council Bluffs, IA (51501) Schedule: Monday - Friday, 8:00 AM 5:00 PM. Enjoy evenings at home! Work Setting: Center-based Remote/ Work From... 

Infotree Global Solutions

Customer Service Representative Job at Infotree Global Solutions

 ...Mexican and Puerto Rican spanish dialects work really well in this role. Candidate...  ...attend ~ 4 week instructor led training Monday through Friday in the office. Hybrid Schedule: In Office...  ...to complete successful work from home environment. PURPOSE OF THE JOB... 

PetSitter.com

Pet Sitter Wanted - Join As A Pet Sitter In Jacksonville, Il Earn $15/Hour Caring For Furry Friends! Job at PetSitter.com

 ...important that you have a genuine passion for pets and can commit to ensuring their well-being and happiness while I'm away.I offer $15 per hour for your time and dedication. If you have experience with dogs and are interested in this pet sitting opportunity, please feel... 

The Wellington Agency

Private Chef in Miami, FL Job at The Wellington Agency

Private Executive Chef - Miami Residence Location: Coconut Grove, MiamiPosition: Full-Time | On-SiteSchedule: Weekdays, full-time. Flexible hours structured around: Lunch around 1:00 PM, Childrens snacks around 3:00 PM and Dinner around 6:00 PM.Compensation: Based...