Deputy Manager Oracle EBS-Techno Functional.

Techno-functional BA

GormalOne is a social impact enterprise focused on farmer centric projects. Our vision is to make farming highly profitable for the smallest farmer, thereby ensuring India's “Nutrition security”. Our mission is driven by use of advanced technology. Our technology will be highly user-friendly, for the majority of farmers, who are digitally naive. We are looking for people, who are keen to use their skills to transform farmers' lives. You will join a highly energised and competent team which works on advanced global technologies such as OCR, facial recognition, AI-led disease prediction amongst others.

We are looking for a Techno-functional BA to bridge the gap between IT and business teams. You will be responsible for engaging with business leaders to gather functional requirements and document processes. A BA is then responsible for conveying the functional requirements to developers, helping them determine the technical requirements for the work.

• Should be quick to understand what business does and how it does and determine how to improve existing business processes.
• Identify the steps or tasks to support the implementation of new features & design the new features to implement. 
• Analyse the impact of implementing new features and implement the new features.
• Generation of technical Design Documents and changing them as per the required changes proposed.
• Validating product bug fixing solutions for production issues are raised on daily basis and handing over to the business team after initial testing.
• We are looking for a Techno-Functional analyst, who should be good in technical skills like SQL, PL/SQL, APIs, Report and XML publishers.
• New business requirement analysis to find the GAP and resolution for smooth business operations.
• Able to translate functional requirements into technical specifications and to gather and document development requirements.
• Work with Business Development Teams and business users to resolve customer support issues and Project work you are doing.
• Involve in QA cycle User acceptance testing.
• Training end-users regarding application functionalities.
• Follow the Scrum process, participate in Scrum ceremonies and follow the incremental delivery model

• 1-2 years of relevant experience in a similar role. 
• Proven experience with business and technical requirements analysis, elicitation, modelling, verification, and methodology development.
• Demonstrated understanding of .Net/Java, Relational Databases, and dev stacks.
• Experience in UI/UX best practices and familiarity with Designing tools like Adobe XD etc.
• Excellent analytical, mathematical, and creative problem-solving Logical and efficient, with keen attention to detail.
• Excellent listening, interpersonal, written, and oral communication The ability to communicate with stakeholders and work closely with them to determine acceptable solutions.
• Experience creating detailed reports and giving presentations and competency in Microsoft applications including Word, Excel, PowerPoint, and Outlook.
• Highly self-motivated and able to effectively prioritize and execute tasks while under pressure. 
• Excellent planning, organizational, and time management skills.
• Willing to travel to customer location.

• A bachelor’s degree in engineering CS/IT or related field.
• Knowledge of integrating with Web Services, XML(Extensible Markup Language), and other API(Application Programming Interface) to transfer the data - from source and target, in addition to the database.
• Knowledge in Dairy domain.

#HiringAlert

We are looking " Oracle Forms & Reports Developer " for Reputed Client @ Permanent Role.

Work Experience: 8+ yrs.

Must Have Skills

1.Experience in Oracle Forms and Reports

2. Should be familiar with various triggers, events, canvas, master child forms, record groups, build-ins, properties etc., in Forms and reports.

3.Experience in SQL / PLSQL concepts

4. Experience in writing Procedure / Function / Packages Datatypes, Constraints, index

5.Experience in the user of Cursors / Collections / Exception handlingGood to Have Skills

1.Experience in production support and troubleshooting will be an added advantage.

2. Having exposure to JavaScript and ReactJS will be an added advantage.Key Responsibilities

1.Participate in meetings / discussions for business requirements.

2.Ensuring Documentation and on time delivery of the development works

3.Coordinate with business user for UAT support and resolutions

4.Provide weekly / monthly development and support status report.Professional Attributes

1.Should be able to work independently with minimal supervision.

2.Should be willing to work in EST timing based on project requirements.

3.Communication should be excellent as the position requires direct interaction with business users from the US.

Educational Qualification: B. E, B. TECH, master’s or Any graduation

Location : Chennai

We are looking "Fusion Technical Consultant (OIC)" for Reputed client @ Chennai Permanent Role.

Experience: 7+ Yrs

• Proven experience as a Fusion Technical Consultant with strong expertise in Oracle Integration Cloud (OIC),

• Strong hand on experience generating BI reports (strictly Mandatory)

• Proficiency in Java, PL/SQL, Web Services, and other relevant programming languages.

• Strong problem-solving skills and the ability to troubleshoot complex technical issues independently.

• Prior experience in a customer-facing technical support role is a plus resolving P1/P2 tickets in a close deadline.

• Hands-on experience with Oracle Fusion Middleware technologies, including Oracle SOA Suite, Oracle Service Bus, and ADF. 

• Excellent communication skills, both written and verbal, to effectively interact with clients and team members.

• Oracle certifications in Fusion Middleware and OIC are highly desirable.

Good To Have Skills:

• Good to have functional knowledge of AR, AP, GL,CM, Expense, FA, Procurement side.

Key Responsibilities: 

• Collaborate with clients to understand their technical requirements and challenges related to Oracle Fusion applications and Oracle Integration Cloud (OIC).

• Provide expert-level support and troubleshooting for technical issues, system outages, and integration bottlenecks in a timely and efficient manner.

• Diagnose and resolve complex technical problems related to Fusion applications, OIC integrations, interfaces, and extensions.

• Perform root cause analysis and implement preventive measures to avoid future technical glitches.

• Collaborate with cross-functional teams, including developers, functional consultants, and business analysts, to ensure seamless integration and functionality.

• Develop and maintain technical documentation, including troubleshooting guides, best practices, and solution implementation details.

