12+ PL/SQL Jobs in Delhi, NCR and Gurgaon | PL/SQL Job openings in Delhi, NCR and Gurgaon

Business Intelligence Consultant – Qlik

Role

·      Working through customer specifications and develop solutions in line with defined requirements

·      Strategizing and ideating the solution design (create prototypes and/or wireframes) before beginning to create the application or solution.

·      Creating load scripts and QVDs to support dashboards.

·      Creating data models in Qlik Sense to support dashboards.

·      Leading data discovery, assessment, analysis, modeling and mapping efforts for Qlik dashboards.

·      Develop visual reports, dashboards and KPI scorecards using Qlik

·      Connecting to data sources ( MS SQL SERVER, ORACLE, SAP), importing data and transforming data for Business Intelligence.

·      Translating data into informative visuals and reports.

·      Developing, publishing and scheduling reports as per the business requirements.

·      Implementing application security layer models in Qlik

 Skills Required

·      Knowledge of data visualization and data analytics principles and skills –including good user experience/UI Design

·      Hands-on developer on Qlik Sense development

·      Knowledge of writing SQL queries

·      Exceptional analytical skills, problem-solving skills and excellent communication skills

 Qualifications 

1.      Degree in Computer Science Engineering disciplines or MCA

2.      2-4 years of hands-on Qlik experience

3.      Qlik Sense certification would be preferred

Roles and Responsibilities:

• Create logical and physical data models using best practices to ensure high data quality and reduced redundancy.

• Create or manage ETL batches and jobs.

• Understand and translate business needs into data models supporting long-term solutions.

• Analyze data-related system integration challenges and propose appropriate solutions.

• Enhance data collection procedures to include information that is relevant for building analytic systems.

Skills Required:

• 6+ years of industry experience with 3+ years in the role of BI Developer

Desired Technical Skills:

• In-depth understanding of database management systems, online analytical processing (OLAP), and ETL (Extract, transform, load) framework.

• Understanding of data modeling, processing, warehousing techniques, and related tools (Erwin or ER Studio or others) required.

• Ability to create KPIs, visualizations, reports and dashboards based on business requirement.

• Knowledge and experience in prototyping, designing, and requirement analysis.

• Experience of Pentaho Business Analytics Platform

• Analytical thinking for translating data into informative reports and visuals.

• Solid experience in writing SQL, stored procedures, proficient in SQL query performance tuning.

• Developing visual reports, KPI scorecards, and dashboards using any one of the following tools like Pentaho BI solutions/Business Object, OBIEE or Micro Strategy.

• Knowledge of Relational Database Management Systems (RDBMS) like Oracle, MySQL, or MSSQL.

• Strong PL/SQL knowledge is an advantage.

• Good communication, comprehension, and analytical skills.

Desired Business Skills:

• Property and Casualty Insurance experience is strongly preferred.

• Well-versed in software processes and methodologies

• Excellent verbal, written, and presentation skills.

• Excellent interpersonal skills.

• A quick learner with a strong analytical mindset.

• Excellent organizational and follow-up skills and the ability to meet time sensitive deadlines.

Primary Skills:

PL/SQL, Pentaho Business Analytics Platform, OLAP, ETL Framework, Stored Procedures, SQL Query Performance Tuning

Experience – 8 – 10 years

Location - NCR

Roles and Responsibilities:

System Analyst

The individual in this role will gather, document, and analyze client functional, transactional, and insurance business requirements across all insurance functions and third-party integrations. System Analyst will also work within a cross-functional project team to provide business analytical support and leadership from the business side.  The individual will play a highly visible, client-facing, and the consultative role and have the ability to offer system solutions to enhance client implementations and transform client workflow and business processes. Individual should be very good in mapping business functions / attributes with the Insurance rules and data.

Skills Required:

• A successful candidate in this role must:
• Good hands-on skills in Oracle, PL/SQL, TSQL
• Object oriented knowledge should be good
• Have Functional knowledge on P & C
• Overall Tech - 60% and Functional - 40%

Primary Skills:

• Good Data Mapping knowledge, RDBMS / SQL Knowledge

