Lead Consultant, Mattillion ETL Engineer

Ready to build the future with AI
At Genpact we dont just keep up with technologywe set the pace. AI and digital innovation are redefining industries and were leading the charge. Genpacts AI Gigafactory our industry-first accelerator is an example of how were scaling advanced technology solutions to help global enterprises work smarter grow faster and transform at scale. From large-scale models to agentic AI our breakthrough solutions tackle companies most complex challenges.
If you thrive in a fast-moving innovation-driven environment love building and deploying cutting-edge AI solutions and want to push the boundaries of whats possible this is your moment.
Genpact (NYSE: G) is anadvanced technology services and solutions company that deliverslastingvalue for leading ourdeep business knowledge operational excellence and cutting-edge solutions we help companies across industries get ahead and stay by curiosity courage and innovationour teamsimplementdata technology and AItocreate tomorrow to know us onLinkedInXYouTube andFacebook.
Inviting applications for the role of Lead Consultant Mattillion ETL Engineer
We are looking for a skilled Mattillion ETL Engineer with strong expertise in support operations configurations and development. The role involves managing day-to-day Mattillion operations performing environment setups creating and maintaining workflows/projects and ensuring smooth ETL pipeline execution on cloud data platforms.

Responsibilities
Monitor and manage Mattillion ETL jobs/workflows in production and non-production environments.
Provide L2/L3 support including troubleshooting job failures debugging errors and applying fixes.
Proactively identify performance issues and optimize ETL jobs for efficiency.
Maintain KB articles and SOPs for common operational issues.
Perform environment setup and administration in Mattillion.
Configure projects version control task scheduling and user/access management.
Manage connections to databases cloud storage and third-party data sources.
Ensure system availability reliability and adherence to compliance/security standards.
Design and develop ETL workflows and pipelines in Mattillion to support data integration projects.
Create and manage projects workflows and access configurations.
Implement error handling logging and recovery mechanisms in workflows.
Collaborate with data engineers architects and business teams to gather requirements and deliver solutions.
Qualifications we seek in you!
Minimum Qualifications / Skills
Bachelors degree in Computer Science Information Technology Electrical Engineering or a related field. Advanced degrees or relevant professional training are a plus.
Strong hands-on exposure to Mattillion ETL operations/support.
Experience in Mattillion setup/configurations including environment setup project creation and access control.
Working knowledge of Mattillion development (projects workflows pipeline creation access management).
Strong SQL skills (querying performance tuning stored procedures).
Experience with cloud data warehouses like Snowflake Redshift or BigQuery.
Familiarity with cloud services (AWS Azure or GCP) such as S3 IAM ADLS or GCS.
Strong troubleshooting and problem-solving abilities.
Preferred Qualifications/ Skills
Knowledge of Python or scripting for automation.
Experience with DevOps/CI-CD pipelines for ETL deployment.
Familiarity with orchestration/scheduling tools (Airflow Control-M etc.).
Exposure to data governance quality and compliance frameworks.
Mattillion or Snowflake certification.

Why join Genpact
Lead AI-first transformation Build and scale AI solutions that redefine industries
Make an impact Drive change for global enterprises and solve business challenges that matter
Accelerate your careerGain hands-on experience world-class training mentorship and AI certifications to advance your skills
Grow with the best Learn from top engineers data scientists and AI experts in a dynamic fast-moving workplace
Committed to ethical AI Work in an environment where governance transparency and security are at the core of everything we build
Thrive in a values-driven culture Our courage curiosity and incisiveness - built on a foundation of integrity and inclusion - allow your ideas to fuel progress
Come join the 140000 coders tech shapers and growth makers at Genpact and take your career in the only direction that matters: Up.
Lets build tomorrow together.

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.
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.