Assistant Manager-SQL Developer
Genpact
5 - 10 years
Hyderabad
Posted: 9/3/2024
Job Description
Responsibilities
:• Database Design and Architecture: Designing and implementing efficient and scalable database architectures that meet the organization's requirements and ensure data integrity and security.
• SQL Development: Writing/Understanding complex SQL queries, stored procedures, functions, and triggers to manipulate and retrieve data from databases.
• Performance Optimization: Analyzing and optimizing SQL queries, indexes, and database structures to improve query performance and overall system efficiency.
• Data Modeling: Collaborating with stakeholders to design and maintain data models that accurately represent the organization's data and business requirements.
• Data Warehouse: Experience in data preparations, data transformation, data structures, traditional Data warehouses and Data Marts is considered an added advantage
• AWS: Understand the core AWS services and apply best practices regarding security and scalability is considered an added advantage
• Data Integration: Integrating data from various sources and systems to ensure data consistency and availability across the organization.
• Documentation: Creating and maintaining technical documentation, such as database schemas, data dictionaries, and system diagrams, to facilitate understanding and collaboration among team members.
• Collaboration: Working closely with cross-functional teams, including developers, data analysts, and business analysts, to understand data requirements and provide technical guidance and support.
• Excellent verbal, written and presentation communication skills.
• Strong oral and written communication skills required to effectively and concisely present key findings to senior management/ Client is a must.
Minimum Qualifications:
• Bachelor’s degree in computer science, Information Technology, or a related field.
• Good years of experience as a SQL Developer or in a similar role including pricing analysis and/or sales analytics.
• Strong knowledge of database administration, design, and normalization procedures.
• Strong knowledge of SQL Server (including SSIS); experience with Oracle is a plus.
• Ability to develop and troubleshoot complex SQL scripts and stored procedures.
• Strong experience in Performance Tuning, Query Optimization, Database Setup & Configuration.
• Excellent analytical, project management and problem-solving skills.
• Ability to communicate findings and recommendations to executive-level stakeholders.
• Proficiency in MS Office suite (particularly Excel).
• Strong attention to detail and excellent organizational skills.
Preferred Qualifications:
• Familiarity with ETL processes and tools.
• Knowledge of data warehousing concepts.
• Experience with database administration tasks.
• Familiarity with version control systems.
• Certifications in database development or related fields (optional).
• Hands on experience of Statistical modelling and Pricing techniques.
About Company
Genpact is a global professional services firm delivering digital transformation by putting digital and data to work to create competitive advantage.
Services you might be interested in
One-Shot Campaign
Reach out to ideal employees in one shot!
The intelligent campaign for reaching out to the ideal audience to whom you can ask for help (guidance or referral).