Genpact is hiring Business Analyst – SQL Developer. This section offers a comprehensive overview of the role, including key job requirements and any relevant additional information.
Genpact is hiring Business Analyst – SQL Developer
| Company Name: | Genpact |
| Website: | www.genpact .com |
| Job Role: | Business Analyst – SQL Developer |
| Location: | Hyderabad, India |
| Qualifications: | B.Tech/MBA/MSc/MCA |
| Salary: | 4 – 7 LPA (Expected) |
| Experience: | Fresher |
About Genpact
Genpact, originally established in 1997 as a division of General Electric, has evolved into a worldwide professional services organization. It operates independently, serving over 30 countries and providing a comprehensive suite of services encompassing digital transformation, business process management, and consulting. Genpact is recognized for its commitment to blending process mastery, technology, and analytics to enhance business results, making it a dependable collaborator for enterprises striving to enhance operational efficiency, elevate customer satisfaction, and optimize overall performance.
Responsibilities
- Proficiency in writing T-SQL Queries, including joins and subqueries in MS SQL Server.
- Highly proficient in T-SQL development, with the ability to craft intricate queries that encompass multiple tables and utilize joins effectively.
- Proficient in the process of Extracting, Transforming, and Loading (ETL) data from MS Access Database into MS SQL Server.
- Competence in creating and modifying tables, fields, and constraints in MS SQL Server.
- Proficiency in creating and modifying stored procedures in MS SQL Server.
- Skill in scheduling and modifying jobs to automate tasks in MS SQL Server.
- Knowledge in creating Views, Triggers, and Functions.
- Basic proficiency in handling MS Access Database.
- Adept with SQL Server Analysis Services (SSAS), Integration Services (SSIS), and Reporting Services (SSRS).
Minimum qualifications
- B.Tech/MBA/MSc/MCA.
Preferred qualifications
- Ability to design and develop QlikView Dashboards.
- Knowledge of designing Data models (Star/Snowflake Schema).
- Proficiency in designing KPIs based on Business Requirements.
- Proficient in retrieving data from QVDs and creating QVDs.
- Good understanding of handling variables in QlikView.
- Basic knowledge of Section Access.
