Senior Data Performance Engineer (ETL developer with Performance tuning experience)

Location: Austin TX (Remote) Hire Type: ContractClient Name: LPL Financials/AltimetrikKey Skills to Evaluate – Ability to write complex SQL queries, DB query tuning questions, strategy/process to optimize large data volume processing time, ETLSkill and Experience RequiredExperience in consuming large data volumeAdvance SQL skillsOptimize strategy process for data handling for aggregation tables (Minimize processing time for large data volume) Experience in data loading with complex model for data and batch orchestrationThroughput understanding, monitoring for efficient data loadingIdentifying bottlenecks and resource investigationExperience in periodic ETL code maintenance and setting up SLA for cross functional teamImplementing necessary techniques to improve ETL performance in both DB and ApplicationImproving query performance by turning ad re-evaluating data modelIdentifying dependency impact on both data and ApplicationDuties and ResponsibilitiesPerformance analysis and documenting factors (bottleneck, memory handling and inefficiency area which needs improvement) Identifying and documenting execution benchmarks and metricsOptimization on application and databaseValidation techniques for data and orchestrationDocumentation for optimization and operationsImplementation alert mechanism in case of potential impact to downstreamCollecting and documenting the metrics for each ETL application