7-10 years’ experience in Oracle Exadata, SQL, PL/SQL
Implement ETL solutions for large volume of data by applying various data warehouse modeling techniques like Star Schema, Data partitioning, Data compression, Direct path loads etc. and that maximizes re-usable components and services that incorporate versioning, reconciliation and exception handling
2-3 years’ experience in SQL Performance tuning. Perform application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, AUTOTRACE and AWR Reports.
Should have a clear understanding of Oracle Server Process Architecture and memory structures PGA (Program Global Areas) SGA (System Global Areas) to optimize memory usage.
Knowledge about Oracle VPD
Knowledge of Python is a desirable and a plus
Strong coding, debugging, and analytical skills
Knowledge about Oracle architecture and process
Knowledge of computer science data structures and algorithms
Experience with Analytic reporting tools like Tableau
Analytical skills to perform technical and functional analysis with strong communication skills
Experience working in regulatory projects is strongly desirable
Experience working in Containers
Seniority level
Mid-Senior level
Employment type
Full-time
Job function
Information Technology
Industries
Information Technology & Services
Referrals increase your chances of interviewing at V Technology Solutions LLC by 2x