FEATURED JOBS
FEATURED JOBS
SR. SQL Developer
EXPERIENCE REQUIRED: 5 – 8 Years
NUMBER OF POSITIONS: 4
DEPARTMENT: Information Systems
REPORTS TO: Director IS
LOCATION: Gurugram
ESSENTIAL DUTIES AND RESPONSIBILITIES:
—
Help write and optimize in-application SQL statements.
—
Ensure performance, security, and availability of databases.
—
Prepare documentations and specifications.
—
Profile server resource usage, and optimize and tweak as necessary.
—
Collaborate with other team members and stakeholders.
—
Translate business needs to technical specifications.
—
Design, build and deploy BI solutions (e.g. reporting tools).
—
Maintain and support data analytics platforms (e.g. MicroStrategy).
—
Create tools to store data (e.g. OLAP cubes)
—
Conduct unit testing and troubleshooting.
—
Evaluate and improve existing BI systems.
—
Collaborate with teams to integrate systems.
—
Develop and execute database queries and conduct analyses.
—
Create visualizations and reports for requested projects.
—
Develop and update technical documentation
SUPERVISORY RESPONSIBILITIES:
This position does not have any supervisory responsibilities.
LANGUAGE REQUIREMENTS:
| Required | English | Ability Level | Business Fluent |
| Required | Hindi | Ability Level | Business Fluent |
QUALIFICATIONS:
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
—
Strong proficiency with SQL and its variation among popular databases.
—
Experience with some of the modern relational databases.
—
Skilled at optimizing large complicated SQL statements.
—
Knowledge of best practices when dealing with relational databases.
—
Capable of configuring popular database engines and orchestrating clusters as necessary.
—
Proven experience as a BI Developer or Data Scientist.
—
Industry experience is preferred.
—
Background in data warehouse design (e.g. dimensional modeling) and data mining.
—
In-depth understanding of database management systems, online analytical processing
(OLAP) and ETL (Extract, transform, load) framework.
—
Familiarity with BI technologies (e.g. Microsoft Power BI, Oracle BI).
—
Knowledge of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server
Integration Services (SSIS).
—
Proven abilities to take initiative and be innovative.
—
Analytical mind with a problem-solving aptitude.
EDUCATION:
Bachelor’s degree (IT – Software/Data or other related disciplines) from 3-4-year college or university.
LANGUAGE SKILLS:
Ability to read and interpret documents such as safety rules, operating and maintenance
Instructions, and procedure manuals, ability to write routine reports and correspondence.
Ability to speak effectively before groups of customers or employees of organization.
MATHEMATICAL SKILLS:
Ability to add, subtract, multiply and divide in all units of measure, using whole
Numbers, common fractions and decimals. Ability to compute rate, ratio, and
Percent and to draw and interpret bar graphs.
REASONING ABILITY:
Ability to solve practical problems and deal with a variety of concrete variables in Situations where only limited standardization exists. Ability to interpret a variety of Instructions furnished in written, oral, diagram or schedule form.
CERTIFICATES, LICENSES, REGISTRATION:
Candidates with quality related certification/licenses will be preferred.
PHYSICAL DEMANDS:
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the
Essential functions.
While performing the duties of this job, the employee is regularly required to stand; walk;
Use hands to finger, handle, or feel; and talk or hear. The employee is occasionally
Required to climb or balance. The employee must occasionally be required to lift and/
Or move up to 50 pounds. Specific vision abilities required by this job include close
Vision, distance vision, color vision, peripheral vision, depth perception and ability to
Adjust focus.
WORK ENVIRONMENT:
The work environment characteristics described here are representative of those an Employee encounters while performing the essential functions of this job. Reasonable Accommodations may be made to enable individuals with disabilities to perform the Essential functions.
While performing the duties of this job, the noise level in the work environment is Usually moderate.
ABOUT THE COMPANY:
AIS is a Texas-based fintech firm committed to lowering operating costs, improving quality and reducing cycle time with back-office automation, highly skilled talent and standardized reporting and analytics solutions. AIS manages the day-to-day work so our clients can focus on growing their business. We review client processes, eliminate non-value adds, and enhance productivity. We build financial and legal technology to automate and optimize workforce performance. We recruit, train, and manage specialized human resources to meet staff augmentation needs. We equip decision makers with deep data sets and forward-thinking analytics so they can make smarter business decisions and create better customer experiences. We serve a variety of industries including banking, automotive finance, credit card, mortgage, insurance and telecommunications.
Website – www.aisinfo.com
LinkedIn – https://www.linkedin.com/company/aisinfo/
ABOUT US
AIS offers exciting opportunities to provide innovative solutions that help clients maximize their potential.