STRONGPOINT CONSULTING
Onsite from Day 1 Job Description A candidate who works as a PL/SQL Developer but also collaborates with the Data Warehouse and UI (react) or App Dev (.NET) or other Database Dev (Oracle) teams. Core PL/SQL Development Skills Strong expertise in PL/SQL programming (procedures, functions, packages, triggers). Writing and optimizing complex queries, performance tuning, and debugging. Hands-on experience with Oracle databases (or other relational databases with PL/SQL-like capabilities). Knowledge of transaction management, error handling, and exception handling. Understanding of ETL (she does not want someone heavy ETL) Understanding of star/snowflake schema, fact/dimension tables, and slowly changing dimensions (SCD). Ability to extract, transform, and load (ETL) large datasets efficiently. Proficiency in SQL performance tuning for data warehouse queries. Experience with materialized views, partitions, and indexing strategies. General Technical & Soft Skills Strong problem-solving and analytical thinking for data modeling and debugging. Experience with version control (Git, Bitbucket, SVN). Good communication skills to translate business requirements into technical implementations.