SQL Developer - ETL / SAS Viya

Roles and Responsibilities :

• Manage SQL development tasks and ensure timely delivery of project milestones, coordinating with onshore and offshore teams.
• Develop, optimize, and maintain complex SQL queries, stored procedures, and ETL processes for data extraction, transformation, and loading.
• Perform data validation, cleansing, and quality checks to ensure data accuracy and integrity.
• Monitor database performance, troubleshoot issues, and implement optimization techniques such as indexing and query tuning.
• Schedule and oversee regular backup, restore operations, and support end-user connectivity and access issues.
• Assist in migration activities involving SQL databases and SAS datasets, ensuring seamless transitions and data integrity.
• Prepare and maintain comprehensive technical documentation for SQL scripts, workflows, and standard operating procedures.
• Collaborate closely with development, testing, and business teams to translate requirements into effective database solutions.
• Communicate project status, technical concepts, and challenges clearly with clients and stakeholders, including preparing presentation materials.
• Mentor junior team members, foster knowledge sharing, and demonstrate ownership and proactive problem-solving in a fast-paced environment.
• Monitor project progress and ensure adherence to client expectation
• Communications, including deck writing
• Coordination of all sub-team efforts; Creation of project plan, define milestones, timelines, review plan with the team
• Delivery of output
• Facilitation and gathering of client feedback on problem structuring
• Understand and define business problems, get all background information and collect relevant data points
• Create solution hypothesis and get client buy in, discuss and align on end objective, staffing need, timelines and budget
• Effective management of frequency of feedback loop with offshore resources

Technical skills :

Soft skills :

Candidate Profile :

(ref : hirist.tech)