Sr. Teradata Developer

Data Inc
Charlotte, United States of America
15 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
$ 135K

Job location

Remote
Charlotte, United States of America

Tech stack

CA Workload Automation Ae
Unix
Data Integration
ETL
Data Warehousing
Database Design
Software Design Documents
Software Design Patterns
Shell
Operational Data Store
Standard Sql
SQL Stored Procedures
Teradata
Data Import/Export
Macros

Job description

  • Collaborate with stakeholders to understand the current process
  • Collaborate with business to convert the business requirement into technical requirements.
  • Develop Teradata code meeting 100 percent of technical specifications and business requirements according to the established design patterns
  • Analyze, design, code, and test highly complex ETL processes, for data warehouses and/or operational data stores
  • Understand design for ETL application including data sources, data targets, data definitions, data relationships, and business rules
  • Work closely with technical leads, analysts, data modelers, and other developers to understand project requirements and contribute to the project solution
  • Provide post go-live & application maintenance support
  • Provide technical expertise on Database design, Data modeling, Data Warehousing, and Data integration

Requirements

  • Teradata
  • BTEQ
  • Unix Scriptin
  • SQL
  • Data Import/ Data Export
  • Error Handling
  • Batch Mode
  • Interactive Mode, * 4-8 years hand on Experience on writing Teradata.
  • Experience in Teradata Utilities (BTEQ, Fast Load, Multi Load)
  • Extensive experience in developing complex SQL code using Teradata stored procedures, macros etc.
  • Should be good in Unix Shell scripting
  • Should be able to create Design documents, mapping documents
  • Design and document development standards
  • Should have knowledge on ETL and Data warehouse Concepts
  • Should have knowledge of SQL Server and Autosys.

Apply for this position