Senior BI & ETL Developer

Responsibilities include:  

• Develop and maintain data validation logic in our proprietary Control Framework tool 
• Actively participate in business requirement elaboration and functional design sessions to develop an understanding of our Operational teams’ analytical needs, key data flows and sources 
• Assist Operational teams in the buildout of Checklists and event monitoring workflows within our Enterprise Control Framework platform 
• Build effective working relationships with Operational users, Reporting and IT development teams and business partners across the organization 
• Conduct interviews, generate user stories, develop scenarios and workflow analyses  
• Contribute to the definition of reporting solutions that empower Operational teams to make immediate decisions as to the best course of action 
• Perform some business user acceptance testing 
• Provide production support and troubleshooting for existing operational dashboards  
• Conduct regular demos and training of new features for the stakeholder community 

Qualifications  

• Bachelor’s degree or equivalent in Business, Accounting, Finance, MIS, Information Technology or related field of study 
• Minimum 5 years’ of SQL required 
• Experience querying data on cloud platforms (AWS/ Azure/ Snowflake) required 
• Exceptional problem solving and analytical skills, attention to detail and organization 
• Able to independently troubleshoot and gather supporting evidence  
• Prior experience developing within a BI reporting tool (e.g. Spotfire, Tableau, Looker, Information Builders) a plus  
• Database Management and ETL development experience a plus 
• Self-motivated, self-assured, and self-managed  
• Able to multi-task to meet time-driven goals  
• Asset management experience, including investment operation a plus 

SharePoint Developer

Job Description

We are seeking a highly skilled SharePoint Developer with 4-15 years of experience to join our dynamic team. The ideal candidate will have a deep understanding of SharePoint technologies and a proven track record of designing, developing, and deploying robust SharePoint solutions.

Responsibilities:

• Design, develop, and customize SharePoint solutions, including workflows, custom forms, and web parts.
• The candidate must know tamil language.
• Migrate SharePoint environments and upgrade existing solutions to the latest versions.
• Troubleshoot and resolve complex technical issues related to SharePoint.
• Collaborate with business analysts, project managers, and other stakeholders to understand requirements and deliver effective solutions.
• Stay updated with the latest SharePoint trends and technologies.
• Adhere to best practices and coding standards.

Required Skills and Experience:

• Strong proficiency in SharePoint development, including SharePoint Framework (SPFx), PowerShell scripting, and SharePoint Add-ins.
• In-depth knowledge of SharePoint architecture, configuration, and administration.
• Experience with SharePoint Online and on-premises environments.
• Strong understanding of web development technologies, including HTML, CSS, and JavaScript.
• Experience with Microsoft Power Platform (Power Apps, Power Automate, Power BI) is a plus.
• Excellent problem-solving and analytical skills.
• Strong communication and interpersonal skills.

If you are a passionate SharePoint Developer with a proven track record of delivering innovative solutions, we encourage you to apply.

Responsibilities

• Manage and drive a team of Data Analysts and Sr. Data Analysts to provide logistics and supply chain solutions.
• Conduct meetings with Clients to gather the requirements and understand the scope.
• Conduct meetings with internal stake holders to walk them through the solution and handover the analysis.
• Define business problems, identify solutions, provide analysis and insights from the client's data.
• 5 Conduct scheduled progress reviews on all projects and interact with onsite team daily.
• Ensure solutions are delivered error free and submitted on time.
• Implement ETL processes using Pentaho Data Integration (Pentaho ETL)Design and implement data models in Hadoop.
• Provide end-user training and technical assistance to maximize utilization of tools.
• Deliver technical guidance to team, including hands-on development as necessary; oversee standards, change controls and documentation library for training and reuse.

Requirements

• Bachelor's degree in Engineering.
• 16+ years of experience in Supply Chain and logistics or related industry and Analytics experience.
• 3 years of experience in team handling(8+People) and interacting with the executive leadership teams.
• Strong project and time management skills with ability to multitask and prioritize workload.
• Solid expertise with MS Excel, SQL, any visualization tools like Tableau/Power BI, any ETL tools.
• Proficiency in Hadoop / Hive.
• Experience Pentaho ETL, Pentaho Visualization API, Tableau.
• Hands on experience of working with Big data sets (Data sets with millions of records).
• Strong technical and Management experience.

Desired Skills and Experience

• NET,ASP.NET

Java/Scala + Data Engineer

Experience: 5-10 years

Location: Mumbai

Notice: Immediate to 30 days

Required Skills:

·       5+ years of software development experience.

·       Excellent skills in Java and/or Scala programming, with expertise in backend architectures, messaging technologies, and related frameworks.

·       Developing Data Pipelines (Batch/Streaming). Developing Complex data transformations, ETL Orchestration, Data Migration, Develop and Maintain Datawarehouse / Data Lakes.

·       Extensive experience in complex SQL queries, database development, and data engineering, including the development of procedures, packages, functions, and handling exceptions.

