Hi
Hope you are well
We have urgent requirements with our Implementation Partner TCS for the below requirement.
Role: IBM PA TM1 Developer
Location: Dallas, Texas Remote
Visa: GC USC EAD H1B with PP number
Rate $80/hr C2C
Required Technical Skill Set** IBM Planning and Analytics Development
Design the Dimensions and Cubes as per the new Oracle GL accounting structure
2 Develop procedures to support changes in Oracle Account structure
3 Design and development of Data hub for budget data Data ingestion from input data sources, build transformation rules and persist data in consumption layer Integration of financial data in Data hub to IBM PA
4 Interface & Account Mapping - create automated procedures to map with Site Hub information to PA data cubes
5 Update the current budget process to import the budget data to Oracle
6 Budget Planning Analytics Procedures
Create TI procedures to map dimensions with Site Hub information and export the Budget data from TM1 into the csv data extracts for Oracle
Create TI processes to import the Oracle version of Budget data from the Data HUB into TM1 using ODBC connectivity and SQL queries to fetch the required data Security and Maintenance
Create Users and User Groups as per the Business Requirements
Implement Cube, Element and Cell level Security in the IBM PA model as per the Business Requirements
Create Automated Process (Chores) to update the Dimensions as per the latest GL Accounting structure (including unwinding and re-winding of the Hierarchy) followed by updating the Cube data with latest Oracle GL data available in Data HUB
Scheduling the Processes Full / Incremental Loads as per Business Requirements Data Hub
Ingest from data sources and build staging layer
Develop transformation rules and build aggregated/summarized data consumption from PA
Develop data quality & data reconciliation processes for data validation
Orchestrate the data flows via a scheduler and develop exception handling routines