This job was posted by : For more information, please see: NOTE: This is a 100% Remote Position. Candidates will be working on PST Hours One of our clients in San Deigo, California is looking for an Oracle PL/SQL Developer with the following skills and experience: Interview Process: First Round: CoderByte technical assessment (\2 hours) Second Round: 1-hour panel interview with the team Must-Have Skills: PL/SQL, Informatica, SQL, ETL, Performance Tuning Required Skills: Technical Skills: PL/SQL Development: 5+ years of experience, specifically with Oracle. Proficient in developing complex database objects such as Stored Procedures, Functions, Packages, and Triggers using SQL and PL/SQL. Informatica: Expertise in data integration and ETL processes using Informatica PowerCenter, Data Transformation, and Informatica B2B Data Exchange products. Strong understanding of Informatica design concepts and best practices. SQL & Performance Tuning: Experience in SQL and PL/SQL Performance Tuning, query rewriting, and the use of Explain Plan and Hints. Proficient in Collections, Exception Handling, Partitioning techniques, BULK features, Analytics functions, and External tables. ETL & Data Modeling: Strong ETL and data modeling experience, including creating mappings and workflows, and implementing ETL concepts. Unix/Linux: Comfortable with UNIX/Linux platforms and commands. Experience in Unix Shell, Perl, or Python programming languages. Additional Technical Skills: Proficiency in the latest version of Oracle RDBMS. PostgreSQL knowledge is a plus. Experience with Standard Oracle Packages (e.g., UTL_FILE), Dynamic SQL, Records, Arrays, PL/SQL tables, and File handling. Familiarity with Agile methodologies, Scrum, and SDLC best practices. Experience with Atlassian products (JIRA, Confluence, BitBucket). Knowledge of DevOps tools such as UC4, Maven, Jenkins, and CI/CD pipelines. Understanding of object-oriented analysis and design principles. Experience in modern programming languages and frameworks (e.g., Java, Angular or React, JPA, Spring Boot, XML, JSON). Knowledge of API gateways (e.g., Gravitee) is a plus. Comprehensive knowledge of software methodologies, distributed networking, databases, communications, and multiprocessing applications. Nice-to-Have Skills: Experience with Java, Angular or React, JPA, Spring Boot, XML, and JSON. Interested candidates may submit their resumes online or call at for further information regarding the position. Beacon Hill is an Equal Opportunity Employer that values the strength diversity brings to the workplace. Individuals with Disabilities and Protected Veterans are encouraged to apply. If you would like to complete our voluntary self-identification form, please click here or copy and paste the following link into an open window in your browser: Completion of this form is voluntary and will not affect your opportunity for employment, or the terms or conditions of your employment. This form will be used for reporting purposes only and will be kept separate from all other records. Company Profile: Beacon Hill Technologies, a premier National Information Technology Staffing Group, provides world class technology talent across all industries utilizing a complete suite of staffing services. Beacon Hill Technologies\’ dedicated team of recruiting and staffing experts consistently delivers quality IT professionals to solve our customers\’ technical and business needs. Beacon Hill Technologies covers a broad spectrum of IT positions, including Project Manageme t and Business Analysis, Programming/Development, Database, Infrastructure, Quality Assurance, Production/Support and ERP roles. Learn more about Beacon Hill Staffing Group and our specialty divisions, Beacon Hill Associates, Beacon Hill Financial, Beacon Hill HR, Beacon Hill Legal, Beacon Hill Life Sciences and Beacon Hill Technologies by visiting . We look forward to working with you. Beacon Hill. Employing the Future
PostgreSQL Informatica API Spring Boot Python JSON PL/SQL Perl Performance optimization SQL XML Java JPA ETL React Angular