Responsibilities:Design, development and support of ETL processes using tools and Oracle technologies.Extract, transform and load data from various sources into data warehouses.Collaborate with data architects, analysts and stakeholders to understand data requirements. Optimizing ETL workflows to increase productivity and efficiency.Ensuring data integrity, quality, and security throughout the ETL process.Resolving issues related to ETL processes .Create and maintain documentation for ETL proces
Responsibilities:
- Design, development and support of ETL processes using tools and Oracle technologies.
- Extract, transform and load data from various sources into data warehouses.
- Collaborate with data architects, analysts and stakeholders to understand data requirements.
- Optimizing ETL workflows to increase productivity and efficiency.
- Ensuring data integrity, quality, and security throughout the ETL process.
- Resolving issues related to ETL processes .
- Create and maintain documentation for ETL processes and data compliance.
- Monitor ETL tasks and ensure timely and accurate data loading.
Requirements:
- Education: Bachelor's degree in Computer Science, Information Technology or related field.
- < strong>Experience:
- For Senior level: 5+ years of ETL development experience.
- For Regular level: 2+ years of ETL development experience.
- /ul>
- Technical skills:
- Proficiency in Oracle database technologies, including Oracle PL/SQL.
- Practical experience with Oracle Data Integrator (ODI) (creation of mappings, scripts, packages, procedures, load plans) from 2 years.
- Experience with other ETL tools (for example, Informatica, Talend, SSIS, Apache NiFi) .
- Deep understanding of data warehouse concepts and methodologies.
- Experience in data modeling and database design.
- Knowledge of performance optimization of ETL processes and SQL queries.
- Knowledge of Unix/Linux scripting.
- Personal Skills:
- Strong analytical and problem solving skills .
- Excellent communication and cooperative skills.
- Ability to work independently and as part of a team.
- Attention to detail with an emphasis on quality and accuracy.
< /ul>
- Additional requirements:
- Experience with cloud-based ETL solutions is an advantage.
- Knowledge of other database technologies (e.g. , SQL Server, MySQL) is an advantage.
- Certification in relevant technologies is a plus.