Engineer - ETL and PL/SQL Developer

We are seeking an experienced ETL and PL/SQL Developer to design, develop, test, and deploy data integration solutions using ETL tools and PL/SQL. The successful candidate will work closely with cross-functional teams to ensure data quality, accuracy, and integrity.

4. KEY ACCOUNTABILITIES:

1. ETL Development: Design, develop, test, and deploy ETL processes using ETL tools (ODI) to extract, transform, and load data into various data warehouses and systems.

2. PL/SQL Development: Write complex PL/SQL queries to extract, manipulate, and analyze data from relational databases (e.g., Oracle, SQL Server).

3. Data Modeling: Develop and maintain data models, data dictionaries, and data mappings to ensure data consistency and integrity.

4. Data Quality: Identify and resolve data quality issues, ensuring data accuracy, completeness, and consistency.

5. Collaboration: Work closely with business stakeholders, data analysts, and data scientists to gather requirements, design solutions, and implement data integration projects.

6. Testing and Deployment: Test ETL processes and PL/SQL queries to ensure data integrity and deploy changes to production environments.

7. Performance Optimization: Optimize ETL processes and PL/SQL queries to improve performance, scalability, and reliability.

8. Documentation: Maintain accurate and up-to-date documentation of ETL processes, PL/SQL queries, and data models.