Python Integration Engineer ( Canada Candidate )

Role: Python Integration Engineer

Location: Kanata ON, Canada

Skills: Python, ETL processing, Production, High visibility, 8/10 in Python, SQL, Snowflake

Integration Engineer

• Must have experience creating highly efficient and customized warehouse environments that perfectly suits the data storage needs of the company.
• Need to have both design and programming skills as they are also responsible for testing the performance of the system and troubleshooting any problems before it goes live
• Responsible for extracting and copying business data and loading it into a data warehousing environment that they have designed.
• Must have extensive knowledge of coding languages, especially Python and warehouse architecture, and be able to clearly communicate your ideas to the company.

Essential Responsibilities/Duties:

• Designing and coding the data warehousing system to desired company specifications.
• Testing the new storage system once all the data has been transferred.
• Leads the design of the logical data model and implements the physical database structure and constructs and implements operational data stores and data marts.
• Develop/Maintain confluence pages to track all data warehouse implementations and specifications
• Develops logical and physical data flow models for ETL applications.
• Translates data access, transformation, and movement requirements into functional requirements and mapping designs.
• Providing maintenance support.
• Conducting preliminary testing of the warehousing environment before data is extracted.
• Consulting with data management teams to get a big-picture idea of the company’s data storage needs.
• Presenting the company with warehousing options based on their storage needs.
• Extracting company data and transferring it into the new warehousing environment.
• Troubleshooting any issues that may arise.
• Develop/Maintain data mapping confluence pages based on data hosted by company warehouse

Skills:

• Any experience with Regulatory Reporting is a Plus
• Strong project management skills.
• Ability to analyze a company’s big-picture data needs.
• 3+ years’ experience in Finance / Banking industry – some understanding of Securities and Banking products and their data footprints
• Ability to troubleshoot and solve complex technical problems.
• 5+ years - Enterprise Data Management
• Experience withAzure Data Factory and Azure Databricks
• Dimensional modeling experience
• Extensive knowledge of coding languages, includingPython, Java, XML, and SQL.
• Proficiency in warehousing architecture techniques, including MOLAP, ROLAP, ODS, DM, OLTP, OLAP, Dimensions, Facts, Data modeling and EDW.
• Clear communication skills.
• Modeling tools experience, such as Toad Data Modeler, Erwin, and Embarcadero
• PL/SQL Server developmentexperience
• 4+ years with Data Warehouse Architecture, Snowflake experience preferred
• Proven work experience as an ETL developer.
• Hands-on experience with Tasks, Streams, Time travel, Optimizer, Metadata Manager, data sharing
• 5+ years -SQL Server based development of large datasets
• ETL tools experience, such as SSIS
• 5+ yearsPython coding experience