Database Consultant-I (PostgreSQL)

Reports Developer

Description - Data Insights Analyst specializing in dashboard development, data validation, and ETL testing using Tableau, Cognos, and SQL.

Work Experience: 5-9 years 

 Key Responsibilities

Insights Solution Development:

•    Develop, maintain, and enhance dashboards and static reports using Tableau and IBM Cognos.

•    Collaborate with Senior Data Insights specialists to design solutions that meet customer needs.

•    Utilize data from modeled Business Data sources, Structured DB2 Datamarts, and DB2 Operational Data stores to fulfill business requirements.

•    Conduct internal analytics testing on all data products to ensure accuracy and reliability.

•    Use SQL to pull and prepare data for use in Dashboards and Reports

Data Management Tasks:

•    Test new ETL developments, break-fixes, and enhancements using SQL-based tools to ensure the accuracy, volume, and quality of ETL changes.

•    Participate in data projects, delivering larger-scale data solutions as part of a project team.

•    Report defects using Jira and work closely with IT team professionals to ensure the timely retesting of data defects

•    Utilize Spec. Documentation and Data lineage tools to understand flow of data into Analytics Data sources

•    Develop repeatable testing processes using SQL based tools

Technical Experience

•    SQL

•    Tableau

•    Data Visualization

•    Report Design

•    Cognos Analytics

•    Cognos Transformer

•    OLAP Modeling (Cognos)

 Additional Skills

An Ideal Candidate would have the following additional Skills

•    Python

•    SAS Programming

•    MS Access

•    MS Excel

Work Hours: We would like to have the majority of the work hours align to U.S. Eastern time zone with people working until 2 p.m. or 3 p.m. est. so that work hours align to times the Senior Analysts are available and Data Bases are available.  

Experience : 4 - 8 Years

Primary Skills

• BE/BTech/MTech with 1 year of experience in .NET Framework like C#.Net and ASP.Net
• Atleast 1 year of experience on Web Application development with ADO.Net, HTML, CSS, JavaScript/Jquery
• Good experience in Writing Complex SQL Queries using any of the RDBMS Database like Oracle, SQL Server etc
• Experience in Creating and Testing Stored Procedures and Functions

Secondary Skills

• Ability to analyse the existing code in the application and identify the Program Logic
• Experience in implementing AJAX through Javascript/Jquery
• Experience in Creating Reports and Documents using Crystall Reports
• Experience in creating Front End Validations using JavaScript/Jquery
• Experience in doing Manual or Automated Test will be a plus

Desired Skills

• Good communication Skills
• Good conceptualization skills
• Good visualization ability
• Good analytical capability
• Quality focused
• Good problem solving ability

Location : Bangalore

Responsibilities :-

1.      Design and engineer new next generation fintech solutions.

2.      Implement, optimize and manage the microservices based architecture, end to end, considering various technologies and business stakeholders.

3.      Build the correct database design and be ready to evolve it as per upcoming requirements.

4.      Design, develop and implement various web and mobile app based customer/partner/merchant journeys.

5.      Work with multiple stakeholders to understand inherent complexities involved in building the new solutions on top of the existing product and provide the most suitable and optimized one.

6.      A go getter with no reservations, should be ready to jump in and code if required.

7.      Do code reviews and ensure that best practices are followed

Ensure that best security practices are taken care of while building the product. 

Requirements:-

1.      Bachelor of Engineering or Bachelor of Technology in Computer Science / Information Technology or a related field

2.      At least 12 years of experience that includes at least 5 years of experience in technology architecture with a significant focus on building scalable full stack applications to be deployed on cloud

3.      Excellent problem solving and strategic thinking and leadership skills with the ability to implement complex projects to successful completion

4.      Hands on experience in Nodejs, JavaScript, Mongo DB, Relational Database and React. Must be efficient in building efficient code and DB queries.

5.      Experience in using cloud services from various cloud providers i.e. AWS, Azure, OCI (AWS exposure is the must)

6.      Understanding and experience in ensuring the security best practices are taken care of while building the product.

Should have excellent communication and interpersonal skills.

Develop and implement comprehensive online marketing strategies to

achieve company objectives.

 Manage and optimize online advertising campaigns, including PPC, display ads, and remarketing.

 Conduct keyword research and monitor SEO performance to improve organic search rankings.

 Plan and execute email marketing campaigns, including segmentation,content creation, and performance analysis.

 Manage social media channels, create engaging content, and monitor

