Oracle PLSQL Lead

5 days ago


Delhi, India Alp Consulting Limited Full time
Opportunity with one of Alp Consultancy's most fortuned client which is into large-scale supply chain data collection

and doing extremely excellent in IT Monopoly Job Description: We are looking for a technical lead with 8+ Yrs exp who should have Coordinated with team in understanding the business requirements and delivering the deliverables to the business users. Design, develop, and support PL/SQL, ETL processes for loading data from external as well as internal systems using SQL Loader and External tables. Roles and Responsibilities:

Should have hands on experience and be able to guide the team of developers

Design, develop and maintain tables, standard views, materialized views, synonyms, unique indexes, non-unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, reference cursors and other database objects.

Extensively worked on creating database objects including tables, indexes, views, sequences, packages.

Worked with Bulk Collections for bulk load processing. Involved in code walk through and review sessions with the development team.

Extensively done performance tuning of oracle databases by rewriting optimized SQL queries.

Worked on Partitioning large tables using rollback tablespace, range partitioning and created indexes on various tables to improve query performance.

Extensively worked on SQL commands including all DDL (Data Definition Language), DML (data manipulation language), and DCL (Data Control Language) .

Interacted with Business Analysts and Users for gathering and analyzing the Business Report requirements.

Requirements gathering for the Interfaces and custom programs development through meetings with functional team and business users.

Analysis (Business and Technical) of existing system with objective of improving & optimizing the system performance.

Handled a project where it involved building a process for BEx Team. Required Skills:

Should have sound experience with calling API thru PLSQL procedures and able to debug API code & test API utilizing Postman

Should have good exposure to Linux/Unix, Shell Scripting & XML

Good experience in using WinSCP & Putty

Knowledge or experience with scheduling tools like Control-M

Good understanding on Ansible script (YAML creation) & Monitoring jobs

Flexible working hours (able to work in shifts, if needed)

Must have hands on experience in coding and be able to guide the team of developers.

Developed Advanced PL/SQL packages, procedures, triggers, functions, cursors and collections to implement business logic using SQL developer.

Generated SQL scripts for data validation, data conversion and manipulation and materialized the views for remote instances.

Location:Chennai and Hyderabad

