Beacon Hill Staffing Group - Frankfort, KY
posted 3 months ago
The Oracle PL/SQL Developer position at Beacon Hill Staffing Group, LLC 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 scripting or programming languages such as Perl or Python. The role requires extensive proficiency in modern RDBMS products, particularly Oracle, and familiarity with PostgreSQL is considered a plus. The developer will be expected to work with the Informatica Platform, applying best practices for Informatica PowerCenter, Data Transformation, and Informatica B2B Data Exchange products. A solid understanding of Informatica design concepts is essential for this role. In addition to database development, the candidate will be responsible for creating complex database objects, including Stored Procedures, Functions, Packages, and Triggers using SQL and PL/SQL. Performance tuning of SQL and PL/SQL queries, along with the use of Explain Plan and Hints, will be a critical part of the job. The developer should also have experience with ETL processes, data modeling, and the creation of mappings and workflows. Familiarity with UNIX/Linux platforms and Agile methodologies, particularly Scrum and SDLC, is also required. The role may involve using tools such as JIRA, Confluence, BitBucket, and CI/CD tools like Jenkins and Maven. The position also requires knowledge of object-oriented analysis and design principles, as well as programming languages and frameworks such as Java, Angular, React, JPA, and Spring Boot. Understanding of XML and JSON, along with experience with API gateways, will be beneficial. The Oracle PL/SQL Developer will be part of a diverse team that values inclusion and encourages individuals with disabilities and protected veterans to apply. Beacon Hill Technologies is committed to providing world-class technology talent across various industries, and this role is crucial in delivering quality IT solutions to meet customer needs.