Genpact (NYSE: G) is a global professional services and solutions firm delivering outcomes that shape the future. Our 125,000 people across 30 countries are driven by our innate curiosity, entrepreneurial agility, and desire to create lasting value for clients. Powered by our purpose – the relentless pursuit of a world that works better for people – we serve and transform leading enterprises, including the Fortune Global 500, with our deep business and industry knowledge, digital operations services, and expertise in data, technology, and AI.
Inviting applications for the role of Senior Principal Consultant – Database Architect
Responsibilities:
Provide development and administration support for various databases, primarily SQL server databases, in a client-server development environment including stored procedures and triggers, SQL, and index performance tuning, and database design and file storage
• Develop, deploy, and maintain Extract-Transform-Load (ETL) scripts and schedules, using SQL Server Integration Services (SSIS) to facilitate data movement and transformation.
• Develop and implement all database indexing, maintenance, back-up, transformations, and stored procedures
• Expose data to application in various business tiers
• Assist software developers in implementing appropriate data access permission schemas
• Utilize a product mindset to identify opportunities for improvement and innovation in data solutions that enhance user experience and deliver business value.
• Perform data analysis to support decision-making and improve data quality.
• Implement data governance and security measures to ensure data integrity and compliance with industry standards.
• Troubleshoot and resolve database-related issues and performance bottlenecks.
• Collaborate with cross-functional teams to gather requirements and design data solutions that meet business objectives.
• Participate in the refinement and development of user stories, assessing the impact of new development on current database implementation
• Communicate with technical and product owner stakeholders to help them anticipate and mitigate configuration management issues
Qualifications we seek in you
Minimum Qualifications
• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• Ideally hands-on experience in MS SQL Server database development and administration.
• Strong proficiency in MS SQL and Postgre SQL, stored procedures, and performance tuning.
• Solid knowledge of relational database architecture and concepts
• Strong database architecture, engineering, and design skills
• Extensive experience with SSIS for ETL processes and data integration.
• Solid understanding of data warehousing concepts and practices.
• Experience in data analysis and the ability to interpret complex datasets.
• Familiarity with database design principles and data modeling techniques.
• Excellent problem-solving skills and attention to detail.
• Strong communication and collaboration skills, with the ability to work effectively in a team environment.
• Demonstrated product mindset, with the ability to prioritize user needs and deliver value-driven solutions.
Genpact is an Equal Opportunity Employer and considers applicants for all positions without regard to race, color, religion or belief, sex, age, national origin, citizenship status, marital status, military/veteran status, genetic information, sexual orientation, gender identity, physical or mental disability or any other characteristic protected by applicable laws. Genpact is committed to creating a dynamic work environment that values diversity and inclusion, respect and integrity, customer focus, and innovation. Get to know us at genpact.com and on LinkedIn, X, YouTube, and Facebook.
Furthermore, please do note that Genpact does not charge fees to process job applications and applicants are not required to pay to participate in our hiring process in any other way. Examples of such scams include purchasing a 'starter kit,' paying to apply, or purchasing equipment or training.