Strong SQL knowledge on Databases like Oracle/Teradata/Snowflake.
Knowledge on Concepts of Data Warehousing is a must.
ETL tool knowledge like Talend/Informatica/DataStage/Azure and other technologies.
Knowledge on cloud technologies is an added advantage.
Unix Shell Scripting, performance tuning and troubleshoot
Strong in data analytical skills
Experience on Ticketing tools like JIRA/ServiceNow etc. is a must.
Effective communication skills; verbal, non-verbal and written
Experience with maintaining DWH pipelines and writing SQL queries (Azure SQL, Azure Data Factory) any other experience with Azure resources would be a plus.
Good understanding and exposure to ITIL framework
Some light debugging duties using SQL will be required to develop queries/reports of varying complexity to troubleshoot and recommend fixes to development teams
Coordinate with business and IT groups to ensure reliability of the RDW system
Monitoring dashboard and escalate issues where needed
Providing 24/7 operational support to all production practices on holidays and weekends.
Coordinating with various teams and raise support ticket for all issues, analyze root cause and assist in efficient resolution of all production tickets
Maintaining logs of all issues and ensure resolutions according to quality assurance tests for all production processes
Acting as the point of contact for the data warehouse production eco system
Note:
Shift work required
Keyskills: snowflake oracle servicenow jira informatica teradata dba itil sql
Magna Infotech is a division of USD 400 + million Quess Group (quesscorp.com) which in turn is a subsidiary of USD 37+ billion - Canadian Multinational, Fairfax Financial Holding Group. Magna Infotech is the largest staff Augmentation and Solutions Company in India, USA and APAC regions. We are a ...