Teradata Solution Lead

Must Have Technical/Functional Skills * 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 Roles & 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 < div>Base Salary Range : $100,000 to $145,000 Per Annum TCS Employee Benefits Summary: Discretionary Annual Incentive.

Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.

Family Support: Maternal & Parental Leaves.

Insurance Options: Auto & Home Insurance, Identity Theft Protection.

Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.

Time Off: Vacation, Time Off, Sick Leave & Holidays.

Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.

#LI-SV2 #LI-KUMARAN