11+ Crystal Reports Jobs in Bangalore (Bengaluru) | Crystal Reports Job openings in Bangalore (Bengaluru)

• 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.

MANDATORY TECHNICAL SKILLS

SSRS, PowerBI, SQL Server 2008/2012, TSQL, Stored Procedures, Views, UDF’s, Triggers, Charts

EXPERIENCE

• 7+ years professional experience in database development using SQL Server 2008/2012(T-SQL, SSRS)

• Strong analytical and critical thinking skills, with the ability to analyze business requirements to determine

• processing flow, user requirements and inter-dependencies of multiple information systems.

• Experience with SDLC required

• Excellent verbal and written communication skills.

• Strong in performance tuning especially tuning complex queries, procedures and indexing strategies

Job Description - Jasper 

• Knowledge of Jasper report server administration, installation and configuration
• Knowledge of report deployment and configuration
• Knowledge of Jaspersoft Architecture and Deployment
• Knowledge of User Management in Jaspersoft Server
• Experience in developing Complex Reports using Jaspersoft Server and Jaspersoft Studio
• Understand the Overall architecture of Jaspersoft BI
• Experience in creating Ad Hoc Reports, OLAP, Views, Domains
• Experience in report server (Jaspersoft) integration with web application
• Experience in JasperReports Server web services API and Jaspersoft Visualise.JS Web service API
• Experience in creating dashboards with visualizations
• Experience in security and auditing, metadata layer
• Experience in Interacting with stakeholders for requirement gathering and Analysis
• Good knowledge ETL design and development, logical and physical data modeling (relational and dimensional)
• Strong self- initiative to strive for both personal & technical excellence.
• Coordinate efforts across Product development team and Business Analyst team.
• Strong business and data analysis skills.
• Domain knowledge of Healthcare an advantage.
• Should be strong on Co- ordinate with onshore resources on development.
• Data oriented professional with good communications skills and should have a great eye for detail.
• Interpret data, analyze results and provide insightful inferences
• Maintain relationship with Business Intelligence stakeholders
• Strong Analytical and Problem Solving skills 

• 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

• Experience in Developing QlikView / Qlik Sense BI visualizations and dashboards. QlikSense and NPrintiing experience is a must.
• Strong knowledge of building Qlik Sense dashboards applying business rules and data validations.
• In-depth understanding of Qlik Sense Server Architecture, building QVDs and QVFs, applying business rules and data validations.
• Familiarity with charts and graphs, creating complex visualizations for dynamic aggregation Good Knowledge of Incremental data loading concepts and data modeling.
• Additionally, Qlik developers have to troubleshoot issues and provide the necessary solution

• 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

• 3+ years’ experience developing and implementing enterprise-scale reports and dashboards.

• Proficiency with MS Power BI / SSRS.

• Knowledge of logical and physical data modeling concepts (relational and dimensional).

• Understanding of structured query language (SQL).