Engineer - ETL and PLSQL Developer
Engineer - ETL and PLSQL Developer
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
2. JOB PURPOSE:
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 crossfunctional 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 uptodate documentation of ETL processes PL/SQL queries and data models.
Requirements
6. QUALIFICATIONS & EXPERIENCE:
1. Education: Bachelors degree or Higer.
2. Experience: 35 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 problemsolving skills
Employment Type
Full-Time
