Required qualifications, capabilities, and skills
- BS/BA university degree, specialized training or equivalent work experience.
- 8 years of Experience across the data lifecycle.
- 5+ years of strong experience with data management activities, that includes : Relational and Dimensional data modeling, SQL querying, DB / Query Performance Tuning, hands on development using PL / SQL, experience in writing Oracle Packages, Stored procedures, Functions, Triggers, including working with scheduling tools like Autosys.
- Advanced Knowledge at SQL (e.g., joins and aggregations)
- Working understanding of NoSQL databases
- Significant experience with statistical data analysis and ability to determine appropriate tools and data patterns to perform analysis
- Database Management skills including Data Analysis & Comparison, Data Quality Management, Reference and Master Data Management.
- Excellent knowledge of DB technologies including Oracle, Autosys, Shell Scripting and writing complex queries using SQL.
- Practical experience with unit testing and troubleshooting PL/SQL code.
- Experience with Oracle system tables, Data Privacy, Access and Security
Preferred qualifications, capabilities and skills
- Familiarity and experience with Data Lakes, Data Lakehouses (Databricks), ETL, Data Mesh, AI / ML Concepts, LLM etc.
- Knowledge of Data warehousing and Business Intelligence concepts.
- Hands on experience in working with tools like ERWIN, Oracle SQL Developer, TOAD etc.
- Cloud - Experience with both Private and Public clouds.
- Knowledge on cloud-based application architectures, micro services, and distributed systems.
- Knowledge of build tools, source control like Git/Bitbucket with CI/CD.