Etl & Data Integration Engineer

- Design, develop, and maintain ETL processes and data integration workflows across multiple source and target systems.
- Develop complex Oracle PL/SQL procedures, packages, functions, triggers, and SQL queries.
- Build and optimize data extraction, transformation, and loading processes for performance and scalability.
- Work with ODI, DataStage, or Informatica PowerCenter to develop, tune, and maintain ETL workflows.What You Will Do On a Daily BasisDevelopment & Maintenance- Design, develop, and maintain ETL processes and data integration workflows across multiple source and target systems.
- Develop complex Oracle PL/SQL procedures, packages, functions, triggers, and SQL queries.
- Build and optimize data extraction, transformation, and loading processes for performance and scalability.
- Work with ODI, DataStage, or Informatica PowerCenter to develop, tune, and maintain ETL workflows.Analysis & Design- Analyze business and technical requirements and translate them into scalable, maintainable data solutions.
- Design data models and mapping specifications in collaboration with data architects and business stakeholders.
- Document ETL processes, data flows, and technical specifications.Quality & Support- Monitor, troubleshoot, and resolve issues in ETL jobs and data pipelines, ensuring data quality and integrity.
- Lead testing and validation of ETL processes before deployment.
- Provide production support and root-cause analysis for complex data-related incidents.Collaboration- Work closely with business analysts, DBAs, and other developers to ensure alignment between technical solutions and business needs.
- Lead code reviews and drive best practices for ETL development.
- Mentor junior team members.Your Key Skills- Solid professional experience as an ETL Developer / Data Integration Developer.
- Strong hands-on experience with Oracle Database and PL/SQL (procedures, packages, functions, triggers).
- Solid experience with at least one ETL tool: ODI, DataStage, or Informatica PowerCenter.
- Proven experience developing, optimizing, and troubleshooting complex ETL processes.
- Strong understanding of data warehousing concepts and data modeling.
- Strong analytical and problem-solving skills.
- Ability to work independently, manage priorities, and mentor others.
- Strong communication skills, able to work with both technical and business stakeholders.
- Fluent English (written and spoken);
Portuguese is a plus.Location & Schedule- Hybrid, 2x/week — AmoreirasWhat can you expect from us?
Mind-blowing workplace culture.
You will be integrated in a professional, dynamic and collaborative team.100% Remote opportunitiesWe want you to have the flexibility to work where you feel most comfortable and productive.International Career- You can expect professional growth and to be connect with the world.
- We are represented in Portugal, Belgium, Luxembourg, and Denmark.
- And with projects in many other countries: Netherlands, Luxembourg, Singapore and in the United States of America (and a lot more is coming...)Extra Benefits & Perks- If you wish to work with us and you are outside European Union (good news...) we are a Tech Visa Company, We will help
- As a plus, we provide Health and Life Insurance.
#J-*-Ljbffr