39 Sql Loader Jobs

Job Summary We are seeking a dedicated professional for the PE-Ins Claims role with 1 to 3 years of experience to join our team. The ideal candidate will possess strong technical skills in the Life and Annuity domain. This role requires working from the office during night shifts. The candidate will play a crucial role in processing and managing insurance claims efficiently contributing to the companys success and enhancing customer satisfaction. Responsibilities Analyze and process insurance claims in the Life and Annuity domain to ensure accuracy and compliance with company policies. Certifications Required Certified Life and Annuity Claims Specialist (CLACS)

Hiring for PL SQ DEVELOPER- BANGALORE DDL / DML SQL, PL-SQL Procedures / functions / Triggers Oracle DB Object relational mapping (ORM) Prepare abstract data layer on top of transactional data Integrate / test / debug data flows/ processing with other web services Exposure to front-end tech - JavaScript and HTML5

The Business Process Improvement Manager will support the Process Integrations across the Secure Power plants. You should have extensive experience and expertise in Oracle APPS Techno-Functional knowledge, specifically in Manufacturing and Supply Chain modules such as Purchasing, iSupplier Portal, iProcurment, OSP, Inventory, OM, ASCP, etc. Additionally, you should be well-versed in EDI Integrations, Coupa, and SupplyON tools. Your role will require expertise in Technical development and Integrations, including Oracle, PL/SQL, Oracle ECC, Oracle Apps implementation, personalization's, migrations, up-gradation, Form and Report building, Web design, PI, Power Automation, RPA, and Data analytics. You should also have experience in Process Integrations and EDI projects implementation. Proficiency in tools like Oracle SQL Developer, Toad, SQL Navigator, SQL Loader, and Data Loader will be essential. As the Business Process Improvement Manager, you will be responsible for understanding business specifications, new capabilities, requirements, and data mappings to provide optimal solutions. This involves evaluating the scope of projects, finalizing project requirements, building BRD, MD50, Test cases, training material, and deployment knowledge. You should be capable of integrating third-party tools with Oracle ERP and quick analysis of issues to provide necessary support to operational/business teams. Your role will also involve managing and participating in UAT, conducting gap analysis of Business scenarios/flows, ensuring that business requirements and functional specifications are tested and fulfilled. Implementation and deployment of projects within scheduled deadlines, as well as extending post-implementation and maintenance support to end-users, will be part of your responsibilities. Desired Skills: - Bachelor's Degree in Engineering - 5+ years of experience and expertise in Oracle APPS Techno-Functional knowledge in Manufacturing and Supply Chain modules with EDI Integrations, Coupa, and SupplyON tools knowledge - Bachelor's Degree in Engineering with Oracle ERP Techno-Functional experience in SCM and Planning modules Schneider Electric values IMPACT - Inclusion, Mastery, Purpose, Action, Curiosity, Teamwork. As an IMPACT Maker at Schneider Electric, you will contribute to turning sustainability ambition into actions at the intersection of automation, electrification, and digitization. If you are looking to make a difference and be part of a team that values sustainability and inclusivity, apply today. Schneider Electric is committed to being an inclusive and caring company that provides equitable opportunities to all. We believe in championing inclusivity, diversity, ethics, and compliance in everything we do. Join us in our mission to create a more resilient, efficient, and sustainable world.,

Junior consulting position for those who are continuing to develop their expertise. Receives general instruction on routine work and detailed instruction on new projects or assignments. Career Level - IC1 Career Level - IC1 As a member of a project team, follows standard practices and procedures to analyze situations/data and provide quality work products to deliver functional and technical solutions on applications and technology installations. Work involves some problem solving with assistance and guidance in understanding and applying relevant Oracle methodologies and practices. Implements Oracle products and technology in various industries to meet customer specifications.

