- Assess and analyze existing TM1 TurboIntegrator (TI) processes and data integration workflows currently sourcing data from Amazon Redshift.

- Refactor, remediate, and enhance TM1 TI processes to support connectivity and data extraction from Snowflake.

- Convert and optimize embedded SQL queries for Snowflake compatibility and performance.

- Modify and maintain TM1 data load processes to ensure accurate cube population and data refreshes.

- Validate TM1 cubes, dimensions, rules, feeders, and calculations following migration activities.

- Perform data reconciliation and integrity checks between Redshift-based and Snowflake-based TM1 outputs.

- Support User Acceptance Testing (UAT) by preparing test scenarios, validating results, and addressing business feedback.





- Investigate, troubleshoot, and resolve TM1 integration defects and data issues identified during testing and deployment.

- Collaborate with business stakeholders, data engineers, and project teams to ensure successful migration and implementation.

- Document migration activities, process changes, testing results, and operational procedures.

- Must have experience with IBM Planning Analytics on Cloud. Must have strong SQL knowledge.

- Valuable to have experience with cloud-based data warehouses such as Snowflake and Redshift.

📌 IBM Planning Analytics (Canada)
🏢 KTek Resourcing
📍 Canada