| Oracle Developer with Need prior ADP candidates || hybrid in Pasadena, CA or Parsippany NJ (local dl , local only )25 mils || Visa: GC Holder, GC EAD, US Citizen at Pasadena, Texas, USA |
| Email: satyam0720@gmail.com |
|
Share me resume at satyam@1pointsys.com 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. Visa: GC Holder, GC EAD, US Citizen C2C 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, Satyam Gupta 1 Point System LLC satyam@1pointsys.com -- Keywords: user interface database information technology green card procedural language California New Jersey Oracle Developer with Need prior ADP candidates || hybrid in Pasadena, CA or Parsippany NJ (local dl , local only )25 mils || Visa: GC Holder, GC EAD, US Citizen satyam0720@gmail.com https://jobs.nvoids.com/job_details.jsp?id=2232515 |
| satyam0720@gmail.com View All |
| 07:26 PM 06-Mar-25 |