MS SQL Developer
Indexed description
Develop advanced T-SQL scripts for data extraction, transformation, reconciliation, and reporting.
Perform query tuning and performance optimization for high-volume transactional systems. Support automation scripting for recurring data processes and AR reporting workflows.
Data Quality & Validation
Ensure data quality, integrity, completeness, and accuracy across all data processes.
Perform data validation, reconciliation, and deduplication.
Implement row-count checks, hash validations, record sampling, and automated quality checks.
Identify and resolve data discrepancies between source and target systems.
Maintain audit trails and documentation for all data-related processes.
Technical Skills
SQL - Query, Optimization (Strong)
Azure/AWS Table Migration (Strong)
Power BI (Strong)
Expertise in Excel
SQL Querying-Core skill for datasets
Database Analysis -Understanding business data
Schema Understanding-Knowing relationships between tables
SSRS/Report Designing-Layout can be learned
Performance Optimization-Important for large datasets
DB Migration Concepts
ETL and automation scripting
Stored Procedure development and performance tuning
External database integration and management
Data reconciliation and validation techniques
MS Excel (PivotTables, VLOOKUP, Macros)
Data Tracing-Most important when report data is wrong
Create a free Caio profile to unlock more results and save your role and location preferences.
Unlock free search