ETL / EDW Lead – Sybase to PostgreSQL Migration (AWS Cloud)
- Location
- Dallas, Texas, United States
- Salary
- Not specified
- Company
- Akash pawar
Job description
### Role & Company / Project Overview We are seeking an experienced ETL / EDW Lead to drive data warehouse modernization and cloud migration initiatives, focusing on migrating legacy Sybase databases and ETL workloads to PostgreSQL on AWS. The ideal candidate will bring strong expertise in ETL development, database migration, performance optimization, and technical team leadership. ### Key Responsibilities & Daily Duties • Lead end-to-end Sybase ASE / IQ to PostgreSQL migration initiatives. • Analyze legacy ETL / EDW architecture and define migration strategies. • Design and implement scalable ETL pipelines on AWS. • Perform data mapping, transformation, validation, and reconciliation. • Optimize database performance, indexing, partitioning, and SQL queries. • Ensure data quality, governance, and migration testing. • Coordinate release planning, deployment, and production support. • Collaborate with business and technical stakeholders while mentoring ETL teams. ### Required Qualifications, Skills & Experience • Required Technical Skills: - Sybase ASE / IQ and PostgreSQL - AWS: RDS, EC2, S3, Glue, Lambda, DMS - ETL Tools: DataStage, SSIS, Azure Data Factory (ADF) - SQL, PL/SQL, and Stored Procedures - Data Modeling: Dimensional and OLTP - Database Migration and Modernization - Data Validation, Reconciliation, and Performance Tuning - Agile / Scrum Delivery • Required Experience: - 8+ years of ETL / EDW development and support experience. - Hands-on experience with Sybase to PostgreSQL migration projects. - Experience in AWS cloud migration and modernization programs. - Strong understanding of ETL design patterns and data integration. - Proven leadership, team coordination, and stakeholder communication skills. ### Working Hours, Shifts & Location Details • Location: Dallas, TX • Work Arrangement: Onsite 3 Days a Week (Hybrid) ### Compensation & Benefits • Not specified. ### Application Instructions • Please submit your profile for consideration.