107 Oracle Pl Jobs

Responsibilities We are looking for a skilled Smart Plant Materials (SPM) Consultant to provide expert-level support in the Installation/upgrade, implementation, customization, and optimization of Hexagon’s SmartPlant Materials. The consultant will work with engineering, procurement, and construction teams to ensure efficient material management across the project lifecycle. Experience in the installation and setup of Hexagon SmartPlant Materials on servers and client machines. Install and configure the necessary software components (Java JDK, Apache Tomcat, IIS, Oracle Database, etc.) Understanding of system requirements and prerequisites for the installation process. Installation/upgrade of smart plant materials for new projects/existing projects and Installation of hotfixes. Installing of Oracle Application Server components and updating DB object/scripts which are delivered by Hexagon. Upgrading the existing version product to new versions, installing hotfixes/patches. Oracle DBA skills are required. Implement and configure Hexagon SmartPlant Materials (SPM) modules to meet client-specific requirements. Provide consulting and advisory services related to material management, procurement, logistics, and site functionalities. Collaborate with business stakeholders to gather requirements and translate them into functional specifications. Support integration between SPM and other enterprise systems (ERP,SAP, Ecosys, Primavera, etc.). Conduct system testing, validation, and user acceptance testing (UAT). Deliver user training and create support documentation. Troubleshoot technical issues and provide ongoing support and upgrades. Assist with data migration, configuration, and reporting activities. Education / Qualifications Bachelor’s degree in engineering. 3–7 years of experience working with Hexagon Smart Plant Materials or similar engineering material management tools. Strong knowledge of SPM modules such as: Bill of Materials (BOM) Smart Reference Data (SRD) Procurement Expediting Site and Warehouse Management Understanding of material lifecycle in large capital projects (EPC domain). Experience in customizing and integrating SmartPlant tools with external systems. Proficiency in PLSQL programming language and database management (Oracle). About Hexagon Hexagon is the global leader in digital reality solutions, combining sensor, software and autonomous technologies. We are putting data to work to boost efficiency, productivity, quality and safety across industrial, manufacturing, infrastructure, public sector, and mobility applications. Our technologies are shaping production and people related ecosystems to become increasingly connected and autonomous – ensuring a scalable, sustainable future. Hexagon (Nasdaq StockholmHEXA B) has approximately 24,500 employees in 50 countries and net sales of approximately 5.4bn EUR. Learn more athexagon.comand follow us@HexagonAB. Hexagon’s R&D Centre in India Hexagon’s R&D Center in India is the single largest R&D hub for the company globally. Over 2,100 talented engineers and developers create innovation from this center that powers Hexagon's products and solutions. It was established with Hexagon’s acquisition of Intergraph, the first IT MNC in Hyderabad and has now grown to deliver innovations and create solutions for all business lines of Hexagon including Asset Lifecycle Intelligence, Safety Infrastructure & Geospatial, Geosystems, Mining, Manufacturing Intelligence and Autonomous Solutions. It also hosts a few dedicated services teams for global implementation of Hexagon's products. Hexagon is undergoing a global reorganization, resulting in the formation of two separate entitiescore Hexagon and NewCo (a placeholder for internal communication). This job opening is for the role at NewCo in India comprising of 1650 colleagues. With the proposed split, NewCo globally will have 5,000 employees with a 1+ B" annual revenue. R&D India – MAKES THINGS INTELLIGENT Asset Lifecycle Intelligence: Produces insights across the asset lifecycle to design, construct, and operate more profitable, safe, and sustainable industrial facilities. Everyone is welcome At Hexagon, we believe that diverse and inclusive teams are critical to the success of our people and our business. Everyone is welcome—as an inclusive workplace, we do not discriminate. In fact, we embrace differences and are fully committed to creating equal opportunities, an inclusive environment, and fairness for all.

Skill : Postgres Developer Experience: 6 to 13 years Location: Noida Postgres Developer JD: 8+ years of experience in Postgres SQL database. Should have hands on development and support experience in Postgres DB. Well versed with PL/pgSQL coding, Implement queries, stored procedures, cursors, functions & triggers. Should be able to translate Oracle PL/SQL constructs to Postgres PL/pgSQL Good understanding and knowledge of Postgres Database architecture and features. Experience in Performance Tuning and Optimization. Should be able to tune Postgres PL/pgSQL code. Monitor PostgreSQL database performance issues and resolve them. Well versed with Data loading and validations. Experience in DB migrations from Oracle to Postgres is a plus. Good understanding of Database designs and data modelling techniques. Knowledge and exposure to GCP cloud infrastructure and tools. Ability to communicate with Onshore clients, and dependent teams. Should have good problem solving and communication skills with a positive can-do attitude. Should be proactive, requires minimal supervision, ability to work as a team player.

