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.
#LI-SV2 #LI-KUMARAN
In order to comply with U.S. laws and regulations pertaining to this position, the person(s) hired must be a U.S. Citizen or U.S. Permanent Resident (i.e. Green Card Holder)
Job Tags
Permanent employment,