GCP Data Lead

Ascendion Engineering; Pune District, Chennai, Bengaluru; On-site; INR 3,500,000 - 7,500,000; Full time

Job summary

Ascendion is seeking a hands-on Data Architect – GCP to lead modernization of legacy workloads from Oracle, Informatica PowerCenter to Google Cloud Platform. You will design scalable data architectures, govern migrations, and deliver production-ready solutions with data quality and traceability.

Join a global team delivering AI-native software engineering services. You will mentor engineers, collaborate with client stakeholders, and ensure secure, cost-efficient data pipelines using BigQuery,

Qualifications

• 10+ years in data engineering and data modernization, with leadership experience.
• 5+ years in senior/architect roles and program leadership.
• Strong Oracle SQL/PLSQL and Informatica PowerCenter expertise.
• Hands-on with GCP data services and cloud-native migration patterns.

Responsibilities

• Assess Oracle schemas, PL/SQL programs, Informatica mappings, and data lineage to define migration strategies.
• Define scalable GCP architectures using BigQuery, Cloud Storage, Dataflow, Dataproc, Pub/Sub, Datastream, and more.
• Lead migration of Informatica mappings to GCP-native patterns and refactor legacy workloads.
• Design bulk and incremental data migration, CDC, orchestration, observability, and cost/performance optimization.
• Ensure data reconciliation, governance, security, and production readiness through testing and hypercare.

Skills

Data engineering

ETL

Data architecture

Data modernization

Technical leadership

Oracle SQL/PLSQL

Informatica PowerCenter

Pro*C / Embedded SQL

GCP data services

Python

SQL

Education

Google Professional Data Engineer

Google Cloud Architect

Tools

Informatica PowerCenter

Oracle SQL/PLSQL

Pro*C/Embedded SQL

BigQuery

Dataflow

Dataproc

Pub/Sub

Datastream

Cloud Composer

Cloud SQL/AlloyDB

Job description

About Ascendion

Ascendion is a leading provider of AI-Native software engineering services. Our applied AI, software engineering, cloud, data, experience design, and talent transformation capabilities accelerate innovation for Global 2000 clients. Ascendion is headquartered in New Jersey. In addition to our remote/hybrid workforce, we have a presence in 12 countries and 40+ global offices across North America, Europse, and APAC. We are committed to building technology powered by Generative AI with an inclusive workforce, service to our communities, and a vibrant culture. For more information, please go to www.ascendion.com.

Experience a community of change makers!

Join a culture of high-performing innovators with endless ideas and a passion for tech. Our culture is the fabric of our company, and it is what makes us unique and diverse. The way we share ideas, learning, experiences, successes, and joy allows everyone to be their best at Ascendion.

Role Overview:

We are seeking a hands-on Data Architect – GCP to lead the modernization and migration of legacy data workloads from Oracle, Informatica PowerCenter, Pro*C, PL/SQL, and SQL-based applications to Google Cloud Platform (GCP).

The role combines deep expertise in legacy data technologies with GCP architecture, data engineering, migration strategy, governance, modernization, and production delivery. The ideal candidate will be comfortable working hands-on with complex migration challenges while providing technical leadership to distributed engineering teams and engaging with client stakeholders.

Key Responsibilities

• Assess and analyze Oracle schemas, PL/SQL programs, Informatica mappings/workflows, Pro*C programs, SQL scripts, schedules, dependencies, data volumes, interfaces, and data lineage to define migration and modernization strategies.
• Define scalable and secure GCP target architectures leveraging BigQuery, Cloud Storage, Dataflow, Dataproc, Cloud Composer, Pub/Sub, Datastream, Cloud SQL, AlloyDB, and other relevant GCP services.
• Analyze and map Oracle data types, partitioning, indexing, constraints, sequences, stored procedures, packages, triggers, and embedded business logic to GCP-native solutions, identifying opportunities for refactoring and modernization.
• Lead the modernization of Informatica PowerCenter mappings, sessions, and workflows into GCP-native patterns using SQL, Dataflow/Apache Beam, Dataproc/Spark, and Cloud Composer.
• Design and implement bulk and incremental data migration, CDC, orchestration, restartability, idempotency, error handling, auditability, lineage, observability, security, and cost/performance optimization.
• Assess and modernize Pro*C and embedded SQL workloads, including host variables, cursors, transaction handling, file processing, and batch processing patterns.
• Establish robust data reconciliation and traceability frameworks covering record counts, control totals, balances, transformations, data integrity, and critical business rules.
• Lead migration testing, data validation, performance testing, cutover planning, rollback strategy, production readiness, and hypercare.
• Define and enforce data engineering standards, coding practices, architecture patterns, security controls, and CI/CD practices across the migration program.
• Evaluate and incorporate Agentic AI capabilities and industry-standard agentic implementation platforms where they can accelerate migration, modernization, testing, documentation, or operational processes.
• Communicate architecture decisions, technical risks, dependencies, assumptions, and delivery readiness to client stakeholders, architects, and distributed engineering teams.
• Provide hands-on technical guidance and troubleshoot complex migration and production issues across the data platform.

Required Experience & Skills

• 10+ years of experience in data engineering, ETL, database migration, data architecture, or data modernization, including 5+ years in a senior technical leadership or architect role.
• Strong experience in data migration and modernization programs, preferably involving large-scale Oracle and Informatica environments.
• Deep expertise in Oracle SQL and PL/SQL, including schemas, packages, procedures, triggers, execution plans, partitioning, indexing, bulk processing, performance tuning, and large-volume data migration.
• Strong understanding of Informatica PowerCenter, including repository objects, mappings, sessions, workflows, parameterization, dependencies, troubleshooting, performance tuning, and migration assessment.
• Working knowledge of Pro*C and embedded SQL, including host variables, cursors, transaction control, file processing, and modernization/refactoring approaches.
• Hands-on experience with GCP data services, including:
• BigQuery
• Cloud Storage
• IAM and security
• VPC Service Controls
• Cloud Composer
• Dataflow / Apache Beam
• Dataproc / Spark
• Pub/Sub
• Datastream
• Cloud SQL / AlloyDB
• Cloud Logging and Monitoring
• Strong expertise in BigQuery data modeling, partitioning, clustering, SQL optimization, batch and streaming ingestion, governance, metadata, lineage, reconciliation, security, and cost optimization.
• Proficiency in Python, SQL, Shell scripting, Git, CI/CD, and Terraform or equivalent Infrastructure-as-Code tools.
• Experience with production deployment, monitoring, troubleshooting, and operational support of enterprise data platforms.
• Knowledge of Agentic AI implementation and experience working with industry-standard agentic platforms is preferred.
• Strong analytical and problem-solving skills with the ability to translate complex legacy business logic into secure, scalable, maintainable, and supportable GCP solutions.
• Proven ability to lead distributed/global engineering teams and work effectively with client stakeholders.

Preferred Qualifications

• Google Professional Data Engineer or Google Cloud Professional Cloud Architect certification.
• Experience with Oracle-to-BigQuery migration programs.
• Experience modernizing Informatica PowerCenter workloads to cloud-native data engineering platforms.
• Experience with database conversion and migration assessment tools.
• Experience with Terraform, dbt, and data-quality frameworks.
• Experience with automated data reconciliation, validation, and migration testing frameworks.
• Domain experience in Retail, Supply Chain, Inventory, Pharmacy, or Enterprise Reporting/Analytics.
• Experience with large-scale legacy modernization and transformation programs.

Join Ascendion

Be part of a team building next-generation AI solutions and helping enterprises accelerate innovation through Generative AI.