5 Owb Jobs

Must Have Skills: Minimum 6+ years of e xperience in support and operation process with below skills- DB PL/SQL Oracle SQL and PL/SQL (performance tuning of SQL queries) Servers Linux (must)- Understanding and through knowledge of Linux server environment (bash) Script Bash/Python/PL/SQL Application Server Apache Tomcat Production Support Troubleshoot application problems, analyse logs and provide details Good to Have Skills Report PowerBI /Webfocus report ETL tools ODI/OWB Good knowledge of system security, update OS process, analyse vulnerability, apply patches Communication Should have good analytical and communication skills. Create any necessary Documentation: Create necessary documentation as part of the support activity, RCA and process. Job Roles / Responsibilities\u202F Support running production application, validate data, validate data replication between multiple databases and data processing with client. Analyse application logs to validate if application is running as expected. Support QA Platformvalidate deployment package provided by dev team, deploy application to QA platform, validate application is running as expected in QA environment. Identified potential issues in QA and report to dev team. Develop required script which will help in day-to-day support activity LSQL - Procedures/Functions, bash/python scripts and Windows bat script. Deploy application to staging and production environment. Validate deployment, test application, debug application. Coordinate support activity across support team and getting job done. PL/SQL Development: Design, develop, and maintain PL/SQL packages, procedures, functions, triggers, and scripts. Write efficient and optimized PL/SQL code for business logic and data manipulation. Database Design and Management: Create and manage database objects such as tables, views, indexes, sequences, and synonyms. Normalize database schema and enforce data integrity using constraints. Understanding on OLTP and OLAP Performance Tuning: Analyze and optimize existing PL/SQL code and queries for performance. Use tools like SQL Trace, TKPROF, and Explain Plan to identify bottlenecks. Data Integration: Develop ETL (Extract, Transform, Load) processes using PL/SQL to migrate and transform data. Work with external systems for data import/export. Debugging and Troubleshooting Debug PL/SQL code and resolve run-time errors. Conduct unit testing and participate in integration testing. Collaboration with Other Teams Work with front-end and middleware developers to integrate PL/SQL logic with applications. Collaborate with data analysts, DBAs, and business analysts to understand data requirements. Support: Support production environments and handle on-call support for PL/SQL-based issues. Ability to check and simulate the production tickets and provide the fix in a timeline Shell Scripting: Monitoring the crontab jobs to validate the smooth process of daily loads Ability to write and understand the shell script Conduent is an Equal Opportunity Employer and considers applicants for all positions without regard to race, color, creed, religion, ancestry, national origin, age, gender identity, gender expression, sex/gender, marital status, sexual orientation, physical or mental disability, medical condition, use of a guide dog or service animal, military/veteran status, citizenship status, basis of genetic information, or any other group protected by law. People with disabilities who need a reasonable accommodation to apply for or compete for employment with Conduent may request such accommodation(s) by submitting their request through this form that must be downloaded:click here to access or download the form. Complete the form and then email it as an attachment toFTADAAA@conduent.com.You may alsoclick here to access Conduent's ADAAA Accommodation Policy. At Conduent we value the health and safety of our associates, their families and our community. For US applicants while we DO NOT require vaccination for most of our jobs, we DO require that you provide us with your vaccination status, where legally permissible. Providing this information is a requirement of your employment at Conduent.

