Beacon Hill Staffing Group - Boise, ID
posted 4 months ago
The Oracle PL/SQL Developer position at Beacon Hill Staffing Group involves working with a variety of technical skills and tools to develop and maintain database applications. The ideal candidate will have a strong background in SQL and Oracle PL/SQL, along with experience in Unix Shell programming or other scripting languages such as Perl or Python. The role requires extensive proficiency in modern RDBMS products, particularly Oracle's latest version, with PostgreSQL knowledge considered a plus. In this role, the developer will be responsible for utilizing the Informatica Platform, applying best practices for Informatica PowerCenter, Data Transformation, and Informatica B2B Data Exchange products. A strong understanding of Informatica design concepts is essential, as well as experience in ETL processes and data modeling. The developer will create mappings and workflows, implementing ETL concepts effectively. The position also requires the development of complex database objects, including Stored Procedures, Functions, Packages, and Triggers using SQL and PL/SQL. Performance tuning of SQL and PL/SQL queries, including query rewriting and the use of Explain Plan and Hints, is a critical aspect of the job. The candidate should be comfortable with UNIX/Linux platforms and possess solid command-line skills. Agile working experience, particularly with Scrum and SDLC methodologies, is necessary, along with familiarity with Atlassian products such as JIRA, Confluence, and BitBucket. The developer will also engage in DevOps practices, utilizing tools like UC4, Maven, Jenkins, and CI/CD pipelines. Knowledge of object-oriented analysis and design principles is important, as well as programming experience in languages and frameworks such as Java, Angular, or React, JPA, Spring Boot, XML, and JSON. Familiarity with API gateways, such as Gravitee, is a plus. Overall, this position requires a thorough understanding of software methodologies, distributed networking, databases, communications, and multiprocessing applications, making it a challenging yet rewarding opportunity for the right candidate.