Sr. Teradata Developer

Data Inc

Charlotte, NC, United States

3 months ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

4 years minimum

Compensation

$131,040.0 - $135,200.0

Working hours

Regular working hours

Job source

indeed.com

Tech stack

CA Workload Automation Ae Unix Data Integration Extract Transform Load (ETL) Data Warehousing Database Design Software Design Documents Software Design Patterns Unix Shell Operational Data Store Standard Sql SQL Stored Procedures

+3 more

Teradata SQL 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.