PositionSenior Data Engineer - Airflow, PLSQL Experience5+ Years LocationBangalore/Hyderabad/Pune Seeking a Senior Data Engineer with strong expertise in Apache Airflow and Oracle PL/SQL, along with working experience in Snowflake and Agile methodologies. The ideal candidate will also take up Scrum Master responsibilities and lead a data engineering scrum team to deliver robust, scalable data solutions. Key Responsibilities: Design, develop, and maintain scalable data pipelines using Apache Airflow. Write and optimize complex PL/SQL queries, procedures, and packages on Oracle databases. Collaborate with cross-functional teams to design efficient data models and integration workflows. Work with Snowflake for data warehousing and analytics use cases. Own the delivery of sprint goals, backlog grooming, and facilitation of agile ceremonies as the Scrum Master. Monitor pipeline health and troubleshoot production data issues proactively. Ensure code quality, documentation, and best practices across the team. Mentor junior data engineers and promote a culture of continuous improvement. Required Skills and Qualifications: 5+ years of experience as a Data Engineer in enterprise environments. Strong expertise in Apache Airflow for orchestrating workflows. Expert in Oracle PL/SQL - stored procedures, performance tuning, debugging. Hands-on experience with Snowflake - data modeling, SQL, optimization. Working knowledge of version control (Git) and CI/CD practices. Prior experience or certification as a Scrum Master is highly desirable. Strong analytical and problem-solving skills with attention to detail. Excellent communication and leadership skills.

Working hours 2-11PM As a Principal Software Engineer, you will be leading technology execution amongst a team of skilled software engineers to build out and maintain our Equity Management SaaS Application. You will be an expert amongst the team, responsible for ensuring the team is implementing correct solutions to new features, enhancements, and fixes to the product through work items planned in the current sprint and actively participating in planning, refinement, and retrospective meetings. You will be working in a product team, alongside Engineers and QA Engineers, following an Agile SDLC to create new products and maintain existing applications with C#, .Net, Oracle PL/SQL. You will be a great fit for this position if quality is at the forefront of your development best practices and you are willing to continuously learn new things to better yourself, your career, and our products. Responsibilities Be a leader amongst the team in solving complex software development items that meet customer expectations. Review work items to estimate and assist junior engineers in creating design solutions. Be involved with SDLC from requirements to test but own executing development of features & bug fixes that is clean, reusable, maintainable code in .Net, C# and PL/SQL. Make necessary database changes to support ongoing development tasks Build quality into all tasks, ensure adequate unit testing and support quality assurance engineers in testing completed items Lead, critique and coach others in code reviews and architecture discussions Lead cross team development efforts, identifying dependencies and resolving impediments other engineers encounter Qualifications Bachelor's degree in Computer Science, or equivalent work experience Strong Backend API and Database experience with large scale, consumer facing, enterprise level applications. 10+ years’ experience designing and developing SaaS web applications using .Net/.Net Core, C# and SQL, preferably in a product development organization. 10+ years’ experience w/database technologies – SQL, Entity Framework 2+ years’ experience with cloud technologies (Azure/AWS) Ability to mentor all levels of engineers in best practices Experience developing RESTful APIs Experience in ETL (Extract-Transform-Load) applications Experience with Unit Testing and Mocking frameworks and concepts Experience with Agile/Scrum methodologies Experience with GIT Strong communication skills – written and verbal Strong collaboration skills – experience working in a small-team environment Experience with Oracle databases, including writing/optimizing complex queries, stored procedures,and scripting is a plus Experience w/front-end technologies – HTML5, SASS/CSS, Angular, Typescript is a plus Experience with cloud technologies (preferably Azure)is a plus Experience building apps in financial domain is a plus Additional Information Insightsoftware is an Equal Employment Opportunity employer and as such does not discriminate against any applicant for employment or employee on the basis of race, color, religious creed, gender, age, marital status, sexual orientation, national origin, disability, veteran status, or any other classification protected by applicable discrimination laws. ** At this time insightsoftware is not able to offer sponsorship to candidates who are not eligible to work in the country where the position is located . ** insightsoftware About UsHear From Our Team - InsightSoftware (wistia.com) Background checks are required for employment with insightsoftware, where permitted by country, state/province.

