About the job
Envision Employment Solutions is seeking a talented Data Integration Developer to enhance our team and contribute to our enterprise data integration projects. The ideal candidate will possess extensive hands-on experience with Informatica PowerCenter as an ETL tool, coupled with a robust proficiency in SQL and PL/SQL, particularly in the context of enterprise relational databases.
Key Responsibilities:
- Design, develop, test, and support processes for extracting, transforming, and loading data from source systems into data warehouses (DWH) and Data Marts.
- Create processes that align with service level agreements regarding data timeliness and frequency.
- Analyze and enhance current solutions, focusing on physical model optimization and query tuning.
- Provide mentorship to junior team members on best practices in data integration development.
- Assess and improve query and solution performance while optimizing the physical model.
- Document project deliverables thoroughly.
- Familiarity with Online Data Processing Tools is essential.