community engagement.

 Create and optimize landing pages and conversion funnels to maximize lead generation and customer acquisition.

 Analyze website traffic and user behaviour using web analytics tools to identify areas for improvement and conversion rate optimization.

 Collaborate with the content team to develop high-quality, SEO-friendly content for websites, blogs, and other digital platforms.

 Stay up-to-date with industry trends, best practices, and emerging digital marketing technologies.

 Monitor and report on the performance of online marketing campaigns using analytics tools and prepare regular reports for management.

 Assessing the online user experience and developing strategies to increase NPS.

 Monitoring and maintaining the media budget.

QUALIFICATIONS  Bachelors' degree in marketing, business, or a related field.

 Proven experience in online marketing, preferably in a managerial role.

 Strong understanding of digital marketing channels, including SEO, PPC, email

marketing, and social media.

 Proficiency in using marketing automation tools, web analytics platforms, and

content management systems.

 Knowledge of HTML, CSS, and website optimization techniques.

 Excellent analytical skills with the ability to interpret data and make data-

driven decisions.

 Strong project management skills with the ability to prioritize and manage

multiple projects simultaneously.

 Excellent written and verbal communication skills.

 Creative thinking and problem-solving abilities.

 Up-to-date with the latest digital marketing trends and best practices

• Knowledge of various testing techniques and the ability to use them in practice (at least 4 years of practical experience)
• Strong analytical and interpersonal skills with the ability to work independently and collaboratively.
• Intermediate programming experience in one or more of the following languages: Java, C#, JavaScript/TypeScript, Python
• Hands-on experience in frontend, API and/or database test automation: Selenium, Cypress, Serenity BDD, REST API testing, Cucumber
• Experience with defect tracking/management tools such as JIRA.
• Demonstrated experience with industry standard Quality Assurance best practices for Agile and Iterative SDLCs, testing methodologies, implementation, and deployment activities.
• Experience in every-day use of version control system (git)
• Experience in testing in a continuous integration environment Jenkins/TeamCity, Maven
• Basic knowledge of SQL
• Working experience in creating test documentation (Test Plan, test report, basic test metrics)
• Experience in working with requirements
• As a consultant, ability to effectively cooperate with the client and/or end users
• Fluent English in speech and writing (frequent communication with English-speaking clients)

• Must have strong knowledge of the programming language (Java).
• Experience in performing performance tests using dedicated tools (e.g. Jmeter)
• Experience in performing usability and/or security tests
• Experience in mobile testing, cloud migration testing or data integrity testing
• Team leading skills
• Ability to design test strategy for a project

About the company

WonDRx (pronounced as Wonder-Rx) - spearheaded by two serial Entrepreneurs Mr. Pankaj Sindhu along with his Co-Founder Mr. Pankaj Agrawal; is a very unique and novel technology which has the capacity to change the way healthcare eco-system interacts with each-other. We are determined to change the way of Healthcare domain working and make it more convenient while ensuring a pleasant experience for the consumers and all other stakeholders involved. You need to see the product to believe the power it has and what it can enable in the healthcare domain.

Designation: Team Leader Data Analyst & Project Management

Job Description:

We are seeking a highly skilled and detail-oriented Team Leader- Data Analyst & Project to join our team. In this role, you will be responsible for extracting insights from raw data, preparing analytics reports, and overseeing data-driven projects from start to finish.

The ideal candidate should have a strong background in Advanced Excel, proficiency in various Business Intelligence (BI) tools will be an added advantage, and experience in follow up with various internal and external stakeholders related to ongoing projects.

Responsibilities:

•          Gather, clean, and validate raw data from various sources.

•          Develop and maintain efficient data management systems.

•          Apply advanced Excel techniques to manipulate and analyse data effectively.

•          Utilize BI tools to create insightful reports, visualizations, and dashboards.

•          Identify trends, patterns, and correlations in data sets.

•          Collaborate with cross-functional teams to understand their data needs and provide analytical support.

•          Present findings and recommendations to stakeholders in a clear and understandable manner.

•          Manage data-driven projects from initiation to completion, ensuring deliverables are met on time and within budget.

•          Maintain project plans, including timelines, resource allocation, and task assignments.

•          Monitor project progress, identify risks, and implement mitigation strategies.

•          Coordinate and communicate with team members, ensuring alignment and effective collaboration.

•          Prepare project status reports and deliver presentations to stakeholders.

•          Evaluate project outcomes and identify areas for improvement.

Requirements:

•          Master’s or Bachelor's degree with a relevant experience in coordinating Data Driven projects

•          Proficiency in Advanced Excel functions and formulas.

•          Knowledge of at least one Business Intelligence (BI) tool (e.g., Tableau, Power BI, QlikView) will be an added advantage

•          Excellent project management skills, including planning, organization, and prioritization.

•          Strong problem-solving and critical-thinking abilities.

•          Excellent communication and interpersonal skills.

•          Ability to work independently and manage multiple projects simultaneously.

