Location
Stamford, CT | United States
Job description
Job Role: ETL Developer with Teradata
Location: Stamford, CT Onsite only
Duration: Long-term
Hire-Type: Contract
Job Description :
- Strong Teradata Developers with good understanding in ETL and strong in writing Advanced SQL & UNIX
- Strong ETL Background (Data Extraction, Transformation and loading in target from heterogeneous data sources)
- Writing Teradata Stored Procedures for ETL.
- Working on Teradata Utilities like BTEQ scripts, Fast Load, MLoad, TPT, etc. BTEQ is very IMPORTANT
- Work with scheduling tools like One Automation
- Develop and provide inputs to design specifications within defined architecture, utilizing standard procedures and techniques.
- Interface with Product Owners, Scrum Masters and Business Clients to clarify requirements, as appropriate.
- Set up complex workflows and schedules
- Develop ETL data workflows and code for new data integrations and maintain/enhance existing workflows and code.
- Write documentation that describes installation and operating procedures.
- Deep knowledge of data extraction, transformation & loading (ETL) methods using Teradata.
- Advanced SQL skills (Teradata and RDBMS like Oracle, MS SQL, DB2).
- Advanced hands-on experience with Data Warehousing.
- Experience participating in multiple technical projects using Agile methodology
- 5 years of experience with SQL Query Design in large-scale data warehouse environments.
- 5 years of experience in data collection, database design, and report development.
- Demonstrated experience in delivering IT/BI solutions.
- Expertise in Query optimization and Performance tuning techniques
- Strong in Teradata Stored Procedures, BTEQ, Utilities
- Person must have good analytical skills
- Good knowledge on UNIX programming.
- Good communication skills
Report this job
- Dice Id: 80163760
- Position Id: 8211864
Job tags
Salary