Req ID: 321996 We are currently seeking a GCP-Cloud Run Engineer to join our team in Hyderabad, Telangana (IN-TG), India (IN). GCP-Cloud Run Exp- 5+ years Notice Period- Immediate to 30 days : Senior Application Developer with Google Cloud Platform experience in BigQuery, SQL, CloudRun. Need a Senior Application Developer with GCP Skillset for a project involving re-design and re-platform of legacy Revenue Allocation system Mandatory Skills: GCP BigQuery, SQL, CloudRun Desired Skills: Linux Shell Scripting is a huge plus; Nice to have - Kafka, MQ Series, Oracle PL/SQL Location - Bengaluru,Chennai,Gurugram,Hyderabad,Noida,Pune

Module Lead - Oracle Unified Assurance Location: Pune/ Noida Experience: 4 to 6 years Education: B.E./ B.Tech./MCA Primary Skills: Oracle Unified Assurance, Service Assurance, OSS, BSS Job Description: - Strong experience in Unified Communications Monitoring and Service Assurance to support the Customer's Engineering and Operations team to standardize processes and practices defined for system and infrastructure monitoring as well as ensure service assurance. - Work with the Customer's Engineering and Operations team to evaluate and optimize Unified Communications systems monitoring capabilities - Review system alarms definitions and technical articles provided by the vendors and write process and knowledge base articles to enhance system monitoring and incident management - Streamline and enhance monitoring methodologies to ensure uptime, voice and video performance and client experience. - Work with the Customer's Engineering and Operations team to evaluate and optimize Unified Communications systems monitoring capabilities - Review system alarms definitions and technical articles provided by the vendors and write process and knowledge base articles to enhance system monitoring and incident management - Implement new processes to achieve and maintain availability and performance SLAs for Customer's Services.

5+ Years of experience In Enovia PLM 13x In-depth technical and architectural knowledge on Enovia PLM Ability to configure and customize Enovia PLM business objects per business needs. Experience in PLM Migration from Enovia to Other PLM Systems (ARAS PLM Preferable) Prior experience in Integrating Enovia PLM with various subsystems. In Depth knowledge on Enovia PLM database schema for extracting data from Enovia PLM Knowledge on Java, Oracle PL/SQL and other PLM Systems (additional value)

Techwave, we are always in an exercise to foster a culture of growth, and inclusivity We ensure whoever is associated with the brand is being challenged at every step and is provided with all the necessary opportunities to excel in life People are at the core of everything we do Join us! https://techwavedot net/join-us/ Who are we Techwave is a leading global IT and engineering services and solutions company revolutionizing digital transformations We believe in enabling clients to maximize the potential and achieve a greater market with a wide array of technology services, including, but not limited to, Enterprise Resource Planning, Application Development, Analytics, Digital, and the Internet of things (IoT) Founded in 2004, headquartered in Houston, TX, USA, Techwave leverages its expertise in Digital Transformation, Enterprise Applications, and Engineering Services to enable businesses accelerate their growth Plus, we're a team of dreamers and doers who are pushing the boundaries of what's possible And we want YOU to be a part of it Job Title: PLSQL Developer Experience: 6 9 Years Mode of Hire : Full time Required Skills: Extensive experience in SQL and Oracle PL/SQL development, including writing complex and optimized database scripts Strong knowledge of advanced PL/SQL concepts, including Collections, Object Types, and Oracle 12c architecture Proficient in developing procedures, functions, packages, and implementing robust exception handling mechanisms Skilled in performance tuning of SQL and PL/SQL, with hands-on experience using partitions and developing migration scripts Solid understanding of Oracle database memory structures and architecture, with the ability to apply optimization strategies and recommend improvements to development teams Demonstrated ability to work independently, with sound judgment in planning and executing tasks Strong debugging and problem-solving skills, with a focus on root cause analysis Familiarity with software development methodologies, including Agile and Waterfall models Quick to acquire domain knowledge and understand customer business processes for implementing enhancements Proven track record of resolving incidents within defined SLAs and delivering high-quality solutions Show more Show less

