Beacon Hill Staffing Group - Montpelier, VT
posted 4 months ago
The Oracle PLSQL Developer position at Beacon Hill Staffing Group is a critical role that requires a deep understanding of SQL and Oracle PLSQL, along with proficiency in Unix Shell scripting or programming languages such as Perl or Python. The ideal candidate will have extensive experience with modern RDBMS products, particularly Oracle in its latest version, and familiarity with PostgreSQL is considered a plus. This role demands a strong background in the Informatica Platform, including best practices for Informatica PowerCenter, Data Transformation, and Informatica B2B Data Exchange products. The candidate should be adept in Informatica design concepts and have a solid foundation in ETL processes and data modeling, including the creation of mappings and workflows. In addition to technical skills, the position requires the development of complex database objects such as Stored Procedures, Functions, Packages, and Triggers using SQL and PLSQL. The candidate should have experience with standard Oracle packages, dynamic SQL, and performance tuning techniques, including query rewriting and the use of Explain Plan and Hints. Expertise in collections, exception handling, partitioning techniques, and analytics functions is essential. The role also necessitates a solid understanding of the UNIX/Linux platform and its commands, as well as experience with Agile methodologies, particularly Scrum and SDLC best practices. Familiarity with DevOps practices, including tools like UC4, Maven, Jenkins, and CI/CD processes, is also required. The candidate should possess knowledge of object-oriented analysis and design principles, along with programming languages and frameworks such as Java, Angular, or React, JPA, Spring Boot, XML, and JSON. Experience with API gateways, such as Gravitee, is a plus. The Oracle PLSQL Developer will play a vital role in ensuring the efficiency and effectiveness of database operations and will contribute to the overall success of the IT team at Beacon Hill Technologies.