Job Desription

• Strong Knowledge of Oracle database …Key skills : SQL Developments, PL / Sql, Oracle Forms 6i / 10g / 11g / 12c, Oracle Reports 6i / 10g / 11g / 12c, DBA etc.
• Knowledge of SQL Developments (write a sql code, table creation, ddl/dml statements, joins, triggers, set operators, Views, Index).
• Knowledge of PL / SQL (Writing skill of procedure, function, cursors, packages, collection, external table, Trigger, Temporary Table ).
• Design and Develop Oracle forms ( Design master Forms ,transaction Forms, Write a sql, pl/sql code in the form).
• Design and Develop Oracle Reports (Design tabular, matrix, report, Lexical Report, Summary Column, Formula Column, Place Holder).
• Basic knowledge for Data Base administration (DBA).
• Having experience of ERP software (Manufacturing will be plus).
• Performance Tuning.

Skills

Job Desription

• Proficiency in Oracle Forms development, in versions 6i or above. Expertise in different types of Oracle Forms objects, such as:

  a. Object Type: Single DB Block, Multi DB Blocks, Parent-Child Relation, Parent-Child-Child Relations, From Clouse query block etc.

  b. Canvas Types: Content, Stacked, Tab, Horizontal Toolbar, Vertical Toolbar, hierarchical tree, ole container etc.

  c. Visual Attributes: Customizing the appearance of objects using visual attributes.

  d. Object Libraries: Reusable components for application development.

  e. Program Units: Procedures, Functions, Packages for modular code organization.

  f. Triggers : Forms Level, block level , item level.

• Proficiency in PLSQL coding with extensive knowledge of advanced SQL, dynamic SQL, and PLSQL, collections, records, etc.
• Design, implement, and execute performance tuning strategies to improve the responsiveness, scalability, and overall performance of Oracle Forms applications. This may involve optimizing SQL queries, tuning PL/SQL code, and adjusting database configurations.
• Review application code and provide recommendations to development teams on best practices and performance optimization techniques.
• Conduct thorough testing of applications to validate functionality and identify and resolve defects before deployment.
• Monitor and analyze database performance metrics to proactively identify and address potential performance issues.
• Stay up-to-date with industry best practices, emerging technologies, and trends related to database development and PL/SQL programming.
• Provide guidance and mentorship to junior developers and team members

Skills

Job Desription

• Install, configure, and upgrade Oracle database software and related products.
• Design and implement database structures, including tables, indexes, and views.
• Monitor and optimize database performance using tools like Oracle Enterprise Manager (OEM) and AWR reports.
• Perform routine backups, restores, and disaster recovery procedures to ensure data integrity and availability.
• Implement and maintain database security policies, roles, and permissions.
• Troubleshoot and resolve database issues, performance bottlenecks, and connectivity problems.
• Plan and implement database upgrades, patches, and migrations.
• Collaborate with development teams to optimize SQL queries, stored procedures, and application performance.
• Conduct capacity planning and scalability assessments to meet growing business needs.
• Document database configurations, processes, and procedures.
• Provide 24/7 support for critical production databases as part of an on-call rotation.

Skills

Job Desription

• Develop and maintain PL/SQL code: Write, modify, and optimize PL/SQL procedures, functions, triggers, and packages.
• Database Development: Assist in the design and implementation of database structures to support business applications.
• SQL Query Development: Write and maintain complex SQL queries to meet business requirements.
• Performance Optimization: Identify and resolve database performance issues by tuning SQL queries and PL/SQL code.
• Collaborate with teams: Work with business analysts and senior developers to understand system requirements and deliver quality solutions.
• Testing and Debugging: Conduct unit testing and debugging to ensure the accuracy and efficiency of database code.
• Documentation: Maintain technical documentation related to database development and processes.

Skills

Job Desription

• Basics of SQL, PLSql.
• Basics of Oracle forms 6i / 10g / 11g / 12c & Reports 6i / 10g / 11g / 12c.
• Knowledge of PL / SQL (Writing skill of procedure, function, cursors, packages, trigger )
• Knowledge of SQL Developments (write a sql code, table creation, ddl/dml statements, joins, triggers, set operators).
• Having experience of ERP software will be added advantage

Skills

Job Desription

