ETL and PL/SQL Developer
Posted Updated
Description
**\
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
