Integration Designer - chilliwack, Chilliwack

Job Description/ Responsibilities This will be an integration delivery lead/design level role, where a background in ETL/Informatica development and Java/Microservices is required. The Design Lead will drive integration design including understand the business requirements and processes, data sourcing, data analysis and transformation, apply appropriate integration pattern/technology, and provide design documentation for development and support development and testing team. This person will be required to work with multiple teams (onshore/offshore/nearshore) including the architecture, development, and external application teams. What are the top 3 skills required for this role? Mandatory: • 7+ years Mulesoft, Java/Python Microservices, ETL/Informatica, or Tibco development experience with • Advanced SQL query skills (be able to write, execute, inner/outer joins, aggregations, grouping) • Expertise in Informatica DIH and IICS (will accept Power Center as alternate) • Design of complex data migration/integration expertise (from source data to target data) • Messaging framework experience such as Kafka, Tibco, MuleSoft, Boomi, or other ESB • Experience pulling data from multiple databases (SQL, Oracle, Couchbase, etc -relational and NoSQL) • Experience in Master Data and Transactional Data • Be able to Author design documents including FD and FMD (Field Mapping Document) independently • Excellent communication skills Nice to Have Skills & Experience: Azure SQL Azure Data Lake Azure Delta Lake Azure and AWS Cloud Salesforce integration expertise and SOQL experience IICS Integration delivery lead experience We are an Equal Prospect Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, sexual orientation, or gender identity), national origin, citizenship status, age, disability, genetic information, protected veteran status, or any other characteristic protected by applicable law. Apply on Kit Job: kitjob.ca/job/2o0sb4