The Business Intelligence (BI) Specialist is responsible for the design, development, implementation, management and support of mission- critical enterprise BI reporting and Extract, Transform, Load (ETL) processes and environments. Job Description Exposure to one or more implementations using OBIEE Development and Administration. Must have 6+ Years Development experience in PL/SQL. Experience in developing OBIEE Repository at three layers (Physical, Business model and Presentation Layers), Interactive Dashboards and drill down capabilities using global and Filters and Security Setups. Must have 3+ year of experience in Data Modeling, ETL Development (Preferably OWB), Etl and BI Tools installation and configuration & Oracle APEX. Experience in developing OBIEE Analytics Interactive Dashboards with Drill-down capabilities using global and local Filters, OBIEE Security setup (users/ group,access/ query privileges), configuring OBIEE Analytics Metadata objects (Subject Area, Table, Column), Presentation Services/ Web Catalog objects (Dashboards,Pages, Folders, Reports). Hands on development experience on OBIEE (version 11g or higher), Data Modelling. Experience in installing and configuring Oracle OBIEE in multiple life cycle environments.. Experience creating system architecture design documentation.. Experience presenting system architectures to management and technical stakeholders. Technical and Functional Understanding of Oracle OBIEE Technologies. Good knowledge of OBIEE Admin, best practices, DWBI implementation challenges. Understanding and knowledge of Data warehouse . Must have OBIEE Certification on version 11g or higher. Experience with ETL tools. Experience on HP Vertica. Domain knowledge on Supply Chain, Retail, Manufacturing.. Developing architectural solutions utilizing OBIEE. Work with project management to provide effort estimates and timelines. Interact with Business and IT team members to move the project forward on a daily basis.. Lead the development of OBIEE dashboard and reports . Work with Internal stakeholder and development teams during project lifecycle.

We are seeking a detail-oriented and skilled Oracle SQL/PLSQL Developer to join our team. The ideal candidate will have strong expertise in Oracle SQL and PL/SQL, with a proven ability to understand, debug, and optimize existing codebases. Experience with Linux and Oracle Warehouse Builder (OWB) is a strong plus. Familiarity with WebFOCUS is highly appreciated. Key Responsibilities: Analyze, develop, and maintain complex PL/SQL code and Oracle SQL queries. Debug and optimize existing stored procedures, functions, and packages. Collaborate with team members to understand business requirements and translate them into technical solutions. Review and refactor legacy code for performance improvements and best practices. Conduct unit testing and assist in system and integration testing. Work in Linux-based environments to deploy and maintain database scripts and jobs. (If applicable) Work with Oracle Warehouse Builder (OWB) for ETL processes. (Optional) Contribute to reporting and data visualization using WebFOCUS tools. Required Skills: Strong expertise in Oracle SQL and PL/SQL development . Solid understanding of database design and performance tuning techniques. Ability to read, understand, and improve existing codebases. Experience in debugging, error handling, and optimizing complex queries. Exposure to Linux environments (basic shell scripting is a plus). Preferred / Nice to Have: Hands-on experience with Oracle Warehouse Builder (OWB) . Familiarity with WebFOCUS for reporting and analytics. Understanding of ETL concepts and data warehouse principles.

Roles & Responsibilities: Oracle Warehouse Builder, OWB, Oracle Workflow Builder, Oracle TBSS Oracle Warehouse Builder 9i (Client Version 9.0.2.62.3/Repository Version 9.0.2.0.0) Oracle Warehouse Builder 4 Oracle Workflow Builder 2.6.2 Oracle Database 10gTNS for IBM/AIX RISC System/6000Version 10.2.0.5.0 - Production More than 5 years experience on Oracle Warehouse Builder (OWB) and Oracle Workflow Builder Expert Knowledge on Oracle PL/SQL to develop individual code objects to entire DataMarts. Scheduling tools Oracle TBSS (DBMS_SCHEDULER jobs to create and run) and trigger based for file sources based on control files. Must have design and development experience in data pipeline solutions from different source systems (FILES, Oracle) to data lakes. Must have involved in creating/designing Hive tables and loading analyzing data using hive queries. Must have knowledge in CA Workload Automation DE 12.2 to create jobs and scheduling. Extensive knowledge on entire life cycle of Change/Incident/Problem management by using ServiceNow. Oracle Warehouse Builder 9i (Client Version 9.0.2.62.3/Repository Version 9.0.2.0.0). Oracle Warehouse Builder 4 Oracle Workflow Builder 2.6.2 Oracle Database 10gTNS for IBM/AIX RISC System/6000Version 10.2.0.5.0 - Production. Oracle Enterprise Manager 10gR1.(Monitoring jobs and tablespaces utilization) Extensive knowledge in fetching Mainframe Cobol files(ASCII AND EBSDIC formats) to the landing area and processing(formatting) and loading(Error handling) of these files to oracle tables by using SQL*Loader and External tables. Extensive knowledge in Oracle Forms 6 to integrate with OWB 4. Extensive knowledge on entire life cycle of Change/Incident/Problem management by using Service-Now. work closely with the Business owner teams and Functional/Data analysts in the entire development/BAU process. Work closely with AIX support, DBA support teams for access privileges and storage issues etc. work closely with the Batch Operations team and MFT teams for file transfer issues. Migration of Oracle to Hadoop eco system: Must have working experience in Hadoop eco system elements like HDFS,MapReduce,YARN etc. Must have working knowledge on Scala & Spark Dataframes to convert the existing code to Hadoop data lakes. Must have design and development experience in data pipeline solutions from different source systems (FILES, Oracle) to data lakes. Must have involved in creating/designing Hive tables and loading analyzing data using hive queries. Must have knowledge in creating Hive partitions, Dynamic partitions and buckets. Must have knowledge in CA Workload Automation DE 12.2 to create jobs and scheduling. Use Denodo for Data virtualization to the required data access for end users.

