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.
...quality in a fast-paced, constantly changing dynamic environment. Preferred Qualifications: Background in computational linguistics or natural language processing. Bachelor's Degree in Computational linguistics, Linguistics Experience in a voice assistant...
...Careers With Purpose Join our not-for-profit organization that has provided over 100 years of housing and services to seniors with... ...residents. The Good Samaritan Society is proud to be one of the largest non-profit providers of senior services in the US. Since our...
...At CVS Health, were building a world of health around every consumer and surrounding ourselves... ...are passionate about transforming health care. As the nations leading health... ...Physician Assistant or Physician) to provide In-Home Health Evaluations, engaging with people...
...State/Province: ArizonaCity: TucsonGeneral OverviewFunctional Area:OPS - OperationsCareer Stream:PRD - ProductionRole:FAA Production 4SAP Short Name:FPD4Job Title:FAA Production Technical Operator 4 Job Code:FPD4-OPS-TOPRJob Level:Band 04...
...and care of the patients in a fast-paced, Level I Trauma and Academic Medical Center. The... ...their patients with a safe and positive experience. Technologists support teaching and continue... ...certification Experience: Entry Level: Limited or no experience; MIT Level...