Seeking for candidates with 5+ yrs of experience in Oracle background using PL SQL.
Responsible for writing PL/SQL Stored procedures, functions, triggers, cursors, views, Indexes, Sequences, collections, bulk binding etc
Responsible in writing complex queries with varied large data sets
Analyse, Design, Code and Debug using Oracle/PL SQL
Good in PL SQL concepts like Oracle Packages, stored procedures, functions, triggers, cursors, views, Indexes, Sequences, collections, bulk binding etc.
Ability to write efficient, complex queries against very large data sets using SQL Developer and TOAD
Expertise in pl/sql concepts- Oracle Packages, stored procedures, functions, triggers, cursors, views, Indexes, Sequences, collections, bulk binding etc
Experience in performance tuning - Strong analytical, design and debugging skills

About Careator Technologies Pvt Ltd
About
Careator Technology is an end-to-end service provider for all your Application Development, Recruitment, and Staffing related requirements. Our primary competitive advantage is our ability to provide customized solutions that cover the whole process from beginning to finish. Careator maintains a broad variety of productive partnerships with organizations of the highest tier, and the firm ensures that each of its commercial associates is provided with an effective solution.
The founders of Careator understand that the combination of people and technology is essential to the success of a business. The company places a high premium on its employees and their relationships. This is reflected in the way that it creates its operational and strategic models, how it responds to consumers, how it connects with people, and how it promotes diversity in the workplace and the community.
Connect with the team
Similar jobs


Developer Requirements/Expectations:
- Experience: 5+ Years
- Tech Stack: Core PHP, MySQL, Basic JavaScript, Oracle
- 3rd Party Integration: Payment Gateways (Apple Pay Wallet, Google Pay, Stripe)
- Tools: Trello, Slack, Github
- Soft Skills: Team Work, Excellent Client Communication.
Engagement Type: Full Time, Dedicated
- Work Hours: 8 Hours per day, 160 hours per month
- Shift: 10 AM-7 AM IST (Including Lunch hour)
- Work shifts need to be flexible to accommodate client calls in EST.
Screening Process:
Round 1: Technical
Round 2: Managerial
Location: Ahmedabad (Hybrid)
- Position: Appian Tech Lead
- Job Description:
- Extensive experience in Appian BPM application development
- Knowledge of Appian architecture and its objects best practices
- Participate in analysis, design, and new development of Appian based applications
- Mandatory Team leadership and provide technical leadership to Scrum teams Certification Mandatory- L1, L2 or L3
- Must be able to multi-task, work in a fast-paced environment and ability to resolve problems faced by team
- Build applications: interfaces, process flows, expressions, data types, sites, integrations,
- Proficient with SQL queries and with accessing data present in DB tables and views
- Experience in Analysis, Designing process models, Records, Reports, SAIL, forms, gateways, smart services, integration services and web services
- Experience working with different Appian Object types, query rules, constant rules and expression rules
Qualifications:
- At least 6 years of experience in Implementing BPM solutions using Appian 19.x or higher
- Over 8 years in Implementing IT solutions using BPM or integration technologies
- Experience in Scrum/Agile methodologies with Enterprise level application development projects
- Good understanding of database concepts and strong working knowledge any one of the major databases e g Oracle SQL Server MySQL
Additional Information Skills Required
- Appian BPM application development on version 19.x or higher
- Experience of integrations using web services e g XML REST WSDL SOAP API JDBC JMS
- Good leadership skills and the ability to lead a team of software engineers technically
- Experience working in Agile Scrum teams
- Good Communication skills
Job Description
Build and maintain bots on Azure platform. Integration with Active directory, WEB API based integration with external systems. Training and Integrate bots as per users’ requirements. Work in line with design guidelines, best practices and standards of bot deliverable. Creative approach to the conversation flow design, human aspects in the bot responses and sentiments
Qualifications
- a) 5 years of experience in software development with clear understanding of the project life cycle
b) Min 2-3 years of hands-on experience in Microsoft Azure Bot Framework, LUIS and other Cognitive services offered by Azure
c) Hands on experience with Machine Learning based chat bots
d) Experience with Azure bot services like Text Analytics etc.
e)Strong database skills and hands-on experience on databases like SQL Server/Oracle - f) Strong experience on Azure Active directory and adaptive cards integration in Chat bot.
- g) Strong experience designing and working with
with service-oriented architectures (SOA) and WebAPIs.
- h) A strong experience on Microsoft Azure, ASPNET / MVC and programming languages such as C#/VBNET
- i) Knowledge of Python and NodeJS is a plus
- j) Ability to design and optimize SQL Server 2008 stored procedures.
- k) Experience with JQuery, CSS3, HTML5 or similar technologies.
- l) Ability to adapt quickly to an existing, complex environment.
Job Profile
Purpose of Role: To support and maintain the existing and future applications managed by ABD (Agile Business Development) Team.
Main Responsibilities:
- To work on existing and future applications as required
- Work with ABD India Application Support and Business Support team to address production issues and/or to do development work
- Work with US ABD team to coordinate the on-going support and monthly release of C-Hub (Customer-Hub) application and other ABD Applications
- Report status to management on project progress
- Identify and escalate related issues and risks
- Coordinate with others in Development and Business Support team to implement new features of SQL Server/ MS Web based technologies
- Assess current modules and offer performance improvements techniques
- Make sure Database Design Standards/coding standards established by ABD are followed
- Constant communication with ABD leadership team in US.
- Problem Solving ability with “Can-do” attitude
- IT experience in Banking industry is preferred
Candidate Profile:
- Minimum 10 years of experience at least 3-5 years of experience in Corporate & Investment Banking area and Bachelor's degree in Engineering, Accounting, Finance, or equivalent
- Expertise with MS SQL Server development including SSIS and SSRS, Proficient in development of Stored procedure, Views, Functions etc in MS SQL Server
- Experienced with DBA kind tasks such as replication, linked server, query analyzer, DBCC commands, data transfer from one DB server to other DB Server etc
- Experienced in MS Excel VBA and macro scripting
- Knowledge of data Encryption in database
Job Description for Drools developer -
- Hands on experience in design and development in Drools rule engine (minimum 1.5 years) and Core Java
- Exceptional ability to communicate with both technical and non-technical people
- Expertise in object oriented programming
- Experience in Deploying and supporting core and advanced features
- Good exposure to SQL and/or Oracle/ MySQL,
- Candidate should be well verse with Agile processes
- Strong ability to work collaboratively across diverse groups of business and technical stakeholders is required.

- Develop high performance, reusable, and reliable DOT net and PL/SQL code.
- Create interface services in Dot Net.
- Ensure the best possible performance and quality of the application
- Help maintain code quality, organization, and automatization
- To set and maintain coding standards.
- Able to mentor junior developers to use new coding techniques.
- Should be process-oriented.
Skills:
-Programming experience on the .NET platform in MVC framework with C# language, creating Web
applications, Web APIs, Windows Service, with good PL/SQL experience.
- PL/SQL in SQL Server/ Oracle
- Skills in HTML, C#, MVC 4, JavaScript, JQuery, AJAX, TFS, IIS
- Visual Studio 2012
- Team player with good communication skills



