We are seeking a skilled Data Integration and Analytics Solutions Architect to design, develop and lead the delivery of enterprise-grade data integration solutions.
About the Role:
The ideal candidate will have deep expertise in data engineering with a strong understanding of Oracle performance tuning and Oracle Data Integrator (ODI). They will also possess excellent leadership and communication skills to collaborate effectively with cross-functional teams.
* Develop and implement data integration solutions using Oracle Data Integrator (ODI) and other related technologies.
* Optimize query and database performance to meet strict service level agreements.
* Analyze execution plans and recommend indexing, partitioning, and optimization strategies.
Key Responsibilities:
· Optimize query and database performance to meet strict SLAs (<2 seconds).
· Analyze execution plans and recommend indexing, partitioning, and optimization strategies.
· Partner with DBAs to validate and implement tuning recommendations.
· Develop and implement data integration solutions using Oracle Data Integrator (ODI) and other related technologies.
Required Skills and Qualifications:
Essential Qualifications:
* 7+ years of experience in data engineering within enterprise-scale environments.
* Expertise in Oracle performance tuning, including query optimization, execution plans, indexes, partitioning, and parallelism.
* Hands-on experience writing and optimizing complex SQL queries.
* Expertise in Oracle Data Integrator (ODI).
* Experience in data warehouse design, ETL/ELT processes, and data modeling.
* Proven leadership experience, including team mentoring and technical guidance.
* Excellent communication skills, with the ability to collaborate effectively with cross-functional teams.
Nice to Have:
* Hands-on experience with AWS data services (S3, Redshift, Glue, Lambda, DMS).
* Prior experience in Wealth Management.
Benefits:
We offer a dynamic and challenging work environment where professionals have the opportunity to interact with different technologies, participate in various projects, bring new ideas and work from anywhere in Brazil and worldwide. We value our employees' growth and well-being, offering opportunities for learning and development, as well as a competitive compensation package.
Our Values:
- People serving people - Teamwork and collaboration - Pursuing excellence and simplicity - Innovation and creativity - Growth and learning together