common ETL patterns and establish scalable design standards.
• Build, test, deploy, and support data pipelines and orchestration workflows
• Collaborate with business stakeholders to translate requirements into technical solutions
• Drive performance optimization, reliability, and operational excellence across data platforms. Required Skills
• 10+ years of experience in Data Engineering, ETL Development, and Data Warehousing
• Strong development experience in PySpark, Python, and SQL
• Hands-on experience with: o AWS EMR Serverless o AWS Glue o AWS Step Functions o AWS EventBridge o Amazon S3 o Apache Airflow
• Strong database experience, preferably DB2, Snowflake and Amazon Athena
• Advanced SQL skills include complex joins, window functions, CTEs, performance tuning, and data reconciliation
• Experience with Informatica PowerCenter and the ability to understand and analyze existing ETL implementations
• Strong analytical, problem-solving, and communication skills
• Ability to work independently and take ownership from design through production deployment.
Preferred Skills
• Experience building metadata-driven and reusable ETL frameworks
• Experience with large-scale ETL modernization and cloud migration initiatives
• Knowledge of data quality, data governance, and reconciliation processes. Nice to Have
• Experience integrating external systems through REST APIs using Python/PySpark
• Exposure to CI/CD pipelines and DevOps practices
• Experience with Medallion Architecture (Bronze, Silver, Gold)
• Insurance domain experience
Requirements
Skills and Capabilites
Other Critical Skills
AWS Glue - Advanced
SQL - Advanced
Pyspark - Advanced
Python - Intermediate
AWS EMR Serverless - Intermediate
AWS Step Functions - Intermediate
AWS S3 - Intermediate
AWS Airflow - Intermediate
Snowflake - Advanced
AWS Athena - Intermediate
Perks
Competitive compensation and benefits package:
• Competitive salary and performance-based bonuses
• Compr
📌 FBS Agile Dev Team Member III (Pune)
🏢 Capgemini
📍 Pune
Reply to this offer
Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.