Azure Stream Analytics, MS SQL | 4 To 6 Years | Kolkata
Job Description
• Provide support to existing EDW in shift as support team member
• Perform detailed application debugging and Root Cause Corrective Actions
• Ensure all activities are in compliance with rules, regulations, polices, and procedures, Complete other duties as assigned
• Extensive experience in Production Support Project & having good understanding of support environments and Service Level Agreements
• Experience in handling major incidents and escalations.
• Diagnosing and resolving data and system issues to ensure warehouse usability for the consumers of the warehouse data
• Performing daily, weekly, monthly, quarterly, and yearly operations tasks required for the ongoing functionality of the software applications.
Technical skills:
• Experience in creating SSIS packages, develop and maintain existing Production SSIS/DTS Packages, TSQL Code and Windows batch jobs.
• Experience in Cloud-based (Azure, AWS and Google Cloud) Application Support, ideally in a Managed services environment.
• Experience in supporting core business applications within a Software development environment, ideally Azure Stream Analytics
• Experience in Databases and writing complex SQL queries.
• Experience in application monitoring and alerts.
• Good problem-solving/troubleshooting skills, quick learner.
• Extensive knowledge of Data Warehousing, ETL and BI Architectures, concepts, and frameworks
• Design, implement, and maintain data pipelines for data ingestion, processing, and transformation in Azure Stream Analytics.
• Create and maintain data storage solutions including Azure SQL Database, Azure Data Lake, and Azure Blob Storage.
• Utilizing Azure Stream Analytics or comparable technologies, create and maintain ETL (Extract, Transform, Load) operations.
• Implementing data validation and cleansing procedures will ensure the quality, integrity, and dependability of the data.
• Improve the scalability, efficiency, and cost-effectiveness of data pipelines.
• Monitoring and resolving data pipeline problems will guarantee consistency and availability of the data.
Primary Skill
Azure Stream Analytics, MS SQL Server - SSIS
Secondary Skill
Excellent Team Player
Kolkata, WB, IN