The business and/or technical problem the job is looking to solve is to develop and support application solutions leveraging Teradata and Teradata Tools and Utilities, including designing, analyzing, coding, and testing highly complex ETL processes for data warehouses and/or operational data stores, and creating solutions for large and complex data-driven applications.
Requirements
- 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 have knowledge on ETL and Data warehouse Concepts
- Should have knowledge of SQL Server and Autosys.
- TeraData
Responsibilities
- 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
- Design, develop and support application solutions leveraging Teradata and Teradata Tools and Utilities
- Deployment of data ingestion pipelines into dev, pre, and production environments.
- Unit testing, integration testing, functional, and non-functional testing.
- Reconciliation and test cases of developed solutions
Other
- Collaborate with stakeholders to understand the current process
- Collaborate with business to convert the business requirement into Technical requirements.
- 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
- Report out to stakeholders highlighting achievements, risks, and future work.
