ETL Developer Job at CloudVital, Canada

c0VteW9YYk1nV2U3cTZXRlVZbk5HdTlEeEE9PQ==
  • 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

China Global Connections

Research Academic Writing Teacher Job at China Global Connections

 ...and adhering to academic integrity standardsWork closely with teachers across disciplines to integrate research and writing skills into...  ...in the related subjectTeaching certificateThree or more years teaching experience in the subjectExcellent communications skills Salary... 

SimCare AI (YC S24)

Founding Sales Development Representative (SDR) Job at SimCare AI (YC S24)

Join to apply for the Founding Sales Development Representative (SDR) role at SimCare AI (YC S24) .This range is provided by SimCare AI (YC S24). Your actual pay will be based on your skills and experience talk with your recruiter to learn more.Base pay range$75,... 

Arkansas Total Care

Care Coordinator II Job at Arkansas Total Care

You could be the one who changes everything for our 28 million members. Centene is transforming the health of our communities, one person at a time. As a diversified, national organization, you'll have access to competitive benefits including a fresh perspective on workplace... 

Beth Israel Lahey Health

Triage Nurse (RN or LPN) - Women's Health - Full Time, Days Job at Beth Israel Lahey Health

 ...Previous experience in an internal medicine setting preferred.**Licenses/Certifications Required:**+ State of Massachusetts LPN or RN Licensure+ BLS**Benefits working at Anna Jaques Hospital:**+ Tuition Reimbursement+ Career Development and Opportunities+ Free On... 

Towne Automotive

HUMAN RESOURCES GENERALIST/ASSISTANT - BENEFITS Job at Towne Automotive

Join Our Team as a Human Resources Generalist at Towne Automotive!Are you ready to advance your career in an environment where teamwork,...  ...ensuring smooth transitions.Administering group benefits and assisting with enrollment.Maintaining and organizing employee files and...