• 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