SQL Database Developer

The candidate must demonstrate in-depth knowledge & understanding of Database concepts for developing new and supporting existing apps in Azure Cloud Platform. PowerBI Report development experience is a must.

The ideal candidate must demonstrate in-depth knowledge and understanding of Database concepts for developing new and supporting existing applications in Azure Cloud Platform. PowerBI Report development experience is a must. Need to support the applications by handling Large Volume of Data, in Oracle and SQL Server, Azure SQL platform.

Essential Duties and Responsibilities:

1. Experience in data analysis and data mapping and consequently data integration routines which involves moving, cleansing, and transforming large amounts of data between multiple systems.
2. Identifies data sources, provides data flow diagrams, and documents sources to target mapping and process.
3. Design, implement, and maintain database objects (tables, views, indexes, etc.) and database security.
4. Maintain the data warehouse performance by optimizing batch processing through parallelization, performance tuning, etc.
5. Troubleshoot performance and reliability issues and investigate anomalous behavior in the Database environment.
6. Power BI Development experience in Reports, Dashboards, and DAX queries.
7. Experience in Power BI Administration and/or Angular is a plus.
8. Experience with Source Version Control software like GitHub and CICD pipelines
9. Provide support after hours as and when needed.

Requirements:

• 7+ years of experience in Data Warehousing and Business Intelligence
• 5+ Years in BI development leveraging the Microsoft SQL Server. Needs to be an expert in T-SQL
• 3+ Years in Azure SQL
• 3-4 Years in SSIS and use of Stored Procedures.
• 3-4 Years in PowerBI Report Development
• Ingest and aggregate data from both internal and external data sources to build our data stage areas
• Strong understanding of data modeling (i.e., conceptual, logical, and physical model design, experience with Operation Data Stores, Enterprise Data warehouses, and Data Marts).
• Strong experience with business intelligence and data warehousing design principles and industry best practices.

Qualifications: