| Oracle Developer||Pasadena, CA Parsippany NJ Local at Oracle, Arizona, USA |
| Email: [email protected] |
|
Role: Oracle Developer Location: Onsite 2-3days/wk (Pasadena, CA office or Parsippany NJ office) Candidate must already be local within a 25-mile commuting distance and willing to work onsite for the 2-3 day requirement. Duration: 12+ months Must have Need prior ADP candidates MUST HAVE SKILLSET: Minimum of 8 years of experience Strong PL/SQL Development Skills Proficient in database development utilizing partitions, DBMS jobs, packages, procedures, function, and Oracle user defined types Proficient in working with UI teams/applications and using cursors, XML, JSON etc. Strong experience in developing end-to-end jobs as part of ETL Strong SQL and PL/SQL tuning skills Data analysis skills to debug, trace, and fix performance problems Key Responsibilities: Oracle Exadata: Utilize experience with versions 12c or above to manage and optimize databases. (Currently in 19c) PL/SQL: Handle outdated ETL processes with a strong emphasis on packages, procedures, functions, triggers, and indexing. Provide troubleshooting support as the team transitions to other ETL tools. Dynamic SQL: Develop and maintain dynamic SQL queries. Parallel Processing: Design and automate processes using Autosys. Experience with scheduling software such as Control M, Autosys, and IBM tools is required. SQL Explain Plan: Analyze and optimize SQL queries using Explain Plan. Data Preparation: Prepare data to simplify reporting processes, ensuring minimal need for complex data processing. Requirements Gathering: Collaborate with small business lending teams, especially in digital analytics (AB Initio), to gather and understand requirements. Transformation Projects: Support the transformation of small business processes using tools like nCino, ensuring data integration into the analytics space. Dashboard Integration: Feed data into dashboards for real-time analysis and reporting. Regulatory Reporting: Manage regulatory reporting processes, ensuring all reports are accurately generated and submitted. Automation Recreation: Recreate and optimize processes for automation. Performance Tuning: Apply fundamental knowledge of performance tuning to ensure efficient data processing and system operations. Preferred Skill Sets Familiarity with Oracle Exadata Familiarity with SingleStore/ Mysql is a big plus Experience with Python, exposure to DB connect libs and others like requests, Json, pandas etc. Regards, Adarsh Jaiswal Technical Recruiter 1 Point System LLC 115 Stone Village Drive Suite C Fort Mill, SC 29708 L: linkedin.com/in/adarsh-jaiswal-065a90224 E : [email protected] | W : www.1pointsys.com -- Keywords: user interface database information technology procedural language California New Jersey South Carolina Oracle Developer||Pasadena, CA Parsippany NJ Local [email protected] |
| [email protected] View All |
| 07:28 PM 06-Mar-25 |