• Design, develop, and maintain Oracle D2k applications (Forms and Reports) to support business requirements.
• Work closely with business analysts, project managers, and end-users to gather and analyze requirements.
• Write and optimize PL/SQL scripts, stored procedures, triggers, and packages.
• Perform debugging, troubleshooting, and performance tuning of Oracle Forms/Reports.
• Develop and maintain technical documentation for all programming activities.
• Collaborate with the QA team to ensure the quality of delivered solutions.
• Provide technical support for existing Oracle applications and troubleshoot issues as they arise.
• Participate in code reviews to ensure adherence to best practices and coding standards.
• Ensure data integrity and security across Oracle databases and applications.
• Stay updated with the latest developments in Oracle technologies and recommend improvements.

Skills

Job Desription

• Design, develop, and maintain Oracle APEX applications based on business requirements.
• Collaborate with business users to gather, analyze, and understand system requirements.
• Write efficient SQL and PL/SQL code to support the application functionality.
• Customize Oracle APEX applications by designing intuitive interfaces using HTML, CSS, and JavaScript.
• Perform troubleshooting, debugging, and resolving technical issues in existing applications.
• Conduct unit testing and assist in user acceptance testing to ensure the quality of the delivered solution.
• Document code, technical designs, and system architecture for future reference.
• Stay current with the latest Oracle APEX technologies and best practices.

Skills

Job Desription

• Manage full life cycle of implmentation
• Develop solution design and lead client throughout implementation and support phases.
• Evaluate customer’s business requirements, needs and objectives and transform same to company processes, solutions and modules being implemented.
• Analyze and solve complex customer issues related to data and processes.
• Ensure seamless transition through customer lifecycle working closely with presales, professional services and support teams.
• Enhance and update knowledge on domain field practices and related technology.
• Documentation & deploying ERP at client place and discuss solutions with clients to limit the requirements for timely completion of projects.
• Develop know-how and expertise in domain field products.
• Perform daily activity reporting against plans and schedules.
• Engage in project coordinating, team leading and implementing ERP functional consultation.
• Experience on Domain knowledge (Manufacturing) will be an added advantage

Skills

Job Desription

• Oversee the Customer Relationship Management (CRM) system, ensuring it is updated and maintained following the marketing team's reporting.
• Implement improvements to the CRM system to enhance efficiency and effectiveness.
• Train and support team members in using the CRM system effectively.
• Develop and execute strategies for generating new business leads.
• Identify potential clients and build relationships to convert leads into business opportunities.
• Utilize various channels such as social media, email campaigns, networking events, and cold calling to generate leads.
• Maintain regular communication with existing leads to nurture and develop potential business opportunities.
• Provide timely responses to inquiries and follow up on leads to move them through the sales pipeline.
• Keep detailed records of lead interactions and status updates in the CRM system.
• Work with potential clients to understand their needs and present suitable solutions.
• Negotiate terms and conditions to close sales and secure contracts.
• Coordinate with internal teams to ensure the smooth delivery of products or services.
• Promote and sell hardware and system software solutions to new and existing clients.
• Stay updated on the latest product offerings and industry trends.
• Provide technical knowledge and support to clients to help them make informed purchasing decisions.
• Prepare detailed proposals and quotations based on client requirements.
• Ensure all offers are accurate, competitive, and submitted within the required timelines.
• Follow up on submitted offers and negotiate terms to close deals.

Skills

Job Desription

• Familiarizing you with all products and services offered by our company.
• Procuring new clients through direct contact, word-of-mouth, and collaboration with the marketing department.
• Attending networking activities to research and connect with prospective clients.
• Maintaining meaningful relationships with existing clients to ensure that they are retained.
• Suggesting upgrades or added products and services that may be of interest to clients.
• Crafting business proposals and contracts to draw in more revenue from clients.
• Negotiating with clients to secure the most attractive prices.
• Equipping staff with the technical and social skills needed to enhance sales.
• Reviewing clients' feedback and implementing necessary changes.
• Remaining in tune with trends in consumption to ensure that our offerings remain relevant.

Skills

Job Desription

