QUICKBASE DEVELOPER With SQL

We have positions available for ETL Testing position.

This role requires the following qualitfications

• Experience with manual testing.
• Experience with SQL language and Databases is essential.
• Experience of the Software Testing Life Cycle (STLC) and designing Test Scripts.
• Experience in ETL Testing (2 years).
• Experience in ETL Test Automation
• Knowledge in any MDM solution (Boomi preferred )
• Knowledge of Azure Data Factory, Logic Apps, Snowflake stored procedures, Stages and functions with complex SQL
• Knowledge of the Java/Python language, data model and ETL architecture.
• Knowledge of SOAP and REST API endpoints and Postman or similar tools.
• Knowledge of performance tools such as JMeter.
• Knowledge of documenting testing results.
• Knowledge of automation testing frameworks.

Please visit this link for more information about Onepoint and the roles

http://www.onepointltd.com/wp-content/uploads/2023/08/PUNE_JD2023-08_IN.009-Test-Engineer.pdf

To view other positions available, please visit

https://www.onepointltd.com/career-opportunities/

We are looking for an exceptionally talented Lead data engineer who has exposure in implementing AWS services to build data pipelines, api integration and designing data warehouse. Candidate with both hands-on and leadership capabilities will be ideal for this position.

Qualification: At least a bachelor’s degree in Science, Engineering, Applied Mathematics. Preferred Masters degree

Job Responsibilities:

• Total 6+ years of experience as a Data Engineer and 2+ years of experience in managing a team

• Have minimum 3 years of AWS Cloud experience.

• Well versed in languages such as Python, PySpark, SQL, NodeJS etc

• Has extensive experience in the real-timeSpark ecosystem and has worked on both real time and batch processing

• Have experience in AWS Glue, EMR, DMS, Lambda, S3, DynamoDB, Step functions, Airflow, RDS, Aurora etc.

• Experience with modern Database systems such as Redshift, Presto, Hive etc.

• Worked on building data lakes in the past on S3 or Apache Hudi

• Solid understanding of Data Warehousing Concepts

• Good to have experience on tools such as Kafka or Kinesis

• Good to have AWS Developer Associate or Solutions Architect Associate Certification

• Have experience in managing a team

Strong problem-solving capabilities and able to independently think through a challenge.

Demonstrated ability to learn new technology quickly

Every project can be different, and there may not be a “template” to work off of. Need someone who can be resourceful and has a “figure it out” attitude

2+ years of experience in Salesforce or other development

BS/MS in Computer Science, Engineering, or related years of experience and technical skills

Salesforce certifications preferred, e.g. Certified Salesforce Administrator, Certified Salesforce Platform App Builder, Platform Developer II

Experience in Salesforce CRM app development with strong expertise in Sales Cloud, Service Cloud, and / or Force.com at an enterprise level

Experience with SFDC Administrative tasks like creating Profiles, Roles, User Security Models, Page Layouts, Email Services, Dashboards, Tasks, and Events

Experience with Lightning Components, Design System, APEX Classes, Process Builder, Triggers, Visualforce, Approval Processes, Aura, and Flow

Verify and validate complete end-to-end testing with the business and client/carrier

Expert knowledge of Object-Oriented programming

Experience with database design concepts and use of SOQL, SOSL, and SQL

Experience with Salesforce API and Web Services (REST/SOAP/Bulk)

Experience with environment management, release management, code versioning, deployment methodologies, and CI/CD tools

Utilize strong written and oral communication skills to regularly update stakeholders on project status, e.g. project phase, issues/roadblocks, go-live dates, etc.

• Responding to escalated customer issues from L1 Customer Support Specialists.
• Excellent communication skills, especially related to relaying information between technical and non-technical parties
• Working closely with support and Level 3 teams.
• Building a deep technical knowledge of our product capabilities for both the front and back end.
• Escalating issues when required according to defined escalation paths.
• Maintaining a high level of professionalism with internal teams and customers and working to establish a positive rapport.
• Participation in standard product management processes (grooming sessions, stand-ups, etc. ) related to the resolution of customer-facing issues
• Work continuously to document product and technical knowledge.
• Responsible for driving L2 and L3 cases to closure meeting "case to closure" and "customer satisfaction" deliverables

