Teradata Solution Lead

Teradata Solution Lead

Location:

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

Duration:
Fulltime

Job Description:

Skills Desired:

• Design scalable data warehousing solutions using Teradata.

• Develop and maintain normalized (3NF) and dimensional models.

• Optimize physical models and fine tune queries for performance.

• 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.

• 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

Responsibilities:

• Lead and optimize database jobs for performance by collaborating with DBAs and implementing SQL coding and design changes within the job structure.

• Lead and actively participate in troubleshooting and resolving issues related to data loading delays and database server outages, ensuring minimal disruption to data flow and system operations.

• Provide technical leadership and guidance to team members, fostering a collaborative and supportive team culture.

• Lead the planning, solution design and implementation, ensuring alignment with program objectives and timeline

• Engage 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.

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

Generic Managerial Skills, If any:

• Strong technical expertise in legacy application modernization, including proficiency in ETL, solution frameworks and technologies.

• Excellent communication skills, with the ability to manage business expectation efficiently

• Detail-oriented with solid problem-solving and analytical abilities

If you are interested, please send me your updated resume ASAP with below details :

Full Name:

Current Location/Zip:

Contact Number:

E-Mail :

Alternate Email :

Visa/Work Permit Status:

Current Rate/Salary:

Expected Base Salary:

Notice Period/Availability to Start:

Skype :

Willingness to relocate to job location:

Any Relocation Concern (family/house/weather):

Current/Previous Employer Name:

Preferred Interview timings (Specify Time zone):

Any other job opportunity in process & at which stage:

Overall Experience

Summary:

Linked In URL:

Looking forward for your response..

Thanks and Regards,

Abhishek Singh

Jconnect Infotech Inc.

168 Barclay Center Ste. 347,

Cherry Hill, NJ 08034

Contact:

Email: abhi.k@jconnectinc.