Working hours 2-11PM As a Principal Software Engineer, you will be leading technology execution amongst a team of skilled software engineers to build out and maintain our Equity Management SaaS Application. You will be an expert amongst the team, responsible for ensuring the team is implementing correct solutions to new features, enhancements, and fixes to the product through work items planned in the current sprint and actively participating in planning, refinement, and retrospective meetings. You will be working in a product team, alongside Engineers and QA Engineers, following an Agile SDLC to create new products and maintain existing applications with C#, .Net, Oracle PL/SQL. You will be a great fit for this position if quality is at the forefront of your development best practices and you are willing to continuously learn new things to better yourself, your career, and our products. Responsibilities Be a leader amongst the team in solving complex software development items that meet customer expectations. Review work items to estimate and assist junior engineers in creating design solutions. Be involved with SDLC from requirements to test but own executing development of features & bug fixes that is clean, reusable, maintainable code in .Net, C# and PL/SQL. Make necessary database changes to support ongoing development tasks Build quality into all tasks, ensure adequate unit testing and support quality assurance engineers in testing completed items Lead, critique and coach others in code reviews and architecture discussions Lead cross team development efforts, identifying dependencies and resolving impediments other engineers encounter Qualifications Bachelor's degree in Computer Science, or equivalent work experience Strong Backend API and Database experience with large scale, consumer facing, enterprise level applications. 10+ years’ experience designing and developing SaaS web applications using .Net/.Net Core, C# and SQL, preferably in a product development organization. 10+ years’ experience w/database technologies – SQL, Entity Framework 2+ years’ experience with cloud technologies (Azure/AWS) Ability to mentor all levels of engineers in best practices Experience developing RESTful APIs Experience in ETL (Extract-Transform-Load) applications Experience with Unit Testing and Mocking frameworks and concepts Experience with Agile/Scrum methodologies Experience with GIT Strong communication skills – written and verbal Strong collaboration skills – experience working in a small-team environment Experience with Oracle databases, including writing/optimizing complex queries, stored procedures,and scripting is a plus Experience w/front-end technologies – HTML5, SASS/CSS, Angular, Typescript is a plus Experience with cloud technologies (preferably Azure)is a plus Experience building apps in financial domain is a plus Additional Information Insightsoftware is an Equal Employment Opportunity employer and as such does not discriminate against any applicant for employment or employee on the basis of race, color, religious creed, gender, age, marital status, sexual orientation, national origin, disability, veteran status, or any other classification protected by applicable discrimination laws. ** At this time insightsoftware is not able to offer sponsorship to candidates who are not eligible to work in the country where the position is located . ** insightsoftware About UsHear From Our Team - InsightSoftware (wistia.com) Background checks are required for employment with insightsoftware, where permitted by country, state/province.

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.

Proven experience as a PL/SQL Developer or similar role with at least 6 years of hands-on experience. Proficiency in writing complex SQL queries, PL/SQL stored procedures, functions, triggers, and packages. Experience in performance tuning and optimization techniques for Oracle databases. Strong understanding of database concepts and principles. Familiarity with version control systems such as Git. Excellent problem-solving and analytical skills. Ability to work independently and collaboratively in a team environment. Effective communication skills, both verbal and written. Certification in Oracle PL/SQL or related technologies is a plus.

Greetings!!! This is in regards to a Job opportunity for Oracle PLSQL Developer with Datamatics Global Services Ltd. Position: Oracle PLSQL Developer Website: https://www.datamatics.com/ Job Location: Mumbai/Bangalore Job Description: 1. An Oracle PLSQL Developer is responsible for developing and maintaining Oracle database applications using the PLSQL programming language. 2. Developing and maintaining Oracle database applications using PLSQL. 3. Designing and developing database schemas, stored procedures, functions, and triggers using PLSQL. 4. Optimizing database performance by tuning SQL queries and PLSQL code. 5. Developing and executing test plans to ensure the quality and accuracy of PLSQL code. 6. Troubleshooting and resolving issues related to PLSQL code. 7. Convert user stories into application logic; reports, printed outputs, and interfaces with other systems. Roles and Responsibilities: 1. Fixes and develops changes to applications to meet functional and technical designs following best practices and development standards and guidelines. 2. Supports production systems; analyzes and resolves production problems in a timely manner; resolves end user service requests as assigned. 3. Participates in Backlog grooming, sprint planning and Daily stand-up meetings. 4. Engages with business analysts and stakeholders to understand functional requirements, and contributes to completion of functional specifications. 5. Prepares technical documentation on application specifications 6. Debugs applications and ensures specifications are met before integrating new modules and upgrades into the online production database system. 7. Adheres to coding standards and other standard work as laid out for applications development. 8. Responds promptly to customer needs; takes a customer-centric approach to problem solving; solicits customer feedback to improve service; responds to requests for service and assistance; meets commitments; manages customer expectations.

