Fusion Practices | Hiring | SQL Developer | BigDataKB.com | 2022-09-26

0

Job Location: India

We are looking for a strong BI developer that can solve complex technical problems.

 

The client is a bank, and they have a huge data volume in their Microsoft SQL Server Data Warehouse. We are working with them to improve their current warehouse and also are working to move them to the Azure cloud.

You must be Responsible for:

  • Staging additional data from upstream systems into the SQL Server Staging DB
  • Writing Stored Procedures to publish the data into the Risk Data Warehouse
  • Loading the data into Power BI Data Models
  • Enhancing SSRS reports to include the additional data
  • Writing Control-M jobs to orchestrate the batch processes
  • Documenting changes made in the required format
  • Testing and releasing changes
  • Diagnosing issues and applying technical changes to remediate
  • To enhance the existing Risk data warehouse and associated reporting.

Skills and Experience:

  • Expert-level SQL Server knowledge
  • Experience using SSIS to load data
  • Complex TSQL Stored Procedures
  • Hands-on SSRS, SSAS & Power BI experience
  • Experience in handling large data volumes – partitioning, column store
  • Data Warehouse Design, Kimball Methodologies
  • Experience in working with Risk systems within a financial institution
  • Experience in using Control-M or similar orchestration tools
  • Any exposure to Snowflake Cloud Data Warehouse, Python, ADF

Apply Here

Submit CV To All Data Science Job Consultants Across Bharat For Free

🔍 Explore All Related ITSM Jobs Below! 🚀 ✅ Select your preferred "Job Category" in the Job Category Filter 🎯 🔎 Hit "Search" to find matching jobs 🔥 ➕ Click the "+" icon that appears just before the company name to see the Job Detail & Apply Link 📝💼

LEAVE A REPLY

Please enter your comment!
Please enter your name here