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.
...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:...
...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...
...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...
...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...
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...