Data Engineer / Data Warehouse Developer
PPG
Santiago de Querétaro, Querétaro, Mexico
hace 1 hora

As a Data Warehouse Developer, you will be working as part of the Data Analytics Center team and will be responsible for the data warehouse development over Oracle and SQL Server Databases, also eventually will start developing in Azure Databricks.

Key Responsibilities

  • Design and Develop database tables, views, queries and stored procedures as part of Data Analytics solutions to cover business needs based on data warehouse standard methodologies.
  • Apply modifications suggested in the executions plan to improve performance in existing objects like indexes, hints or even table partitioning if vital.
  • Work with development methodologies in order to achieve requirements on time.
  • Participate in collecting requirements with other members, providing mentorship on databases topics.
  • Promote developments among DEV, UAT and PROD environments.
  • Write technical specification documents for new processes.
  • Optimal execution of integration processes.
  • Tackle issues in existing integration processes reported through the IT service desk or related to data problems.
  • Deliver administrative, technical and functional documentation, in relation to developments or modifications made on integration processes.
  • Run unit tests, together with the client and the IT quality area (QA), in order to validate the correct functioning of the application
  • Qualifications

  • Bachelor's Degree or higher education in Computer Science, Software Engineering, Information Systems or a related field.
  • Advance knowledge in performance and development in Oracle databases
  • Medium experience in SQL Server databases.
  • Good understanding of data warehouse architecture
  • Advance experience in PL / SQL programming
  • Advance experience crafting tables, views (joins, filtering), aggregation, stored procedures, loops also implementing indexing, hints, partition.
  • Reportar esta oferta
    checkmark

    Thank you for reporting this job!

    Your feedback will help us improve the quality of our services.

    Inscribirse
    Mi Correo Electrónico
    Al hacer clic en la opción "Continuar", doy mi consentimiento para que neuvoo procese mis datos de conformidad con lo establecido en su Política de privacidad . Puedo darme de baja o retirar mi autorización en cualquier momento.
    Continuar
    Formulario de postulación