Beacon Hill Staffing Group - Topeka, KS

posted 3 months ago

Full-time
Topeka, KS
Administrative and Support Services

About the position

Beacon Hill Technologies is seeking a highly skilled IT professional with extensive experience in SQL, Oracle PL/SQL, and Unix Shell programming. The ideal candidate will have a strong background in modern RDBMS products, particularly Oracle and PostgreSQL, and will be proficient in using the Informatica Platform, including Informatica PowerCenter and B2B Data Exchange products. This role requires a solid understanding of ETL processes and data modeling, with the ability to create mappings and workflows effectively. The successful candidate will have developed complex database objects such as stored procedures, functions, packages, and triggers using SQL and PL/SQL. Performance tuning of SQL and PL/SQL queries is essential, along with experience in using standard Oracle packages and dynamic SQL. Familiarity with UNIX/Linux platforms and commands is also required, as is experience with Agile methodologies, particularly Scrum, and tools such as JIRA and BitBucket. In addition to technical skills, the candidate should have a good understanding of programming languages and frameworks such as Java, Angular, or React, as well as knowledge of API gateways. The role also involves working with DevOps practices and CI/CD tools like Jenkins and Maven. The candidate will be expected to apply object-oriented analysis and design principles in their work, ensuring best practices are followed throughout the software development lifecycle.

Responsibilities

  • Develop and maintain complex database objects including stored procedures, functions, packages, and triggers using SQL and PL/SQL.
  • Create and implement ETL mappings and workflows using Informatica PowerCenter and B2B Data Exchange products.
  • Perform SQL and PL/SQL performance tuning and query optimization.
  • Utilize UNIX/Linux commands for database management and scripting.
  • Collaborate with cross-functional teams using Agile methodologies and tools like JIRA and BitBucket.
  • Implement CI/CD practices using tools such as Jenkins and Maven.
  • Apply object-oriented analysis and design principles in software development.

Requirements

  • Excellent working knowledge of SQL and Oracle PL/SQL.
  • Proficiency in Unix Shell programming (or Perl or Python).
  • Extensive experience with Oracle RDBMS and familiarity with PostgreSQL.
  • Strong experience with Informatica Platform and best practices for ETL processes.
  • Solid experience in data modeling and ETL design concepts.
  • Experience in developing complex database objects and performance tuning.
  • Familiarity with Agile methodologies and DevOps practices.
  • Good knowledge of programming languages such as Java, Angular, or React.

Nice-to-haves

  • Experience with API gateways such as Gravitee.
  • Knowledge of additional programming frameworks like Spring Boot, XML, and JSON.

Benefits

  • Equal Opportunity Employer
  • Encouragement for individuals with disabilities and protected veterans to apply
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service