Secondary Skills:

• Oracle Big+

• 4-15 year experience in Application Support
• Must have good knowledge in Java/J2EE, Microservices, PL/SQL, Unix
• Good to have knowledge in Agile, JIRA, Splunk, Service Now
• Good understanding and hands-on experience in Incident, Problem and Change Management
• Provide technical leadership to the team & contribute in the skill development within team
  Interact with internal teams and client stakeholders to trouble shoot the tickets/incident and manage other support activities
• Good communications skills are necessary, must be team player and inquisitive.
• Strong customer service and support focus with a desire to deliver a high-quality service
• Ability to multi-task, work under pressure and to tight deadlines
• Flexible in working outside of office business hours at short notice (as required)
• Should be able to examine the system and identify the areas for Service Improvements & Value adds.

Position: Big Data Engineer

What You'll Do

Punchh is seeking to hire Big Data Engineer at either a senior or tech lead level. Reporting to the Director of Big Data, he/she will play a critical role in leading Punchh’s big data innovations. By leveraging prior industrial experience in big data, he/she will help create cutting-edge data and analytics products for Punchh’s business partners.

This role requires close collaborations with data, engineering, and product organizations. His/her job functions include

• Work with large data sets and implement sophisticated data pipelines with both structured and structured data.
• Collaborate with stakeholders to design scalable solutions.
• Manage and optimize our internal data pipeline that supports marketing, customer success and data science to name a few.
• A technical leader of Punchh’s big data platform that supports AI and BI products.
• Work with infra and operations team to monitor and optimize existing infrastructure 
• Occasional business travels are required.

What You'll Need

• 5+ years of experience as a Big Data engineering professional, developing scalable big data solutions.
• Advanced degree in computer science, engineering or other related fields.
• Demonstrated strength in data modeling, data warehousing and SQL.
• Extensive knowledge with cloud technologies, e.g. AWS and Azure.
• Excellent software engineering background. High familiarity with software development life cycle. Familiarity with GitHub/Airflow.
• Advanced knowledge of big data technologies, such as programming language (Python, Java), relational (Postgres, mysql), NoSQL (Mongodb), Hadoop (EMR) and streaming (Kafka, Spark).
• Strong problem solving skills with demonstrated rigor in building and maintaining a complex data pipeline.
• Exceptional communication skills and ability to articulate a complex concept with thoughtful, actionable recommendations.

About this role

We are seeking a seasoned DBA to join our team. You will have extensive experience in a mission-critical environment as a database administrator over a successful career.  You will primarily work on the Supporting our Databases, AWS RDS (MySQL), and  MongoDB/ Cassandra.

What You’ll Do

• Provide leadership in database scaling & monitoring. Maintain runbooks for our 24x7 SRE team. 
• Assist in troubleshooting and resolution of database issues. Perform database upgrades and patches.
• Define and develop data pipelines between platforms in a mission-critical environment using DMS, Fivetran, Kafka, etc.
• Work with our developers to optimize and tune their SQL queries.
• Assist in application development, debugging, and optimization with respect to data concerns.
• Provide input in the design and implementation of backup, recovery, and DR strategy
• Review application and database design for compliance.

What You’ll Need

• Ability to script in a high-level language like Python, Ruby, etc for Automation. 
• 8+ years of experience in AWS database services like RDS (Mysql), MongoDB/ Cassandra.
• 4+ years of experience in database design and DevOps on AWS.
• Must demonstrate a clear understanding of logical and physical database design and standards. 
• Experience in columnar data warehouse solutions like Redshift or Snowflake. 
• Must have extensive hands-on experience with MySQL in a large scale 24x7 production environment with millions of records.
• Bachelor of Science in Computer Science, Mathematics, or Engineering; or equivalent work experience

Bonus Points If You Have

• Experience with NoSQL solutions such as Cassandra/MongoDB etc.
• Experience with software development life cycle (SDLC) in an agile environment
• Hands-on production experience with Big Data applications such as Spark.
• Knowledge of development best practices (source control with Git, continuous integration, automated testing).