What are the responsibilities and job description for the Teradata ETL Developer position at Jobs via Dice?
Dice is the leading career destination for tech experts at every stage of their careers. Our client, Centraprise Corp, is seeking the following. Apply via Dice today!
Must Have Technical/Functional Skills
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.
- 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.