·       Knowledgeable in issue tracking tools (e.g., JIRA), code collaboration tools (e.g., Git/GitLab), and team collaboration tools (e.g., Confluence/Wiki).

·       Proficient in Linux/Unix, including shell scripting.

·       Ability to translate business and architectural features into quality, consistent software design.

·       Solid understanding of programming practices, emphasizing reusable, flexible, and reliable code.

Skill for BI Backend developer -

-SQL development (Snowflake preferred but any other version of SQL would work)

- ETL

- Stored Procedures

- Creating jobs and work flows in SQL

- some business knowledge

Company Overview

CareStack is a complete cloud-based dental software solution for scheduling, clinical, billing, patient engagement, and reporting needs of dental offices of any size - whether it's a single location or a large multi-site DSO with hundreds of locations.

The company was founded in 2015 and the commercial launch was done in early 2018. Since then, more than 1000 offices have chosen CareStack as their single source of truth. This is the fastest growth till date in the dental practice management software market, dominated by 100 year old distribution companies.

More about CareStack

●    Rated by independent B2B software reviews and research analysts as the most modern, innovative and customer experience focussed company in the space with the fastest growth in the segment.

●    Important strategic go to market partnerships with dental industry leaders like Delta Dental, Darby Dental and several others.

●    Venture backed with over $60M raised from leading financial and strategic investors.

●    HQ'd in Orlando, FL with offices in Minnesota, Bangalore, Trivandrum and Cochin.

Role Overview

CareStack seeks to hire Software Development Engineer - 1 to build its next generation healthcare platform. You will be reporting to a Staff SDE in your business unit , to develop and release services and solutions for our platform, aligning with your business unit’s goals and objectives.

Key responsibilities

●    Technical Design

You can be a specialist in technology areas, but capable of creating complete designs to solve a specific problem that accomplishes a definitive product feature or enables a technical advancement.You should work with your lead to review your design and embrace the feedback

●    Process Definition/Adherence

You should deliver estimations, review test scenarios/cases created by QAs in your team, participate in sprint grooming and planning meetings. You must learn, practice and evangelize standard techniques for grooming, defining complexity of stories and estimation.

●    Code Quality

At Carestack we believe that your code reflects your character. Code for scale, produce maintainable reusable code. You must commit to clean coding, continuous refactoring to ensure a high level of code quality. Continuously learn, practice and evangelize coding patterns/best practices within and outside your team. You should ensure testability of team functional areas, facilitate integration testing, resolve deep rooted technical issues and proactively collaborate with team members in solving complex problems.

●    Team Player

You should proactively communicate to resolve dependencies within and outside the team. Understand organizations culture code and streamline conversations and activities that will further instill this code. Mentor and coach new additions to your team.

●    Value/Mission Alignment

Be a champion for CareStack within the Engineering team. Help drive workplace and cultural norms within your business unit that align with CareStack company values.

This role may be for you if you…

●    Have an insatiable itch to join and the courage to scale an early-stage technology company.

●    Have 2-4 years of experience in building modern day web platforms, using Microsoft technologies on the backend.

●    Can be a generalist or specialist with deep understanding of building software components that meet defined requirements, with good understanding of .NET Core/ASP.NET.

●    Are proficient in data structures and algorithms, and object oriented analysis and design of software systems.

●    Are a backend specialist with good understanding of event driven programming, distributed systems, caching/in-memory computing systems, data modeling for transactional systems.

●    Solid understanding of relational and non relational databases including warehouses.Preferably MySQL, MSSQL, Vertica and CosmosDB

●    Solid understanding of CI/CD patterns and IaC.

●    Expertise in building ETLs in both batch and streaming model.

●    Expertise in building and testing APIs and micro services

This role may not be for you if you…

●    Don’t have the itch to design solutions and write code and you don’t grab every other opportunity to review and write code.

●    Don’t have the fire in you to fight for your design suggestions and debate with logical data points

●    Don’t have the trait to be transactional in code reviews/design discussions, accept your mistakes and appreciate better ideas from your peers.

●    Haven’t developed the habit of doing objective conversations that are data driven.

• BE/MTech/MCA/MSc
• 3+yrs Hands on Experience in TSQL / PL SQL / PG SQL or NOSQL
• Immediate joiners preferred*
• Candidates will be selected based on logical/technical and scenario-based testing

Note: Candidates who have attended the interview process with TnS in the last 6 months will not be eligible.

1. Technical Skills Desired:
   1. Experience in MS SQL Server and one of these Relational DB’s, PostgreSQL / AWS Aurora DB / MySQL / Oracle / NOSQL DBs (MongoDB / DynamoDB / DocumentDB) in an application development environment and eagerness to switch
   2. Design database tables, views, indexes
   3. Write functions and procedures for Middle Tier Development Team
   4. Work with any front-end developers in completing the database modules end to end (hands-on experience in parsing of JSON & XML in Stored Procedures would be an added advantage).
   5. Query Optimization for performance improvement
   6. Design & develop SSIS Packages or any other Transformation tools for ETL

