Job Description
Proven track record in Oracle PL/SQL Lead Developer/Scrum Master, Reporting and Dashboarding, Design, Development, Testing, and implementation of Business Applications using Relational database Management Systems (RDBMS)
Oracle Certified associate for Oracle 8i/9i/10g/11g/12c Databases with experience and skills in data collection, analysis, and management.
SnowPro Advanced Data Engineer/Analyst Certification with skills to apply comprehensive data engineering principles using Snowflake.
Experience in design, analysis, development, and implementation of various application environments using BI Tools.
Works well under pressure and consistently meets data management and application reporting deadlines and targets while delivering high-quality work.
Excellent technical and Analytical skills with a clear understanding of product design goals using Tables, Functions, Indexes, Analytical Functions, Materialized Views, and Table Partitioning.
Good understanding of database architecture, data warehousing, data modeling, and ETL to develop complex database objects like Stored Procedures, Functions, Packages, and Triggers.
Strong hands-on experience implementing dashboarding, data visualizations, and analytics using Tableau Desktop and Server.
Produce attractive visuals/dashboards to convey the story inside the data and worked on Test plans, Test Strategies, Debugging, Object testing, and Functional Testing.
Extensive knowledge of manual code formatting, Performance testing, Integration Testing, and User Acceptance Testing (UAT).
Developed, enhanced, and implemented standard UNIX Shell scripts, and Windows batch/FTP scripts for database monitoring, exports, and transfers.
Created shell scripts for invoking SQL scripts and scheduled them using cronjob and worked on transforming complex datasets to integrate with end reports and dashboards.
Expertise in Dynamic SQL, Collections, and Exception Handling. Experience in SQL Performance tuning.
Worked with customers and product data experts to prioritize and validate requirements.
Maintained and implemented physical data model for DDWA report metadata.
Created JSON NOSQL schema logical models based on legacy CRD applications.
Architected, developed, and maintained zero downtime, non-DMS configuration.
Oracle Certified
Bachelor’s degree in computer science/engineering or other relevant discipline. A minimum of 7 years of work experience may be substituted for bachelor’s degree requirements.