Job Description

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.

Qualification and Experience

1. Education: Bachelor's degree or Higer.

2. Experience: 8-10 years of experience in ETL and PL/SQL development.

3. Skills:

- ETL tools (Informatica PowerCenter, Microsoft SSIS)

- PL/SQL (Oracle, SQL Server)

- Data modeling and data warehousing concepts

- Data quality and data integrity principles

- Collaboration and communication skills

- Strong problem-solving skills