Job Title:Hi ApplicantsHiring for a Job in a Reputed Organization (Product and Service based company) .Here is a Gateway to it, through ALP Consulting.RecruitingEmployment Type: PermanentExperience:Skills Required:Excellent Communication SkillsStrong Experience in :Job Location: Pan IndiaNote: Maximum 60 Days Notice Period will be Prioritized.


  • Oracle Plsql Dev

    1 week ago


    Delhi, India Nityo Infotech Full time

    Job DescriptionWe are looking for an outstanding Software engineer strong in… •Strong PL/SQL experience including•Stored procedure development•Packages development•Functions development•Performance Tuning•Willing to travel anywhere inside India or outside India for long duration, as requiredEducationAny professional Degree / Bachelor degree /...

  • Oracle Plsql Dev

    2 weeks ago


    Delhi, Delhi, India Nityo Infotech Full time

    Job DescriptionWe are looking for an outstanding Software engineer strong in... Strong PL/SQL experience includingStored procedure developmentPackages developmentFunctions developmentPerformance TuningWilling to travel anywhere inside India or outside India for long duration, as requiredEducationAny professional Degree / Bachelor degree / Diploma in Computer...

  • Oracle PLSQL Lead

    6 days ago


    Delhi, India Alp Consulting Limited Full time

    Job Description: We are looking for a technical lead with 8+ Yrs exp who should have Coordinated with team in understanding the business requirements and delivering the deliverables to the business users. Design, develop, and support PL/SQL, ETL processes for loading data from external as well as internal systems using SQL Loader and External tables. Roles...


  • Delhi, India Virtusa Full time

    **Job Title-** **Oracle PLSQL with Informatica** **Tier-T2** **Experience: 6-9 years** - 6 to 8 years of relevant experience in medium or large-scale data integration and data warehouse solutions. - 4 to 6 years of hands on experience in Oracle PL/SQL + Informatica and expert in high performance SQL queries - Well versed with Data analysis, Dimensional...


  • Delhi, India Oracle Full time

    Short description displayed on job tileYou will be responsible for applying your extensive hands-on knowledge of Oracle SQL, PL/SQL & Unix features to lead the team and execute the batches in SIT environment, support and provide first level of analysis on the SIT issues. You would be responsible for the entire SIT support activitiesJob description displayed...


  • Delhi, Delhi, India Virtusa Full time

    Job Title-Oracle PLSQL with InformaticaTier-T2Experience: 6-9 years 6 to 8 years of relevant experience in medium or largescale data integration and data warehouse solutions. 4 to 6 years of hands on experience in Oracle PL/SQL + Informatica and expert in high performance SQL queries Well versed with Data analysis, Dimensional Modelling, Data Warehousing and...


  • Delhi, India Oracle Full time

    Primary Skills -FC-T-UBS-Oracle, PL/SQL, JS, Java . Good knowledge of FLEXCUBE UBS Core, DDA and mainly CL/OBCL modulesCandidate should have hands-on Development, Implementation and / or production support experience with any Core Banking product, ideally Oracle Flexcube UBS• Sound Oracle DB, Oracle SQL, PL/SQL, Java, JavaScript, XML, basic Unix shell...


  • Delhi, India Oracle Full time

    Oracle PLSQL Developer7-11 yrs of experience• Good Knowledge in Oracle SQL, PL/SQL or Java/J2EE, Microservices• Knowledge of OBIEE, BIP• Knowledge of DEVOPS, Microservices, Docker, Kubernetes is an advantage• Exposure to Application servers – WebLogic, Tomcat, JBoss• Exposure to middleware concepts – JMS, MQ, OSB• Exposure to Security...

  • Lead Developer

    4 weeks ago


    Delhi, India Alignity Solutions Full time

    Job DescriptionDo you love a career where you Experience, Grow & Contribute atthe same time, while earning at least 10% above the market? If so, we are excited to have bumped onto you.Learn how we are redefining themeaning of work, and be a part of the team raved by Clients, Job-seekers and Employees.Jobseeker Video TestimonialsEmployee Glassdoor ReviewsIf...


  • Delhi, India Oracle Full time

    What You’ll DoThis role gives you an opportunity to apply your technology knowledge, skills, and experience to work in the Banking Consulting team with a new generation of Oracle Banking products in next generation architecture built using the newest technologies. Activities in Development or Implementation or Managed Service activity streams as a...


  • Delhi, India Oracle Full time

    Job DescriptionOracle’s Construction and Engineering Global Business Unit (CEGBU) focuses on project-intensive industries such as engineering and construction, aerospace and defense, utilities, oil and gas, chemicals, industrial manufacturing, automotive, financial services, communications, travel and transportation, healthcare; state, local and federal...


  • Delhi, India Oracle Full time

    OverviewOracle Consulting is passionate about Oracle Applications and Technology solutions and staffed with the experts that others turn to for best practices. With our global scale of more than 7,000 experts in more than 100 countries driven by core values of client service, candor, collaboration, commitment & character, we know how to move our customers to...


  • Delhi, India Oracle Full time

    Job DescriptionCustomer Success Services (CSS) is a unit within the Oracle’s Customer Service Organization that establishes long-term relationships with many of Oracle's customers through annuity-based service contracts and project based one-time services. CSS services team sells from a broad IT-services portfolio both in fixed price and T&M basis. CSS...


  • Delhi, Delhi, India Jade Global Full time

    At least 15 years Oracle ERP experiences with minimum 5 years on Oracle Cloud.Expert level for PLSQL, BIP and SQL with strong SQL tuning skillsExpert level for web service calls, including invoking SOAP/REST APIs from PLSQL and other programs.Workable functional knowledge in at least two of the three areas, SCM, FIN and HCM.


  • Delhi, India Bechtel Corporation Full time

    Position SummarySuccessful candidate for this position should be able to demonstrate 12+ years' experience leading and performing the following functions supporting & developments of Oracle EBS Financial implementation:Responsible for leading development and technical support of Oracle Financial (AP/GL, FA...) and custom modules interface, conversions,...


  • Delhi, Delhi, India Jade Global Full time

    Summary: Minimum 15 years of experience with Oracle ERP, out of which 5 years focused on Oracle Cloud Expert in PLSQL, BIP, and SQL with a strong emphasis on SQL tuning Proficient in web service calls, including invoking SOAP/REST APIs from PLSQL and other applications Functional understanding in at least two of the following areas: Supply Chain Management,...


  • New Delhi, India Oracle Full time

    Job DescriptionCustomer Success Services (CSS) is a unit within the Oracle’s Customer Service Organization that establishes long-term relationships with many of Oracle's customers through annuity-based service contracts and project based one-time services. CSS services team sells from a broad IT-services portfolio both in fixed price and T&M basis. CSS...


  • Delhi, Delhi, India Bechtel Corporation Full time

    Position SummarySuccessful candidate for this position should be able to demonstrate 12+ years' experience leading and performing the following functions supporting & developments of Oracle EBS Financial implementation:Responsible for leading development and technical support of Oracle Financial (AP/GL, FA...) and custom modules interface, conversions,...


  • Delhi, India Oracle Full time

    Oracle Flexcube Banking Team is looking for a Principal Applications Engineer to be part of Oracle Banking Solution in Bangalore, who will design, develop, test and deploy enterprise applications. Successful candidate will be a technology champion, customer oriented, results driven and passionate about building great products and solutions used by large...

  • Oracle PlSQL

    4 weeks ago


    delhi, India Live Connections Full time

    Experience : 4+ YearsJob Location : Bangalore, PuneNotice Period - 0 to 30 days only. (If candidate is having more than 30 days notice period then credit will not be given thus make sure candidates will have maximum 30 days notice period or serving notice period).Detailed Job Description:4+ years of experience in all phases of SDLC including requirement...