Senior Database Developer

Description

Job Summary: We are seeking a Data Developer to collaborate with the Pentaho team, developing and maintaining SQL Server databases, optimizing performance, and ensuring data quality. Key Highlights: 1. Collaborate with the Pentaho team on the Quality Gate Integration project 2. Develop and maintain SQL Server databases 3. Optimize performance and ensure data quality **What We Are Looking For?** We seek a Data Developer to work closely with the Pentaho development team in delivering a robust Quality Gate Integration project deployed on OpenShift. The role involves developing and maintaining SQL Server databases, supporting ETL data flows, optimizing performance, and ensuring the quality and integrity of data provided to downstream systems. **Main Responsibilities:** #### **1\. Database Design and Development** * Design, develop, and maintain SQL Server databases—including tables, views, and stored procedures—within the Quality Gate framework. * Collaborate with Pentaho developers to implement and test data transformations and validation logic. * Support schema design, data mapping, and configurations aligned with business rules and integration contracts. #### **2\. Data Quality and Validation** * Create SQL scripts for data validation, cleansing, and reconciliation. * Ensure data integrity across systems such as PIM, PXHub, and output platforms. * Implement exception handling mechanisms and anomaly reporting. #### **3\. Performance and Optimization** * Analyze and optimize queries, indexes, and execution plans for large data volumes. * Identify performance bottlenecks in ETL processes and propose improvements. #### **4\. Integration and Automation** * Integrate SQL components into ETL pipelines developed in Pentaho. * Contribute to automation of deployments and scheduling in the OpenShift environment. * Collaborate with architects and infrastructure teams to ensure continuous data flow and execution monitoring. #### **5\. Documentation and Knowledge Transfer** * Document database structures, data dictionaries, and SQL logic. * Support knowledge transfer to support and operations teams. **Requirements:** Technical Expertise * 3–5 years of experience in SQL Server database development and administration. * Proficiency in T-SQL, performance tuning, and stored procedure development. * Experience in ETL or data pipeline projects, preferably using Pentaho Data Integration (PDI). * Strong knowledge of data modeling, normalization, and relational design. Integration and Platforms * Experience with containerized environments (OpenShift or Kubernetes). * Familiarity with integrations via SFTP, APIs, or files between enterprise systems (PIM, PLM, ERP). * Understanding of data validation frameworks and information governance. Collaboration and Delivery * Ability to work collaboratively with ETL developers, system architects, and QA teams. * Experience with agile methodologies and sprint-based delivery. * Strong analytical, documentation, and communication skills. **Nice-to-Have:** Experience with Pentaho Data Integration (PDI) or similar ETL tools Knowledge of DevOps, CI/CD, and OpenShift deployment models Familiarity with Python or shell scripting for task automation **Location: Curitiba/PR** **Why Build Your Career at Meta?** We offer autonomy, clear goals, and a dynamic, challenging environment where professionals have the opportunity to interact with diverse technologies, participate in all types of projects, bring new ideas, and work from anywhere in Brazil—and why not, the world? Additionally, we are one of the best companies to work for in Brazil according to Great Place to Work and among the top 10 fastest-growing companies in the country for three consecutive years, per the Informática Hoje Yearbook. **Our Values:** * We are people serving people * We think and act like owners * We have a drive for performance * We grow and learn together * We pursue excellence and simplicity * Innovation and creativity are in our DNA All individuals are welcome regardless of their background, disability, ethnicity, religious belief, sexual orientation, appearance, age, or related factors. We want you to grow with us in an inclusive environment full of opportunities. If this resonates with you, \#VemSerMeta!