Job Summary: We are looking for a skilled Application Support – Database Developer to ensure the performance and reliability of production systems. The role involves responding to incidents, identifying and resolving system vulnerabilities, and applying creative solutions to maintain a stable application and infrastructure environment. This position requires hands-on expertise in Oracle PL/SQL and related systems, along with strong troubleshooting and communication skills. Roles and Responsibilities Troubleshoot and resolve issues in production systems and applications across various technologies. Investigate and address user-submitted incident and service request tickets. Work primarily with Oracle PL/SQL-based applications and supporting systems, including web, mobile, and web services. Monitor and respond to internal and external reports of product issues. Analyze complex technical problems across applications, systems, and infrastructure. Collaborate with business and IT teams, including network, server, QA, and development teams, to resolve production issues. Make application modifications to fix defects and reduce the risk of future incidents. Participate in testing and validation of system changes. Modify database applications using SQL, PL/SQL, and Oracle Forms. Review upcoming production changes and contribute to minimizing their potential impact. Perform additional duties as assigned by the Director of Application Support. Required Skills and Qualifications Strong experience in application support or development in an RDBMS environment, particularly with SQL and PL/SQL on Oracle. Proficiency in developing reliable and maintainable PL/SQL code, including packages, procedures, and triggers. Working knowledge of Linux operating systems. Excellent communication and interpersonal skills. Strong analytical and problem-solving skills. Ability to think creatively and develop alternative solutions. Quick adaptability to changing technologies and business needs. Familiarity with enterprise technologies such as sFTP, SSL/SSH, networking basics, Citrix, and ETL tools. Able to work independently as well as in a team-oriented environment. Strong customer-focus and a desire to support end users effectively. Preferred Skills Bachelor’s degree in Computer Science, Information Systems, or a related field. Experience with web and mobile application technologies. Knowledge of enterprise performance monitoring tools such as AppDynamics or Dynatrace. Familiarity with MS-SQL and MySQL, including their procedural languages. Background in supporting complex, database-driven transaction processing applications. Exposure to ColdFusion/CFML web applications and PHP-based portals. Familiarity with Oracle E-Business Suite is an added advantage. This position will serve as a level II support engineer and will be required to work outside normal business hours in response to production outages & impacts. Off hours on-call operates as a rotation among the team. The candidate’s objective is to eliminate those occurrences by identifying and closing vulnerabilities before they become a production incident.

Job Title : System Analyst IBM Datastage and Oracle Pl/Sql Technical consultant What you will do: Collaborate with development and business analysis teams to understandsystem design and function. Develop program units in IBM Datastage and Oracle Pl/SQL. The code shouldmeet the requirements as per system design andcoding standards under minimal supervision, and perform unit testing. Support System Integration testing (SIT), User Acceptance Testing (UAT),and Performance testing of the Oracle Pl/Sql code and IBM DataStage jobs. Create and maintain project artifacts and effectivelycommunicate technical impact and risks to team leads and management. Ensure the complete development activities on time, within budget, and tothe required quality standards. Perform gap analysis and assess the impact of systemsoftware changes. Primary focus will be the development of DataStage jobsand Optimize existing DataStage jobs for performance. Responsible for troubleshooting and resolving issueswith existing jobs in Oracle PL/SQL and IBM DataStage codes. Troubleshoot DataStage job failures and provide rootcause analysis. Responsible of code version maintenance as per thecompany standards. Utilize the environment variables and stage variablesfor developing parameter-driven jobs and debugging them. Convert the complex job designs into segments and executein job sequencer for better performance and easy maintenance. Create and maintain shared container to simplify thedesign of DataStage jobs, and find options for code reuse and simplification. What you willneed: Bachelors degree with 5-7 years of work experience inIBM DataStage and Oracle Pl/SQL, processes, tools, and techniques. Minimum of 4 years experience working with Oracle SQLand PL/SQL. Experience with maintenance of IBM Datastage server. Knowledge of troubleshooting technical issues withstandard or custom programs. Familiarity with the Software Development Lifecycle(SDLC) and Software Testing Lifecycle (STLC). Strong analytical skills and thinking ability. Hands-on experience writing SQL queries and PL-SQLscripts, such as Procedures, Functions, etc. Highly organized with excellent verbal and writtencommunication skills. Adaptable to project and task changes, ability tomultitask. Ability to work within project plans and meetdeadlines.

You have an entrepreneurial spirit. You enjoy working as a part of well-knit teams. You value the team over the individual. You welcome diversity at work and within the greater community. You aren't afraid to take risks. You appreciate a growth path with your leadership team that journeys how you can grow inside and outside of the organization. You thrive upon continuing education programs that your company sponsors to strengthen your skills and for you to become a thought leader ahead of the industry curve. Hands on experience in Oracle PL/SQL Database Development + Crystal reports is a must. 1. Oracle pl/sql (4+ years of experience in development of stored procedures, Package, Functions, Trigger, View, and wrapper sqls) 2. Design and develop Crystal standard (SAP Crystal Reports 2020) and ad-hoc reports using Oracle 12c database 3. Handle BI Folder security, user/group security using CMC 4. Migration of BI reports using promotion management tool 5. Monitor and support existing schedules using, use Query builder to analyze report schedules 6. Investigate and fix production issues related to BI universes and WebI report 7. Investigate and fix production issues related to Crystal reports 8. Investigate and improve performance issues related to BI WebI report and Crystal reports 9. Address different issues through JIRA and Salesforce 10. Strong analytical and rational thinking 11. Clear, logical, and effective verbal/written communication skills

