ETL Data Engineer

ETL and database (Oracle/Teradata/SQL Server) understanding to perform day to day Prod support activities.

SQL proficiency (intermediate skill level minimum)

Experience in ETL tool like DataStage/ Teradata (TPT, BTEQ)

Ability to manage Teradata/SQL Server/ Oracle database migration including code migration, data loads and server

retirements.

Solving basic data types problems (casting, NULL handling)

Solid skills with writing/translating SQL queries and SQL data validation.

Performance tuning of SQL queries.

On-call production support, promptly identifying defects, documenting them in on-call logs, and efficiently resolving issues without violating SLA commitments.

Diligently monitoring Autosys scheduler to track all the jobs ran within SLA.

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

Engaging in SOX activities to maintain compliance and ensure regulatory requirements are met.

Optimizing DataStage jobs for performance by collaborating with DBAs and implementing SQL coding and design changes within the job structure.

Resolving data issues arising from load delays or database server downtimes, with a focus on ensuring customer satisfaction.

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.

Collaborated with stakeholders to understand business requirements, providing valuable insights and recommendations for optimizing data processing workflows.