Role: Teradata ETL Developer
Location: Seattle, WA (Day 1 onsite)
FTE only
Job Description
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