• Participate in regular status meetings with clients to address support requests, provide updates, and offer recommendations for process improvement.

• Stay updated with the latest releases, patches, and updates related to Oracle Fusion applications and OIC.

Professional Attributes: 

• Flexibility

• Willing to work in shifts

• Willing to learn attitude

Educational Qualification: ANY

AEM including AEM 6.x .

· Strong hands on experience of Components, Templates, Taxonomy, metadata management, Forward and Reverse Replication, Workflows, Content Publishing and unpublishing, Tagging, Analytics, Deployment(Maven) and Content migration/ planning. · Significant hands-on design experience with AEM and very strong concepts of OSGi, Apache Sling, Apache Sightly, Apache Oak and Adobe Dispatcher

· Has worked on and implemented at least one of the popular Search engines with AEM like Solr, ElasticSearch or Lucene and involved in search queries performance tuning.

· Worked on integrations with popular products /Technologies like Salesforce, SSO, LDAP, API Gateways using ReST · Understands and implements the Quality Properties of the system in every day work including Accessibility, SEO, URL management, Security, Performance and Responsive architecture.

· Has implemented Quality Processes for projects like Continuous Integration (Bamboo/Jenkins/Git/BitBucket/Cloud Manager), SonarQube, Code reviews (Manual and Automated), code Formatters, Automation testing etc.

· Understanding of frontend technologies like Bootstrap, Backbone.js, ReactJS, Handlebars, Grunt, Angular, CSS3, HTML 5 and jQuery.

· Mastery of all core web and Java technologies including java 8/11, JEE, XML, XHTML, client/server-side scripting languages such as JavaScript, and JSP, and web services development using Restful implementations.

· Good understanding of AEM capabilities including Multi-site manager and Blueprinting, and the use of Online marketing components such as advanced targeting/personalization, and multi-variate testing, is preferred.

· Proficient knowledge of the end to end content lifecycle, web content management, content publishing/deployment, and delivery processes.

· Familiarity of Cloud native approaches and platforms including AWS, Azure or GCP.

· Familiarity with basics of Adobe I/O Runtime and Adobe I/O Events (preferred)

· Good understanding of integration patterns and content-centric application development patterns using AEM Search, Commerce package or others platforms is preferred. Education:

· Full time Bachelor’s/Master’s degree(Science or Engineering preferred)

• You would be responsible for Developing SQL Databases, automation of business reports and Developing Business Dashboard using BI Tools.
• Development of high quality database solutions 
• Create complex functions, scripts, stored procedures and triggers to support application development.  
• Develop, implement and optimize stored procedures and functions using T-SQL
• Review and interpret ongoing business report requirements
• Build appropriate and useful reporting deliverables
• Analyze existing SQL queries for performance improvements
• Fix any issues related to database performance and provide corrective measures.  
• MIS Automation
• Provide timely scheduled management reporting
• Create Business dashboard using Tableau BI Tool

Requirement / Desired Skills:

• 5+ years of business Analyst / SQL developer experience in Fintech,internet,consulting etc industry
• Excellent understanding of T-SQL programming
• Excellent understanding of Microsoft SQL Server 
• Good knowledge of HTML and JavaScript 
• SQL Server Reporting Services and SQL Server Analysis Services
• Knowledge of any of the BI Tool (Tableau, PowerBI or Qlikview)

• 4-15 year experience in Application Support
• Must have good knowledge in Java/J2EE, Microservices, PL/SQL, Unix
• Good to have knowledge in Agile, JIRA, Splunk, Service Now
• Good understanding and hands-on experience in Incident, Problem and Change Management
• Provide technical leadership to the team & contribute in the skill development within team
  Interact with internal teams and client stakeholders to trouble shoot the tickets/incident and manage other support activities
• Good communications skills are necessary, must be team player and inquisitive.
• Strong customer service and support focus with a desire to deliver a high-quality service
• Ability to multi-task, work under pressure and to tight deadlines
• Flexible in working outside of office business hours at short notice (as required)
• Should be able to examine the system and identify the areas for Service Improvements & Value adds.

About this role

We are seeking a seasoned DBA to join our team. You will have extensive experience in a mission-critical environment as a database administrator over a successful career.  You will primarily work on the Supporting our Databases, AWS RDS (MySQL), and  MongoDB/ Cassandra.

What You’ll Do

• Provide leadership in database scaling & monitoring. Maintain runbooks for our 24x7 SRE team. 
• Assist in troubleshooting and resolution of database issues. Perform database upgrades and patches.
• Define and develop data pipelines between platforms in a mission-critical environment using DMS, Fivetran, Kafka, etc.
• Work with our developers to optimize and tune their SQL queries.
• Assist in application development, debugging, and optimization with respect to data concerns.
• Provide input in the design and implementation of backup, recovery, and DR strategy
• Review application and database design for compliance.

What You’ll Need

• Ability to script in a high-level language like Python, Ruby, etc for Automation. 
• 8+ years of experience in AWS database services like RDS (Mysql), MongoDB/ Cassandra.
• 4+ years of experience in database design and DevOps on AWS.
• Must demonstrate a clear understanding of logical and physical database design and standards. 
• Experience in columnar data warehouse solutions like Redshift or Snowflake. 
• Must have extensive hands-on experience with MySQL in a large scale 24x7 production environment with millions of records.
• Bachelor of Science in Computer Science, Mathematics, or Engineering; or equivalent work experience

Bonus Points If You Have

• Experience with NoSQL solutions such as Cassandra/MongoDB etc.
• Experience with software development life cycle (SDLC) in an agile environment
• Hands-on production experience with Big Data applications such as Spark.
• Knowledge of development best practices (source control with Git, continuous integration, automated testing).