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.
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.
1. Education: Bachelor's degree or Higer.
2. Experience: 3-5 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