BI Backend Developer

Job brief 

We are looking for a qualified Database developer to design stable and reliable databases, according to our company’s needs. You will be responsible for developing, testing, improving and maintaining new and existing databases to help users retrieve data effectively.

As part of our IT team, you will work closely with developers to ensure system consistency. You will also collaborate with administrators and clients to provide technical support and identify new requirements. Communication and organization skills are keys for this position, along with a problem-solution attitude.

Ultimately, you should be able to ensure our database systems run effectively and securely on a daily basis.

Responsibilities

• Design stable, reliable and effective databases
• Optimize and maintain legacy systems
• Modify databases according to requests and perform tests
• Solve database usage issues and malfunctions
• Liaise with developers to improve applications and establish best practices
• Gather user requirements and identify new features
• Develop technical and training manuals
• Provide data management support to users
• Ensure all database programs meet company and performance requirements
• Research and suggest new database products, services and protocols

Requirements

• Proven work experience as a Database developer (5+ Years)
• In-depth understanding of data management (e.g. permissions, recovery, security and monitoring)
• Knowledge of software development and user interface web applications
• Advanced proficiency and hands on experience with T-SQL, Stored Procedures, Cursors, Triggers, Schedulers etc.
• Familiarity working with MS SQL Server, MySQL, .Net Framework, java
• Excellent analytical and organization skills
• An ability to understand front-end users’ requirements and a problem-solving attitude
• Ability to craft detailed technical manuals.
• Excellent verbal and written communication skills
• BE/MCA/MSc Degree in Computer Science or relevant field.

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.

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 

.Net Core Developer

Experience 2+ Yrs in .Net Core/C# Responsibilities Responsible for designing and developing REST APIs using .Net Core Framework and C#. Create high-performance REST APIs for financial applications. Qualifications B.Tech/BE or MCA – May be relaxed in the case of experienced candidates.

Experience At least 2+ Years of experience as .Net Core Developer Proficient in .Net Core and C# Excellent knowledge in developing REST APIs and Entity Framework Knowledge and experience in writing SQL, SPs, and Triggers Sound knowledge in MVC frameworks and databases. Good project management skills. Good communications skills A good team player

Salary 2 -8 LPA

RequiredSkills:

• Minimum of 4-6 years of experience in data modeling (including conceptual, logical and physical data models. • 2-3 years of experience inExtraction, Transformation and Loading ETLwork using data migration tools like Talend, Informatica, Datastage, etc. • 4-6 years of experience as a database developerinOracle, MS SQLor another enterprise database with a focus on building data integration process • Candidate should haveanyNoSqltechnology exposure preferably MongoDB. • Experience in processing large data volumes indicated by experience with BigDataplatforms (Teradata, Netezza, Vertica or Cloudera, Hortonworks, SAP HANA, Cassandra, etc.). • Understanding of data warehousing concepts and decision support systems.

• Ability to deal with sensitive and confidential material and adhere to worldwide data security and • Experience writing documentation for design and feature requirements. • Experience developing data-intensive applications on cloud-based architectures and infrastructures such as AWS, Azure etc. • Excellent communication and collaboration skills.

• Basic knowledge of Oracle Forms and reports - (Must)
• Good experience on SQL*Loader.
• Should Knowledge on Agile / Scrum.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Using SQL developer tool we debugged the code and unit test
• Knowledge of oracle programming
• MySQL, Oracle,
• Knowledge of Unix platform
• PostgreSQL
• advance database knowledge.
• Writing PL/SQL and PL/MySQL
• Coding support
• Debugging & Project module management
• Deployment and fine-tuning as per team lead.

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.

- 2+ years experience in application support on Asp.Net and SQL

- Should be able to debug production issues and bug fixes

- Should be able to write queries for extracting data using joins

- Interact with stakeholders and provide regular status updates on call logs to on-site and offshore project co-coordinator

- Provide daily status updates and time-sheets to on-site and offshore project

- Ready to work in shifts

- Knowledge Transfer / Training to stakeholders

- Good communication skills

- Highly committed and able to work independently and as a team

- Positive attitude towards learning

- Deadline orientated and escalate in advance in case of delays 

- Contribute towards improving quality, standardization and documentation for all 

changes & Support activity

- Ability to remain calm in a fast-paced and highly pressure environment