About the role
Category: Technology
Location:
Responsibilities:
* Analyze, solve, and correct issues in real time. * Provide suggestions for solutions. * Create ETL packages. (Mandatory on SSIS, Knowledge of other ETL is good to have). * Experience with complicated SSIS Package coding and maintenance. * Participate in ongoing DW/BI performance tuning activities. * Refine and automate regular processes, track issues, and document changes. * Assist developers with query tuning and schema refinement. * Provide support for critical production systems as required. * Maintaining code versioning and support code deployments. * Perform scheduled maintenance and support deployment activities as required. * Manage SQL Databases but not limited and can extend to NoSQL/Cloud Database as applicable. * Preserve data integrity. * Maintains contemporary knowledge of industry trends, concepts, and techniques. * Experience in creation of SQL Tables, Views, MV’s, Stored Procedures and working on complex T- SQL statements.
Requirements
Skills & Certifications:
* Expert knowledge in traditional relational database concepts and design. * Fluent in SQL * Database design and query optimization. * Write and debug stored procedures and ability in advanced SQL operations. * Advanced query, join operation, and aggregate. * Knowledge of data warehousing. * Automate manual data tasks through workflows and ETL packages. * Should possess skill to maintain, monitor, troubleshoot daily jobs using SQL Server Agent. * Administrate application and server environments. * Analyze data quality and make recommendations for data preparation. * Strong ability to communicate both verbally and in writing, especially with technical analysis (including understanding internal documents). * Experience with data manipulation, data engineering, and working with large data sets.
Details
Originally posted on Himalayas