Oracle PL/SQL Developer

Must-Have Skills: Core Oracle PL/SQL Engineering: Development of complex stored procedures, packages, database business logic, custom data types, and transactional data modeling. Advanced SQL Analytics & Data Manipulation: Analytical and windowing functions, complex joins, aggregation pipelines, set operators, and subquery optimization. Database Performance Tuning: Query optimization, reading execution plans, database diagnostics, PGA memory tuning, and partitioning strategies. ETL, Batch & DevOps Integration: Informatica PowerCenter mapping development, Autosys batch job scheduling/recovery, and database ATDD automation with CI/CD deployment pipelines. Job Responsibilities: Expertise writing Oracle SQL and PLSQL code, performing data analysis, data modelling, designing and implementation of data APIs and performance tuning. Expertise writing and maintaining batch jobs with technologies like ETL/Informatica and Autosys Understanding of fundamental design principles for building a scalable application Experience following ATDD (acceptance test driven development) and writing automated tests for database code. Experience with cloud technologies is a bonus: Snowflake, S3 Interest in writing clean, testable, readable, easily maintainable, and performant code. Benefits at IntelliBee Long-Term Stability: Join us on a multi-year opportunities with room to grow. Comprehensive Health Coverage: Access quality healthcare benefits to keep you and your family well. Future Planning: Enroll in our 401(k) program and invest in your financial security. GC Assistance: We support immediate Green Card processing, if required.