About the Role
We are seeking a highly skilled Lead Data Engineer to define and drive the data migration strategy from legacy RDBMS platforms to PostgreSQL for a mission-critical billing and invoicing system. This role requires a hands-on technical leader who can design the migration architecture, oversee implementation, and ensure seamless transition without disruption to core business functions.The ideal candidate will have deep expertise in data migration frameworks, large-scale distributed processing (Spark preferred), and experience with both open-source and AWS ecosystem tools. They will work closely with business stakeholders and customers to manage expectations, deliver with precision, and ensure system reliability and performance post-migration.
Key Responsibilities
Define and Own Migration Strategy
- Architect end-to-end data migration solution from RDBMS to PostgreSQL.
- Evaluate open-source and AWS-native tools (e.g., AWS DMS, Glue, EMR, Schema Conversion Tool).
- Design frameworks for schema conversion, bulk data loads, CDC (Change Data Capture), and reconciliation. Technical Leadership
- Lead a team of data engineers to execute migration plans.
- Establish coding, testing, and validation standards to ensure accuracy and performance.
- Leverage Spark (preferred compute engine) for high-volume transformation and migration workloads. Customer & Stakeholder Management
- Engage with business and customer teams to align migration timelines with billing cycle dependencies.
- Manage customer expectations through transparent planning, reporting, and risk management.
- Serve as

Keyskills: schema hive technical leadership glue amazon redshift pyspark data warehousing data migration emr sql java postgresql spark aws dms hadoop big data etl reporting architecture python development rdbms amazon rds aws lambda aws glue amazon ec2 framework s migration hdfs athena aws
Infogain is a Silicon Valley headquartered company with software platform engineering and deep domain expertise in the travel, retail, insurance and high technology industries. We accelerate the delivery of digital customer engagement systems using digital technologies such as cloud, mic...