1. Functional Skills Desired:
   1. Banking / Insurance / Retail domain would be a
   2. Interaction with a client a

1. Knowledge in a Cloud Platform (AWS / Azure)
2. Knowledge on version control system (SVN / Git)
3. Exposure to Quality and Process Management
4. Knowledge in Agile Methodology

1. Soft skills: (additional)
   1. Team building (attitude to train, work along, mentor juniors)
   2. Communication skills (all kinds)
   3. Quality consciousness
   4. Analytical acumen to all business requirements

CRM Technical Developer

Country: Malaysia

Cities: Kuala Lumpur

Area of expertise: Customer Relationship Management (CRM)

Job Description

You're a problem solver, knowing the systems, applications, and processes that will make a client happy, no matter how complex the IT solution and integrating architecture. You bring expertise and creativity to designing activities and building system prototypes.

About the job

Business and IT don't always speak the same language. It can be difficult for companies to know how IT can help tackle their problems and increase profitability. They need you to understand their business and translate their needs into a software solution that will realize results. 

As a CRM Technical Developer, you will be familiar with at least one leading commercial CRM system. You will assist delivery teams with CRM solution planning, analysis, designing, building, and testing. You will be considered a product specialist that is also responsible for providing support in CRM issue, customer concern, and resolution. This role is typically focused on more complex assignments, often requiring diverse inputs, processes, and/or outcomes with room for discretion within established parameters.

Day-to-day you will:

• Assist across all phases of projects (e.g. Plan, Analyze, Design, Build, and Test)
• Demonstrate technical knowledge to design and implement CRM solutions
• Research customer issues that may be non-standard in order to offer solutions
• Support design of conceptual architecture and technical solutions
• Ensure project quality meets standards through critical metric identification and testing plan
• Identify process gaps and work cross-functionally to formulate improvement plans
• Travel as needed

Key Role Skill & Capability Requirements:

You are passionate about working with a global technology leader to solve business-critical problems for some of the top companies in the world. You are a fast learner, a self-starter, and a creative problem solver. You are passionate about software and its potential to move organizations forward through innovation.

Your technical skills may include:

• Design, develop, deploy, customize and integrate Microsoft Dynamics CRM with other systems
• Configure and customize on standard workflows, dashboards, forms, views and develop standard or custom reports
• Develop reports or dashboards using PowerBI and integrate with D365CS
• Develop web application, web API, console application, window services to integrate with D365CS
• Develop a script to migrate existing CRM to D365CS
• Complete the documentation required including the source codes, technical specification, and unit test result
• Support SIT, UAT, and production and fix the defect within the agreed SLA
• Strong understanding of Microsoft Dynamic365 CRM, with domain knowledge in Customer Service and Telco industry - this would be a plus point
• Develop Power BI reports and integration to Microsoft Dynamic 365 CRM

Your non-technical skills may include:

• Client management skills and the ability to work with customers to develop and manage an action plan
• Some consulting experience working with external clients
• Experience working with global/offshore teams
• Excellent communication skills

Preferred Education Background:

Bachelor's degree in a relevant field preferred.

Preferred Years of Work Experience:

• Minimum 3 year of Microsoft Dynamic 365 CRM and Power BI development experiences
• Minimum 3 year of experience in ASP.NET C# development, JavaScript, HTML 5, CSS and other web base technology and tools
• Experience with Microsoft Dynamics 365 Field Service is essential

Reporting and Business Intelligence

Minimum of 8 to 10 years of experience in Report building and Business Intelligence with

Profound knowledge on Oracle BI Publisher and BI Analytics with Oracle Fusion HCM domain especially in Core HR, Payroll and Absences modules

Primary skill:

• Experience generating BI publisher reports, dashboards and drill-down reports
• BI Publisher (RTF design/ eText/ Scheduling/ Parameter Handling/Bursting/backup and migration of reports to different pods)
• Design Oracle BI Publisher Data Models, Data sets and Templates/sub-templates
• Strong PL/SQL and Advanced PL/SQL experience
• Solid understanding of performance tuning best practices and experience improving end-to-end processing times
• Knowledge on the data models related to Fusion HCM (Core HR, Absence and Payroll modules)

Nice to have skills:

• Experience generating BI publisher reports, dashboards and drill-down reports
• Strong OBI Administrator activity
• Create mobile applications with Oracle Business Intelligence Mobile App Designer
• Use BI Mobile to access BI Content
• Create and modify Interactive Dashboards
• Knowledge of additional reporting tools viz. HCM Extract / OTBI / Analysis Dashboard would be an added advantage

Behavioural and Process Skills

• Experience working in Agile teams
• Self-motivated and self-directed abilities to prioritize and execute tasks in a high-pressure environment with "time-critical" deadlines
• Proven analytical, evaluative, and problem-solving abilities
• Possesses a team and customer service provision orientation