Teradata ETL Developer

Seattle, OR - USA

Monthly Salary: Not Disclosed

Posted on: 11 hours ago

Vacancies: 1 Vacancy

Job Summary

Must Have Technical/Functional Skills

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.

Roles & Responsibilities

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

Create solutions for large and complex data driven applications

Reconciliation and test cases of developed solutions

Design develop and support application solutions leveraging Teradata and Teradata Tools and Utilities

Prepare Test cases for Unit Testing/SIT/Regression

Should be able to take ownership and deliver independently Report out to stakeholders highlighting achievements risks and future work.

Follow the Agile standard for the development of the requested proposal.

Bring best practices standards and innovative ideas for architecture and design.

Deployment of data ingestion pipelines into dev pre and production environments.

Unit testing integration testing functional and non-functional testing.

Generic Managerial Skills If any

Azure DevOps for project management

Must Have Technical/Functional Skills 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 scripti...