The business and/or technical problem the job is looking to solve is to design, develop, and support enterprise data warehouse solutions, ensuring data quality, integrity, and consistency, while optimizing ETL processes for performance and reliability. This includes troubleshooting and resolving data integration issues, optimizing database jobs, and collaborating with stakeholders to meet business requirements.
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
