Cognos TM1 & CDM

SmartRecruiters, Inc.; Lone Tree (CO); On-site; USD 90,000 - 130,000; Full time

Job summary

Sonsoft, Inc. in the USA seeks a DW ETL specialist with 4+ years in DW ETL and IBM Cognos TM1. You will develop TM1 planning/forecasting apps, implement TI processes to load data, and optimize cube performance.

Strong SQL/PLSQL, data modelling, and experience with Cognos CDM reporting are highly valued. Certification in IBM Cognos TM1 is a plus and TM1 security management is required.

Qualifications

• At least 4 years of experience in DW and IBM Cognos TM1.
• Experience with Financial Planning, Budgeting and Forecasting solutions preferred.
• Certification in IBM Cognos TM1 is a plus.
• Strong analytical and communication skills.

Responsibilities

• Develop and maintain Cognos TM1 Planning/Forecasting/Budgeting applications.
• Create and tune TI processes to load data into cubes and manage dimensions.
• Design active forms and enhance form performance.
• Maintain TM1 security, roles and user management.
• Load and transfer currency data to currency cubes and manage data transfers between cubes.
• Perform data modelling, design and implementation to standards.

Skills

IBM Cognos TM1

IBM Cognos Disclosure Management

Turbo Integrator (TI) Processes

SQL and PL/SQL

Data modelling

Performance tuning

TM1 security management

Cognos CDM development

Cognos TM1 reporting

Education

Bachelor’s degree or foreign equivalent

3 years of relevant work experience in lieu of education

Tools

TM1 Planning/Forecasting

Active Forms

Cognos TM1 security

Job description

Sonsoft , Inc. is a USA based corporation duly organized under the laws of the Commonwealth of Georgia. Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development, Software Consultancy and Information Technology Enabled Services.

Job Description

Job Description:-

• At least 4 years of overall experience in DW ETL related technologies and tools
• Financial background is strongly preferred.
• Experience with Financial Planning, Budgeting and Forecasting solutions strongly preferred.
• Strong Analytical skills.
• Certification in IBM Cognos TM1 is plus.
• Data modelling, design & implementation based on recognized standards.
• Performance monitoring and tuning.

Technical Skills:-

• Skills: IBM Cognos TM1 and IBM Cognos Disclosure Management.
• Hands-on development and performance modeler experience in Cognos TM1.
• Hands-on development of Narrative, Chart, Table and Graph reporting using IBM CDM.
• Develop Turbo Integrator (TI) Processes to load and retrieve data from database tables and other data sources, for creating dimensions, hierarchies, and cubes.
• Maintenance of TM1 users, roles, and security.
• Create complex Active Forms and enhance the performance of existing Active forms.
• Schedule Chores and Monitor Data Loads on timely manner.
• Create TI Processes to transfer currency data to currency cube.
• Create rules to transfer data between cubes.
• Develop and maintain Cognos TM1 Planning/Forecasting/Budgeting Applications.
• Should have work experience in TM1 and CDM environment.
• Strong SQL and PL/SQL background.
• Performance Tuning of Reports, Queries.
• Strong communication skills – written and verbal.

Qualifications

Basic Qualifications :-

• Bachelor’s degree or foreign equivalent required.
• Will also consider 3 years of relevant work experience in lieu of every year of education.
• At least 4 years of experience in DW and IBM Cognos TM1.

Additional Information

**U.S. citizens and those authorized to work in the U.S. are encouraged to apply.We are unable to sponsor at this time.

Note:-

• This is a Fulltime job for you
• Only US Citizen, Green Card Holder,TN Visa, H4-EAD, GC-EAD & L2-EAD can apply.
• No OPT-EAD Consultants please.
  
• Please mention yourVisa Statusin youremailorresume.