Job Description

•   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
•   Troubleshooting and resolving data integration issues
•   Solid skills with writing/translating SQL queries and SQL data validation.
•   Performance tuning of SQL queries.
•   Defining, managing, and monitoring job schedules, as well as troubleshooting issues within the Autosys environment
•   Understanding and implementing job schedules, dependencies, and workflows within Autosys
•   Analyzing and resolving issues with Autosys jobs and processes
•   Jobs failures troubleshoot in AutoSys, failure can be Linux scripting, DataStage ETL, Teradata SQL.
•   Part Loader which is ETL in DataStage 

Roles & Responsibilities

•  Optimizing Database jobs for performance by collaborating with DBAs and implementing SQL coding and design changes within the job structure.
•  Actively participated in troubleshooting and resolving issues related to data loading delays and database server outages, ensuring minimal disruption to   data flow and system operations.
•  Engaged in periodic reviews of job logs and performance metrics to identify trends, proactively addressing potential issues.
•  Troubleshooting production issues through meticulous job log reviews, implementing necessary design changes via change management and adhering to   the code promotion process.
•  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 
•  Resolving data issues arising from load delays or database server downtimes, with a focus on ensuring customer satisfaction.
•  Collaborated with stakeholders to understand business requirements, providing valuable insights and recommendations for optimizing data processing   workflows.

Posted By