11+ OTM Jobs in Bangalore (Bengaluru) | OTM Job openings in Bangalore (Bengaluru)
Apply to 11+ OTM Jobs in Bangalore (Bengaluru) on CutShort.io. Explore the latest OTM Job opportunities across top companies like Google, Amazon & Adobe.
Minimum 4 to 14 Years OTM Technical / Functional experience
- Must have functional and techno-functional experience in OTM implementation and/or have supported projects dealing with these systems, and/or have worked on OTM Cloud
- Must have strong technical and functional knowledge of the latest OTM Application
- Must have knowledge of preparing mapping document to interface OTM system with EDI, WMS, order management and finance systems, and be able to translate the functional specifications into design specifications for the Offshore Delivery Centre
- Must have ability to write SQL statements for automation agents and other technical topics
- Hands on experience on JSPX/XSL will be additional advantage.
- Experience in end-to-end OTM life cycle/implementations/up-gradation and OTM architecture will be preferred
Briefly describe Mandatory Skills:
We are looking for a MIS Analyst to participate with other Analysts in the team to convert the data into reports in various forms and thereby provide meaningful insights to the users of the reports and help them in decision making process. Experience Level – 1-2 yrs. of experience as MIS executive/analyst Responsibilities - · Managing the data including creation, updates, and deletion · Collecting the data, interpreting, analyzing, and developing the reports and dashboards · Generating reports from single or multiple systems · Processing confidential data and information according to the guidelines · Create visualizations and reports for requested projects in MS Excel and PowerBI platforms · Develop and update documentation Skills / Requirements - · Strong knowledge and experience in Advance MS Excel (MUST HAVE) · Basic knowledge of reporting tools like Power BI or Tableau · Basic Knowledge of SQL queries · Strong mathematical and analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy · Ability to analyze large data set and create meaningful visualization and reports · Analytical mind with a problem-solving attitude · Excellent communication · BSc/ MSc in Computer Science MSc/MCA, Engineering, or relevant field |
L2 Support
Location : Mumbai, Pune, Bangalore
Requirement details : (Mandatory Skills)
- Excell communication skills
- Production Support, Incident Management
- SQL ( Must have experience in writing complex queries )
- Unix ( Must have working experience on Linux operating system.
- Pearl/Shell Scripting
- Candidates working in the Investment Banking domain will be preferred
Job Description
Education : Graduation in Computer Science
Job Description :
Around 3 years of professional experience in Oracle Applications 11i / R12 as Technical Consultant.
Expertise in developing the reports using Report Builder , Discoverer and XML Publisher. Having Technical knowledge in various modules like OM , FA , GL , AP , PO , INV , AR , CM and AOL.
Oracle Database Upgrade 9i to 11g.
Database Patching , Space Management Purging Archiving , Connectivity Issue Tablespace Creation , Modification , Deletion , Troubleshooting Concurrent Manager , Monitoring Application Performance
Excellent Knowledge in Oracle (SQL , PL / SQL , Reports 10g).
Good exposure with SQL Loader.
Good Knowledge on Technical architecture and functional flow of Oracle Applications modules such as Account Payable , Account Receivables , Purchasing , General Ledger , Fixed Assets , Inventory and Order Management.
Having good experience in designing and preparation of documents likeMD70 , MD120 and TE20 as a part of Object Deliverables.
Worked on Inbound Interfaces for e.g. (AP Invoice , GL Interface , AR Invoice etc.).
Experience in designing and development of Conversion Programs to load data from Legacy system to Oracle Applications with effective validation logic and Error handling mechanism (Supplier Conversion , Item Conversion).
Job Description
Experience: 3 to 5 Yrs
Job Location: Bangalore (Work from office from the date of joining)
Shifts: General Shifts
Notice Period: Immediate
Skills Required:
- Experience 3 to 5 years of relevant experience in PeopleSoft
- Should have good knowledge of various PeopleTools Objects Components, Pages, Application Engine, SQR, and Component Interface.
- Should be able to create PS Query, SQR reports
- Should know Financials modules in Billing, AP, and GL.
- Should be able to write SQL scripts for data migration and data correction
Skills
PEOPLESOFT FINANCIALS, PEOPLE TOOLS, SQL
It's a worldwide service provider company.
JD – Attached Sample Profile for Reference
1) WebFOCUS BI Reporting
2) WebFOCUS Adminstration
3) Sybase or Oracle or SQL Server or Snowflake
4) DWH Skills
Nice to have
1) Experience in SAP BO / Crystal report /SSRS/ Power BI
2) Experience in Informix
3) Experience in ETL
Responsibilities
• Technical knowledge regarding best practices of BI development / integration.
• Candidate must understand business processes, be a detailed-oriented person and quickly grasp new concepts.
• Additionally the candidate will have strong presentation, interpersonal, software development and work management skills.
• Strong Advanced SQL programming skills are required
• Proficient in MS Word, Excel, Access, and PowerPoint
• Experience working with one or more BI Reporting tools as Analyst/Developer.
• Knowledge of data mining techniques and procedures and knowing when their use is appropriate
• Ability to present complex information in an understandable and compelling manner.
• Experience converting reports from one reporting tool to another
Informatica PowerCenter (9x ,10.2) : Minimum 2+ years experience
SQL / PLSQL: Understanding of SQL procedure. Able to convert procedures into Informatica mapping.
Good to have- Advantage if you have knowledge of Windows Batch Script.
What essential skills you need
- 4 -6 years’ experience in MySQL database development. You know your way around problems,logic & code but you occasionally need help with how to do things. That’s cool with us. We usestack overflow too.
- Expertise in database design & development (preferably on MySQL).
- Expertise in writing complex SQL queries, stored procedures, and functions, triggers.
- Expertise in performance tuning, query optimization, using performance monitor, SQL Profiler andother related monitoring and troubleshooting tools.
- BE/B.Tech ( or equivalent education), good written & communication Skills.
- 5 to 8 years of hands on experience in automating MS Office applications like Excel, Word, PPT and Outlook using VBA
- 5 plus years of experience in the design, development, and implementation of programming code
- Experience in database development
- VBA - Should have good experience in developing efficient logic/algorithms using VBA
- Solid understanding of SDLC concepts
- Solid experience in MS Excel (2003, 2007, 2010, 2013,2016)
- Must be good at all excel features and excel formulas
- Well versed with complete MS Office package (Excel, Word, Outlook, PPT)
- Work both independently and as part of a team
- Experience in requirements gathering, effort estimate, designing and implementation and creating mock-up screens
- Experience in databases like MS SQL Server (2005 to 2012,2014), MySQL and MS Access
- Must have strong database concepts and DB designing skills
- SQL - must be good at writing efficient, fine-tuned queries using joins and aggregates
- Experience in writing Stored procedures, Triggers and T-SQL
- Nice to have programming knowledge in C#
- VBA, SQL
- Strong analytical and problem-solving skills
- Excellent interpersonal and communication skills
- Should be able to take complete ownership of the project from requirements gathering to delivery and maintenance
- Should be able to work independently
- Must be Proactive and Self-motivated
- Must have the ability to prioritize the work, execute tasks and meet the deadline without fail
- Effective time management skills
- Customer Focus, Willing to learn and self- teach any new technology
- Strong business and collaboration skills, and responsive to service needs and operational demands.
Job Title: |
Senior Cloud Service DBA |
||
Department & Team |
Technology |
Location: |
INDIA |
Reporting To: |
Senior DBA – Team Lead |
Role Purpose: |
This role will be a mix of project, BAU and innovation and will encompass typical database administration duties that you may expect in a large-scale telecommunications environment: performance tuning, replication, database design, backups, high availability, encryption, security, configuration etc.
1. Network Services Team – Responsible for IP Network and its associated components 2. Infrastructure Team – Responsible for Server and Storage systems 3. Database Services Team – Responsible for all Databases 4. Cloud Architect Team – Delivering future strategy, ongoing cloud performance optimisation.
The DBA function forms part of Client’s Tier 3 support function and works closely with the internal NOC, Service Desk, Infrastructure, IP Networks and Cloud Architect teams. To enable the business in achieving its stated objectives by assisting the other technology teams to achieve world-class benchmarks of customer service and support.
To highlight, a key requirement of the role will be involvement in defining our future strategy around database modernisation in the cloud.
|
Responsibilities: |
Operations · Involved in new solutions design discussions and to recommend suitable, secure, performance optimised database offerings based on business requirements · Ensure all databases in the AWS and Azure are configured for performance, scale and high availability where required · Take responsibility of modernisation of Clients database estate in the cloud, leveraging open source technologies and cloud native hosting platforms · Drive innovation by constantly reviewing latest public cloud platform database service releases such as Babelfish in AWS to fast track adoption of native services · Ensure security considerations are at the forefront when designing and managing database solutions · Optimise query performance · Ensure all key databases have deep insight monitoring enabled to enable improved capabilities around fault detection · Perform regular database maintenance when required and ensure databases are backed up according to agreed RTO / RPO information · Maintenance work to be planned meticulously to minimise/eradicate self-inflicted P1 outages · Monitoring database costs regularly and identify strategies to minimize cost as part of internal FinOps practices · Ability to provide technical system solutions, determine overall design direction and provide hardware recommendations for complex technical issues · Provisioning, deployment, monitoring cloud environment using automation tools like Terraform |
Skills & Experience: |
Certifications: · SQL Server Database Administration - REQUIRED · AWS Certified Solutions Architect Associate – Highly Desirable · AWS Certified Database Specialty – REQUIRED · Azure Database Administrator Associate – Highly Desirable
Skills & Experience: · Ideal candidate has been supporting traditional server based relational databases for over 8 years who then transitioned into AWS and Azure public cloud for the last 5 years · SQL Server / MSSQL 2008 / 2012 / 2014 / 2016 / 2017 / 2019 (including Always-On and Analysis Services) · Postgres / MYSQL as standalone and managed service platforms · Strong database migration experience (Particularly MSSQL to open source and leveraging AWS native platforms including RDS, Athena, Aurora) · Extensive AWS experience in a commercial environment, architecting database best practices · Strong experience supporting AWS / Azure based datalake/data warehouse environments. Required to support internal BI teams · Solid experience and understanding which workloads are best suitable for which specific database platforms in AWS and Azure · Extensive experience and understanding of database security, including appropriate encryption and authentication best practices · Good working knowledge of Microsoft Power BI · Good knowledge of Azure cloud database services · Any working experience around non-relational databases (internally hosted or managed service such as DynamoDB in AWS will be favoured) · Good working knowledge of Windows and Linux Server Operating Systems · Excellent presentation skills to both an internal and external audience · The ability to share and communicate your specific expertise to the rest of the Technology group
|
Behavioural Fit: |
· Professional appearance and manner · High personal drive; results-oriented; make things happen; “can-do attitude” · Can work and adapt within a highly dynamic and growing environment · Team Player; effective at building close working relationships with others · Effectively manages diversity within the workplace · Strong focus on service delivery and the needs and satisfaction of internal clients · Able to see issues from a global, regional and corporate perspective · Able to effectively plan and manage large projects · Excellent communication skills and interpersonal skills at all levels · Strong analytical, presentation and training skills · Innovative and creative · Visionary and strategic view of technology enablers (creative and innovative) · High verbal and written communication ability, able to influence effectively at all levels · Possesses technical expertise and knowledge to lead by example and input into technical debates · Depth and breadth of experience in infrastructure technologies · Enterprise mentality and a global mindset · Sense of humour
|
Role Key Performance Indicators: |
· Design and deliver repeatable, best in class, cloud database solutions · Pro-actively monitor service quality and take action to scale operational services, in line with business growth · Generate operating efficiencies, to be agreed with Infrastructure Services Manager · Establish a “best in sector” level of operational service delivery and insight · Help creates an effective team · Continuous improvement
|