ETL Lead
Jagadeesh KapiliUnited StatesLEADPosted 22m ago
SybasePostgreSQLAWSRDSEC2S3GlueLambdaDMSETLIBM DataStageSSISAzure Data FactorySQLPL/SQLstored proceduresEDWdata warehousingdimensional modelingOLTP modelingdata mappingdata validationdata reconciliationdata qualitydata governanceindexingpartitioningquery optimizationperformance tuningmigration testingdeploymentproduction supportAgileScrum
About the Role
We are looking for an ETL Lead to drive an enterprise Sybase-to-PostgreSQL migration on AWS. This role requires extensive experience in ETL, Enterprise Data Warehousing (EDW), database migration, and cloud modernization, with a focus on maintaining data integrity, performance, and business continuity.
Key Responsibilities
• Lead end-to-end migration of Sybase databases and ETL workloads to PostgreSQL on AWS.
• Assess ETL/EDW architecture and dependencies; define migration strategy and roadmap.
• Design, build, and optimize AWS ETL pipelines.
• Perform data mapping, transformation, validation, and reconciliation.
• Convert Sybase SQL, stored procedures, and database objects for PostgreSQL.
• Tune queries, execution plans, indexes, and partitions.
• Work with AWS RDS, EC2, S3, Glue, Lambda, and Database Migration Service (DMS).
• Manage migration testing, data quality, governance, deployment, and production support.
• Collaborate with business, architecture, application, and cloud teams; minimize risks and disruption.
• Mentor ETL developers and coordinate offshore/onshore teams; support Agile/Scrum delivery.
Requirements
• 10+ years in ETL/EDW development and support.
• Hands-on Sybase-to-PostgreSQL migration experience.
• AWS cloud migration and database modernization experience.
• Strong SQL, ETL design, data transformation, and performance tuning skills.
• Ability to lead teams, manage timelines, and communicate with stakeholders.