Genpact is hiring for Business Analyst – SQL Developer. This section offers a comprehensive overview of the position, incorporating both job prerequisites and any relevant additional information.
Genpact is hiring for Business Analyst – SQL Developer
About Genpact
Genpact, established in 1997 as a division of General Electric and now an independent global professional services firm, delivers digital transformation, business process management, and consulting services across various sectors in over 30 countries. By blending process knowledge, technology, and analytics, Genpact has emerged as a reliable ally for enterprises aiming to enhance operational effectiveness, customer satisfaction, and overall results.
| Company Name: | Genpact |
| Website: | www.genpact.com |
| Job Role: | Business Analyst – SQL Developer |
| Location: | Hyderabad , India |
| Qualifications: | B.Tech/MBA/MSc/MCA |
| Salary: | 5 LPA (Expected) |
| Experience: | Fresher |
Responsibilities
- Exhibit proficiency in T-SQL query composition by effectively utilizing joins and subqueries within Microsoft SQL Server.
- Demonstrate adeptness in T-SQL development, showcasing the ability to craft intricate queries that involve multiple tables and require advanced join operations.
- Showcase hands-on experience in Extracting, Transforming, and Loading (ETL) data from MS Access Database into MS SQL Server, ensuring seamless data migration and integration.
- Illustrate competence in designing, modifying, and managing tables, fields, and constraints within the Microsoft SQL Server environment, highlighting skillful database administration.
- Display expertise in creating, fine-tuning, and updating stored procedures within MS SQL Server, enhancing database functionality and performance.
- Exhibit proficiency in scheduling and fine-tuning automation jobs using MS SQL Server, streamlining routine tasks and operations.
- Possess adept knowledge of constructing Views, Triggers, and Functions, contributing to a robust database architecture within MS SQL Server.
- Demonstrate a solid foundational understanding of MS Access Database management, ensuring smooth data handling and integration processes.
- Show familiarity with SQL Server Analysis Services (SSAS), Integration Services (SSIS), and Reporting Services (SSRS), indicating a comprehensive grasp of Microsoft SQL Server’s broader functionalities.
Minimum qualifications
- Bachelor of Technology (B.Tech), Master of Business Administration (MBA), Master of Science (MSc), or Master of Computer Applications (MCA) degree.
Preferred qualifications
- Design and create QlikView Dashboards.
- Possess proficiency in crafting data models, including Star and Snowflake Schema designs.
- Develop Key Performance Indicators (KPIs) that closely align with specific Business Requirements.
Preferred qualifications
- Retrieve data from QVD (QlikView Data) files and generate new QVDs as needed.
- Demonstrate strong understanding of managing variables within QlikView.
- Possess fundamental familiarity with Section Access functionality in QlikView.
