BI Backend Developer

Requirements:

• 4-6 years of experience in developing Enterprise Web Applications using Java/J2EE technologies with a good professional track record.
• Excellent knowledge in Core Java (J2SE) and J2EE technologies.
• Proficient knowledge in Servlets, JDBC & JSP.
• Good knowledge of Spring framework (MVC, Cloud, Data and Security. Etc) and ORM framework like JPA/Hibernate.
• Strong knowledge of Exception Handling, Collections, File I/O Streams, Interfaces, and logging mechanisms is a must.
• Experience in developing REST APIs and integration of third-party APIs.
• Proficient knowledge in SQL/PLSQL.
• Expertise in application/web server deployment and connection pooling techniques.
• Cloud deployment (AWS & Azure) will be an added advantage.
• Experience in Version Control tools like Git, Bitbucket, etc.
• Experience in data security and protocols is a must.
• Maven and IDE tools experience is a must.
• Multi-threading and serialization techniques knowledge is a must.
• Good understanding of end-to-end software development lifecycle.
• Ability to read and understand requirements and design documents.
• Good Analytical skills and should be self-driven. Good communication with interpersonal skills.
• Open to learning new technologies and domains.
• A good team player and ready to take up new challenges
• Languages: Java(J2SE), J2EE (Servlets, JSPs, JDBC)
• Databases: MySQL, Oracle, SQL Server, PostgreSQL.
• DB Script: SQL and PL/SQL
• Frameworks: Spring, Spring Boot, Jersey, Hibernate and JPA
• OS: Windows, Linux/Unix.
• Cloud Services: AWS and Azure (Good to have)
• Version Control tools: Git, Bitbucket.
• Deployment Servers: Tomcat, JBoss, and Web sphere
• Build Tools: Gradle/Maven

Oracle Apex Developer:

• No. of Position: 3
• Budget: 12 - 16 LPA all inclusive depending on experience bracket
• Work Location – For Mumbai candidate it will be Mahape - Navi Mumbai; candidates from Pan India who are not ready to relocate can permanently WFH.
• Joining Time – Immediate to 45 Days
• US Client – Long term logistics domain project
• Opportunity to work with a team of 20+ Apex experts on the latest Apex technologies in the market
• Onsite opportunity for tenured employees

Experience:

• 5-8 years’ experience in Oracle PL SQL & Oracle Apex; (Majority of Oracle Apex experienced required)
• Preferred Education: B. Tech / B. E - Any Specialization, Computers (OR) BCA (AND/OR) MCA                                 

Core Competencies:

• Experience working on Oracle PL/SQL Programming and DB features
• Proficient in Oracle Apex components is a must
• Experience in Javascript, Jquery and CSS
• Knowledge of Page zero concept, shared components, Page rendering & processing, Interactive reports
• Exposure to DBA activities like Table space management, Export/Import etc.
• Experience in Unix Shell scripting
• Exposure to any reporting tool
• Good communication skills
• Ability to take responsibility and handle pressure 
• Ability to think creatively and solve complex problems 
• Self-motivated, fast learner with the ability to operate independently 
• Team player with strong interpersonal skills and a willingness to help others 
• Ability to thrive in a cross-functional team on business-critical projects 
• Intrinsically cares about the quality of work 
• Organized and focused on delivering tasks within defined deadlines

Specific Responsibilities:

• Would work in design, develop, enhance, test and maintain software applications
• Design and develop SQL scripts, stored procedures, packages, parameterized queries and objects using tools like Toad, SQL Developer, Pl/SQL developer
• Build and maintain Application database schema/objects and account for data migration/upgrades across versions
• Identify and automate routine maintenance tasks
• Optimizing DB queries, stored procedures, Data structures, Indexes and DB Normalization.
• Certify all queries written by software developers to ensure optimal execution of the queries
• Research, investigate and evaluate potential database solutions to business problems/requirements
• Write Test cases for developed queries/functions using PLSQL and Quest code tester.

Job Description:
7+ years of experience as a Techno-Functional specialist supporting a finance organization with an emphasis on project management.

Must have 2-3 Project implementation and more than one support experience in Oracle EBS R12.

Expert level knowledge of Oracle Applications Framework, Oracle Workflow, Oracle Forms, Oracle Report, XML Report, PLSQL