Collaborate with development and business analysis teams to understandsystem design and function. Develop program units in IBM Datastage and Oracle Pl/SQL. The code shouldmeet the requirements as per system design andcoding standards under minimal supervision, and perform unit testing. Support System Integration testing (SIT), User Acceptance Testing (UAT),and Performance testing of the Oracle Pl/Sql code and IBM DataStage jobs. Create and maintain project artifacts and effectivelycommunicate technical impact and risks to team leads and management. Ensure the complete development activities on time, within budget, and tothe required quality standards. Perform gap analysis and assess the impact of systemsoftware changes. Primary focus will be the development of DataStage jobsand Optimize existing DataStage jobs for performance. Responsible for troubleshooting and resolving issueswith existing jobs in Oracle PL/SQL and IBM DataStage codes. Troubleshoot DataStage job failures and provide rootcause analysis. Responsible of code version maintenance as per thecompany standards. Utilize the environment variables and stage variablesfor developing parameter-driven jobs and debugging them. Convert the complex job designs into segments and executein job sequencer for better performance and easy maintenance. Create and maintain shared container to simplify thedesign of DataStage jobs, and find options for code reuse and simplification. What you will need: Bachelors degree with 5-7 years of work experience inIBM DataStage and Oracle Pl/SQL, processes, tools, and techniques. Minimum of 4 years experience working with Oracle SQLand PL/SQL. Experience with maintenance of IBM Datastage server. Knowledge of troubleshooting technical issues withstandard or custom programs. Familiarity with the Software Development Lifecycle(SDLC) and Software Testing Lifecycle (STLC). Strong analytical skills and thinking ability. Hands-on experience writing SQL queries and PL-SQLscripts, such as Procedures, Functions, etc.

Design, develop, and maintain high-performance SQL and PL/SQL procedures, packages, and functions in Snowflake or other cloud database technologies. Apply advanced performance tuning techniques to optimize database objects, queries, indexing strategies, and resource usage. Develop code based on reading and understanding business and functional requirements following the Agile process Produce high-quality code to meet all project deadlines and ensuring the functionality matches the requirements Analyze and resolve issues found during the testing or pre-production phases of the software delivery lifecycle; coordinating changes with project team leaders and cross-work team members Provide technical support to project team members and responding to inquiries regarding errors or questions about programs Interact with architects, technical leads, team members and project managers as required to address technical and schedule issues. Suggest and implement process improvements for estimating, development and testing processes. Support the development of automated and repeatable processes for ETL/ELT, data integration, and data transformation using industry best practices. Support cloud migration and modernization initiatives, including re-platforming or refactoring legacy database objects for cloud-native platforms. BS Degree in Computer Science, Information Technology, Electrical/Electronic Engineering or another related field or equivalent A minimum of 7 years prior work experience working with an application and database development organization with deep expertise in Oracle PL/SQL or SQL Server T-SQL; must demonstrate experience delivering systems and projects from inception through implementation Proven experience writing and optimizing complex stored procedures, functions, and packages in relational databases such as Oracle, MySQL, SQL Server Strong knowledge of performance tuning, including query optimization, indexing, statistics, execution plans, and partitioning Understanding of data integration pipelines, ETL tools, and batch processing techniques. Possesses solid software development and programming skills, with an understanding of design patterns, and software development best practices Experience with Snowflake, Python scripting, and data transformation frameworks like dbt is a plus Work experience in developing Web Applications with Java, Java Script, HTML, JSPs. Experience with MVC frameworks Spring and Angular

Design, develop, and maintain high-performance SQL and PL/SQL procedures, packages, and functions in Snowflake or other cloud database technologies. Apply advanced performance tuning techniques to optimize database objects, queries, indexing strategies, and resource usage. ; Develop code based on reading and understanding business and functional requirements following the Agile process Produce high-quality code to meet all project deadlines and ensuring the functionality matches the requirements ; Analyze and resolve issues found during the testing or pre-production phases of the software delivery lifecycle; coordinating changes with project team leaders and cross-work team members ; Provide technical support to project team members and responding to inquiries regarding errors or questions about programs Interact with architects, technical leads, team members and project managers as required to address technical and schedule issues. ; Suggest and implement process improvements for estimating, development and testing processes. Support the development of automated and repeatable processes for ETL/ELT, data integration, and data transformation using industry best practices. ; Support cloud migration and modernization initiatives, including re-platforming or refactoring legacy database objects for cloud-native platforms. ; BS Degree in Computer Science, Information Technology, Electrical/Electronic Engineering or another related field or equivalent ; A minimum of 7 years prior work experience working with an application and database development organization with deep expertise in Oracle PL/SQL or SQL Server T-SQL; must demonstrate experience delivering systems and projects from inception through implementation ; Proven experience writing and optimizing complex stored procedures, functions, and packages in relational databases such as Oracle, MySQL, SQL Server ; Strong knowledge of performance tuning, including query optimization, indexing, statistics, execution plans, and partitioning ; Understanding of data integration pipelines, ETL tools, and batch processing techniques. ; Possesses solid software development and programming skills, with an understanding of design patterns, and software development best practices ; Experience with Snowflake, Python scripting, and data transformation frameworks like dbt is a plus ; Work experience in developing Web Applications with Java, Java Script, HTML, JSPs. Experience with MVC frameworks Spring and Angular

