HQL jobs in California, USA

Citibank, N.A. seeks an IT Business Lead Analyst for its Irving, Texas location. Duties: Develop Hive and Oracle SQL queries to analyze data. Analyze data patterns and trends from various source systems to produce meaningful and measurable reports. Access data using Hive Command Line Interface, HQL and Beeline. Perform data mapping and map gap analysis, and devise solutions to minimize gap. Maintain business data mapping and derivation logics in data dictionaries for consumption from upstream s