US IT STAFFING/RECRUITMENT (Everything You Need To Know)
Recruitment refers to the process of Sourcing, Screening, And Selecting People for a Job or Vacancy Within / For an Organization. The Process of finding candidates for a job or function, usually undertaken by the recruiters.
US IT Recruiting:
US IT Recruitment is the Selection process of Consultant (Candidate) for the US Companies or clients from the hometown/States
Staffing Company
a. Recruiters in the staffing company work on lower base salaries and huge incentives. They therefore work long hours to make lots of money through incentives.
b. Staffing companies make money through placing candidates with their end customers and are focused on closing the deal
c. Staffing companies have revenue and placement targets
d. Staffing companies often compete with a multitude of other agencies to close open positions
e. Staffing company recruiters may have limited access to hiring managers and may not get enough feedback
f. Staffing company recruiters need to find the best candidate first to beat competition. Speed of submittal is very important.
Corporate recruiter Department
Corporate recruiter get a better base salary and little or no incentives. They usually work only standard 9 to 5 business hours and make less total money.
Corporate recruiting departments want to hire great employees for their employer and are also concerned about issues such as not damaging their brand.
Corporate recruiting departments have targets to fill open positions on or before deadlines.
Corporate recruiters don’t have competition for filling open positions, but they may manage a multitude of staffing agencies
Corporate recruiters may have a better access to hiring managers, Corporate recruiters do not have competition. However, they may have deadlines for filling the positions.
Elements of the Staffing Industry:
End Customer:
End customer is the final recruiter(i.e. hiring company) and it is the one who creates the job requirement as per the need of the resource.
The Hiring Manager
The Hiring Manager is an employee of the end customer, and he is the first person to identify the need to hire more staff.
He is the decision maker in hiring a candidate. At times the Hiring Manager can be someone from Senior Level Management like Vice President or Head of Operational Department depending on the seniority of the open position.
Corporate Recruitment:
This is the in-house recruitment department of the End Customer. Corporate Recruiters work on requirements to get suitable candidates to fill their positions.
Corporate recruiters are also responsible for the hiring process such as rolling out offers, salary negotiation, background checks, drug tests and reference checks before the candidate starts with the project i.e. joins the company.
Account Manager:
The Account Manager works with the staffing company and is responsible for management of sales and relationship with the End Customers.
In staffing industries, account managers play a vital role. They are responsible for closing a sale
(convince the End Customer to work with the company) by using different sales techniques.
Staffing Companies are divided into 2 parts:
Vendor:
Vendor are organizations, often companies or corporations, which sell staffing solutions. This means that they recruit individuals to fill positions opened by their corporate clients, such as Fortune 500 companies.
VMS stands for Vendor Management System.
End customers post job orders on VMS portals.
Agencies receive job orders and submit candidates through the VMS portal.
VMS is a computer program that sends job requirements to the MSP and staffing agencies.
Implementation Partner:
It is a mediator Company between client and 3rd party Vendors. It takes full responsibility of the client project.
A Managed Service Provider (MSP) in the staffing industry refers to an outsourced agency that manages the contingent worker (temporary staffing) program of a client company.
Typically, MSPs are found at large Fortune 1000 companies like Apple, Coca-Cola, Microsoft or Citibank who might have thousands of contractors and hundreds of staffing agencies to manage.
MSP or Managed Service Providers are outsourced providers who oversee and manage temp staffing requisition. Their job is to receive the requirements and then hire from the preferred staffing agencies (vendors).
Example for VMS and MSP: Vendor Management Systems (VMS):
Econometrix
Acceleration VMS
Beeline
Wand
Fieldglass
IQ Navigator (IQN)
Managed Service Provider (MSPs):
Allegis Global Solutions (AGS)
Agile-1
Bartech
Pontoon
ZeroChaos
Workforce Logic
KellyOCG
Randstad Sourceright
TAPFIN
GRI (Geometric Results, Inc.)
The key responsibilities of a sourcer:
Finding passive candidates.
Understanding the future employment needs of the company.
Creating interest in the company as an employer.
Making first contact with potential candidates.
Networking.
Paying close attention to diversity goals.
Ensuring that unconscious bias is removed from the selection process.
And if we’re honest, those are just the key responsibilities. A good sourcing consultant will have a million and one other small tasks to add to this list.
Key responsibilities of a recruiter:
Screening sourced candidates.
Arranging interview times.
Liaising with the hiring manager.
Communicating job details to potential candidates.
Carrying out negotiations (talking about salary, benefits, etc.).
Nurturing candidates in the pipeline.
Managing CRM and ATS software.
Posting jobs on boards.
Publishing ads on social media.
Creating employer brand-focused content.
Steps involved in Recruitment
Assignment of Requirement to Recruiter by Accounts Manager/Team Lead, Requirement Understanding.
Sourcing Resumes through Portals, linked in, Mass Mailing and other sources.
Screening candidates over phone, Getting Updated Resume.
Account Manager Consults the candidate for further Clarifications, if required.
Submitting resume to the client.
Client provides feedback / interview request.
Recruiter arranges the interview and confirms it with the client (INCLUDED- DOCUMENTATION).
Closure/PO (Purchase Order).
Requirement Understanding.
Understanding a Requirement is the key to find the right talent for the right job at the right time.
When looking at the requirement, you should look for the following skills and attributes.
Location
Duration
Rate / Salary
Primary and Secondary Skills
Job description
Roles and Responsibilities
Client / End Client
Screening the candidate over the call
Phone screening the candidate is the most critical step in identifying and hiring the candidate for the given requirement. While hiring the Candidate, Recruiter generally following Steps.
Greets the candidate on opening of the call and introduces himself and his Staffing Company.
Seeks the permission from candidate to speak about the position.
Gives the Details about the position (Title, Location, Client, Duration, and nature of the Job) and discusses the Candidate’s Experience to qualify the resume of assigned requirement.
Negotiating Pay Rate / Salary Range and Summarizes the details for the call to confirm the Candidate’s interest
Closes the call and sends him the RTR / Rate confirmation to the candidate for the assigned Position.
Q. What kind of ATS and Job Boards does your current organization use?
Ans. ATS — Sales Force, Bullhorn, Zoho.
JOB PORTAL — Monster, JOB DIVA, DICE and LinkedIn, INDEED
COAST
East Coast:
Maine, New Hampshire, Massachusetts,
Rhode Island, Connecticut, New York, New Jersey, Delaware, Maryland, Virginia, North Carolina, South Carolina, Georgia, and Florida.
West Coast:
California, Oregon, Washington, Alaska, and Hawaii
DATE FORMAT
India — DD/MM/YYYY
10th Jan 2021- 10/01/2021
USA — MM/DD/YYYY
Jan 10th 2021- 01/10/2021
Location Hierarchy:
USA has 50 states.
States are divided into counties.
A county may have several cities and zip codes On an average, each state has 62 counties are used in 48 states.
Louisiana is divided into parishes and Alaska into boroughs.
Daylight Savings Time (DST)
Every spring, the clocks in the U.S. move forward by one hour.
Daylight saving time in the US begins at 2.00 AM local time on the second Sunday in March and ends at 2.00 AM local time on the first Sunday in November.
DST is not observed in Arizona and Hawaii.
Calculation of Time Difference:
To convert Indian time to Eastern Standard Time (EST), add one and a half hours and convert PM to AM
For daylight saving, add two and half hours to Indian time to get EDT (Eastern Daylight saving Time)
Example: If it is 5.30 PM IST, it will be 7.00 AM EST
For CST subtract one from EST; for CDT subtract one from EDT For MST subtract two from EST; for MDT subtract two from EDT For PST subtract three from EST; for PDT subtract three from EDT
General Information:
Normal working hours in the US are from 8.00 AM to 5.00 PM or 9.00 AM to
6.00 PM. The best time to call candidates is early morning or after work hours.
The commute rush hour is between 8.00 AM and 9.00 AM and in the evening it is between 6.00 PM to 7.00 PM.
Time for commute on MapQuest can be misleading. In big cities, commute takes longer during rush hours.
Most candidates may not be willing to relocate on their own expense or on company’s expense. The big problem with relocating is that houses in the US are very expensive, and it is difficult to buy and sell a house in the US. Business on the west coast may start earlier if they have branch offices on the east coast as well.
US VISA
Objective:
TO UNDERSTAND THE US WORK AUTHORIZATION TYPES AND POLICIES
Immigrants
People who have immigrated to the United States
Non- Immigrants
Temporary visitors to the country. Example: tourists, businessmen, temporary work or study
SPONSORSHIP
This applies to the non-immigrant visa type. A non-immigrant can work in the United States provided a US based company sponsors their work permit.
WORK PERMIT
Work permit is a legal document that authorizes a person to work in a country where they do not hold citizenship.
US CITIZEN
There are two ways of acquiring US citizenship:
Birth within the US
Naturalization
A US Citizen can work for any employer
GREEN CARD HOLDER
A Green Card Holder is a lawful permanent resident who is authorized to live and work in the US on a permanent basis.
Permanent residents working in the US on an immigrant visa DO NOT require a sponsorship.
To be eligible for permanent residency, individuals need to spend six plus years in the country.
Naturalization
Naturalization is the acquisition of citizenship or nationality by somebody who was not a citizen or national of that country when he or she was born.
To become a naturalized citizen one must be at least 18 years of age and must be a legal permanent resident for 5 years minus 90 days before they apply.
A citizenship test and Interview has to be cleared for getting a US citizen status as well.
One has been a permanent resident for at least 5 years and meets all other eligibility requirements.
One has been a permanent resident for 3 years or more and meets all eligibility requirements to file as the spouse of a U.S. citizen.
One who has qualifying service in the U.S. armed forces and meets all other eligibility requirements.
A child may qualify for naturalization if the child was born outside the
U.S. and/or is currently residing outside the U.S., and all other eligibility requirements are met.
Types of Visas
E3 VISA
Applicable only for citizens of Australia They do not need sponsorship
The E3 status may be renewed indefinitely in two-year increments
E3 visa holders work in a specialty occupation that requires a Bachelor’s degree or equivalent
They cannot stay in the US if unemployed
The H-1B
It is a non-immigrant visa in the United States under the Immigration and Nationality Act, section 101(a)(17)(H). It allows U.S. employers to temporarily employ foreign workers in specialty occupations. If a foreign worker in H-1B status quits or is dismissed from the sponsoring employer, the worker must either apply for and be granted a change of status to another non-immigrant status, find another employer (subject to application for adjustment of status and/or change of visa), or leave the United States.
The H1B Visa enables US Employers to Hire Foreign professionals for a specified period of time
Visa Validity: 3 Years (It can be extended for 1 to 3 Years)
Number of H1B Visa issued each year is 65,000 for Graduate and 20,000 for Post graduate. If it extends, the candidate will be selected in a lottery basis.
Visa — but they cannot work unless they obtain their own work visa. The candidate can apply H1B visa on April 1st Week.
He/she can get the visa only at the month of April to October
H1B is a dual intent visa allowing the holder to apply for a Green Card.
B-1/B-2 Visas
Visitor visas are non-immigrant visas for persons who want to enter the United States temporarily for business (visa category B-1), tourism, pleasure or visiting (visa category B-2), or a combination of both purposes(B-1/B-2)
F1 Visas
F1 Visa is for Study purpose, who wants to Study in us they can apply for F1 visa, they can work 20 Hours in a Week.
E3 Visas
The E3 visa classification currently applies only to nationals of Australia as well as their spouses and children. E3 principal applicants must be going to the United States solely to work in a specialty occupation. The spouse and children need not be Australian citizens.
TN Visas
The non-immigrant NAFTA Professional (TN) visa allows citizens of Canada and Mexico, as NAFTA professionals, to work in the United States in prearranged business activities for U.S. or foreign employers.
Permanent residents of Canada and Mexico are not able to apply for TN visas to work as NAFTA professionals.
PS: North American Free Trade Agreement (NAFTA) established a free-trade zone in North America; it was signed in 1992 by Canada, Mexico, and the United States and took effect on Jan. 1, 1994.The goal of NAFTA is to eliminate all tariff and non-tariff barriers of trade and investment between the United States, Canada and Mexico.
L1 Visas -
Intracompany Transferee.
The L-1 visa facilitates the temporary transfer of foreign worker in the managerial, executive or specialized knowledge category to the U.S. to continue employment with an office of the same employer, its parent, branch, subsidiary or affiliate.
EAD — (Employment Authorization Document)
EAD is NOT A VISA!
When a non-immigrant applies for a Green Card, they are an issued an EAD which is a temporary document before they get their Green Card.
It is a document which allows non-immigrants to work for any employer in the US
There are various types of EAD such as: OPT-EAD
GC-EAD L2 EAD H4 EAD
E-3D EAD
EOPT and CPT Visas
OPT stands for Optional Practical Training
OPT is a temporary authorization offered to students on F-1 visa to work in their related field for a period of twelve months.
In order to receive OPT authorization, students do not require any employment or job offer.
Students on OPT can work with any employer across the U.S. if their OPT jobs are related to their field of study.
CPT stands for Curricular Practical Training
CPT is a temporary work authorization provided to the students on F-1 visa, which is directly related to their majors for the period of twelve months.
While applying for CPT, students require a job or employment offer.
Students on CPT can work only with employers those are on the Student and Exchange Visitor Information System (SEVIS).
CPT
Curricular Practical Training (CPT) is temporary employment authorization for F-1 visa non-immigrant foreign students in the United States while enrolled in a college-level degree program.
Can work for 20 hours or more.
OPT EAD
Optional Practical Training (OPT) is a program that temporarily allows international students with an F-1 visa in the United States to work up to 12 months in relation to their major of study. F-1 visa students are eligible for OPT after completing their first academic year. OPT can be completed both before or after completing your studies, but it’s important to remember that you are only allowed to work 12 months total.
An extension of 24 months is allowed to who have completed degrees in certain
science, technology,
engineering and mathematics (STEM)
GC EAD
When individuals contemplate immigrating to the United States, their first thought usually sways towards a green card. … Employment Authorization Documents (EAD) are granted when an individual has a pending Immigration Petition for Permanent Residence or I-485.
L2 EAD
L2 Visa for Dependents. (L1)
Spouse (legally married husband or wife) and unmarried minor children (under the age of 21 years) are eligible to accompany the L-1 visa holder on
L-2 visa. As L-2 visa is a dependent visa, the duration of valid stay is the same as that of the L-1 visa holder.
Identification of a Candidate’s Work Permit
If a non-American candidate has worked in the U.S. for more than eight years, they may be a Green Card Holder.
If a non-American candidate has worked in the US for more than twelve years, they may be a US citizen.
A non-American candidate who has worked on contract positions all over the U.S. is highly likely to be H1-B visa holders.
Non-American candidates that completed their graduation in the US are highly likely to hold an OPT-EAD.
Recruiter must confirm the work permit with the candidate. However, you cannot directly ask about the work permit to the candidate since it is considered discriminatory and illegal in the U.S.
US TAX TERMS
W2 — Candidates who are on the Payroll of the employer
1099 — One of the contracting job types where employee can directly work with the clients/vendors without being on their payroll/w2, and will manage their taxes by themselves. Only USC/GC are eligible
C2C — (Corp to Corp)
Corp to Corp (Corporation to Corporation) this is also called C2C. This is totally a contract job opportunity. It means our candidate who is basically our employee (he is on our pay roll or on our W2) will work through the vendors for their End Clients. So there will be below possible chain in such process
Candidate (John) => Bench Sales Company (Tanisha Systems) => Preferred or Tier-1 Vendor (Uncodemy) => End Client (Google)
Candidate (John) => Bench Sales Company (Tanisha Systems) => Preferred or Tier-1 Vendor (Uncodemy) => Implementation Partner(Wipro)=> End Client (Google)
US EDUCATION SYSTEM
All US citizens have the right to a free public education from kindergarten (usually age five) through grade 12 (usually age 18) of high school.
Attending school is mandatory from kindergarten through ages 14 to 18 depending on the state they are located in.
Children are divided by age groups into grades. The term “grade” is equivalent to the term “standard” in India. For example: in India we say “first standard”, whereas in the US they would say “first grade”
Public education is divided into three levels:
Elementary School (usually kindergarten through grade 5). In India first to fourth standard is usually called primary school
Middle School (sometimes called junior high, usually grades 6 through 8)
High School (sometimes referred to as secondary education; usually grades 9 through 12)
Undergraduate Degrees: Known as Bachelor’s degrees
The most common structure consists of four years of study leading to a Bachelor of Arts (BA) or a Bachelor of Science (BS) degree in various fields of study
In India we usually refer to the bachelor’s degree as a graduate degree
Graduate Degrees:
These degrees are completed as graduate study after earning a Bachelor’s degree Graduate degrees include Masters and Doctorate (PhD) degrees
Degrees in law and medicine in the US are not offered at the undergraduate level In India we usually refer to the Master’s degree as a post-graduate degree
Associates Degrees:
Associate degrees are usually two year courses and include Associates of Arts (AA) and Associates of Science (AS)
After getting an Associate’s degree one may directly get into the junior year of the undergraduate program to get a Bachelor’s Degree
This degree is equivalent to a diploma course in India
Grading System
In US, most educational institutions calculate a student’s Grade Point Average (GPA) by assigning each letter grade a number and using a mathematical formula come up with a numerical representation of a student’s work.
The GPA can be used by potential employers or educational institutions to assess and compare applicants.
How Does a Job Board Work?
Job boards contain a huge database of candidate information.
When you enter a keyword, the search engine within the job board looks through all the resumes or information in their database.
The system checks to see if the keyword entered is present on resumes or candidate information.
The search engine only shows you those resumes that match the keyword.
Identifying Keywords and Finding Alternatives:
Keywords are not limited only to the technical skills; you can also use the company name, industry, job title, and sometimes the job responsibilities to form effective keywords.
You can pick up keywords from resumes — search on job portals or LinkedIn for resumes with similar job descriptions or candidates working with the end customer on the same or similar position.
To make sure that you do not miss out on good candidates you must think from the candidate’s perspective. Think of all the ways that a candidate may write a particular term on his/her resume, and do not just focus on the words used in the job description.
Research the terms you are not familiar with — use resources like Google and Wikipedia to find information about the search terms (keywords).
Use the OneLook Reverse Dictionary and similar tools to find synonyms/alternatives for all the keywords — always use good alternatives in your search strings to increase the scope of your results.
Take help from your colleagues after you have covered all other resources.
Tips to Build Effective Search Strings:
What should a recruiter or sourcer do to find the best available candidate first? — Find candidates with all the required and desired skills!
The likelihood of finding candidates with all the required as well as desired skills is low. A search string that has a lot of constraints is a narrow string. A narrow string will have many ‘AND’ operators.
If you do not find good candidates what should you do?
Broaden the string by reducing the constraints or adding more alternatives
The less complicated your search string is the better results you get. Keep it short and simple (KISS).
Some job boards and search engines do not accept search strings with more than 10 keywords
The less complicated your search string is the better results you get. Follow the KISS principle — Keep It Short and Simple.
Fundamentals of Leaving a Voicemail:
Crisp & Clear/Concise/Scripted Should get you a call back Should contain:
Name Organization
Why are you calling
Why he/she should call you back Your number/email
Voice mail Greeting
Technical IT Part
In this IT Part we explain all the Technologies for complete & deep understanding of the Technical Requirements, It will make easy for recruiter to work on multiple requirement for multiple profile.
Technologies
Front End technologies Back End technologies Full Stack technologies.
Application / Software Developer/Architect
Person who is responsible to developing the application / Software using any technologies called Application / Software Developer. It’s divided into four part / profile.
Front End technologies. Back End technologies. Full Stack technologies. Software Architect.
Front End Technologies
Person who can work on front end of Application / Software using any front end technologies. It can be Web Developer
Java front end Developer
.Net Front End Developer Web Designer.
Android Front End Developer IOS Front end Developer Salesforce Front End Developer
HTML
Angular.js
CSS
React.js
Applets
XML
Bootstrap
Node.JS
JavaScript
Jquery
AJAX
Java
Java is an Object Oriented platform independent Programming Language used for developing the Standalone application which is known as Desktop application or window application, Web application, Enterprise application, Mobile application, Game application, Embedded System, Robotics etc.
Types of Java
J2SE (Java 2 Standard Edition)
Core Java :- (Array, Abstraction, Encapsulation, Collection, Multithreading, Exception Handling). JDBC (Java Database Connectivity)
J2EE (Java 2 Enterprise Edition)
Servlets
JSP (Java Server Page)
Hibernate Framework
Struts
Spring MVC
Spring Web services
JSTL (Java Server Tag Library)
Front End Java Developer (Skill Set)
JSP
JavaScript
Struts
Angular.js
JSTL
React.js
HTML
XML
CSS
Node.JS
Applets
Jquery
Bootstrap
AJAX
Java Back End Developer (Skill Set)
Servlets
Web Server (Apache Tomcat, Jboss, Weblogic). Database (MySQL, NoSQL) Oracle,
JSP
JSTL
Struts (Framework)
EJB (Enterprise Java Bean)
JDBC
Spring (Framework)
JDK (Java Development Kit)
Hibernate (Framework)
API
JSF (Framework)
Java Full Stack Developer (Skill Set)
JSP
Servlets
Struts (Framework)
JSP
JSTL
JDBC
HTML
Spring (Framework)
CSS
Hibernate (Framework)
Applets
API
Bootstrap
Web Server (Apache Tomcat, Jboss, Weblogic).
JavaScript
Database (MySQL, Oracle, NoSQL)
Angular.js
JSTL
React.js
XML
EJB (Enterprise JavaBean)
Node.JS
JDK (Java DevelopmentKit)
Jquery
AJAX
.Net / Dot Net (Skill Set)
NET is a framework which is used to develop software applications. It is designed and developed by Microsoft.
ASP.net ADO.net C#(Sharp) VB.net
WCF(Window Communication Foundation) WPF (Window Presentation Foundation) LINQ (Language Integrated Query)
FCL (Framework Class Library) WinForms (Window Forms) WF (Workflow Foundation)
Net front End Developer (Skill Set)
HTML
VB.net
JavaScript
WPF
XML
ASP.net
AJAX
Angular.js
CSS
React.js
Bootstrap
Node.JS
Jquery
.Net Backend Developer (Skill Set)
ASP.net
C#(Sharp)
ADO.net
LINQ (Language Integrated Query)
WCF(Window Communication Foundation)
FCL (Framework Class Library)
WPF (Window Presentation Foundation)
WF (Workflow Foundation)
.Net Full Stack Developer (Skill Set)
ASP.net
HTML
ADO.net
JavaScript
WCF(Window Communication Foundation)
XML
WPF (Window Presentation Foundation)
AJAX
#(Sharp)
CSS
LINQ (Language Integrated Query)
Bootstrap
FCL (Framework Class Library)
VB.net
WF (Workflow Foundation)
Angular.js
React.js
Node.JS
Jquery
Software Tester
Testing is a process, to evaluate the functionality of a software application to find whether the developed software met the specified requirements or not and to identify the defects to ensure that the product is defect free or not.
Types of Tester / Testing:
Manual Tester / Testing
Manual Testing is a type of Software Testing where Testers manually execute test cases without using any automation tools.
Automation Tester / Testing
Automation test is a Software testing technique achieved by using any automation testing tool.
Manual Testing skill set
Black Box Testing
White Box Testing
Grey Box Testing.
Unit Testing
System Testing
Integration Testing
Acceptance Testing
Automation Testing skill set
Selenium
HP QTP(Quick Test Professional)
Robotium
TestDrive
Jira
cucumber
LoadRunner
QTP
TestNG
SoapUI
WinRunner
WATIR
Jenkins
Maven
Business System Analyst
A business systems analyst is a type of computer systems analyst who specifically works with the computer technology required at a business. Business systems analysts determine which technological upgrades and installations will improve efficiency in the workplace.
Project Manager
A project manager is a person who has the overall responsibility for the successful initiation, planning, design, execution, monitoring, controlling and closure of a project.
Types:-
Architectural Project Manager
Engineering Project Manager
IT Project Manager
Software Project Manager
IT Infrastructure Project Manager
Certification:-
Project Management Professional (PMP)
Certified Associate in Project Management (CAPM).
Program Manager
Program manager oversees a team of information systems professionals who are engaged in various
projects. Program managers differ from project managers in that their roles are broader in scope. The role of a program manager is to act as a coordinator for an organization’s projects.
OS and Web Server
Operating
Web Server
System
Apache Tomcat
Mac OS
Web Logic
Linux
Jboss
Unix
Apache HTTP Server
Window
WebSphere
Ubuntu
GlassFish
MS-DOS
Red Hat
Programming and Scripting Language
Programming Language
Scripting Language
Java
JavaScript
C#
Python
C++
Shell Script
Python
VB Script
PHP
Perl
Ruby on Rails
Jython
iOS/Swift
Ruby
ABAP (SAP)
TypeScript
SQL Database and NOSQL Database
SQL Database
NOSQL Database
MySQL
MongoDB
Oracle
HBase
DB2
Cassandra
Microsoft SQL Server
Redis
PostgreSQL
Couch DB
SQLite
Neo4j
MariaDB
OrientDB
IBM Db2 Family
Microsoft Access
Software Development Methodologies and SDLC
Methodologies
SDLC
Agile
Requirement gathering and analysis
Waterfall Model
Design
RUP (Rational Unified Process)
Implementation or coding
Spiral Model
Testing
Prototype
Deployment
Rapid Application Development
Maintenance
Scrum
Cloud technologies
BI Tools
Amazon Web Services
Microsoft Azure
SAP Business
Intelligence
Google Cloud Platform
MicroStrategy
Oracle BI
ETL Tools and Reporting Tools
ETL Tools
Reporting Tools
Informatica PowerCenter
SAP Crystal Reports
IBM Infosphere Information Server
Tableau
Oracle Data Integrator
Oracle XML
SQL Server Integrated
Services (SSIS)
Tableau
Dbxtra
Ab Initio
Talend
Datadog
BIRT
SAS
GoodData
SAP — Business Objects
Sybase ETL
QlikView Expressor
Big Data
Data which are very large in size is called Big Data. Normally we work on data of size MB (WordDoc, Excel) or maximum GB (Movies, Codes) but data in Peta bytes.
Sources of Big Data:-
These data come from many sources like
Social networking sites
E-commerce site
Weather Station
Telecom company
Share Market
Hadoop
Hadoop is an open source framework. It is provided by Apache to process and analyze very huge volume of data called Big Data. It is currently used by Google, Facebook, LinkedIn, Yahoo, Twitter etc.
Hive
Pig
Sqoop
Kafka
Yarn
Scala
Spark
Storm
MapReduce
Hbase
HDFS(Hadoop Distributed file System)
ERP
Definition: Enterprise resource planning (ERP) is business process management software that allows an organization to use a system of integrated applications to manage the business and automate many back office functions related to technology, services and human resources.
Salesforce.com
Microsoft Dynamics
NetSuite
Oracle JD Edwards
Infor 10 ERP
Maximo
People Soft
Oracle EBS
Definition: Salesforce is a CRM (Customer Relationship Management) software on cloud. It involves managing all aspects of relationship between an organization and its customers.
Skill Set
Sales Cloud
Service Cloud
Force.com
Salesforce.com
Visualforce Pages
Lightning
Apex
SOQL
SOSL
SFDC
Sandbox
Android
Definition:
Android is operating system for mobile devices such as tablet computers and smartphones.
It is developed by Google and later the OHA (Open Handset Alliance).
Skill Set:
Android SDK
Android Web Service
Android multithreading frameworks
Android Studio
GitHub
Git
Retrofit
Android Bluetooth
Android SQLite
IOS
Definition: iOS is a mobile operating system created and developed by Apple Inc.. It is the operating system that presently powers many of the company’s mobile devices, including the iPhone, iPad, and iPod Touch.
Skill Set:
Objective C
Swift
Cocoa
UIKit
Xcode
APNS (Apple PushNotificationService )
Cocoapods
MobileCoreServices
AFNetworking
Mapkit
XCTest framework
SAP
SAP stands for Systems Applications and Products in Data Processing. SAP by definition is also named of the ERP (Enterprise Resource Planning) software as well the name of the company. SAP is an enterprise application software (EAS) suite that can be used to manage Enterprise Resources Planning (ERP).
SAP Module
Production Planning (SAP PP)
Material Management (SAP MM)
Financial Supply Chain Management (SAP FSCM)
Sales and Distribution (SAP SD)
Project System (SAP PS)
Financial Accounting and Controlling (SAP FICO)
Plant Maintenance (SAP PM)
Quality Management (SAP QM)
SAP Technical Module
SAP BI
SAP BW (business warehouse)
SAP HANA (High-performance Analytic Appliance)
SAP BASIS (Business Application Systems Integrated Solutions)
SAP ABAP (Advanced Business Application Programming)
SAP NETWEAVER
SAP MDM Master Data Management
DevOps
Definition: DevOps is a set of software development practices that combines software development and information technology operations. DevOps Engineer works with developers and the IT staff to oversee the code releases.
Skill Set:
Jenkins
Jira
GIT
GitHub
Ansible
SVN
Chef
Puppet
Kubernetes
Network Engineer
Definition: A network engineer is a technology professional who has the necessary skills to plan, implement and oversee the computer networks that support voice, data, video and wireless network services.
Skill Set:
LAN (Local Area Network)
WAN(Wide Area Network)
MAN (Metropolitan Area Network)
Configure IP
Switch
Routers
FTP: File Transfer Protocol
SSH: Secure Shell
SSL: Secure Sockets Layer
SMTP: Simple Mail Transfer Protocol
TELNET (telnet)
HTTP: Hyper Text Transfer Protocol
Cisco CCNA Certification.
Cisco CCNP Certification.
VPN (Virtual Private Network)
Network troubleshoot
Operating Systems.
AWS Engineer
AWS is stands for Amazon Web Services. The AWS service is provided by the Amazon that uses distributed IT infrastructure to provide different IT resources available on demand. It provides different services such as infrastructure as a service (IaaS), platform as a service (PaaS) and packaged software as a service (SaaS)
Amazon S3 (Simple Storage Service)
Amazon Redshift
AWS SDK
EBS (Amazon Elastic Block Store)
Amazon VPC (Amazon Virtual Private Cloud)
Amazon ELB (Elastic Load Balancing)
Amazon RDS (Amazon Relational Database Service)
AWS IAM (AWS Identity and Access Management)
Amazon CloudFront
Amazon CloudWatch
AWS Route53
Microsoft Azure
Windows Azure, which was later renamed as Microsoft Azure in 2014, is a cloud computing platform, designed by Microsoft to successfully build, deploy, and manage applications and services through a global network.
Skill Set:
Azure Active Directory (AAD)
Azure AD Connect
Active Directory Federation Services (ADFS)
Azure MFA (Azure Multi-Factor Authentication) Azure CDN (Azure Content Delivery Network)
Azure RBAC (Role-based access control)
Azure IAAS (Infrastructure as a service)
Azure PAAS (Platform as a Service)
Azure SAAS (Software as a Service)
Data Analyst
Definition: Data Analyst interprets data and turns it into information which can offer ways to improve a business, thus affecting business decisions. Data Analysts gather information from various sources and interpret patterns and trends — as such a Data Analyst job description should highlight the analytical nature of the role.
Data collection
Data Science
Data processing
Data cleaning
Exploratory data analysis
Data Modeling
Data visualization
Reporting Tools
BI Tools
Data Scientists
Data scientists are a new breed of analytical data expert who have the technical skills to solve complex problems — and the curiosity to explore what problems need to be solved. They’re part mathematician, part computer science. Data science is a multi-disciplinary field that uses scientific methods, processes, algorithms and systems to extract knowledge and insights from structured and unstructured data.
Skill Set:
Machine Learning
SAS
SQL
Python
Hive
Pig
Apache spark
MATLAB
Understanding of Statistics, Mathematics, visualization, Algorithms.
IMPORTANT TERMS:
I — 94 — Port of entry to US.
I-129 — Petition for a Non-immigrant worker. (Basically all paper work your company submits while applying for H1B to labour dept. for a candidate.)
I -797- H1B approval notice. ( It is the approval notice given consultant when he applied for H1B)
23.4 I -797A — It is an original approval notice with the I-94 attached. I 797A is issued to people only in the USA currently undergoing a change of status (f1-h1, h1-h1, l1- h1 etc.). The “A” is for Change of status approved which means the applicant can continue to remain in the USA and work
I -797B — I-1797B is an original approval notice with no I-94 attached. If you have received an I-797B, this means that the petition itself is approved, but the COS/Extension of Stay is not approved. You would have to go back to your home country to get your visa stamped, and then re-enter the US.
I — 797C — It is a copy of the approved petition. This is usually given to the employers for their reference file.
EAC — (Receipt Number): It receipt no written in 1–797A form. We can check status of the visa of the candidate.
EIN — Employer Identification Number (EIN) is also known as a Federal Tax Identification Number; it has 9 digit numbers and is used to identify a business entity. Also known as the Tax Identification Number (TIN).
SSN — Social Security number (SSN) is a nine-digit number issued to U.S. citizens, permanent residents, and temporary (working) residents. Its primary purpose is to track individuals for taxation purposes.
W-9 -. Taxpayer Identification Number and Certification for the independent consultant. (It is the form issued to the independent (1099) consultant by the employer for the tax Identification Number).
Purchase Order: It is an agreement send to an Employer / an Independent consultant who got confirmed for the project
EAD: EAD is the document (Form I-688, Form I-688A, Form I-688B, Form I-766, or any other successor document issued by USCIS) that proves as evidence that the holder is authorized to work in the United States.
I- 140: Immigrant Worker Petition If you are an employer wishing to sponsor (or petition) for a foreign national to work in the United States on a permanent basis, you must file Form I-140.
I-145: Adjustment of status (“AOS”) is a procedure that allows an eligible applicant to become a lawful permanent resident of the United States without having to go abroad and apply for an immigrant visa.
A security clearance: A security clearance is a status granted to individuals allowing them access to classified information, i.e., state secrets, or to restricted areas after completion of a thorough background check.
Type of securiy clearance:
Confidential: The simplest security clearance to get. This level typically requires a few weeks to a few months of investigation.
Secret: A Secret clearance, also known as Ordinary Secret, requires a few months to a year to fully investigate depending on the individual’s activities.
Top Secret: Top Secret is a more stringent clearance. A Top Secret, or “TS”, clearance is often given as the result of a Single Scope Background Investigation, or SSBI. Top Secret clearances generally afford one access to data that affects national security,
List of the more popular and possible sets of security a clearance is below:
Confidential Secret (Collateral)
Top Secret (Collateral)
DOE — C, L, Q
FBI (equivalent to TS Collateral) NATO Secret
Position of Public Trust Yankee White
Top Secret/SCI
Implementation Partner: The organization which implements the projects to the vendor.
Middle Layer (or) Prime Vendors: The organization which supports the end client and the vendors
Direct Deposit: Salary paid directly to the consultant to their bank account and not by sending in cheque.
Important things to notify:
Once you get a requirement please spend at least 3–4 minutes on each of it Go through the requirement thoroughly and find out the right consultant for the right job Try to find out a consultant who is having strong skills, good attitude, ability to perform at any environment, interest to to the job, strong communication, geographical knowledge of the the client, etc. For a normal requirements (example .net, java, oracle) try to find a consultant from your own database/resource/vendors list. For a normal requirement do not source citizens, always submit H1b’s only. It is advisable to work with the vendors with those we had an agreement before or with whom we have a real confident Never reveal our end customer’s details to the vendors until get a confirmation from RM/AM. If it is a unique/complicated requirement circulate it, in to your vendors list, post it in C2C, Dice, Google (whatever it may be) and also try to avail from a references (friends/colleague, etc.)
Never update the resume without the consultant knowledge/authorization and do not ask the consultant to update it’s which one he does not have an experience on it Make sure that your submittal consultant’s h1b is holding by the vendor who is submitting to you Before submission get the NCA from the vendor and rate confirmation too Never submit the consultant without getting the confirmation from the vendor who is holding the visa Is he/she open for the telephonic calls?
Is he/she ok for the time frame (Some customers take a long time to decide while other not do the same) Is she/he has any pipeline
Screening:
Initial technical/HR evaluation is mandatory before submission
Submission Time:
Make sure that the consultant is really fit for the project Always submit the resume in a format. Try to submit with the consultant’s full name and ensure that you have mentioned his/her contact details on the submittal form Properties of the resume should be edited before submission References details should be mentioned AM/RM will not accept the personal references from friends/colleagues/vendors/ relatives etc References from Project manager/Team leader will be accept at any condition, but from the director or MD will be question?
References details should be in a professional manner. Do not provide the personal email address of your references. Make sure to get an official email address of your references
H1b copy (I797), I94
Our preferred contract terms are C2C and W-2. If incase of 1099, you need to get an approval from Resource Manager
Relocation factor is important for any submission. You must have information from the candidate as to why he/she would like to relocate? You are expected to think on relocation consequences (for the candidate) beyond what you hear from them.
Availability of the candidate for the initial screening by preferred vendor–After your submission of a profile to Resource manager the minimum expectancy of candidate’s availability is 48hrs.
You have to work with the direct employers and no layers. At a later time if you find out that there is a layer in between then we have the right to work with the employers directly. For a critical position, you need to have the prior approval from Resource Manager before working with layers Signed NCA should be in place before making submission to Resource Manager or Account Manager.
Initial technical/HR evaluation is mandatory before submission. Current location and his/her interest to move to the new project location H1 status and employer name
You need to be extra cautious with the independent (H1 transfer candidates) consultants who may work with multiple prospective employers. For Example. ABC consultant working with TCS or Satyam or HCL or Wipro may try to transfer their H1 with other vendor companies. THIS KIND OF CONSULTANTS ARE NOT OUR CHOICE BECOZ they will be working with various vendor companies without having any control. So we might lose the candidate after confirmation.
Communication and presentation skills are very important for any position
Two professional references with name, client name, title, phone and email You need to do this for everyone. Always prefer American references with client email ids.
Before qualifying the resume for submission, you need to check on these things with the employer as well with the candidate
How long he/she has been out off the project?
You should not consider anyone who is out off the project for more than 4 weeks. II. How many interviewsthat he/she has given in that particular week?