We are in search of a proficient Oracle EBS technical resource with experience in Oracle Fusion and OIC to join our team as an ERP Technical Consultant. In this role, you will design, implement, and maintain the ERP EBS Order Management module and assist in the transition from Oracle EBS to Oracle Fusion Cloud. Proficiency in Oracle OM and AR modules, strong technical skills in Oracle APPS, including Oracle PL/SQL, is essential. Knowledge of multi-country taxation is an advantageous skill. You will work with cross-functional and technical teams to develop effective solutions. Key Responsibilities: Design, setup, and maintain the Oracle ERP EBS OM and AR modules. Develop integration solutions using the Oracle Integration Cloud Platform. Collaborate with internal stakeholders and external vendors to collect requirements. Analyze data and requirements to develop efficient and scalable solutions. Be results-oriented, capable of solving complex analytical problems, and providing recommendations. Troubleshoot and resolve issues related to integration flows and data connectivity. Develop program logic according to user stories in close collaboration with the Product Owner. Employ best practices in design and coding, with a focus on continuous improvement, particularly in performance tuning and job failure notification and recovery. Adhere to the organization's design and coding standards. Conduct thorough testing to ensure quality. Create knowledge transfer documentation for support operations. Provide third-level operational support. Work with the Product Owner to create and refine user stories and acceptance criteria. Engage in Scrum/PI Planning to create iteration plans and Team PI Objectives. Commit to Team PI Objectives and iteration goals. Estimate the size and complexity of work assignments. Determine the technical design in their area of concern, within the architectural guidelines. Conduct research, design, prototype, and other exploration activities Deploy the work products to staging and production. Required Skills: Strong knowledge and hands-on experience with Oracle ERP EBS R12, specifically the OM and AR modules (knowledge of Order to Cash modules, including taxes, is advantageous) Solid understanding of Oracle EBS and CRM application concepts and principles In-depth functional knowledge of Oracle AR & Invoicing Familiarity with Oracle Fusion Cloud Application Beneficial to have experience with PaaS, SOA Cloud Service, Java Cloud Service, and VBCS in relation to SaaS Applications Proficient in using Git for version control Experience with Web Service protocols such as SOAP/REST and working with XML/JSON/POST technologies Expertise in SQL and PL/SQL, skilled in Oracle Reports and BI Publisher Strong analytical and problem-solving abilities Knowledge of security protocols and standards like SSL, OAuth, SAML Excellent analytical and problem-solving skills Outstanding communication and interpersonal abilities Offers of employment are conditional upon passage of screening criteria applicable to the job.

Job Information Job Opening ID ZR_1915_JOB Date Opened 06/05/2023 Industry Technology Job Type Work Experience 5-8 years Job Title ENOVIA PLM City Hyderabad Province Telangana Country India Postal Code 500001 Number of Positions 5 5+ Years of experience In Enovia PLM 13x In-depth technical and architectural knowledge on Enovia PLM Ability to configure and customize Enovia PLM business objects per business needs. Experience in PLM Migration from Enovia to Other PLM Systems (ARAS PLM Preferable) Prior experience in Integrating Enovia PLM with various subsystems. In Depth knowledge on Enovia PLM database schema for extracting data from Enovia PLM Knowledge on Java, Oracle PL/SQL and other PLM Systems (additional value) 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

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

Job Information Job Opening ID ZR_2198_JOB Date Opened 15/04/2024 Industry Technology Job Type Work Experience 6-10 years Job Title PLSQL Developer City Chennai Province Tamil Nadu Country India Postal Code 600004 Number of Positions 4 Proven experience as a PL/SQL Developer or similar role with at least 6 years of hands-on experience. Proficiency in writing complex SQL queries, PL/SQL stored procedures, functions, triggers, and packages. Experience in performance tuning and optimization techniques for Oracle databases. Strong understanding of database concepts and principles. Familiarity with version control systems such as Git. Excellent problem-solving and analytical skills. Ability to work independently and collaboratively in a team environment. Effective communication skills, both verbal and written. Certification in Oracle PL/SQL or related technologies is a plus. 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

