Teradata ETL Engineer

Hello,

Greetings!

This is Adesh from Jconnect INC. Below is the requirement with our client. Please let me know if you are available for this role

Role: Teradata ETL Engineer

Location: Seattle, WA/St. Louis, MO/Plano, TX/Dallas, TX/Houston, TX

Type: Fulltime

Job Description:

Must Have Technical/Functional Skills

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.

Creating BTEQ scripts for complex metadata driven ingestion and massive data loads.

Ability to write and understand complex stored procedures.

Developing and maintaining data warehouses, data lakes and data mart architecture.

Optimizing ETL processes for performance, scalability and reliability.

SQL proficiency (intermediate skill level minimum)

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

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

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.

Please fill the below details and attach your updated resume:

Full Legal Name:

Current Location:

Phone:

Mail:

Visa/Work Permit:

Interview Availability:

Salary/Hourly Rate Expectations:

Are you willing to Relocate:

Preferred Start Date:

Overall IT Experience:

LinkedIn URL:

Thanks and Regards,

Adesh Kumar

Jconnect Infotech Inc.

168 Barclay Center Ste. 347

Cherry Hill, NJ 08034

LinkedIn Mail Website Company Page

[We are an E-Verify and Equal Employment Opportunity Employer with adherence to EEO policy]