You will design, develop, and optimize ETL processes to ensure data reliability and performance. You translate data requirements into technical solutions and collaborate with Architects and Project Managers to build integration pipelines.
Responsibilities
- Design and develop ETL processes for extracting data from various sources.
- Monitor and administer automated and manual ETL jobs.
- Create, execute, and document unit test plans for data integration programs.
- Maintain technical specifications and user guides for all ETL processes.
- Troubleshoot and support existing ETL workflows.
Required Skills
- 5+ years of experience in ETL development.
- Proficiency with Matillion and DataStage.
- Hands-on experience with Snowflake and Netezza.
- Strong understanding of Data Warehousing techniques, including Star Schema, Snowflaking, Normalization, Denormalization, and Aggregations.
- Ability to translate data requirements into technical solutions.
- Experience troubleshooting and supporting ETL processes.
Preferred Skills