Summary of the position - The implementation engineer will be part of the implementation team, and this profile requires good knowledge and experience in the implementation/technical field. The engineer will work with technical and non-technical people with the associated clients at different locations. Job Responsibilities - Install company software at clients sites. To resolves all issues and develop all programs according to client requirements. Perform various tests on process and prepare document and coordinate with the manager to resolve issues within required time frame and inform management for any delays. Coordinate with development team to design new programs for the client implementation activities and manage all communications to resolve all issues. Identify problems and new requirements of the client, understand any new requirement from the client and implement the changes. Perform research on all client issues and document all findings and implement all technical activities. Assist clients to monitor all software implementation lifecycle and assist make appropriate customisations. Train clients technical staff on all hardware and software issues and identify all problems in processes and provide solutions. Improve software to meet the clients business needs and follow best practices and standards. Record and manage customer specific implementation user guides for company applications user community. Job Requirements - 5 to 15 years of relevant experience in the field of implementation Sound knowledge of Oracle - PL/SQL At least 2 years experience only in PL SQL A team player with good communication skills. Bachelors / Masters degree in IT or Computer engineering. Candidate should be open to travel within India and abroad as required. Valid passport is must. Candidate should be open to relocate. Candidate should be adaptive and flexible to work. Company offers open work Culture.

The Apex Group was established in Bermuda in 2003 and is now one of the worlds largest fund administration and middle office solutions providers. Our business is unique in its ability to reach globally, service locally and provide cross-jurisdictional services. With our clients at the heart of everything we do, our hard-working team has successfully delivered on an unprecedented growth and transformation journey, and we are now represented by over circa 13,000 employees across 112 offices worldwide.Your career with us should reflect your energy and passion. Thats why, at Apex Group, we will do more than simply empower you. We will work to supercharge your unique skills and experience. Take the lead and well give you the support you need to be at the top of your game. And we offer you the freedom to be a positive disrupter and turn big ideas into bold, industry-changing realities. For our business, for clients, and for you Apex Fund Services Position SQL Developer Employment Type: Full Time Location: Pune, India Salary: TBC Work Experience Applicant for this position should have 4+ years working as a SQL developer. Project Overview: The project will use a number of Microsoft SQL Server technologies and include development and maintenance of reports, APIs and other integrations with external financial systems. The successful applicant will liaise with other members of the team and will be expected to work on projects where they are the sole developer as well as part of a team on larger projects. The applicant will report to the SQL Development Manager : Ability to understand requirements clearly and communicate technical ideas to both technical stakeholders and business end users. Investigate and resolve issues quickly. Communication with end users. Working closely with other team members to understand business requirements. Complete structure analysis and systematic testing of the data. Skills: Microsoft SQL Server 2016 2022. T-SQL programming (4+ years) experience. Query/Stored Procedure performance tuning. SQL Server Integration Service. SQL Server Reporting Services. Experience in database design. Experience with source control. Knowledge of software engineering life cycle. Previous experience in designing, developing, testing, implementing and supporting software. 3rd Level IT Qualification. SQL MSCA or MSCE preferable. Knowledge of data technologies such as SnowFlake, Airflow, ADF desirable Other skills Ability to work on own initiative and as part of a team. Excellent time management and decision making skills. Excellent communication skills in both English written and verbal. Background in the financial industry preferable. Academic Qualification: Any graduation or post graduate. Any specialization in IT. Company Websitewww.apexfundservices.com DisclaimerUnsolicited CVs sent to Apex (Talent Acquisition Team or Hiring Managers) by recruitment agencies will not be accepted for this position. Apex operates a direct sourcing model and where agency assistance is required, the Talent Acquisition team will engage directly with our exclusive recruitment partners.

Role - Oracle PL SQL Developer PRIMARY RESPONSIBILITIES Design, develop, test and support solutions utilizing Oracle RDBMS. Work with Product Owner and Scrum Master to assess impact and provide estimates. Research and evaluate alternative solutions; Recommend efficient and cost effective solutions for system design Re-factor existing application code Provide support and on-the-job training to less experienced team members REQUIRED SKILLS 3+ years of experience working as oracle developer. Strong development skills in SQL & PL/SQL Experience with query optimization / performance tuning Handling of external files /data using data load Excellent Analytical skills Strong debugging skills Good communication skills Self-starter capable of working independently DESIRED SKILLS DBA skills such as backup and maintenance Good working knowledge of Informatica ETL/BOXI or Java / J2EE Agile work experience Prior experience in Reference Data Management implementations