TM1 & Informatica Planning Systems Developer

SGS Consulting
San Diego, CA, United States
about 2 months ago

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
5 years minimum
Working hours
Regular working hours
Job source

Tech stack

Microsoft Excel Data Analysis Information Engineering Data Governance Data Integration Extract Transform Load (ETL) Data Warehousing Enterprise Planning Systems Cloud Services Standard Sql Data Streaming Systems Integration

Job description

The TM1 & Informatica Planning Systems Developer is responsible for designing, developing, and supporting enterprise financial planning and forecasting solutions built on IBM Planning Analytics (TM1) and Informatica-based data integrations. This role bridges Finance, FP&A, and Data Engineering teams to ensure accurate, timely, and governed data flows into planning models supporting budgeting, forecasting, and reporting., TM1 / Planning Analytics

  • Design, develop, and maintain TM1 models, including cubes, dimensions, hierarchies, rules, and feeders
  • Build and support TurboIntegrator (TI) processes for data loading, transformations, validations, and automation
  • Develop and enhance Planning Analytics Workspace (PAW) and/or PA for Excel (PAfE) content
  • Support planning use cases such as Budget, Forecast, OPEX, Revenue, P&L, Balance Sheet, and Cash Flow
  • Implement and manage TM1 security (cube, dimension, element, and application-level)
  • Performance tune TM1 models, rules, and feeders to support scalable enterprise workloads

Informatica / Data Integration

  • Support Informatica mappings, workflows, and schedules to feed data into TM1
  • Partner with data engineering teams to ensure data quality, completeness, and timeliness
  • Support data refresh cycles aligned to financial close and planning timelines

CrossFunctional & Operational Responsibilities

  • Partner with Finance, FP&A, and business users to gather requirements and deliver planning solutions
  • Support UAT, production releases, and hypercare for planning system enhancements or upgrades
  • Troubleshoot data, reconciliation, and performance issues across TM1 and Informatica layers
  • Create and maintain technical documentation, runbooks, and support procedures
  • Participate in planning system modernization, upgrades, or cloud migration initiatives
  • Ensure solutions align with data governance, controls, and audit requirements

Requirements

  • 5+ years of experience in enterprise financial planning systems
  • Strong handson experience with:
  • IBM Planning Analytics (TM1) cubes, rules, feeders, TI processes
  • Informatica (PowerCenter and/or IICS) mappings, workflows, scheduling
  • Solid understanding of financial planning and FP&A processes
  • Experience integrating planning systems with ERP, EDW, or cloud data platforms
  • Strong SQL and data analysis skills
  • Ability to work across business and technical teams

Technologies: What does this temp must know to perform the required job duties(These are not preferred technologies - If they do not have these technologies they will be rejected completely)

Required Education:

Required Years of Experience

5+ years of IT-relevant work experience with a Bachelor’s degree.

OR

7+ years of IT-relevant work experience without a Bachelor s degree.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on dice.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

3:09 min

Balancing data science skillings alongside systems engineering rigor

Nico Schmidt · LIVE

4:06 min

Using ClickHouse as a foundation for fast analytics

Hellmar Becker Hellmar Becker · WWC Europe 2026

1:48 min

Automating exploratory data analysis within training pipelines

Dora Petrella · WWC 2023

2:41 min

Transitioning artificial intelligence infrastructure into scalable commodity cloud services

juarezjunior juarezjunior · WWC 2024

3:46 min

Navigating a career in cloud transformation consulting

Piet Van Dongen · LIVE

1:56 min

Creating immutable blockchain tables using standard SQL syntax

Wei Hu Wei Hu · WWC 2023

Videos

See all

Related articles

See all