The role involves designing and building robust ELT/ETL pipelines using Informatica, DBT, and Kafka for both structured and semi-structured data
Job Summary
The role involves designing and building robust ELT/ETL pipelines using Informatica, DBT, and Kafka for both structured and semi-structured data.
Candidates will lead cloud migration projects to move on-premises data warehouses and workloads to AWS services like Redshift and S3.
The position requires enforcing strict data quality, lineage, and governance standards while automating infrastructure deployments via Terraform and CI/CD.
Matching Summary
Match Score: 85
The role involves designing and building robust ELT/ETL pipelines using Informatica, DBT, and Kafka for both structured and semi-structured data.
Skills & Requirements
Must-have
Informatica PowerCenter IDMC experience
DBT data transformation skills
AWS Redshift S3 Glue migration
Python and Shell scripting automation
Oracle PostgreSQL database management
Terraform Git CI/CD pipeline setup
Nice-to-have
Strong collaboration with business teams
Experience with semi-structured data
Knowledge of data lineage standards
Performance tuning expertise
Cross-functional engineering partnership
Key Requirements
5+ years of experience in Informatica and DBT
Strong SQL and PL/SQL proficiency required
Hands-on experience with Oracle 10g through 13c
Practical background in AWS cloud migration projects
Proficiency in Python, Shell scripting, and automation