Python Integration Engineer Jobs

Role: Python Integration Engineer

Location: Kanata ON, Canada

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

Integration Engineer

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

Essential Responsibilities/Duties:

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

Skills:

• Clear communication skills.
• Extensive knowledge of coding languages, including Python, Java, XML, and SQL.
• 5+ years Python coding experience
• Experience with Azure Data Factory and Azure Databricks
• Ability to analyze a company’s big-picture data needs.
• 4+ years with Data Warehouse Architecture, Snowflake experience preferred
• PL/SQL Server development experience
• ETL tools experience, such as SSIS
• Dimensional modeling experience
• Modeling tools experience, such as Toad Data Modeler, Erwin, and Embarcadero
• Strong project management skills.
• Any experience with Regulatory Reporting is a Plus
• 5+ years - SQL Server based development of large datasets
• Proven work experience as an ETL developer.
• 5+ years - Enterprise Data Management
• Proficiency in warehousing architecture techniques, including MOLAP, ROLAP, ODS, DM, OLTP, OLAP, Dimensions, Facts, Data modeling and EDW.
• Hands-on experience with Tasks, Streams, Time travel, Optimizer, Metadata Manager, data sharing
• 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.

Education

• Master’s degree strongly preferred
• Minimally a BA degree within an engineering and/or computer science discipline