Educational Bachelor of Engineering,Bachelor Of Technology,Bachelor Of Science,Master of Business Administration,Master Of Science,Master Of Technology Service Line Enterprise Package Application Services Responsibilities A day in the life of an Infoscion As part of the Infosys delivery team, your primary role would be to ensure effective Design, Development, Validation and Support activities, to assure that our clients are satisfied with the high levels of service in the technology domain. You will gather the requirements and specifications to understand the client requirements in a detailed manner and translate the same into system requirements. You will play a key role in the overall estimation of work requirements to provide the right information on project estimations to Technology Leads and Project Managers. You would be a key contributor to building efficient programs/ systems and if you think you fit right in to help our clients navigate their next in their digital transformation journey, this is the place for you!If you think you fit right in to help our clients navigate their next in their digital transformation journey, this is the place for you! Additional Responsibilities: Knowledge of design principles and fundamentals of architecture Understanding of performance engineering Knowledge of quality processes and estimation techniques Basic understanding of project domain Ability to translate functional / nonfunctional requirements to systems requirements Ability to design and code complex programs Ability to write test cases and scenarios based on the specifications Good understanding of SDLC and agile methodologies Awareness of latest technologies and trends Logical thinking and problem solving skills along with an ability to collaborate Technical and Professional : 3+ years of experience in Oracle EBS development and implementation. Strong expertise in Oracle EBS Technologies (Forms, Reports, Workflow, SQL Loader, Oracle Applications APIs), Database concepts, PL/SQL, Unix Shell Scripts, Oracle Database Upgrade 9i to 11g, Data mapping, conversions, interfaces, and validation, Oracle R12 data models and SQL queries (preferably using TOAD). Good understanding of SDLC and agile methodologies, Software development principles, Performance engineering and quality processes. Preferred Skills: Technology-Oracle eBS Technical-Oracle Application Development

Detailed JD *(Roles and Responsibilities) We are looking 8+ yrs of exp in Oracle PLSQL Lead Developer Mandatory skills:- Oracle PLSQL, Unix Good to have skills:- Python Domain:- SCI Oracle PLSQL Lead developer . Key Responsibilities: Lead and mentor a team of Oracle PL/SQL developers with hands on. Design, develop, and optimize stored procedures, packages, and queries. Should have hands on experience in Ref cursors, Bulk operation , collections, Analytical functions, exception, materialized views ,Oracle utility packages, SQL Loader, SQL query and PLSQL optimization. Collaborate with business and technical teams to deliver high-quality solutions. Troubleshoot performance issues and implement long-term fixes. Ensure best practices in coding, testing, and documentation. What Were Looking For: 5+ years of Oracle PL/SQL development experience. 2+ years in a senior developer role. Strong performance tuning and SQL optimization skills. Great communicator and team player. Bonus: Python, UNIX Sheel scripting Precise Work Location* (E.g. Bangalore Infosys SEZ or STP):- Bangalore, Hyd, BBS, Pune Candidates must be coming to the F2F interview and ready for the IWAP test (Mandatory) Interested candidate can share me there updated resume in recruiter.wtr26@walkingtree.in

Job Description Extensive experience in Oracle SQL, PL/SQL, Java script; writing OOP PL/SQL codes for applications demanding type objects, nested tables (Min 4-5 years) Proficient in scripting using Python (2-3 Years) Exposure to create use cases, functional specifications technical design specifications Proficient in creation of database objects like stored procedures, functions, packages, tables, indexes, triggers, snapshots etc. Good experience in performing data migrations, data loads using ETL tools Strong hands-on experience to be able to design, develop, deploy and support RESTful services Experience in job scheduling using CRON utilities, legacy AT scheduler, windows scheduler, Toad Self-motivated and committed team player with excellent communication and interpersonal skills Solid written and verbal communication skills and able to articulate the technically complex to be understood by both technical and non-technical personnel Able to develop scalable solutions that can be utilized by current and future channels e.g. mobile Understanding the importance of real business engagement in all stages of IT product lifecycle working in agile delivery methodologies

