Eligibility
Criteria and Topic for IT Professionals (HARTRON) on Job Work Basis
|
Sr. No. |
Category |
Qualification/Experience |
Topics (For |
Remuneration/ Month(Rs) |
|
1 |
Data Entry Operator |
a) 10+2 (with 50% marks) or Graduation Or Three years Diploma in any stream/BCA/ Or Matric (50% marks) with Two years Or Post Matric One Year ITI Course in
b) Data Punching speed of 9000 key |
1.MS 2.Internet, 3.Windows 4.Networking and (English typing 30 WPM timing 5 minutes)
|
23,400/- |
|
2 |
DTP Operator |
a) 10+2 (with 50% marks) with 1 year
b) One year experience in designing |
1.Corel 2.Dreamweaver 3.Flash 4.FrontPage 5.Photoshop 6.PageMaker 7.Windows 8.Internet, 9.Operating 10.MS |
23,400/- |
|
3 |
Web Designer |
a) Graduate (55%) with PGDCA/ OR BCA/B/Sc/(Comp.Sc/IT)/MCA/ M.Sc. Comp. OR Three Years Diploma in Comp. b) One year Certificate Course in |
1.CorelDraw 2.Dreamweaver 3.Flash 4.FrontPage 5.Photoshop 6.PageMaker 7.Internet, 8.Internet, |
24,100/- |
|
4 |
Junior Programmer |
Graduate (55% marks) with PGDCA/ PDCA/ OR BCA/ B.Sc (Comp.Sc./IT)/ MCA/ OR Three Years Diploma in Comp. |
1.ASP .Net 2.Visual Basic 3.JAVA 4.Programming 5.MS Office 6.Internet, 7.Windows 8.Networking 9.System Analysis & Design 10.Hardware 11.Operating 12.DBMS 13.PHP |
24,100/- |
|
5 |
Programmer |
a) B.E./B.Tech/M.Tech (in any stream)/ OR M.Sc (Phy/Math/Statistics) with 60% b) Having knowledge of Software |
1.Hardware 2 Windows 3.Internet, 4.Oracle 5.Networking 6.System 7.SQL Server 8.Operating 9.DBMS 10.Linux/Unix |
29,500/- |
|
6 |
Networking Assistant |
a) Three Years Diploma in b) One year working experience in *Person having MCP/MSCE/DCNE/ |
1.Hardware 2.Windows 3.Internet, 4.MS Office 5.Networking 6.Operating 7.Linux/Unix 8.Windows |
24,100/- |
|
7 |
Networking Engineer |
a) B.E/B.Tech/M.Tech (in any stream)/ OR M.Sc (Phy/Math/Statistics) with 60% b) Certification in MCSE/CCNA/ c) One year working experience of |
1.Hardware 2Windows 3.Internet, 4.Oracle 5.Networking 6.System 7.SQL Server 8.Operating 9.DBMS 10.Linux/Unix 11.Windows |
29,500/- |
|
8 |
Programmer with 2 years experience |
Qualification as that of Programmer at |
1.Hardware 2Windows Server 3.Internet, 4.Oracle 5.Networking 6.System 7.SQL Server 8.Operating 9.DBMS 10.Linux/Unix |
31,850/- |
|
9 |
System Analyst |
Qualification as that of Programmer at |
1.ASP .Net 2.Visual Basic 3.JAVA 4.Programming 5.Windows 6.Internet, 7.Oracle 8.Networking 9.System 10.SQL Server 11.Operating 12.DBMS 13.Project 14.Linux/Unix 15.PHP |
44,250/- |
|
10 |
Junior Software Developer (ASP.NET/ PHP/JAVA) |
a) B.E./B.Tech/M.Tech (in any OR M.Sc.(Phy/Math/Statistics) with 60% b)Knowledge of Software Development on |
1.ASP .Net/ 2.Programming 3.Internet, 4.System 5.SQL Server 6.DBMS 7.Linux/Unix |
42,000/- |
|
11 |
Software Developer and Mobile (ASP.NET/ PHP/JAVA) |
a) B.E./B.Tech/M.Tech (in any OR M.Sc.(Phy/Math/Statistics) with 60% b)Minimum 5 years of relevant |
1.ASP .Net/ 2.Programming 3.Internet, 4.System 5.SQL Server 6.DBMS 7.Project 8.Linux/Unix |
65,000/- |
SAMPLE PAPER:
Programming Test. Time:90 Min.
——————————————————————————————————-
Category:
Software Developer and Mobile Application Developer/ System Analyst
ABC company records
data relating to insurance agents and customers. Create a database
and GUI to save data relating to the Agents and Customers. The complete details relating
to the policies is to be captured like
policy no., date, customer name, policy amount, commission earned by the Agent. The commission percentage for agent
is fixed different type of schemes
and to be calculated automatically, as per the Scheme selected by the Customer and the
Policy amount.
Show reports regarding detail of Policies
done by agents between two dates and detail of
commission earned by agents.
Sample /Brief Note for Practical Paper of System Analyst
(Networking)
Time: 60 Min
Practical Paper (consisting of Multiple
choice & descriptive questions) is meant
to assess the capability of the candidates in terms of hands on knowledge
on the following:
(i)
Computers Hardware Structure
(ii)
Hardware (Computers, Printers,
UPS, Servers, IT Products etc) maintenance
(iii)
Networking Designing
(iv)
Networking Components
(v)
Network Configuration & Troubleshooting
(i)
The candidate knowledge will be tested
on structural aspects
of Hardware.
a)
Functioning of various
parts of computers
b)
Assembling of Computers
c)
Identification, Installation &
Inspection of Hardware
Components
(ii)
Hardware maintenance issues
like MTBF, product
life identification &
rectification faults,
Operating System Installation & Configuration
(iii) Networking
Designing: – Designing of networks like LAN, WAN etc. both technological aspects and installation of networking components required for the network.
(iv) The identification, installation, inspection and usage of various networking components like type of
switches, routers, UTP/STP/fiber cable, patch panel.
(v)
Network Configuration, Server Configuration, VLANs creation, Troubleshooting of Network, Linux server,
windows server, Router & Switches
SAMPLE PAPER
: Programming Test. Time:90
Min.
——————————————————————————————————-
Category:Junior Software
Developer/Sr.Programmer/Programmer
ABC company records
data relating to insurance agents
and customers. Following
are the type of schemes
available and commission
percentage, schemewise, for agent:
|
Name of |
Commission to Agent |
|
1. A |
2% |
|
2. B |
2.7% |
|
3. C |
3.3% |
1.
Create an application to save data relating to the agents and customers
using the following
database tables:-
a. Agent_Master
|
Field Name |
DataType |
Remarks |
|
Agent_No |
Integer |
Primary Key (AutoNumber) |
|
Agent_Name |
Varchar |
|
b. Scheme_Master
|
Field Name |
DataType |
Remarks |
|
Scheme_no. |
Integer |
Primary Key (AutoNumber) |
|
Scheme_Name |
Varchar |
|
|
Commission |
Decimal |
As per detail |
c. Policy_Details
|
Field Name |
DataType |
Remarks |
|
Policy_No |
Integer |
Primary Key (AutoNumber) |
|
Date1 |
Date |
|
|
Scheme_no. |
Integer |
Foreign Key |
|
Agent_No |
Integer |
Foreign Key |
|
CustomerName |
Varchar |
|
|
Policy Amount |
Integer |
|
|
Commission |
Decimal |
To be calculated automatically from Scheme Master |
2.
Make at least 5 manual entries
in master table Agent_Master and 3 entries
in Scheme_Master.
3.
Create a GUI to save data in Policy_Details table as per the conditions
mentioned above. Use dropdownlist to display Scheme and Agent.
4.
Reports:
a.
The detail ofPolicies done by agents:
|
Agent |
Scheme |
No. |
|
|
|
|
a. The detail
ofcommission earned by agents:
|
Agent |
Commission |
|
|
|
Note: Incorporate proper Checks & Validations.
SAMPLE
PAPER : Programming Test. Time:90 Min.
——————————————————————————————————-
Category: Junior Programmer
1.
Create an application to save data of the insurance agents
and customers of ABC Company
using the following database
tables:-
a.
Agent_Master
|
Field Name |
DataType |
Remarks |
|
Agent_No |
Integer |
Primary Key (AutoNumber) |
|
Agent_Name |
Varchar |
|
d. Policy_Details
|
Field |
DataType |
Remarks |
|
Policy_No |
Integer |
Primary Key (AutoNumber) |
|
Agent_No |
Integer |
Foreign Key |
|
PolicyDate |
Date |
|
|
CustomerName |
Varchar |
|
|
PolicyAmount |
Integer |
|
|
Commission |
Decimal |
To be calculated automatically |
2.
Make at least 5 manual entries in master table Agent_Master.
3.
Create
a GUI to save data in Policy_Details table as per the conditions mentioned
below:- Policy Amount Commission to Agent
<10000 2%
>100002.5%
Use dropdownlist to display Agents.
4.
Display Report as below:
|
Agent |
Policy Date |
Policy Amount |
Commission |
|
|
|
|
|
Note: Incorporate proper Checks
& Validations.
Sample /Brief Note for Practical Paper of Networking Engineer
Time: 60 Min
Practical Paper of Networking Engineer is meant to assess
the capability of the candidates in terms of hands on knowledge on the following:-
(i)
Computers Hardware Structure
(ii)
Networking Designing
(iii)
Networking Components
(iv)
Hardware (Computers, Printers, UPS, Servers, IT Products etc) maintenance
(vi)
The candidate knowledge
will be tested on structural aspects of Hardware.
a)
Functioning of various
parts of computers
b)
Assembling of Computers
c)
Identification, Installation &
Inspection of Hardware
Components
(vii) Networking
Designing: – Designing of networks like LAN, WAN etc. both technological aspects and installation of networking components required for the network.
(iii) The identification, installation, inspection and usage of various networking components like type of
switches, routers, UTP/STP/fiber cable, patch panel.
(iv)
Hardware maintenance issues like MTBF, product life
identification & rectification faults etc.
Sample /Brief Note for practical Paper of Networking Assistant
Time: 60 Min
Practical Paper
of Networking Assistant is meant to assess the capability of the candidates in terms of hands on knowledge on the following:
(i)
Computers Hardware Structure
(ii)
Networking Components
(iii)
Hardware (Computers, Printers, UPS, Servers, IT Products
maintenance etc.)
(i)
The candidate knowledge
will be tested on structural aspects of:
a)
Functioning of various
parts of computers
b)
Assembling of computers
c)
Identification Installation &
Inspection of hardware
components
(ii) The identification, installation, inspection and usage of various networking components like type of switches,
routers, UTP/STP/fiber cable,
patch panel.
(iii)
Hardware maintenance issues
like identification &
rectification faults for Computers,
Printers, UPS systems etc.
SAMPLE PAPER: Practical Test. Time:60 Min.
——————————————————————————————————-
Category: Web Designer
Design a responsive web page template for
World Environment Week with Theme
‘Beat Plastic Pollution’ using graphics, font files, drop shadow and alignment
types.
Images/Logo are provided in a folder which
are to be used in the webpage template.
Use following Links
and Navigations
1.
Governor Message
2.
About Environment
3.
Green Suggestions
4.
World Environment Day
5.
Beat Plastic Pollution
6.
Whom to Contact
7.
CSR
Use the below text for content Page i.e.
open on the above link
The United Nations
designated 5thJune as World Environment Day to highlight the protection and health of the
environment which is a major issue and affects the well-being of people
and economic development throughout the world. The celebration of this day provides us
with an opportunity to broaden the
basis for an enlightened opinion and responsible conduct by individuals, enterprises and communities in preserving and enhancing the environment.
SAMPLE PAPER: Practical Test. Time:60 Min.
——————————————————————————————————-
Category: DTP Operator
Design a logo, invitation card & pamphlet
on behalf of Hartron International Gita Mahotsav 2020 Date 25.12.2020 timing 9.AM , Venue:- Dushera
Ground Sector-5, Panchkula,
Chief Guest :- Sh. Manohar Lal Khattar CM Haryana, Discussions and seminars
by eminent scholars
and Hindu priests
to throw light upon the various facets of the holy book and its perennial influence
on humankind for generations. Stage
play and Gita chanting competitions are held for kids to show their
talents as a way to encourage their interest in reading Gita. leaflets, pamphlets
and books containing the essence of Gita are distributed to the
public.
1.
Design a Logo.
2.
Design Standard Size Template of invitation card with proper invitation text.
3.
Design a pamphlet
with proper invitation text.
4.
Using graphics, leading
percentage, font files, vector fonts, drop shadow,
hyphenation and alignment types.
5.
Organized by:- Invite MD Hartron, District
Administration, North Zone Cultural Centre,
Information and Public Relations Department, Haryana.
6.
Photoshop/Corel Draw.