BI Backend Developer

• 10+ years of software development experience
• 3+ years in a technical leadership role
• Strong expertise in Python and SQL
• Experience building scalable APIs and backend systems
• Solid understanding of database design and performance tuning
• Experience with Azure cloud services (AWS familiarity preferred)
• Working knowledge of ML/AI integration in enterprise systems
• Experience in client-facing or consulting environments preferred
• Experience with Databricks or modern data platforms
• Exposure to ETL tools such as Talend
• Experience with BI tools (e.g., Power BI)
• Exposure to regulated domains such as Pharma, Healthcare

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.

Work Details: approx. 3-4 Months of development work and require support for next 3 months.

Job Role:

The selected professional/company will be responsible for:

1. Understanding our software's API structure and Oracle SOA framework.
2. Developing and implementing API integrations to connect our software with the specified Oracle SOA modules.
3. Ensuring seamless functionality and data synchronization between systems.
4. Performing rigorous testing to validate the integrations.
5. Providing ongoing support, troubleshooting, and resolving any issues during and after the integration process.
6. Setup the Development/UAT environment for the Oracle SOA integrations.

Modules to Integrate:

• Purchasing
• Payables
• Supplier
• Inventory
• General Ledger (GL)

Scope of Work:

1. API Integration: Establish seamless integration of APIs between our software and the above-mentioned Oracle SOA modules.
2. Data Flow & Functionality: Ensure smooth data flow and consistent functionality between systems.
3. Support & Troubleshooting: Provide support and resolve any issues arising during the integration process.
4. Relevant Experience: Demonstrate prior experience with Oracle SOA integrations.

We are looking for professionals or organizations capable of delivering on these requirements effectively.

Primary Responsibilities:

• We need strong SQL database development skills using the MS SQL server.
• Strong skill in SQL server integration services (SSIS) for ETL development.
• Strong Experience in full life cycle database development project using SQL server.
• Experience in designing and implementing complex logical and physical data models.
• Exposure to web services & web technologies (Javascript, Jquery, CSS, HTML).
• Knowledge of other high-level languages (PERL, Python) will be an added advantage
• Nice to have SQL certification.

Good to have:

Job Description:

• To resolve the tickets raised as per the defined standards of time, cost, and quality for increased customer satisfaction.

Skills and Experience

• Good SQL & PLSQL knowledge.
• Good Unix basic commands knowledge.
• Good Unix scripting knowledge will be an advantage.
• ANSI SQL
• Unix - Others/
• Experience - Fresher

- 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

Mandatory Requirement/ Preference:

- 4 years of experience for delivering enterprise solutions or products using full SDLC 

- 4 years of work experience with enterprise solutions for Microsoft platform (SQL Server, stored procedures, WCF, C#.net, Entity Framework) 

- Extensive knowledge and experience with creating and maintaining stored procedure in MS SQL Server.

- Working with WEB API added advantage