- Strong knowledge in Power BI (DAX + Power Query + Power BI Service + Power BI Desktop
- Visualizations) and Azure Data Storages.
- Should have experience in Power BI mobile Dashboards.
- Strong knowledge of SQL.
- AAS Data model Deployment in Azure, Querying data from AAS to build Reports
- Experience in developing, optimizing, and administering Tabular Models in 'Azure Analysis service'.
- Design and Create AAS/OLAP/ Tabular cubes and automate processes for analytical needs.
- Good knowledge of DWH concepts.
- Expertise in developing OLAP cubes and developing complex calculations, Aggregations, implementing a dynamic security model using DAX functions in - Azure Analysis service
Similar jobs
- Structured Query Language (SQL), e.g. SQL/PSM, Transact-SQL queries, writes SQL scripts in SQL Server 2000/2005/ 2012/ 2016, etc.
- 1+ years in Cloud Database services like AWS Dynamo DB / RDS
- Excellent Troubleshooting skills of existing functional implementation to derive leaner solutions and effective performance between applications software, systems software, and installed hardware.
- Database instance maintenance tasks such as DB Integrity Checks, Index Maintenance.
- High availability like clustering, log shipping, mirroring, replication.
- Backup and disaster recovery, Capacity planning and performance monitoring, Physical database structure, RDMS administration roles, instances, profiles, and security connectivity.
- Developing, implementing, maintaining, and following change control and testing processes for modifications to databases.
- Establishing backup and recovery or replication plans to minimize data loss and system downtime.
- Improving data quality through data analysis, monitoring, gap analyses, and working with the teams to provide solutions and resolve errors.
- Maintaining data integrity and security (manage roles and permissions of database users).
- Reviewing the security logs from the SQL Server Error Logs to determine if you had a breach or a violation in one of your policies.
- Ensures optimal database performance and availability.
· Creation & maintenance of Databases in AWS.
Exp-8-12 Years
Job location-Hyderabad, Bengaluru, Mumbai, Pune and Goa
CTC – As per market standard
Notice Period-Max 15 -30 days joiners
Responsibilities:
- Work with Database Architect to understand the design considerations for the BI Next Gen Data Warehouse.
- Take accountability of the development / update of the DW Database Objects and Code as per the requirement.
- Take accountability of the development / update of the PowerBI and SSRS Reports.
- Take accountability of Unit Testing the developed solution.
- Be available for weekend job monitoring and troubleshooting, as necessary.
- Ensure that all delivery timelines are adhered to.
- Work with QA (Testing) team to test the DW / Report Solution and fix as necessary.
Job Requirements:
- 8 - 10 years of experience in SQL Server database development.
- Excellent understanding of SQL Server 2016 and above.
- Excellent understanding of T-SQL. Must have the ability to analyze, debug and write complex T-SQL code.
- Very good hand-on knowledge on query tuning and performance optimization.
- Excellent understanding of SQL Server Integration Services and SQL Server Reporting Services.
- Excellent understanding of PowerBI.
- Should be completely aware of coding standards and should be able to develop high performance & scalable database applications.
- Exceptional Problem Solving and Analytical Skills.
Excellent communication skills (oral and written).
Job Description:
Candidate should ideally be a B.E/B.Tech graduate with around 3 to 5 years of experience, with core T-SQL scripting , performance tuning, SSIS, NOSQL skills. The current role requires a core T-SQL , NoSQL and SSIS developer. The SQL Developer will be responsible for:
- Creating & designing database and all database objects such as tables, views, StoredProcedures, functions etc.
- Writing and troubleshooting simple to complex SQL scripts, stored procedures, views, functions, etc. as per the requirement.
- Troubleshooting and fixing all performance issues with respect to databases (objects & scripts).
- SQL Query tuning and performance tuning.
- Develop/migrate existing scripts to SSIS.
- Maintaining referential integrity, domain integrity and column integrity by using the available options such as constraints, etc.
- Maintaining database objects (like tables, views,Stored Procedures) performance by following the tuning tips like normalization, indexes, etc.
- Importing and exporting the data from different sources using tools, writing required scripts.
- Works closely with other members of the team to accomplish the projects.
- Assists project teams to design and develop core business components utilizing industry-accepted analysis and design standards.
- Provides and/or assists with, project management and project leadership.
- Create and maintain documentation for all the projects.
- Working with NOSQL databases (Mostly on MongoDB) .
PRIMARY SKILLS:
TSQL, SQL, NoSQL, Performance Tuning, SSIS, Import & Export of data from different data sources and from different formats.
SECONDARY SKILLS:
Database Administration
REQUIRED SKILLS:
- 3+ years of professional experience in working with MSSQL Server 2008 and above.
- 3+ years of professional experience in writing TSQL scripts.
- Thorough experience in SQL query tuning and performance tuning.
- Experience in developing and maintaining SSIS packages.
- Experience in working with NoSQL databases. MongoDB would be preferable.
- Fluent knowledge of MSSQL server DBA.
- Should be a good team player and should possess good attitude and work ethics.
- Should possess excellent communication and written skills.
PREFERRED SKILLS:
- MSSQL DBA.
- SSIS.
- NOSQL, MongoDB
In today’s marketing-dependent consumer world, businesses demand innovative brand solutions and our client is engaged in providing brand solutions across businesses. They import renowned global brands & distribute the same. They have a dedicated eCommerce practice to build digital retail footprints for their brands in India. They focus on major categories under FMCG such as F&B, Personal care, etc. and also Home & Fabric Care.
Founded in 2003, our client has over 250 Pan-India Distributors and more than 300 SKUs. They deal with 25+ brands and some of the brands are Mogu Mogu, SAN REMO, Simpkins, Moccona, OMINO BIANCO, etc.
As a Assistant Manager - Business Intelligence, you will be responsible for support building and executing portfolio and respective brand execution strategy by mining, understanding, internalising, and creating action stands about inflow and outflow of information from different internal and external sources.
What you will do:
- Assimilating sales & inventory data streams from different ecommerce partners daily
- Planning different inventory streams for all portfolio brands vis--vis PO requirements
- Building future projection models for brands to support healthy and sufficient inventory capacities
Desired Candidate Profile
What you need to have:- Self direction
- Ability to think beyond operational hurdles
Work Location: Bangalore
Shift: Day Time
Primary Skills & Responsibilities
• Strong knowledge in Power BI (DAX + Power Query + Power BI Service + Power BI Desktop Visualisations) and Azure Data Storages.
* Formulates and recommends standards for achieving maximum performance
and efficiency of the DW ecosystem.
* Participates in the Pre-sales activities for solutions of various customer
problem-statement/situations.
* Develop business cases and ROI for the customer/clients.
* Interview stakeholders and develop BI roadmap for success given project
prioritization
* Evangelize self-service BI and visual discovery while helping to automate any
manual process at the client site.
* Work closely with the Engineering Manager to ensure prioritization of
customer deliverables.
* Champion data quality, integrity, and reliability throughout the organization by
designing and promoting best practices.
*Implementation 20%
* Help DW/DE team members with issues needing technical expertise or
complex systems and/or programming knowledge.
* Provide on-the-job training for new or less experienced team members.
* Develop a technical excellence team
Requirements
- experience designing business intelligence solutions
- experience with ETL Process, Data warehouse architecture
- experience with Azure Data services i.e., ADF, ADLS Gen 2, Azure SQL dB,
Synapse, Azure Databricks, and Power BI
- Good analytical and problem-solving skills
- Fluent in relational database concepts and flat file processing concepts
- Must be knowledgeable in software development lifecycles/methodologies
- 4+ years of extensive EXP in TIBCO SPOTFIRE Dashboard Development is MUST
- Design and create data visualizations in TIBCO Spotfire
- Proven EXP in delivering Spotfire solutions to advance business goals and needs.
- Detailed knowledge of TIBCO Spotfire - report developer configuration
- EXP on creating all charts that exist in Spotfire (scatter, line, bar, combo, pie, etc.) and how to manipulate every property associated with a visualization (trellis, color, shape, size, etc.)
- EXP in writing efficient SQL queries, views in relational databases such as Oracle, SQL Server, Postgres and BigQuery (Optional).
- Ability to incorporate multiple data sources into one Spotfire DXP and have that information linked via data table relations.
- EXP with Spotfire Administrative tasks, load balancing, installation/configuration of servers and clients, upgrades and patches would be a plus.
- Strong background in analytical visualizations and building executive dashboards.
- In-depth knowledge & understanding of BI and Datawarehouse concepts