6+ years of experience in DBA,AWS, SQL, PL/SQL, UNIX, Shell Scripting (Korn, Bash), Perl, AWK, Windows and Linux,SQL*Loader, Datapump, Export/Import, data encryption,Oracle databases, Oracle APEX, and cloud database management

We are looking for a skilled Oracle EBS Payroll Techno-Functional professional with 7 to 10 years of experience. The ideal candidate will have expertise in Oracle payroll, preferably with knowledge of India legislation. Roles and Responsibility Implement and manage Oracle payroll systems, including setup, configuration, and maintenance. Provide technical support and troubleshoot issues related to Oracle payroll. Collaborate with cross-functional teams to ensure seamless integration between Oracle payroll and other applications. Develop and maintain documentation of Oracle payroll processes and procedures. Ensure compliance with industry standards and best practices for Oracle payroll management. Analyze and resolve complex technical issues related to Oracle payroll. Job Strong understanding of Oracle HRMS/Payroll, including techno-functional aspects. Excellent written and verbal communication skills, with the ability to work effectively with stakeholders. Experience with Oracle Alert, FND User, Responsibilities, Request Set, value sets, and profile options. Expertise in PL SQL, Package, DB view, Triggers, and other relevant technologies. Ability to work on support activities, including managing Oracle payroll Patches and Version upgrades. Experience with interfaces between applications, such as Oracle Payroll to Others. Btech/MCA in Technology (any stream). Solid techno-functional background in Oracle HRMS/Payroll, with hands-on experience in Oracle Payroll. Technical Skills: BG setup, Payroll Setup, Fast formula, Formula Function (Creation/Debug), Payroll Run, Retro Concept, Pre-Payments, Balances, Element setup, Element Link, Assignment SET, Element Set, EIT, SIT, Costing, Balancing concept between Oracle Payroll to Finance, Security Profiles, KFF, DFF, Request Set, value sets, profile options. Experience with concurrent programs like PL SQL, SQL loader, Host, Java based, SQL file, HRMS and Payroll back-end API, Integration between two modules like HRMS to Payroll, Payroll to Finance, WEBADI, Hooks, AME Setup, Form personalization, Form customization, XML publisher, Oracle report Builder RDF, SQL Loader, UTL file, and Oracle Patching.

Educational Bachelor of Engineering,BTech,BCA,MTech,MCA,MSc Service Line Enterprise Package Application Services Responsibilities A day in the life of an Infoscion As part of the Infosys consulting team, your primary role would be to actively aid the consulting team in different phases of the project including problem definition, effort estimation, diagnosis, solution generation and design and deployment You will explore the alternatives to the recommended solutions based on research that includes literature surveys, information available in public domains, vendor evaluation information, etc. and build POCs You will create requirement specifications from the business needs, define the to-be-processes and detailed functional designs based on requirements. You will support configuring solution requirements on the products; understand if any issues, diagnose the root-cause of such issues, seek clarifications, and then identify and shortlist solution alternatives You will also contribute to unit-level and organizational initiatives with an objective of providing high quality value adding solutions to customers. If you think you fit right in to help our clients navigate their next in their digital transformation journey, this is the place for you! Additional Responsibilities: Knowledge of design principles and fundamentals of architecture Understanding of performance engineering Knowledge of quality processes and estimation techniques Basic understanding of project domain Ability to translate functional / nonfunctional requirements to systems requirements Ability to design and code complex programs Ability to write test cases and scenarios based on the specifications Good understanding of SDLC and agile methodologies Awareness of latest technologies and trends Logical thinking and problem solving skills along with an ability to collaborate Technical and Professional : 3+ years of experience in Oracle EBS development and implementation. Strong expertise in Oracle EBS Technologies (Forms, Reports, Workflow, SQL Loader, Oracle Applications APIs), Database concepts, PL/SQL, Unix Shell Scripts, Oracle Database Upgrade 9i to 11g, Data mapping, conversions, interfaces, and validation, Oracle R12 data models and SQL queries (preferably using TOAD). Good understanding of SDLC and agile methodologies, Software development principles, Performance engineering and quality processes. Preferred Skills: Technology-Oracle eBS Technical-Oracle Application Development

