Overview 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 Teradata 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 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 Teradata 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. Qualifications SQL proficiency (intermediate skill level minimum). Experience with Teradata, SQL Server, and Oracle databases, including migration activities (code migration, data loads, server retirements). Strong data modeling experience (3NF and dimensional models). Experience designing and developing ETL/ELT pipelines and data warehouse architectures. Experience with Autosys job scheduling, dependencies, workflows, and troubleshooting. Problem-solving and data quality assurance skills. Strong ability to translate business requirements into data solutions. Salary and Benefits Base Salary Range: $110,000 $135,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. #J-18808-Ljbffr Tata Consultancy Services
...Join to apply for the Orthopedic Spine Surgeon role at Wesley Healthcare 1 week ago Be among the first 25 applicants Join to apply for the Orthopedic Spine Surgeon role at Wesley Healthcare Get AI-powered advice on this job and more exclusive features...
About the job Junior Data Entry Specialist (Part Time - Remote) This is a remote position. Entry-Level Remote Opportunity: Join Our Team as a Data Entry Specialist! Are you a detail-oriented and organized individual looking to kickstart your career in the...
...Member Services Sales Associate Department: Member Services Reports To: Member Services Sales Manager Location: Central, Audubon Zoo, New Orleans, LA, US General Summary: Drives revenue and provides an exceptional member experience through relationship building,...
...Springbok Holdings, Inc in Raleigh/Durham is a FedEx Ground Contractor. We are looking for Weekend Delivery drivers for the Wake Forest, NC and Cary, NC delivery area. Your day starts and ends at the FedEx terminal in Durham, NC located at 4357 S. Alston Ave. We need...
...the 21st-century, and our evolving portfolio spans five major markets: Defense, Aerospace, Intelligence, Professional Sports, and Health & Life Sciences. Visit our website here . Why Join Us? MoveAmericas Executives foster a supportive work environment...