BI Developer - QlikView/Qliksense

• Extensive exposure to at least one Business Intelligence Platform (if possible, QlikView/Qlik Sense) – if not Qlik, ETL tool knowledge, ex- Informatica/Talend
• At least 1 Data Query language – SQL/Python
• Experience in creating breakthrough visualizations
• Understanding of RDMS, Data Architecture/Schemas, Data Integrations, Data Models and Data Flows is a must

Required Skill Set-

Project experience in any of the following - Data Management,

Database Development, Data Migration or Data Warehousing.

• Expertise in SQL, PL/SQL.

Role and Responsibilities -

• Work on a complex data management program for multi-billion dollar

customer

• Work on customer projects related to data migration, data

integration

•No Troubleshooting

• Execution of data pipelines, perform QA, project documentation for

project deliverables

• Perform data profiling, data cleansing, data analysis for migration

data

• Participate and contribute in project meeting

• Experience in data manipulation using Python preferred

• Proficient in using Excel, PowerPoint

 -Perform other tasks as per project requirements.

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

Job Title: Oracle PL/SQL Developer

Qualification: (B.E./B.Tech/ Masters in Computer or IT)

Years of Experience: 3 – 7 Years

No. of Open Positions – 3

Job Location: Jaipur

1. Proven hands-on Database Development experience
2. Develop, design, test and implement complex database programs
3. Strong experience with oracle functions, procedures, triggers, packages & performance tuning,
4. Ensure that database programs are in compliance with V3 standards. 
5. Hands-on development using Oracle PL/SQL.
6. Performance tune SQL's, application programs and instances. 
7. Evaluation of new and upcoming technologies.
8. Providing technical assistance, problem resolution and troubleshooting support.

JOB SUMMARY:  The Senior Associate supports the Data Analytics Manager by proposing relevant analytics procedures/tools, executing the analytics and also developing visualization outputs for audits, continuous monitoring/auditing and IA initiatives. The individual’s responsibilities include -

Understanding audit and/or project objectives and assisting the manager in preparing the plan and timelines.

Working with the Process/BU/IA teams for gathering requirements for continuous monitoring/auditing projects.

Working with Internal audit project teams to understand the analytics requirements for audit engagements.

Independently build pilot/prototype, determine appropriate visual tool and design the views to meet project objectives.

Proficient in data management and data mining.

Highly skilled on visualization tools like Qlik View, Qlik Sense, Power BI, Tableau, Alteryx etc.

Working with Data Analytics Manager to develop analytics program aligned to the overall audit plan.

Showcasing analytics capability to Process management teams to increase adoption of continuous monitoring.

Establishing and maintaining relationships with all key stakeholders of internal audit.

Coaching other data analysts on analytics procedures, coding and tools.

Taking a significant and active role in developing and driving Internal Audit Data Analytics quality and knowledge sharing to enhance the value provided to Internal Audit stakeholders.

Ensuring timely and accurate time tracking.

Continuously focusing on self-development by attending trainings, seminars and acquiring relevant certifications.

As a Power BI and QlikView Developer, we expect the candidate to be a key contributor in the implementation of data analytics dashboards – from data preparation to dashboard development, unit testing and deployment. The primary work focus for the candidate is as under: 

• Understanding the database design. 

• Develop efficient SQL queries from simple to complex and test the data output as a part of data preparation activity 

• Development & Unit Testing – Dashboards & Data Visualizations using Power BI 

• Troubleshooting/debugging and rectifying issues 

• Review, feedback and mentoring the team 

• Adherence of standards and best practices as defined by the company at the individual level and as a team 

QUALIFICATIONS AND EXPERIENCE 

• Degree in BE/ BTech with at least 3 to 5 years of overall experience 

• Experience in working on multiple databases like MS SQL (Mandatory), PostgreSQL, Mongo DB, MySQL (would be a plus) etc. and data analytics projects (a minimum of 2 to 3).  

• Experience working on SQL Server: Writing queries of 1 to 2 years is mandatory.  

• Expertise in Power BI and knowledge of QlikView (1-2 years). 

• Understanding other tools like Tableau, Domo etc. would be a great plus 

• Experience in working on different types of visualizations, in addition to the generic ones – Scatter plots, Heat Maps, Geo maps, Gantt, Bubbles, Tree Maps etc. 

• Experience working on Trends, forecasting etc. would be a plus 

• Experience in working with projects teams and ensuring the successful delivery of the solution

Datametica is looking for talented SQL engineers who would get training & the opportunity to work on Cloud and Big Data Analytics.

Mandatory Skills:

• Strong in SQL development
• Hands-on at least one scripting language - preferably shell scripting
• Development experience in Data warehouse projects

Opportunities:

• Selected candidates will be provided training opportunities on one or more of the following: Google Cloud, AWS, DevOps Tools, Big Data technologies like Hadoop, Pig, Hive, Spark, Sqoop, Flume, and KafkaWould get a chance to be part of the enterprise-grade implementation of Cloud and Big Data systems
• Will play an active role in setting up the Modern data platform based on Cloud and Big Data
• Would be part of teams with rich experience in various aspects of distributed systems and computing

ETL Developer – Talend

Job Duties:

• ETL Developer is responsible for Design and Development of ETL Jobs which follow standards,

best practices and are maintainable, modular and reusable.

• Proficiency with Talend or Pentaho Data Integration / Kettle.
• ETL Developer will analyze and review complex object and data models and the metadata

repository in order to structure the processes and data for better management and efficient

access.

• Working on multiple projects, and delegating work to Junior Analysts to deliver projects on time.
• Training and mentoring Junior Analysts and building their proficiency in the ETL process.
• Preparing mapping document to extract, transform, and load data ensuring compatibility with

all tables and requirement specifications.

• Experience in ETL system design and development with Talend / Pentaho PDI is essential.
• Create quality rules in Talend.
• Tune Talend / Pentaho jobs for performance optimization.
• Write relational(sql) and multidimensional(mdx) database queries.
• Functional Knowledge of Talend Administration Center/ Pentaho data integrator, Job Servers &

Load balancing setup, and all its administrative functions.

• Develop, maintain, and enhance unit test suites to verify the accuracy of ETL processes,

dimensional data, OLAP cubes and various forms of BI content including reports, dashboards,

and analytical models.

• Exposure in Map Reduce components of Talend / Pentaho PDI.
• Comprehensive understanding and working knowledge in Data Warehouse loading, tuning, and

maintenance.

• Working knowledge of relational database theory and dimensional database models.
• Creating and deploying Talend / Pentaho custom components is an add-on advantage.
• Nice to have java knowledge.

Skills and Qualification:

• BE, B.Tech / MS Degree in Computer Science, Engineering or a related subject.
• Having an experience of 3+ years.
• Proficiency with Talend or Pentaho Data Integration / Kettle.
• Ability to work independently.
• Ability to handle a team.
• Good written and oral communication skills.