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 Lead Consultant-Microsoft ETL Lead Engineer | Database design |Agile Development Process | Release Management)
Position Overview:
We are currently seeking a highly experienced ETL engineer with hands-on experience in Microsoft ETL (Extract, Transform, Load) technologies. The ideal candidate will have a deep understanding of ETL processes, data warehousing, and data integration, with a proven track record of leading successful ETL implementations. As an principal ETL engineer, you will play a pivotal role in architecting, designing, and implementing ETL solutions to meet our organization's data needs.
Key Responsibilities:
Lead and design and development of ETL processes using Microsoft ETL technologies, such as SSIS (SQL Server Integration Services)
Mandatory hands on experience (70% development, 30% leadership)
Collaborate with stakeholders to gather and analyze requirements for data integration and transformation.
Design and implement data quality checks and error handling mechanisms within ETL processes.
Lead a team of ETL developers, providing technical guidance, mentorship, and oversight.
Perform code reviews and ensure adherence to best practices and coding standards.
Troubleshoot and resolve issues related to data integration, ETL performance, and data quality.
Work closely with database administrators, data architects, and business analysts to ensure alignment of ETL solutions with business requirements.
Stay up-to-date with the latest trends and advancements in ETL technologies and best practices
Identify and resolve performance bottlenecks.Implement best practices for database performance tuning and optimization.
Ensure data integrity, security, and availability
Create and maintain documentation for database designs, configurations, and procedures
Ensure compliance with data privacy and security regulations
Qualifications we seek in you
Minimum Qualifications
Education:
Bachelor’s degree in Computer Science, Information Technology, or a related field.
Experience:
experience in designing, developing, and implementing ETL solutions using Microsoft ETL technologies, particularly SSIS.
Strong understanding of data warehousing concepts, dimensional modeling, and ETL design patterns.
Proficiency in SQL and experience working with relational databases, preferably Microsoft SQL Server.
Experience leading ETL development teams and managing end-to-end ETL projects.
Proven track record of delivering high-quality ETL solutions on time and within budget.
Experience with other Microsoft data platform technologies (e.g., SSAS, SSRS) is a plus
Familiarity with version control systems (e.g., Git)
Knowledge of containerization and orchestration (e.g., Docker, Kubernetes) is a plus
Soft Skills:
Strong analytical and problem-solving skills
Excellent communication and collaboration abilities
Ability to work independently and as part of a team
Preferred Qualifications
Experience with cloud-based database services (e.g., AWS RDS, Google Cloud SQL)
Knowledge of other database systems (e.g., PGSQL, Oracle)
Familiarity with Agile development methodologies
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 respect and integrity, customer focus, and innovation. For more information, visit www.genpact.com . Follow us on Twitter, Facebook, LinkedIn, and YouTube.
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.