The business and/or technical problem is to design, develop, and support enterprise data warehouse solutions, ensuring data quality, integrity, and performance while resolving data integration and loading issues.
Requirements
- Design and develop Tera Data ETL jobs and data pipeline.
- Design, Develop and support enterprise data warehouse solutions leveraging Teradata and Teradata tools and utilities.
- Extracting data from various data sources, transforming, and loading it into target systems.
- Ensuring data quality, integrity, and consistency across different systems.
- Optimizing ETL processes for performance, scalability and reliability.
- SQL proficiency (intermediate skill level minimum)
- Ability to manage Teradata SQL
Responsibilities
- Design and develop Tera Data ETL jobs and data pipeline.
- Design, Develop and support enterprise data warehouse solutions leveraging Teradata and Teradata tools and utilities.
- Extracting data from various data sources, transforming, and loading it into target systems.
- Ensuring data quality, integrity, and consistency across different systems.
- Optimizing ETL processes for performance, scalability and reliability.
- Defining, managing, and monitoring job schedules, as well as troubleshooting issues within the Autosys environment
- Troubleshooting production issues through meticulous job log reviews, implementing necessary design changes via change management and adhering to the code promotion process.
Other
- Collaborated with stakeholders to understand business requirements, providing valuable insights and recommendations for optimizing data processing workflows.
- Contributed to the development and maintenance of documentation for troubleshooting procedures, best practices, and system configurations, facilitating knowledge sharing within the team and managing Change Requests
- BACHELOR OF COMPUTER SCIENCE
