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

DB developer 

This position is for Oracle Golden Gate developer and DBA position. The Candidate will implement and support Oracle Golden Gate replication components across many databases. Working closely with many application teams and implementing near real time replications with golden gate. Candidate should provide operational support as well.

Roles and responsibilities :

Configure and build Golden Gate Extracts/replicate for multiple databases.

Configure error handling for restart, logging, production support and status reporting in Golden Gate.

Identify and produce documentation of best practices.

Trouble shooting and performance tuning Golden Gate replications.

Implementing necessary monitoring scripts for Golden Gate in UNIX/PERL scripting

Provide Golden Gate solutions :

- Working with Oracle on SRs for critical issues.

- Strong oral and written communication skills along with problem solving skills.

Individual with min experience of over 5+ years on SQL Server

• Good Experience in SQL Server Installation and Configuration
• Backup and Recovery
• Security management
• Troubleshooting & Monitoring
• SSIS/SSRS/SSAS

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

• 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

Job Requirement – Sr. SQL _PBI Developer

• Minimum 6+ years of expertise in SQL Database Development including SQL queries, data structures, stored procedures, index etc.
• Excellent written and verbal communication
• Advanced knowledge and experience in T-SQL coding: query writing, stored procedures, triggers and user-defined functions.
• Advanced knowledge and experience in development and maintenance of SSIS and SSAS (Tabular and Multidimensional)
• Advanced knowledge and experience in creating dashboards and reports using PowerBI
• Advanced knowledge and experience in DAX
• Experience in creating and publishing reports using SSRS
• Experience in writing MDX queries
• Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
• Optimize and manage SQL server databases
• Independently analyse, solve, and correct issues in real time, providing problem resolution end-to-end.
• Refine and automate regular processes, track issues, and document changes
• Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
• Flexible, team player, “get-it-done” personality
• Ability to organize and plan work independently
• Ability to work in a rapidly changing environment
• Ability to multi-task and context-switch effectively between different activities and teams

Optional Skills (Good to have):

• Microsoft certification in Azure data engineering

• Provide thought leadership on how best to meet business requirements using the CDM platform 
• Help determine the architectural direction of the CDM platform and related infrastructure 
• Collaborate with business analysts and product owners to interpret and synthesize requirements  
• Work with other team members to determine the best technical solution to meet requirements. 
• Keep current on industry best practices and help to incorporate relevant updates into solutions. 
• Analyze and Identify existing architecture and come up with suggestions and implement changes to bring solutions to a more stable state.
• Act as a single point of contact to the team (including dev/QA/support) in guiding to adopt best practices across technology development.

Basic Qualifications: 

• Bachelor’s degree in computer science, information technology, or related field 
• Strong problem-solving, analytical, and critical thinking skills 
• 10+ years working in an IT environment (Preferably on Digital or DWH/ETL applications)
• 5+ years Java/.net (or similar) application design and development experience 
• 4+ years Tibco EBX5 architect/design/development experience
• 5+ years database design/development experience in MS SQL Server or similar DBs with query tuning and optimization
• Proficiency in SQL, XML, JSON 
• Min 5 years working experience an agile development team 
• Min 3 to 5 years of exp with Azure Cloud including services like VMs, Security, Storage, App Services, Service Bus, Active Directory, Azure SQL

Preferred Qualifications: 

• Experience in ETL, DW/BI, modeling, and manipulating data using Microsoft Access, SQL, Tableau, or similar tools 
• Knowledge of MDM (Master data management) foundational concepts 
• Excellent verbal and written communication skills that allow effective communication with all levels of the organization 
• Experience working in a heterogeneous technology environment 
• Ability to participate in high-level architecture design as well as hands-on development 
• Experience developing applications in the Salesforce platform 
• Exposure to web applications and web portals is added advantage

• 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