Senior Data Engineer – ETL, Cloud & GenAI

Responsibilities: • Data Pipeline Development: Design, build, and optimize ELT/ETL pipelines using Informatica IDMC/PowerCenter, DBT, and Kafka for structured and semi-structured data. • Cloud Migration & Modernization: Migrate on-prem data warehouses and ETL workloads to AWS services like Redshift, S3, Glue, and PostgreSQL. • Data Modeling & Quality: Create scalable data models, implement DBT tests, and enforce data quality, lineage, and governance standards. • Automation & DevOps: Automate infrastructure and deployments using Terraform, Git, CI/CD, and scripting in Python/Shell. • Performance Tuning: Optimize SQL, PL/SQL, and data workflows for performance, cost, and reliability. • Collaboration: Partner with business, analytics, and engineering teams to translate requirements into technical solutions and analytics-ready datasets. Requirements: • 5+ years of experience in Informatica PowerCenter/IDMC, DBT, and strong SQL/PL/SQL skills. • Hands-on experience in Oracle 10g–13c, PostgreSQL, Amazon Redshift, and MySQL. • Practical experience in AWS – S3, Redshift, Glue, and cloud migration projects. • Experience in Python, Shell scripting, and automation of data workflows. • Strong experience in data modeling, performance tuning, and data quality frameworks. • Experience in Git, BitBucket, Terraform, and CI/CD for data pipelines.