Educational Bachelor of Engineering,BSc,BTech,MTech,MSc,MBA Service Line Enterprise Package Application Services Responsibilities A day in the life of an Infoscion As part of the Infosys delivery team, your primary role would be to interface with the client for quality assurance, issue resolution and ensuring high customer satisfaction. You will understand requirements, create and review designs, validate the architecture and ensure high levels of service offerings to clients in the technology domain. You will participate in project estimation, provide inputs for solution delivery, conduct technical risk planning, perform code reviews and unit test plan reviews. You will lead and guide your teams towards developing optimized high quality code deliverables, continual knowledge management and adherence to the organizational guidelines and processes. You would be a key contributor to building efficient programs/ systems and if you think you fit right in to help our clients navigate their next in their digital transformation journey, this is the place for you!If you think you fit right in to help our clients navigate their next in their digital transformation journey, this is the place for you! Additional Responsibilities: Knowledge of more than one technology Basics of Architecture and Design fundamentals Knowledge of Testing tools Knowledge of agile methodologies Understanding of Project life cycle activities on development and maintenance projects Understanding of one or more Estimation methodologies, Knowledge of Quality processes Basics of business domain to understand the business requirements Analytical abilities, Strong Technical Skills, Good communication skills Good understanding of the technology and domain Ability to demonstrate a sound understanding of software quality assurance principles, SOLID design principles and modelling methods Awareness of latest technologies and trends Excellent problem solving, analytical and debugging skills Technical and Professional : 5+ years of experience as a software developer focused on Oracle EBS development and implementation. Expert-level understanding of Oracle EBS Technologies (Forms, Reports, Workflow, SQL Loader, Oracle Applications APIs), Database concepts and optimization techniques, PL/SQL, Unix Shell Scripts, Oracle Database Upgrade 9i to 12c (preferably), Data mapping, conversions, interfaces, and validation, Strong understanding of EBS R12 data models across at least 2 modules (Finance, HR, Supply Chain, etc.)SQL queries (including complex queries and use of TOAD). Strong understanding of Software Development Life Cycle (SDLC) and agile methodologies, Software development best practices and coding standards, Design principles and architecture concepts, Performance engineering and quality assurance processes , Version control systems (e.g., Git). Preferred Skills: Technology-Oracle eBS Technical-Oracle Application Development Technology-Oracle Apps Technical-Oracle Apps PL/SQL

Educational Bachelor of Engineering,BSc,BTech,MTech,MSc,MBA Service Line Enterprise Package Application Services Responsibilities A day in the life of an Infoscion As part of the Infosys delivery team, your primary role would be to ensure effective Design, Development, Validation and Support activities, to assure that our clients are satisfied with the high levels of service in the technology domain. You will gather the requirements and specifications to understand the client requirements in a detailed manner and translate the same into system requirements. You will play a key role in the overall estimation of work requirements to provide the right information on project estimations to Technology Leads and Project Managers. You would be a key contributor to building efficient programs/ systems and if you think you fit right in to help our clients navigate their next in their digital transformation journey, this is the place for you!If you think you fit right in to help our clients navigate their next in their digital transformation journey, this is the place for you! Additional Responsibilities: Knowledge of design principles and fundamentals of architecture Understanding of performance engineering Knowledge of quality processes and estimation techniques Basic understanding of project domain Ability to translate functional / nonfunctional requirements to systems requirements Ability to design and code complex programs Ability to write test cases and scenarios based on the specifications Good understanding of SDLC and agile methodologies Awareness of latest technologies and trends Logical thinking and problem solving skills along with an ability to collaborate Technical and Professional : 3+ years of experience in Oracle EBS development and implementation. Strong expertise in Oracle EBS Technologies (Forms, Reports, Workflow, SQL Loader, Oracle Applications APIs), Database concepts, PL/SQL, Unix Shell Scripts, Oracle Database Upgrade 9i to 11g, Data mapping, conversions, interfaces, and validation, Oracle R12 data models and SQL queries (preferably using TOAD). Good understanding of SDLC and agile methodologies, Software development principles, Performance engineering and quality processes. Preferred Skills: Technology-Oracle eBS Technical-Oracle Application Development Technology-Oracle Apps Technical-Oracle Apps PL/SQL

Roles and Responsibility Design, develop, and implement Oracle PL SQL applications. Collaborate with cross-functional teams to identify and prioritize project requirements. Develop and maintain high-quality, efficient, and well-documented code. Troubleshoot and resolve technical issues efficiently. Participate in code reviews and contribute to improving overall code quality. Stay updated with the latest Oracle technologies and trends. Job Requirements Strong knowledge of Oracle PL SQL development principles and practices. Experience with Oracle database management systems. Excellent problem-solving skills and attention to detail. Ability to work collaboratively in a team environment. Strong communication and interpersonal skills. Familiarity with agile development methodologies. A degree in B.Tech/B.E. or MCA is required.

Job Details Skills Oracle HRMS Technical Consultant Experience 4 to 14 years Location Pan India,Chandigarh,Chennai,Dadra & Nagar Haveli,Jammu,Lakshadweep,Nagar,New Delhi,Puducherry,Daman,Diu,Goa,Haveli,Sikkim Job type Contract to HIRE IDESLABS - Job Description: Minimum 4-7 years Oracle HRMS experience and done end-to-End Implementation, Post implementation Support and AMS support Hands-on Development experience in Oracle EBS HRMS suite of Modules Experience as an ORACLE PL/SQL Developer, involved in Requirement Gathering, analysis, Design, Development, Unit Testing, Production Deployment and Support. Solid Experience of creating Packages, Procedures, Functions, Views, Exception handling, SQL*Loader in Oracle., PL/SQL and SQL PLUS Extensive Oracle programming experience developing complex code units including performance tuning, Shell Scripting In-depth knowledge Designing, Developing and Implementing interfaces in oracle with internal and external systems using Oracle API's like REST/SOAP web services, XML and XSD Experience Building and customizing OAF (Oracle Applications Framework) Pages, developing XML Publisher Reports & XML reporting and Bursting. Ability to work effectively both independently and as part of a team in the creation and validation of user interfaces and technical requirements Development and support of associated interfaces with the above modules in PL/SQL, Java, Oracle Application Framework (OAF), and Oracle eBusiness Suite Workflow. Manage work to client and companys SLA requirements Follow defined methodology for delivering Oracle support as is required by client. Additional knowledge on Integrated SOA Gateway, Applaud, SMTP, LDAP, and IMAP integrations will be added advantage

Develop and maintain Oracle PL/SQL code, including stored procedures, functions, and triggers. Work on data extraction, transformation, and optimization for large-scale Oracle database applications.

Design and develop database solutions using PL/SQL and MySQL. You will optimize queries, handle data manipulation, and ensure high performance of database operations. Expertise in PL/SQL and MySQL is required.

Design, develop, and maintain PL/SQL code for efficient data management and integration with Oracle databases. You will write complex SQL queries, optimize database performance, and ensure data integrity. Experience in PL/SQL development, Oracle databases, and query optimization is essential.

Immediate Openings on Skills: SAP ABAP with S/4 HANA Requires 8+ years of experience in SAP S/4 HANA and/or SAP ECC ABAP development experience Multiple (over 4) SAP implementation full life-cycle experience Team Leadership experience Education and Certifications Undergraduate degree or equivalent combination of education and work experience. Skills Solid knowledge of system development methodology, project management and system architecture. Preferably involving the implementation of SAP ECC or S/4HANA, particularly development best practices processes Solid analytical / problem solving skills Ability to evaluate IT and business challenges from a broad perspective. Strong influencing and excellent communication skills. Ability to translate between non-technical business users and technical IT resources. Strong client service attitude Strong organizational and time management skills Languages English fluency preferred.

