Log In
Sign Up
Transportation / Logistics
Trane Technologies Hiring For Procurement Operations Manager at Bengaluru, Karnataka Full Time
Responsible for the systems architecture, and development and management of standard analytical tools, for the Global Integrated Supply Chain organization. Translate high-level business requirements to a detailed technical solution. Leverage existing systems architecture, or create new systems architectures, to develop and implement world-class analytic capabilities. Collaborate with internal and external business and IT stakeholders to design and develop the best technical solution. Performance tune systems to increase end user satisfaction. Provide training that maximizes organizational usage/compliance.
I. Requirement Analysis and Design
II. Development and Testing
III. Production Support
1. Work with the Support team to check for Production Errors
2. Provide quick turnaround to solve critical Production Errors
3. Investigation or Analysis of Production Error.
4. Resolution of Production Error
5. Production job/program code correction
6. Production Process correction
7. Infrastructure or Backend Issue correction
Technical Skills
I. Data Warehousing concepts
1. Basic knowledge about Inmon and Kimball Datawarehouse architectures
2. Understanding of the SITN (Subject-Oriented, Integrated, Time-Variant, Non-Volatile) characteristics of a Data Warehouse
3. Understanding of Logical design, Physical design and Data Warehousing Schemas
4. Understanding of Facts, Dimensions (unchanging/static and slowly changing dimensions), Levels, Level relationships
I. Data Warehousing concepts
1. Basic knowledge about Inmon and Kimball Datawarehouse architectures
2. Understanding of the SITN (Subject-Oriented, Integrated, Time-Variant, Non-Volatile) characteristics of a Data Warehouse
3. Understanding of Logical design, Physical design and Data Warehousing Schemas
4. Understanding of Facts, Dimensions (unchanging/static and slowly changing dimensions), Levels, Level relationships
II. Oracle BI Applications
1. Knowledge about the various Oracle Procurement & Spend Analytics Subject Areas like:
- Procure to Pay
- Purchase Orders
- Purchase Cycle Lines
- Purchase Requisitions
- Purchase Receipts
- Employee Expenses
- Invoice Lines
- Purchase Requisition Status
- Supplier Performance
- Supplier AP Transactions
2. Understanding of the OBIA Technical Architecture
3. Understanding of the pre-built ETL tools and code created in Informatica for Oracle Procurement & Spend
4. Basic understanding of the SDE process for PeopleSoft sources, Universal Adapter sources and the various types of Oracle ERP/CRM sources like the Oracle E-Business Suite (EBS).
III. Informatica Power Center – version 9.0.x, 9.1, 9.5.x, and 9.6.x
1. Knowledge about Informatica Architecture
2. Hands-on experience working in Repository Manager, Designer, Workflow Manager, Workflow Monitor
3. Hands-on experience with the following transformations
a. Aggregator Transformation.
b. Filter Transformation.
c. Router Transformation.
d. Lookup Transformation.
e. Rank Transformation.
f. Expression Transformation.
g. Joiner Transformation.
h. Normalizer Transformation.
i. SQL Transformation.
j. Source Qualifier Transformation.
k. Sequence Transformation.
l. Sorter Transformation.
m. Transaction Control Transformation.
n. Union Transformation.
o. Update Strategy Transformation.
p. XML Generator Transformation.
q. XML Parser Transformation.
4. Hands-on experience with the following tasks
a. Assignment
b. Command
c. Control
d. Decision
e. Email
f. Event-Raise
g. Event-Wait
h. Session
i. Timer
IV. Oracle Database 9i/10g/11g/12c
1. Hands-on experience with Oracle SQL, PL/SQL
2. Experience working with the various Oracle objects and concepts like:
- Database links
- Database triggers
- Dimensions
- Indexes and index types
- Materialized views
- Object tables, object types, and object views
- Sequences
- Stored functions, procedures, and packages
- Synonyms
- Views
- Partitions
V. Oracle Data Warehouse Administrative Console (DAC)
1. Understanding of the DAC features that allow the set-up, configuration, administration, and monitoring of data warehouse processes
2. Understanding of the application specific features of DAC like:
- Dynamic generation of subject areas and execution plans
- Dynamic settings for parallelism and load balancing
- Intelligent task queue engine based on user-defined and computed scores
- Index management for ETL and query performance
- Embedded high-performance OTLP change capture techniques
- Restart from any point of failure
- Phase-based analysis tools for isolating ETL bottlenecks
3. Understanding of how DAC organizes and executes Informatica workflows, Stored Procedures, Unix Scripts
VI. Unix/Linux Scripting
1. Basic understanding of the Standard UNIX file system
2. Understanding of file types like Ordinary Files, Directories, Special Files, Pipes
3. Understanding of the Access Permissions read, write, execute and the levels user, group and other
4. Hands-on experience with UNIX scripts and the file and directory commands
We offer competitive compensation and comprehensive benefits and programs that help our employees thrive in both their professional and personal lives. We are proud of our winning culture which is inclusive and respectful at its core. We share passion for serving customers, caring for others, and boldly challenging what’s possible for a sustainable world.
We are committed to achieving workforce diversity reflective of our communities. We are an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identify, national origin, pregnancy, age, marital status, disability, status as a protected veteran, or any legally protected status.