Pegasys Information Technologies - Alpharetta, GA
posted about 2 months ago
The Database Developer position focuses on utilizing Oracle, SQL, and PL/SQL to develop and maintain robust ETL processes. The ideal candidate will have extensive experience with the ETL process, specifically using Oracle PL/SQL packages, procedures, and various scripting languages such as shell scripts, Perl, Python, or Java. This role requires a strong understanding of data warehousing concepts and the ability to design, develop, and maintain data warehouses and applications effectively. In addition to ETL expertise, the candidate should possess solid skills in SQL performance tuning, debugging, and analyzing SQL code to ensure optimal performance of database queries. Handling bulk loads and managing ETL jobs in a production environment is a critical aspect of this role, requiring attention to detail and a proactive approach to problem-solving. The position also demands familiarity with Agile software development lifecycles, including methodologies such as Scrum, Lean Agile, and Kanban. Experience with data modeling tools like Power Designer or Erwin is essential, as the candidate will be involved in the design and implementation of data models that support business requirements. Overall, this role is pivotal in ensuring the integrity and efficiency of data processes within the organization.