Compunnel Software Group

posted 2 months ago

Full-time - Mid Level
Professional, Scientific, and Technical Services

About the position

The position involves designing both logical and physical databases, ensuring that they meet the requirements of the organization while optimizing for performance and scalability. The candidate will be responsible for coding database descriptions and specifying user access levels to ensure data security and integrity. This role requires a thorough review of existing database programs, testing them for errors, and implementing corrections as necessary to maintain optimal functionality. Additionally, the candidate will modify database programs to enhance processing performance, utilizing technologies such as Oracle, Sybase, and SQL. In this role, the individual will also engage in data modeling and warehousing applications, leveraging ETL (Extract, Transform, Load) tools such as Informatica, Data Stage, and Oracle Data Integrator (ODI). This involves working closely with data architects and business analysts to understand data requirements and translate them into effective database solutions. The candidate will be expected to collaborate with cross-functional teams to ensure that data flows seamlessly across systems and that the databases are designed to support business intelligence and analytics initiatives.

Responsibilities

  • Design logical and physical databases to meet organizational needs.
  • Code database descriptions and specify user access levels.
  • Review, test, and correct program errors in existing database applications.
  • Modify database programs to enhance processing performance using Oracle, Sybase, and SQL.
  • Engage in data modeling and warehousing applications using ETL tools like Informatica, Data Stage, and Oracle Data Integrator (ODI).
  • Collaborate with data architects and business analysts to understand data requirements.
  • Ensure seamless data flow across systems and support business intelligence initiatives.

Requirements

  • Proficiency in database design and implementation.
  • Experience with Oracle, Sybase, and SQL technologies.
  • Strong skills in coding and modifying database programs.
  • Knowledge of ETL tools such as Informatica, Data Stage, and Oracle Data Integrator (ODI).
  • Ability to review, test, and correct program errors effectively.
  • Experience in data modeling and warehousing applications.

Nice-to-haves

  • Familiarity with cloud-based database solutions.
  • Experience with performance tuning and optimization of databases.
  • Knowledge of data governance and data quality best practices.

Benefits

  • Health insurance coverage.
  • 401(k) retirement savings plan.
  • Paid time off and holidays.
  • Professional development opportunities.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service