JD – Attached Sample Profile for Reference

1) WebFOCUS BI Reporting
2) WebFOCUS Adminstration
3) Sybase or Oracle or SQL Server or Snowflake
4) DWH Skills

Nice to have
1) Experience in SAP BO / Crystal report /SSRS/ Power BI
2) Experience in Informix
3) Experience in ETL

Responsibilities

• Technical knowledge regarding best practices of BI development / integration.
• Candidate must understand business processes, be a detailed-oriented person and quickly grasp new concepts.
• Additionally the candidate will have strong presentation, interpersonal, software development and work management skills.
• Strong Advanced SQL programming skills are required
• Proficient in MS Word, Excel, Access, and PowerPoint
• Experience working with one or more BI Reporting tools as Analyst/Developer.
• Knowledge of data mining techniques and procedures and knowing when their use is appropriate
• Ability to present complex information in an understandable and compelling manner.
• Experience converting reports from one reporting tool to another

Mandatory Skills required:

1. Ability to translate business requirements into technical requirements for QlikView

2. Perform detailed analysis of source systems and source system data and model that data in

Qlikview

3. Design, develop, and test QlikView scripts to import data from source systems, data feeds, flat files

to create Qlik marts

4. Proficiency with QlikView Scripting, use of complex QlikView functions,

advanced QlikView Expressions, experience with complex data models and optimization of data

model for query performance to create Qlik Marts

5. Architecture optimization ( includes hardware sizing , security setup , performance tuning )

6. Development of Qlikview/ QlikSense

Informatica PowerCenter (9x ,10.2) : Minimum 2+ years experience

SQL / PLSQL: Understanding of SQL procedure. Able to convert procedures into Informatica mapping.

Good to have- Advantage if you have knowledge of Windows Batch Script.

• 5 to 8 years of hands on experience in automating MS Office applications like Excel, Word, PPT and Outlook using VBA 
• 5 plus years of experience in the design, development, and implementation of programming code
• Experience in database development
• VBA - Should have good experience in developing efficient logic/algorithms using VBA
• Solid understanding of SDLC concepts 
• Solid experience in MS Excel (2003, 2007, 2010, 2013,2016)
• Must be good at all excel features and excel formulas 
• Well versed with complete MS Office package (Excel, Word, Outlook, PPT)
• Work both independently and as part of a team 
• Experience in requirements gathering, effort estimate, designing and implementation and creating mock-up screens 
• Experience in databases like MS SQL Server (2005 to 2012,2014), MySQL and MS Access 
• Must have strong database concepts and DB designing skills 
• SQL - must be good at writing efficient, fine-tuned queries using joins and aggregates 
• Experience in writing Stored procedures, Triggers and T-SQL
• Nice to have programming knowledge in C# 

• VBA, SQL 

• Strong analytical and problem-solving skills 
• Excellent interpersonal and communication skills 
• Should be able to take complete ownership of the project from requirements gathering to delivery and maintenance 
• Should be able to work independently 
• Must be Proactive and Self-motivated
• Must have the ability to prioritize the work, execute tasks and meet the deadline without fail 
• Effective time management skills 
• Customer Focus, Willing to learn and self- teach any new technology 
• Strong business and collaboration skills, and responsive to service needs and operational demands.

Product Support Engineer (L1 Support) – Immediate Requirement.

Key skills

• 1-3 years exp in Product Support Role.
• Need to Understand the product and features, to demonstrate the end users.
• Sound knowledge on Java and SQL
• Need to Analyze and Resolve the Product specific queries, MySQL.
• Consistently Deliver the customer requirements.
• Engage with Development team and manage the progress of cases.
• Should be able to cope up with high pressure work environment.
• Work model will be 24X7.

Must require

• Good Communication both verbal and written
• Analytical skills
• Team player
• Preferred male applicants only