| Performance Data Engineer Local to Raleigh NC GC USC only at Raleigh, North Carolina, USA |
| Email: [email protected] |
| From: Sonali, kpg99 inc [email protected] Reply to: [email protected] Job Title: Performance Data Engineer Visa: GC, USC only Duration: 6+ months Location: Raleigh, NC (Initially 2 months Onsite then Hybrid 2 days onsite in a week) Locals only Must be able to obtain Public Trust clearance Job Description: The knowledge, skills, and abilities with the Teradata relational database must be far and above that typically found in application developers. Significant experience with the Teradata optimizer is required; the ability to read SQL explain plans and take action to effectively utilize the massive parallel nature of the database engine. A thorough understanding of the internal DBC Accounting information is expected in order to effectively measure the performance of application code. The following additional skills are desired, but are not considered requirements: A working knowledge of how Microstrategy and other OLAP tools interact with Teradata. A working knowledge of the major competing Data Warehouse modeling techniques (Third-Normal-Form and Dimensional modeling) and how data modeling decisions affect the performance of ETL, structured report queried, and unstructured data analysis. A working knowledge of Web API development. A working knowledge of storing, reading, and analyzing streaming data i.e., kafka, mqseries, or similar technologies, such as JMS. A working knowledge of Cloud technology - developing and architecting. Ab Initio ETL Coding in GDE Ab Initio Metadata Hub Lineage Ab Initio TRMC ANSI SQL and Teradata SQL extensions Teradata SQL Assistant (a.k.a. QueryMan) for EDS Support Teradata Utilities for EDS Support: BTEQ FastLoad MultiLoad FastExport TPump Azure/Databricks Support: Cloud operations Cloud Governance Data Engineering Platform Engineering Data Integration Data Observability AI/ML In addition, the following UNIX skills are required: UNIX commands and concepts in order to navigate source code directories, find error logs, perform impact analysis assessments, edit code, version files Linux Shell scripting in order to read and create driver scripts In addition, the following Ab Initio skills are required: A working knowledge of how Ab Initio conducts data extract, transformations, and loading especially to and from Teradata Development of graphs, plans, PSETs and how to develop tests and debug PDL scripting Thanks & Regards Sonali Kumari Technical Recruiter KPG99, INC Keywords: artificial intelligence machine learning green card North Carolina Performance Data Engineer Local to Raleigh NC GC USC only [email protected] |
| [email protected] View all |
| Thu May 16 04:33:00 UTC 2024 |