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.

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

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 

JD:

Cloud Technical

Total Exp 4-9  Yrs

Cloud Technical
Need minimum4+ years of experience person in Oracle apps and 2+ year in cloud
Modules - AP PO GL FA
Expertise in BI reports/OTBI/FBDI/Personalization,
Excellent in SQL and PL/SQL

• 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

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