Functional knowledge in financial module like, GL,AP, AR PO, Project is must Extensive use of oracle APIs and interfaces Experience in performance tuning of the code Experience in shell scripting.

Worked on Oracle Alert, AME, OAM ,DFF etc Good to have ADF experience Good to have ORDS experience Good to have exposure in cloud technology.

Responsibilities:
Act as a senior liaison between Business partners and IT communities Facilitate cross-functional teams through business process and application initiatives from requirements definition to prototyping, design, development, testing, training, and deployment.

Create technical designs to support business requirements.

Lead the development of technical solutions. Communicate project status and escalate issues to management. Develop and execute system test plans and scenarios.

Assist in preparing training materials for deployment of applications, modules, enhancements and bug fixes.

Assist in developing baseline datasets and reports to support testing of technical solutions.

• Bachelor's degree required, or higher education level, or foreign equivalent, preferably in area wit
• At least 5 years experience in Duck Creek Data Insights as Technical Architect/Senior Developer.
• Strong Technical knowledge on SQL databases, MSBI.
• Should have strong hands-on knowledge on Duck Creek Insight product, SQL Server/DB level configuration, T-SQL, XSL/XSLT, MSBI etc
• Well versed with Duck Creek Extract Mapper Architecture
• Strong understanding of Data Modelling, Data Warehousing, Data Marts, Business Intelligence with ability to solve business problems
• Strong understanding of ETL and EDW toolsets on the Duck Creek Data Insights
• Strong knowledge on Duck Creek Insight product overall architecture flow, Data hub, Extract mapper etc
• Understanding of data related to business application areas policy, billing, and claims business solutions
• Minimum 4 to 7 year working experience on Duck Creek Insights product
• Strong Technical knowledge on SQL databases, MSBI
• Preferable having experience in Insurance domain
• Preferable experience in Duck Creek Data Insights
• Experience specific to Duck Creek would be an added advantage
• Strong knowledge of database structure systems and data mining
• Excellent organisational and analytical abilities
• Outstanding problem solver

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

• 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

As a Software Engineer at Quince, you'll be responsible for designing and building scalable infrastructure and build applications to solve some very interesting problems in the logistics and finance tech space.

Responsibilities:

• Design and architect solutions on the cloud for various business problems with workflow efficiency and scale in mind.
• Be on the forefront with the business team to learn, understand, identify and translate function requirements into technical opportunities.
• End-to-end ownership - from scoping the requirements to the final delivery of the solution with keen eye to details and quality.
• Build and improve logistics components for this innovative M2C supply-chain model.
• Build and maintain scalable ETL data pipelines.

Requirements:

• Bachelors/Masters/PhD in Computer Science or closely related subject.
• 1-5 years of experience in building software solutions.
• Good at data structures and their practical applications.
• Proficiency in Kotlin, Java, Python.
• Experience in deploying and maintaining applications on cloud platforms (Ex: AWS, Google cloud).
• Proficiency with SQL and databases - relational and/or nosql (Snowflakes, AWS RedShift, etc).
• Experience with messaging middleware such as Kafka is good to have.

Essential duties and responsibilities include the following.

• Design, create and maintain databases through multiple product lifecycle environments, from development to production systems
• Configure and maintain database servers and processes, monitor system health and performance, to ensure high levels of performance, availability, and security.
• Convert complex business requirements into technical specifcations to build scalable and reliable data solutions 
• Apply data modelling techniques to ensure development and implementation support efforts meet integration and performance expectations.
• Independently analyse, solve, and correct issues in real time on production, providing problem resolution end-to-end.
• Refine and automate regular processes, track issues, and document changes.
• Develop complex query, performance tuning, stored procedures and triggers, scheduled jobs, schema refinement.
• Flexibility to work after office hours for any production issue or production deployment.
• Perform scheduled maintenance and support release deployment activities after hours.
• Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.

Qualifications include:

• 4+ years of database and backend development experience
• Good understanding of database systems and architectures
• Expertise in writing complex SQL queries and stored procedures
• Hands on experience with RDBMS and NoSQL data stores like  MySQL and MongoDB
• Experience working with Python scripting and application development
• Experience working with Cloud applications and data stores like AWS RDS is a plus
• In-depth understanding of data management and ETL processes