- Location
-
IndustryInformation Technology and Services
The client company is a global IT services and solutions company that was established in 1995. They focus on providing enterprise digital transformation and modernization solutions. With a strong track record, they have served more than 35 prominent leaders in various industries including Telecom, Retail, Banking, Healthcare, and Technology. The company's global presence allows them to offer offshore, nearshore, and onshore solutions to their clients. They pride themselves on their world-class infrastructure for employees and their commitment to implementing people-centric policies. In recognition of their efforts, they are certified as a Great Place to Work in 2022.
Skills and Qualifications:
4 - 6 years of in SQL and working with Stored Procedures.
Experience in writing and interpreting SQ queries, designing data models, and data
standards.
Experience in Cloud platform – Azure
Experience in SQL Server databases, Oracle, and/or cloud databases.
Experience in data warehousing and data mart, Star and Snowflake model.
Experience in loading data into database from databases and files.
Experience in analyzing and drawing valuable conclusions from data profiling results.
Understanding business processes and relationship of systems and applications.
Must be comfortable conversing with the end-users.
Must have ability to manage multiple projects/clients simultaneously.
Excellent analytical, verbal and communication skills
Well versed with the advanced level of writing stored procedures, construing the query plans,
altering the indexes, and troubleshooting the performance holdups
Skilled at optimizing large, complicated SQL statements.
Familiar with SSRS reporting tools.
Nice to have knowledge of .Net for developing/debugging API/web services.
Role and Responsibilities:
Work with project stakeholders to provide solutions addressing business data requirements.
Work with application developers and business analysts to determine new and changed
database requirements and provide database solutions accordingly.
Design, implement, and support solutions using SQL Server
Develop SQL scripts, including queries, views, stored procedures, functions, and triggers to
create a new product with feature enhancements.
Create and maintain up-to-date documentation of the data model, data flow, and field level
mappings.
Participate in software releases using Agile development and scrum model
Mode of Work-Hybrid (2 days WFO)
