Helical IT Solutions

About Company
Helical Insight an open source Business Intelligence tool from Helical IT Solutions Pvt. Ltd,
based out of Hyderabad, is looking for fresher’s having strong knowledge on SQL. Helical
Insight has more than 50+ clients from various sectors. It has been awarded the most promising
company in the Business Intelligence space. We are looking for rockstar team mate to join
our company.
Job Brief
We are looking for a Business Intelligence (BI) Developer to create and manage BI and analytics
solutions that turn data into knowledge.
In this role, you should have a background in data and business analysis. You should be
analytical and an excellent communicator. If you also have a business acumen and
problemsolving aptitude, we’d like to meet you. Excellent knowledge on SQLQuery is required.
Basic knowledge on HTML CSS and JS is required.
You would be working closely with customers of various domain to understand their data,
understand their business requirement and deliver the required analytics in form of varous
reports dashboards etc. Excellent client interfacing role with opportunity to work across various
sectors and geographies as well as varioud kind of DB including NoSQL, RDBMS, graph db,
Columnar DB etc
Skill set and Qualification required
Responsibilities
 Attending client calls to get requriement, show progress
 Translate business needs to technical specifications
 Design, build and deploy BI solutions (e.g. reporting tools)
 Maintain and support data analytics platforms)
 Conduct unit testing and troubleshooting
 Evaluate and improve existing BI systems
 Collaborate with teams to integrate systems
 Develop and execute database queries and conduct analyses
 Create visualizations and reports for requested projects
 Develop and update technical documentation
Requirements
 Excellent expertise on SQLQueries
 Proven experience as a BI Developer or Data Scientist
 Background in data warehouse design (e.g. dimensional modeling) and data mining
 In-depth understanding of database management systems, online analytical processing
(OLAP) and ETL (Extract, transform, load) framework
 Familiarity with BI technologies
 Proven abilities to take initiative and be innovative
 Analytical mind with a problem-solving aptitude
 BE in Computer Science/IT
Education: BE/ BTech/ MCA/BCA/ MTech/ MS, or equivalent preferred.
Interested candidates call us on +91 7569 765 162

About Company

Helical Insight an open source Business Intelligence tool from Helical IT Solutions Pvt. Ltd, based out of Hyderabad, is looking for a product engineer having strong knowledge on Java. Helical Insight has more than 50+ clients from various sectors. It has been awarded the most promising company in the Business Intelligence space. We are looking for rockstar developers to join our product team.

Job Brief

We are looking for some good candidates with the below-mentioned skill set. We are open to really good candidates with a knack to learn & with the right attitude, even if they don't fulfill the entire criterion mentioned below.

Skill set and Qualification required

Mandatory Experience/knowledge with

• Java , J2EE, Junit
• Servlets , JSP
• SQL
• Spring Framework, Hibernate
• Data Structure, Design Patterns, Multi-threading
• JSON
• Apache Tomcat Web Server
• Problem Solving and Algorithms.

Nice to have

• Knowledge in Business Intelligence and Data Warehousing Knowledge, Database knowledge, Machine Learning.

Work Experience: 2-4 Years

Education: BE/ BTech/ MTech/ MS in Computer Science, or equivalent preferred.

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.

Job Description :We are looking for a Front-End Web Developer who is motivated to build robust applications and prototypes. Responsibilities will include building web applications which are efficient with reusable front-end abstractions. You will work with the Backend developers and bridge the gap between API design and technical implementation, taking an active role on both sides and defining how the works.Responsibilities :- To build web applications which are efficient, reusable front-end abstractions and systems.- Actively participate in design and code reviews to build robust applications and prototypes.- Analyze system function and performance requirements to support design concepts.- Optimize application for maximum speed and scalability- Assure that all user input is validated before submitting to back-end- Collaborate with other team members and stakeholdersSkills And Qualifications :- BE, B.Tech/ MS Degree in Computer Science, Engineering or a related subject.- 1-2 years of overall experience in web application development.- Proficient understanding of web markup, including HTML5, CSS3.- Basic understanding of CSS pre-processing platforms, such as LESS and SASS.- Proficient understanding of client-side scripting and JavaScript, including jQuery.- Good understanding of asynchronous request handling, partial page updates, and AJAX- Proficient understanding of cross-browser compatibility issues and ways to work around them.- Good understanding of API creation and implementation. - Good understanding of JavaScript libraries and frameworks, such as AngularJS, KnockoutJS, BackboneJS, ReactJS,etc.