Role: Teradata Development Lead Engineer
Location: Seattle, WA/St. Louis, MO/Plano, TX/Dallas, TX/Houston, TX
Job Type: Full Time
Job Description
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
• 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.
Base Salary Range: $120,000 - $140,000 per an num
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.
...required High School Diploma or GED (college students and recent grads welcome) Strong communication... ... written and verbal Comfortable working remotely with basic tech knowledge (Zoom... ...to learn What We Offer: Work From Home (100% Remote ) Residual Income...
This role is onsite at our Syracuse, NY Facility Pay expectation $110,000-$120,000 Scope: The Project Manager is responsible for leading and coordinating cross-functional projects across two primary domains: New Product Development (NPD) Managing product...
...the industry. TMC can offer you a fast-paced career where each day brings a new challenge. TMC Transportation is looking for Shag Drivers to join our team, at our Dedicated customer site - Continental. Shift: Sunday-Thursday: 1030pm-7am DUTIES AND RESPONSIBILITIES...
...Job Description Love to drive your car and enjoy a fun yet fast paced experience in store? Then we may be looking for you! Helping customers and making them smile at the end of the day is what we want, so if that's something you feel like you can do then we are...
...: Exempt Location: New Braunfels, TX Shift Days: Monday to Friday or Sunday thru Thursday with some Weekends depending on freight levels. Shift Hours:... ...between 8 - 10 hours per day on either day or night shift. SUMMARY: At Daylight we owe our...