Description

Required Technical Skills:

• Design, develop and implement scalable and high-performance data pipelines that performs ETL loads into enterprise repository
• Collaborate with various business units to gather requirements, transforms the requirements into technical solutions
• Write efficient store procedures/packages, provide operational support, diagnose, and resolves production issues, superior troubleshooting skills
• Develop code to extract data from various cloud environments (Azure, Snowflake) and stage the data on Prem
• Create dataset from staged environment for AI team, upload the dataset to AI cloud environment
• Collaborate with AI team to understand the data requirements, perform data mapping, extract the required data from multiple source systems
• Proficient in writing advance T SQL’s, write store procs, developing SSRS reports, troubleshoot existing reports, suggest, and apply appropriate fixes  
• Independently review and schedule new jobs, resolves performance issues stemming from inefficient queries
• Lead efforts in troubleshoot query performance issues, pro-actively collaborate with DBA team to resolve query/database locking
• Review the existing integrations (ETL – Extract Transform Load) of legacy/new systems process, suggest and lead design modifications  
• Lead effort in peer code review before promoting to production, ensures production stability is maintained
• Support, maintain and document BI functionality, regularly review and update document on share-point

Key Skills

Education

Any Gradute