Oracle EBS R12 developer1 Skills: 6-8 years of experience as a software developer focused on Oracle EBS development and implementation. Expert level understanding of Oracle EBS technologies (Forms, Reports, Workflow, Oracle Applications Framework (OAF), SQL Loader, Oracle Application APIs), database concepts and optimization techniques, PL/SQL, Unix shell scripts, data mappings, conversions, interfaces and SQL queries (preferably using TOAD). Knowledge on AOL components like Concurrent Programs, Value Sets, Lookups, Profile Options etc. Good knowledge of Supply Chain fundamentals including activities and business models in the following business areaManufacturing, Receiving, BOM, Routings, Oracle Purchasing, Inventory and Order Management Good understanding of SDLC and agile methodologies, software development best practices and coding standards, design principles and architecture concepts, version control system - Git

Job Job TitleGreeter-Bundgarden Job TypeFull-Time We are currently seeking a professional Greeter to join our team at Tanishq Jewellery in Bundgarden. As a Greeter, you will be responsible for welcoming and assisting customers as they enter our store. The ideal candidate will have excellent communication skills, a friendly demeanor, and a passion for providing exceptional customer service. If you are looking for a rewarding opportunity in the retail industry, we would love to hear from you. Apply now to join our team at Tanishq Jewellery as a Greeter-Bundgarden.

Job Description Extensive experience in Oracle SQL, PL/SQL, Java script; writing OOP PL/SQL codes for applications demanding type objects, nested tables (Min 4-5 years) Proficient in scripting using Python (2-3 Years) Exposure to create use cases, functional specifications technical design specifications Proficient in creation of database objects like stored procedures, functions, packages, tables, indexes, triggers, snapshots etc. Good experience in performing data migrations, data loads using ETL tools Strong hands-on experience to be able to design, develop, deploy and support RESTful services Experience in job scheduling using CRON utilities, legacy AT scheduler, windows scheduler, Toad Self-motivated and committed team player with excellent communication and interpersonal skills Solid written and verbal communication skills and able to articulate the technically complex to be understood by both technical and non-technical personnel Able to develop scalable solutions that can be utilized by current and future channels e.g. mobile Understanding the importance of real business engagement in all stages of IT product lifecycle working in agile delivery methodologies Good to have: Hands on experience in Web Services Strong hands-on experience to be able to design, develop, deploy and support RESTful services Good experience in Automation and knowledge on at least one automation tool Development Experience in Oracle Application Express Integration based on-Pager Duty / Slack/Jira/Jira SD/Confluence Knowledge of at least one of the python web framework (Django/Flask) Knowledge of fundamental concepts of Database and Programming languages Any certification in Business Analysis domain Knowledge of tools such as JIRA, MS-Visio, MS Project Plan, MS Office suite etc. Roles & Responsibilities Candidate will be responsible for developing and maintaining features/enhancements and participate in complete life cycle of software solutions based on the business need. Analyze, design develop, troubleshoot and debug software programs Writes code, completes programming and performs testing and debugging of applications Build and execute unit tests and unit plans Review integration and regression test plans Duties and tasks are varied and complex needing independent judgment Work independently with minimal supervision, collaborate with internal/external team members to maintain and make bug fixes for improving existing capabilities Integrate business support systems and automate data flow Perform R&D to propose out of the box solutions and utilize emerging technologies Demonstrate strong analytical skills and always coming up with creative ideas, time management skills and multi-tasking capabilities Develop flowcharts, algorithms and UML diagrams required for design/development Track and fully document functional and business specifications; writes detailed universally understood procedures for permanent records and for use in training

