Teradata SQL Developer Location: Hartford, CT or Remote Duration: 03 Months plus Rate: DOE US Citizens and Green cards Preferred. No third parties What You Will Do: Responsible for Extracting, Transforming Loading data from flat files using BTEQ, Fast Load, MultiLoad, Python and loading data into Teradata Data Warehouse. Experience in developing of Complex Teradata database objects like Stored Procedures, Functions, Tables, Views, Indexes, Constraints, Synonyms, Materialized Views using SQL and stored procedures Wrote scripts for data cleansing, data validation, data transformation for data coming from source systems. Developed SQL code as per ETL mapping document to pull data from source to target. Responsible for problem detection correction for system related issues, resolving the Issues during the Data loading Process. The candidate will be an effective contributor in the team by providing advanced technical and operational support/guidance in support of operational and project related activities. Skills and Exp: 5+ years of experience with Teradata Database, Architecture with large scale database applications. Experience with implementing and deploying security features (encryption, anonymization, Data Masking) Knowledge on Cloud technology is a plus Primary Skills – Teradata SQL, Secondary -Data Masking/Data Security
Data transformation Python encryption bteq Cloud Systems Engineer validation view SQL function ETL data cleansing indexing constraints stored-procedures