Job Title

About Position: Responsible for migrating a large‑scale wholesale banking data mart from on‑prem Teradata to Google BigQuery, including schema redesign, SQL conversion, and ETL/ELT orchestration. Designs performance‑optimized, cost‑efficient BigQuery data models while ensuring data accuracy, controls, lineage, and regulatory readiness. Collaborates with business and technical stakeholders to deliver secure, production‑ready analytics solutions with post‑migration support and optimization. Role: Teradata GCP Data Engineer Location: Bengaluru & Hyderabad Experience: 4 to 10 Years Job Type: Full Time Employment What You'll Do: Migration of a wholesale banking datamart from On‑Prem Teradata to GCP BigQuery. Data sourced from multiple upstream systems via complex ETL pipelines with business logic embedded in Teradata stored procedures. Final curated datasets support various use cases inclusing FR Y regulatory submissions, making data accuracy, controls, lineage, audit readiness, and formal migration sign‑off critical responsibilities for this role. Expertise You'll Bring: Strong hands‑on experience migrating large‑scale datasets from On Prem to Google BigQuery Deep expertise in BigQuery data modeling, including table design, partitioning, clustering, and cost‑efficient query patterns Advanced SQL proficiency, with proven experience converting RDBMS SQL, stored procedures and complex transformation logic into BigQuery‑compatible SQL Hands‑on experience designing and orchestrating ETL/ELT pipelines using Apache Airflow (Cloud Composer), including DAG development and dependency management Experience building batch data pipelines and managing multi‑source data ingestion into BigQuery Experience implementing data quality checks, reconciliation, and integrity controls during migration Experience with post‑migration performance tuning, monitoring, and troubleshooting, including use of Cloud Logging and monitoring tools Solid understanding of data warehousing concepts, migration strategies, and production readiness standards/" Benefits: Competitive salary and benefits package Culture focused on talent development with quarterly promotion cycles and company-sponsored higher education and certifications Opportunity to work with cutting-edge technologies Employee engagement initiatives such as project parties, flexible work hours, and Long Service awards Annual health check-ups Insurance coverage: group term life, personal accident, and Mediclaim hospitalization for self, spouse, two children, and parents Values-Driven, People-Centric & Inclusive Work Environment: Persistent is dedicated to fostering diversity and inclusion in the workplace. We invite applications from all qualified individuals, including those with disabilities, and regardless of gender or gender preference. We welcome diverse candidates from all backgrounds. We support hybrid work and flexible hours to fit diverse lifestyles. Our office is accessibility-friendly, with ergonomic setups and assistive technologies to support employees with physical disabilities. If you are a person with disabilities and have specific requirements, please inform us during the application process or at any time during your employment Let's unleash your full potential at Persistent - /careers /"Persistent is an Equal Opportunity Employer and prohibits discrimination and harassment of any kind./"