SQL Developer

Exp: 5+ yrsShift Timings: 9 am to 6 pm

Notes: Candidate must be advanced and ready to hit the ground running. This is a redesign of an existing data warehouse, and we would like the candidate to be fully familiar with DWH tools and techniques and be productive immediately. Skills / Experience Required • Strong SQL Skills using SQL Server – ability to profile data, verify data movement, validate data matches, advanced SQLs expertise, performance tuning of SQLs, Azure SQL managed instance experience, experience in working with large enterprise databases. • Extensive Data movement experience using SQL Server for large enterprise databases: ◦ Familiar with best practices for data flow patterns for data ingestion into Data warehouse including progression through Staging, ODS and Data Warehouse (Dims/Facts) schemas. ◦ Experienced handling Production data loads and designing error handling and alerting into all steps to best support ◦ Experience in transaction processing for large databases ◦ Experience with data retention/archiving policies and procedures ◦ Experience with both event triggers and schedule triggers to trigger pipeline start. ◦ Experience ingesting from SQL and file based sources, with Azure blob storage experience Nice to Have: • Azure Data Factory (ADF) data movement expert • Comfortable with documenting and drawing data flows, data mappings, etc. Sample Tasks • Create or rewrite Stored Procedure with advanced sql to ingest data into Data Warehouse including transaction processing, error handling and reporting • SQL Optimization and performance tuning of existing stored Procedures and tables to minimize processing time • Create new or modify existing ADF data ingestion pipelines • Production Support – support production data loads during normal business hours (daytime). Able to perform root cause analysis on any issues found. Ability to determine best way forward to restart pipeline, backfill missed data, etc.

Key Skills

• SQL