Qlikview/Qliksense Developer

Job Description-

• Proficient in Power BI report development and dashboards and publishing to the consumers for decision making
• Design and develop optimized reporting applications (Power BI/SSRS) on SQL, Azure SQL.
• Sound knowledge of various visuals like Heat Maps, Geocoding, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs and Histograms
• Design and develop SQL procedures / ETL jobs, data processing in Microsoft Azure SQL, SQL Server with optimized processing time.
• Communicate design, requirements, feature set, functionality, usability and limitations of subsystem to team and/or development lead or manager.
• Participate in Business Requirements and Functional Requirements meetings, identify gaps in requirements and drive discussion around appropriate solutions.
• Design and code high quality database solutions within a fast paced sprint release cycle.
• Proficiency in creating visualizations / reports / dashboards based on business requirements.
• Manage errors gracefully. Document code and work completed.
• Conduct thorough unit testing of code and document the unit test cases.
• Conduct appropriate performance testing to ensure all solutions will meet SLAs and performance criteria.
• Provide support as needed throughout Test and User Acceptance Testing phases.
• Create Technical Design Specification documentation that clearly articulates the design and code being implemented.
• Provide client communication as appropriate to project.
• Be able to translate technical specifications into finished programs and systems and also have a thorough understanding of developing solutions to handle
• large volume data sets that are typical with BI solutions.
• Assist in architectural design reviews and ensure technology stack selection is relevant
• Ensure development and testing follow industry standards

• 6-8 years of experience with any Business analytics visualization tool with at least 2 years of relevant experience in PBI development
• Demonstrated SQL expertise, coding functions, packages, stored procedures, scripts, and queries in SQL Server.
• Good technical knowledge in SQL Server BI Suite (ETL, Reporting, Analytics, Dashboards) using SSIS(good to have), SSAS(good to have), SSRS(good to have) and  Power BI (must have)
• Expertise in Query Optimization and create new SQL procedures based on business requirements.  This is a must have skill set
• Advanced working SQL knowledge and experience working with relational databases, query authoring as well as optimizing the data base objects
• Experience in working with Structured, semi-structured and un-structured data.
• Demonstrated experience in working on Power BI
• Understands how to create optimized db schema
• Strong data warehouse design and physical data modeling skills
• Ability to quickly troubleshoot issues and work on multiple tasks in parallel.
• Excellent coding and debugging skills
• Should have exposure of working PBI Premium Workspace and Gateways
• Ability to work in a self-directed way either individually or as part of a team.
• Excellent communication skills (written and spoken) and ability to work under continual deadline constraints are necessary.

Mandatory

·  Candidates must have substantial applicable IT experience, extensive development, programming experience in Java/ Dotnet / VB or other Web Application Development

·  Strong experience in DB (PostgreSQL, SQL server) Web Services using Restful, any.

- Writing queries used for front- end applications (websites, desktop applications)

- Designing and coding database tables to store the application data

.- Data modeling to visualize database structure.

- Reviewing query performance and optimizing code.

• 6 - 10 years’ experience in Oracle EBS (Techno-Functional)
• Experience in implementation, Support, and upgrade projects
• Experience at least in 2 R12.2 upgrade projects.
• Experience in Oracle EBS R12.2.7 or Higher versions of R12.
• Strong knowledge in SQL/PLSQL, Reports, Forms, and workflow. OAF is added advantage.
• At least 40% functional knowledge in SCM and Manufacturing (Modules: PO, OM, INV, WIP, BOM, Quality and Engineering)
• Excellent verbal and written communication skills

About the Role

Key responsibilities:

• Working with stakeholders, including Customer Support team, Customer Success team and senior executive management to address customer/product issues effectively.
• Working cross-functionally with Support, QA, Engineering and PM teams to ensure timely responses and resolutions for customer/product issues.
• Updating tickets in a timely manner.
• Providing regular reports to the management on product performance and customer issues.
• Managing prioritization and trade-offs between customer experience, business impact and product performance.
• Working with the PM team during the sprint releases to help enhance the product with long-term solutions for customer/product issues.

Key requirements:

• Experience of 3 to 8 years in customer service roles in a product company.
• A degree in Computer Science, Engineering or a related field.
• Prior experience in L2/L3 support in a SaaS company would be ideal.
• Experience in triaging and analyzing issues, especially with logs analysis.
• Proficient in SQL queries to derive insights for root cause analysis.
• Advanced MS Excel skills for presenting findings to the management.
• Excellent communication and teamwork skills.
• Ability: strong problem solving and prioritization skills.
• Willingness to work in evening/night shift (1700 to 0200 Hrs IST) to support stakeholders in the US.