•          Attention to detail and ability to work with complex datasets.

Preferred Skills:

•          Data Analysis: Candidate should have strong analytical skills which is crucial for a data analyst. You should be able to collect, organize, and interpret complex data sets to extract meaningful insights. Advanced Excel is a must.

•          Communication and Presentation: Data analysts should be able to effectively communicate their findings to both technical and non-technical stakeholders. You would need to effectively communicate with team members, stakeholders, and other project stakeholders. This includes written communication through project documentation and reports, as well as verbal communication for conducting meetings, providing updates, and resolving issues.

•           Continuous Learning: We are a constantly evolving startup. Ideal candidate should have willingness to learn new techniques, stay updated with the latest tools and technologies, and adapt to changing trends which is crucial for long-term success.

•           Team Player: You should be able to motivate and inspire team members, provide guidance, and facilitate decision-making processes.

•           Project Coordinator: As a project coordinator you should possess strong problem-solving and critical-thinking skills to identify issues, analyse root causes, and propose and implement appropriate solutions

About Rippling

Rippling is the first way for businesses to manage all of their HR & IT—payroll, benefits, computers, apps, and more—in one unified workforce platform.

By connecting every business system to one source of truth for employee data, businesses can automate all of the manual work they normally need to do to make employee changes. Take onboarding, for example. With Rippling, you can just click a button and set up a new employees’ payroll, health insurance, work computer, and third-party apps—like Slack, Zoom, and Office 365—all within 90 seconds.

Based in San Francisco, CA, Rippling has raised $1.2B from the world's top investors—including Kleiner Perkins, Founders Fund, Sequoia, Bedrock, and Greenoaks—and was named one of America's best startup employers by Forbes (#12 out of 500).

About the role

We are building a world-class Support team - committed to helping customers realize the full potential of Rippling. Team members focus on getting our customers back on course when challenges arise and contribute to internal discussions around product enhancements. 

If you are the type of person to look at a flight of 10,000 stairs, pause, get a bit excited, and then seize the moment - you have what it takes!

What you will do

• Take charge of payroll issues for customers from start to finish - while working in a dynamic and fast-paced environment
• Leverage chat, email, and video conferencing functionality to help our customers optimize Rippling to administer payroll processing, quarterly/yearly taxation & filings, and banking & payments inquiries 
• De-escalate and resolve issues by leveraging platform and industry expertise 
• Work well under time constraints and meet schedules; at times with unexpected deadlines, to ensure client’s payroll needs are met
• Build mental muscle and become a product expert - you'll be a go-to resource for both customers and coworkers 
• Interact with cross-functional teams to identify areas where we can better serve our customer base through automation or added features

What you will need

• Bachelor's degree or equivalent work experience
• Ability to work 6:30 PM IST, 5:30 AM IST
• Demonstrated experience problem-solving with attention to detail
• Organizational skills and experience improving processes
• Written and verbal communication skills
• Flexibility with changing job duties and responsibilities
• Time management skills and ability to prioritize
• Nice to have (not required): Bilingual in French-English

Salesforce Developer Responsibilities:

• Developing customized solutions within the Salesforce platform.
• Designing, coding, and implementing Salesforce applications.
• Conduct technical process reviews, technical UAT's and work in partnership with the test and business consultants.
• Maintaining the security and integrity of the application software.
• Ability to gather data migration requirements, define a data migration plan and perform complex data migrations requiring transformation using a database, and potentially containing very large data sets.

Salesforce Developer Requirements:

• Min 2+ years’ experience implementing and configuring Salesforce.com.
• Expertise in using REST API's, SOAP Web services, Bulk API and Streaming APIs.
• Experience with Apex Triggers, Apex Class, LWC, Javascript, HTML, Validation Rules, Workflow Rules, Process Builder,flow,Lightning and Service Cloud.
• Experience in SFDX, VS Studio and ANT Deployment tool.
• Strong business analysis and functional experience, including requirements gathering, creating/deploying solutions to end users
• Knowledge of LWC/Salesforce Marketing Cloud is an added plus
• Certification on PD2 is a bonus.

Build large scale web applications with Single Page Applications (SPA) architecture.

Experience to develop MV(C) based front end frameworks.

Experience with JavaScript, HTML, CSS.

Experience with JavaScript frameworks like Angular, preferably React.JS.

Good understanding of asynchronous request handling, partial page updates, AJAX and Redux.

Proficient with Chrome Developer Tools.

Additional Preferred Qualifications

Experience in Restful API services.

Experience in using performance, analytics and UX tools.

Experience with pull request process and contributing to OSS on github.com.

Experience with unit testing frameworks Mocha and Chai.

Experience with Jenkins.