We are currently seeking a ABAP Technical Lead to join our team in Hyderabad, Telangana (IN-TG), India (IN). Responsibilities Our SAP S/4HANA ABAP Development Consultant will support the implementation of SAP S/4 HANA. Duties include but may not be limited to: Lead Technical Development Team in design and gap analysis project for an SAP global Rollout Work collaboratively with the SAP Functional implementation teams and management team on the identification of development requirements Support the creation of functional specification documentation Creation of technical specifications and other development design documentation Development of reports, interfaces, conversion programs, enhancements, forms, and workflows using agile development best practices Testing and documentation of development objects Support during integration and user acceptance testing activities and resolution of issues and bugs identified during testing Support during testing, cutover, Go live, Hyper care post implementation of the project Years of Experience Requires 8+ years of experience in SAP S/4 HANA and/or SAP ECC ABAP development experience Multiple (over 4) SAP implementation full life-cycle experience Team Leadership experience Education and Certifications Undergraduate degree or equivalent combination of education and work experience. Skills Solid knowledge of system development methodology, project management and system architecture. Preferably involving the implementation of SAP ECC or S/4HANA, particularly development best practices processes Solid analytical / problem solving skills Ability to evaluate IT and business challenges from a broad perspective. Strong influencing and excellent communication skills. Ability to translate between non-technical business users and technical IT resources. Strong client service attitude Strong organizational and time management skills Languages English fluency preferred

JOB DESCRIPTION Job Purpose As an individual contributor role, you will be working as a part of data team, responsible of understanding the business requirements, feasibility of data, taking ownership of the tasks and using best practices. He/she will be responsible for designing and implementing the Data solution. Organizational Relationships Key Responsibilities Working with the business to understand processes and capture requirements. Write efficient, clear code and able to articulate what has been implemented and why and along with accompanying test suites. Working with dynamic agile environment. Status reporting both to business and technology management. Provide seamless support to all the business functions. Support the data management activity for doing dashboards Application support as part of team. Functional Responsibilities Develop, design, test and implement complex database programs using Oracle and third-party tools. Designing & creation of table structures Ensure that database programs follow V3 standards. Ability to write & de-bug complex SQL queries Performance tuning of SQL's, application programs and instances. Evaluation of new and upcoming technologies. Providing technical assistance, problem resolution and troubleshooting support. Job Requirements Graduate / Post Graduate. Qualification & Experience Functional Competencies 2-5 years of experience in PL SQL Development Experience in PLSQL Development. Strong experience with oracle functions, procedures, triggers, packages & performance tuning. Hands on development using Oracle SQL & PL/SQL. Experience with Oracle Version 10g, 11g, 12c. Performance tuning of SQL's, application programs and instances. Experience in Query optimization, Experience / Knowledge of Reporting tool Deep Understanding of DB & DWH concepts Strategic and analytical thinking, Problem solving and decision-making skills Behavioral Competencies Strong communication & interpersonal skills People Management & Networking skills

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.

Implementation and support experience as a Business Analyst on Oracle Applications EBS v12.2.6 or higher, including OBIEE reporting Implementation and RICE Customization of Oracle Applications R12 Strong experience with Oracle Applications modules such as AR, AP, GL, OM, iStore, Inventory, Purchasing, Installed Base, Teleservice, iSupport, Advanced Scheduler, Field Service, Mobile Field Service, Depot Repair, Service Contracts, Spares Management, and CRM Common Applications Experience helping business users exploit E-Business full capabilities to meet the needs of the business. Knowledge of OBI and EBS reporting Knowledge of writing SQL statements and troubleshooting PL/SQL Experience with managing and setup of concurrent requests and schedules Strong communication skills and ability to build positive, professional, and productive business relationships with internal and external clients. Ability to create ad hoc SQL queries and SQL reports across many Oracle EBS modules, based on user or audit requirement Familiarity with Oracle Financial modules Knowledge on Grants Accounting and eAM Module is an added advantage Experience in database programming using Oracle 19c/21c databases. Expertise in SQL, PL/SQL, Packages, Functions, Procedures, Triggers, Views, Indexes & Performance tuning etc. Sound knowledge in using Oracle APIs for interfaces to Oracle Financials and AOL/Sys- Admin components. Experience in various development tools like SQL Developer, SQL*Loader, BI/XML Publisher Reports