Job Information Job Opening ID ZR_1671_JOB Date Opened 20/12/2022 Industry Technology Job Type Work Experience 6-10 years Job Title Oracle Warehouse Builder/Developer City Pune Province Maharashtra Country India Postal Code 411001 Number of Positions 4 Roles & Responsibilities: Oracle Warehouse Builder, OWB, Oracle Workflow Builder, Oracle TBSS Oracle Warehouse Builder 9i (Client Version 9.0.2.62.3/Repository Version 9.0.2.0.0) Oracle Warehouse Builder 4 Oracle Workflow Builder 2.6.2 Oracle Database 10gTNS for IBM/AIX RISC System/6000Version 10.2.0.5.0 - Production More than 5 years experience on Oracle Warehouse Builder (OWB) and Oracle Workflow Builder Expert Knowledge on Oracle PL/SQL to develop individual code objects to entire DataMarts. Scheduling tools Oracle TBSS (DBMS_SCHEDULER jobs to create and run) and trigger based for file sources based on control files. Must have design and development experience in data pipeline solutions from different source systems (FILES, Oracle) to data lakes. Must have involved in creating/designing Hive tables and loading analyzing data using hive queries. Must have knowledge in CA Workload Automation DE 12.2 to create jobs and scheduling. Extensive knowledge on entire life cycle of Change/Incident/Problem management by using ServiceNow. Oracle Warehouse Builder 9i (Client Version 9.0.2.62.3/Repository Version 9.0.2.0.0). Oracle Warehouse Builder 4 Oracle Workflow Builder 2.6.2 Oracle Database 10gTNS for IBM/AIX RISC System/6000Version 10.2.0.5.0 - Production. Oracle Enterprise Manager 10gR1.(Monitoring jobs and tablespaces utilization) Extensive knowledge in fetching Mainframe Cobol files(ASCII AND EBSDIC formats) to the landing area and processing(formatting) and loading(Error handling) of these files to oracle tables by using SQL*Loader and External tables. Extensive knowledge in Oracle Forms 6 to integrate with OWB 4. Extensive knowledge on entire life cycle of Change/Incident/Problem management by using Service-Now. work closely with the Business owner teams and Functional/Data analysts in the entire development/BAU process. Work closely with AIX support, DBA support teams for access privileges and storage issues etc. work closely with the Batch Operations team and MFT teams for file transfer issues. Migration of Oracle to Hadoop eco system: Must have working experience in Hadoop eco system elements like HDFS,MapReduce,YARN etc. Must have working knowledge on Scala & Spark Dataframes to convert the existing code to Hadoop data lakes. Must have design and development experience in data pipeline solutions from different source systems (FILES, Oracle) to data lakes. Must have involved in creating/designing Hive tables and loading analyzing data using hive queries. Must have knowledge in creating Hive partitions, Dynamic partitions and buckets. Must have knowledge in CA Workload Automation DE 12.2 to create jobs and scheduling. Use Denodo for Data virtualization to the required data access for end users. check(event) ; career-website-detail-template-2 => apply(record.id,meta)" mousedown="lyte-button => check(event)" final-style="background-color:#2B39C2;border-color:#2B39C2;color:white;" final-class="lyte-button lyteBackgroundColorBtn lyteSuccess" lyte-rendered=""> I'm interested