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.
Objective: ~ The production associate performs tasks involved in the production of the companys products. Key Responsibilities: Feed raw materials into production machinery. Assemble goods on production lines. Monitor the production process. Carry...
...organizers daily to ensure their needs are met and expectations exceeded. Act as a central communicator between the internal planning team and reservation holders throughout the entire booking lifecycle. Perform regular "spot checks" of room setups and catering...
...A respected law firm is seeking a Trial Associate to join its Medical Malpractice practice group. This position offers the opportunity to take on significant case responsibility within a collaborative, high-performing litigation team. Responsibilities Manage assigned...
...Title: Facility Security Officer Reports to: Director of Security Works with: Mid-level Managers and Supervisors, Employees... ...required in any field. A minimum of 3 years of DoD NISPOM-related experience. Thorough understanding of DoD security requirements and...
A helicopter mechanic in the United States Army plays a vital role in maintaining the operational readiness of the Army's rotary-wing aircraft fleet. Their duties include inspecting, diagnosing, and repairing mechanical and electrical issues on various types of helicopters...