Contact Details:
1.Savitha Chinnappa
Email:
Cell: (732)
2.Pio Dhivagar
Email:
Cell: (732)/ Ext.420
Job Title: Oracle PL/SQL Developer (hands on) Location: Charlotte NC (Hybrid 3 days Onsite)
Duration: 12 Months
Years of Experience: 8 Yrs.
Required Hours/Week: 40hrs./Week
Mandatory Skills and Experience:
7 years of experience in Oracle PL/SQL Programming (Critical) 7 years of experience in Oracle SQL (Critical) 5 years of experience in Data Warehouse and Large data processing (Critical) Unix Shell Scripting is important 3 years of experience in Autosys or any Job Scheduler is important (Autosys preferred) 13 years of experience in Python programming (Desirable)
Duties and Responsibilities:
- Oracle Exadata: 19c 12c or above.
- PLSQL: outdated ETL process. Google Cloud Migration coming up so no investing. Homegrown environment: 95% PLSQL troubleshooting is that they are doing things in other ETL tools not using PL SQL as primary measures (package procedures functions triggers indexing).
- Dynamic SQL
- Parallel Process: Design Automation through Autosys. Scheduling software experience: Control M Autosys IBM tool
- Explain plan in SQL
- Position does not create reports
- Prepare the data so reporting becomes easy. So they dont have to complex data processing. This position is technical work.
- Gathering requirements Small Business Lending: 2 teams (digital analytics (AB Initio
- Small Business is going through a transformation. (nCino).
- nCino: all the data will have to come into the analytic space
- Dashboards: feed data to dashboards.
- Regulatory reporting: every single regulatory report is coming through Desikan.
- Recreating processes in Automation.
- Previous Companies: Previous Wells Fargo experience.
- Performance Tuning fundamental knowledge of knowing what the data is they need to know how things work behind the scenes.