Teradata developer

Tata Consultancy Services; Charlotte (NC); On-site; USD 100,000 - 105,000; Full time

Benefits offered by this job

Discretionary Annual Incentive

Comprehensive Medical Coverage

401K Plan

Certification & Training Reimbursement

Vacation & Holidays

Job summary

Tata Consultancy Services in Charlotte, NC is seeking a senior Data Engineer to develop and maintain data pipelines for analytics across mobile and online platforms. You will work with stakeholders and other engineers to implement data requirements and optimize performance.

The role requires 7+ years of SQL, Teradata and PySpark/Impala, plus strong Agile experience. You will mentor junior engineers and contribute to CI/CD practices, with comprehensive benefits and a competitive salary range.

Qualifications

• 7+ years of advanced SQL experience and understanding of relational databases.
• 5+ years of experience with Teradata and utilities (BTEQ, TPT, etc).
• 4+ years of experience working on Pyspark, Impala/Hive.
• Must have working knowledge of Agile software delivery practices and Scrum.
• Advanced Microsoft Excel, Access, SharePoint skills.
• Attention to detail with strong organizational and planning capabilities.
• Ability to communicate with business and technology partners effectively.
• Experience with Autosys scheduling software.
• Shell scripting experience; Bitbucket, Github, Ansible experience.

Responsibilities

• Codes design and delivery tasks for data integration, cleaning, transformation and control in analytics data systems.
• Collaborates with stakeholders, Product Owners and data engineers to refine requirements and troubleshoot issues.
• Develops complex data pipelines and ensures data quality and governance.
• Assembles large, complex data sets meeting functional/non-functional requirements.
• Builds processes for data transformation, structures, metadata and workload management.
• Contributes to test suites and analyzes test results for issues.
• Documents deployment, maintenance and business functionality details.
• Leads and mentors junior data engineers and coaches on CI/CD practices.

Skills

Advanced SQL

Communication

Organizational skills

Problem solving

Time management

Education

Bachelor of Computer Science

Tools

Teradata

PySpark

Impala

Hive

Autosys

Bitbucket

Github

Ansible

Oracle

Tableau

.NET

JIRA

Data Management tools

Job description

Job Description

Must Have Technical/Functional Skills

• 7+ years of advanced SQL experience and understanding of relational databases.
• 5+ years of experience with Teradata and utilities (BTEQ, TPT, etc).
• 4+ years of experience working on Pyspark, Impala/Hive.
• Must have a working knowledge of Agile software delivery practices and practical experience as part of a scrum team.
• Advanced Microsoft Office suite software skills with (Excel, Access, SharePoint).
• Detail oriented with strong organizational and planning capabilities.
• Requires exceptional organizational skills, problem solving, attention to detail and timeline management.
• Ability to communicate with both business and technology partners effectively.
• Scheduling software experience with (Autosys).
• Shell scripting experience. Experience with Bitbucket, Github, Ansible.
• Strong analytical skills Team player who takes initiative Experience with Oracle, Tableau, .NET, Autosys, JIRA and Data Management tools.
• Knowledge of Global Technology, Enterprise Data Management Enterprise Data Architecture programs, strategies and standards.
• 3+ years of service in the financial industry with reporting and development experience.

Roles & Responsibilities

Codes design and delivery tasks associated with the integration, cleaning, transformation and control of data in analytics data systems for mobile and online data for consumer and wealth management.

Works with stakeholders,
Product Owners, and other data engineers to aid in the implementation of data requirements, analyze performance, conduct research and troubleshoot any issues. Proficient in data engineering practices, and have extensive experience of using design and architectural patterns. Contributes to story refinement/defining requirements.

Codes complex solutions to integrate, clean, transform and control data in operational and/or analytics data systems per the defined acceptance criteria. Assists team with resolving technical complexities involved in realizing story work.

Assembles large, complex data sets that meet functional / non-functional requirements.

Builds processes supporting data transformation, data structures, metadata, data quality controls, dependency and workload management.

Defines and builds data pipelines that enable faster, better, data-informed decision-making within the business.

Contributes to existing test suites (integration, regression, performance), analyzes test reports, identifies any test issues/errors, and triages the underlying cause.

Documents and communicates required information for deployment, maintenance, support, and business functionality.

Adheres to team delivery/release process and cadence pertaining to code deployment and release.

Identifies gaps in data management standards adherence and works with appropriate partners to develop plans to close gaps.

Provides leadership and mentoring to junior Data Engineers and coaches team on CI-CD practices and automating tool stack.

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 &am p; 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.
• Salary Range: $100,000 - $105,000 a year

Qualifications

BACHELOR OF COMPUTER SCIENCE