Genpact Hiring For Production Support - Informatica

Genpact; Bengaluru, Secunderabad; Hybrid; INR 9,00,000 - 15,00,000; Full time

Job summary

An established industry player is seeking a highly experienced ETL engineer to lead the design and development of ETL processes using Microsoft technologies. This pivotal role involves architecting solutions to meet data needs, mentoring a team of developers, and ensuring data integrity and performance optimization. Join a dynamic work environment that values innovation and respect, where your expertise will shape the future of data integration and transformation. If you are passionate about technology and eager to make a significant impact, this opportunity is perfect for you.

Qualifications

• Experience in leading ETL teams and implementing Microsoft ETL solutions.
• Strong understanding of data warehousing and dimensional modeling.

Responsibilities

• Lead the design and development of ETL processes using Microsoft ETL technologies.
• Collaborate with stakeholders to gather requirements for data integration.

Skills

ETL processes

Microsoft ETL technologies

SQL

Data warehousing

Problem-solving

Communication

Team leadership

Education

Bachelor’s degree in Computer Science

Tools

SSIS

Git

Docker

Kubernetes

Job description

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 a 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:

1. Lead and design and development of ETL processes using Microsoft ETL technologies, such as SSIS (SQL Server Integration Services).
2. Mandatory hands-on experience (70% development, 30% leadership).
3. Collaborate with stakeholders to gather and analyze requirements for data integration and transformation.
4. Design and implement data quality checks and error handling mechanisms within ETL processes.
5. Lead a team of ETL developers, providing technical guidance, mentorship, and oversight.
6. Perform code reviews and ensure adherence to best practices and coding standards.
7. Troubleshoot and resolve issues related to data integration, ETL performance, and data quality.
8. Work closely with database administrators, data architects, and business analysts to ensure alignment of ETL solutions with business requirements.
9. Stay up-to-date with the latest trends and advancements in ETL technologies and best practices.
10. Identify and resolve performance bottlenecks. Implement best practices for database performance tuning and optimization.
11. Ensure data integrity, security, and availability.
12. Create and maintain documentation for database designs, configurations, and procedures.
13. Ensure compliance with data privacy and security regulations.

Qualifications:

Education:

1. Bachelor’s degree in Computer Science, Information Technology, or a related field.

Experience:

1. Experience in designing, developing, and implementing ETL solutions using Microsoft ETL technologies, particularly SSIS.
2. Strong understanding of data warehousing concepts, dimensional modeling, and ETL design patterns.
3. Proficiency in SQL and experience working with relational databases, preferably Microsoft SQL Server.
4. Experience leading ETL development teams and managing end-to-end ETL projects.
5. Proven track record of delivering high-quality ETL solutions on time and within budget.
6. Experience with other Microsoft data platform technologies (e.g., SSAS, SSRS) is a plus.
7. Familiarity with version control systems (e.g., Git).
8. Knowledge of containerization and orchestration (e.g., Docker, Kubernetes) is a plus.

Soft Skills:

1. Strong analytical and problem-solving skills.
2. Excellent communication and collaboration abilities.
3. Ability to work independently and as part of a team.

Preferred Qualifications:

1. Experience with cloud-based database services (e.g., AWS RDS, Google Cloud SQL).
2. Knowledge of other database systems (e.g., PGSQL, Oracle).
3. 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.