• Expertise in Angular framework, Ionic 4+, Angular 7+, Strong proficiency in JavaScript. Good knowledge of HTML, CSS3, Bootstrap.
• Designing and developing user interfaces using Angular 7+ best practices.
• Adapting interface for modern internet applications using the latest front-end technologies.
• Writing JavaScript, TypeScript,CSS, and HTML.
• Developing product analysis tasks.
• Developing application codes and unit tests in Angular 7+,Java Technologies, and Rest Web Services.
• Knowledge of JAVA (Core+Spring Framework) and SQL will be beneficial

Skills

Job Desription

• Designing, Developing and maintaining Business Intelligence Solutions
• Familiarity with BI Technologies
• Proven Experience as a BI Developer or Data Analyst
• Proficiency in Excel and Power BI

Skills

Job Desription

• Bootstrap, HTML5, CSS3, Java script, Coral Draw or Photoshop, Web page designing.
• Application UI designing.
• Illustrating design ideas using storyboards, process flows and sitemap.
• Design graphical user interface elements.
• Develop UI mock-ups and prototypes that clearly illustrate how sites function and look like.
• Prepare and present rough drafts to internal teams
• Adhere to style standards on fonts, colours and images

Skills

Job Desription

• Designing and writing test automation scripts.
• Good Knowledge of Selenium or Jmeter for Load & Performance Testing of Applications.
• Investigating problems in software as a result of testing.
• Can write UAT Test Cases & work as QA Analysts with software developers to find solutions.

Skills

Job Desription

• Create a content plan (based on the concept of content pillars).
• Align older blogs, pages and other gated content to the content pillar plan.
• Build a process to scale the content generation activity.
• Create gated content, both individually and in partnership with Magento, for lead generation.
• Generate videos for audience to consume the content easily.
• Build a marketing database over a period of time using newsletters and forms on website.
• Create a metric plan to study the performance of the blogs and other gated content.

Skills

Job Desription

• Write and optimize SQL queries.
• Develop PLSQL stored procedures, functions, and triggers.
• Perform data analysis and validation.
• Assist in database design and modeling.
• Help with database maintenance tasks like backup and recovery.
• Troubleshoot and debug SQL/PLSQL code.
• Document code and database procedures.
• Collaborate with developers and administrators.
• Stay updated with SQL and PLSQL best practices and technologies.

Skills

Job Desription

• Must have implemented either - Tally / Marg / ERP Munim / Focus or any ERP Software.
• Ensures the technical issues are handled as per the severity and defined standards.
• Closely work with support engineers to foresee the problems are resolved for customers promptly with satisfaction.
• Responsible for delivering solutions as per the defined timeline.
• Work closely with the customer service team / Tech Team regularly to take all required measures to satisfy the customers needs.
• Will be responsible for the daily/weekly meetings with customers as required.
• Would assist the transition process for new implementation accounts in ERP.
• Need to ensure CRM is being updated with required details by the support team.

Skills

Job Desription

• Hands On Experience
• Mentorship
• Skill Development
• Opportunity For Employment Continuation with us

Skills

About the Internship

• HKickstart your career in Digital Marketing with Lighthouse Info Systems Pvt. Ltd. We offer a Free Internship Program where you can learn through Live Projects and gain real-world experience.

What you’ll Gain:

• Master training to become an industry expert.
• Opportunity to build a strong portfolio with real projects.

Key Learning & Responsibilities:

• Website of HTML / Wordpress.
• Content Creation: Develop content and enhance your basics of English writing to attract and engage the target audience.
• Search Eng. Optimization: (SEO of On-page & Off-page) Learn and apply SEO techniques to improve online visibility.
• Video Editing
• Social Media Optimization & Management: Assist in creating and managing social media campaigns.

Who Can Apply?

• Students or fresh graduates looking to build a career in digital marketing.
• Individuals with a passion for social media, content creation, and digital strategies.

Achievements:

• 6 Months Internship Certificate on completion
• Hands-on experience with live projects
• Guidance from industry experts
• Capable to perform as an experience candidate

Job Desription

• Assist in editing and producing engaging video content for social media, websites, and other platforms.
• Trim footage segments and assemble the sequence of the video.
• Add sound effects, music, voice overs, and graphics.
• Collaborate with the marketing and design team to understand project needs.
• Stay updated with new trends in video editing and content creation.
• Help organize and manage video files and media assets.
• Assist in maintaining video standards for quality, style, and branding.
• Ensure all videos meet deadlines and are delivered in the appropriate formats.

Skills