onsite
Data Integrator - PCS InfoTech
Data Integrator
Senior Data Integrator to design and execute scalable data migration pipelines using PostgreSQL, DBT, and AWS services.
About the role
Key Responsibilities
- Design and execute customer data migration and integration processes into modern platforms
- Extract, transform, and load data from legacy and third-party systems with accuracy and scalability
- Develop and maintain cloud-based ETL/ELT pipelines using AWS Glue, Amazon S3, and Airbyte
- Build data transformation workflows with DBT for standardized, auditable processes
- Validate data integrity through automated checks, reconciliation, and exception reporting
- Collaborate with customers and internal teams to resolve data discrepancies and ensure smooth system adoption
Requirements
- 5+ years of experience designing and implementing ETL/ELT solutions, including legacy system data extraction
- Strong expertise in PostgreSQL, advanced SQL, and PL/pgSQL programming
- Hands-on experience with DBT, Airbyte, AWS Glue, and Amazon S3
- Ability to develop automated data validation and quality processes
- Experience with cloud-native data platforms and modern development ecosystems
Skills
postgresqlpl pgsqldbtairbyteaws glueamazon s3