Senior Manager
EXL · Pune, Maharashtra · Full-time
Core Technologies
• DBT (Data Build Tool)
• Google BigQuery
• SQL
• Python
• PySpark
• Git
GCP Services
• BigQuery
• Cloud Storage
• Dataproc
• Cloud Composer (Airflow)
• Dataflow
• IAM
SAS Migration & Modernization
• Analyze existing SAS datasets, ETL jobs, PROC SQL code, and SAS macros.
• Convert SAS transformation logic into DBT models and cloud-native data pipelines.
• Support migration of historical and incremental data from SAS platforms to GCP.
• Participate in migration assessments, code conversion, and reconciliation activities.
Data Engineering & Development
• Design and develop scalable ELT pipelines using DBT and BigQuery.
• Build and optimize data ingestion, transformation, and aggregation processes.
• Develop reusable and modular DBT models following best practices.
• Implement performance tuning for SQL and BigQuery workloads.
• Create and maintain data lineage and metadata documentation.
Data Quality & Reconciliation
• Design and implement data quality validation frameworks.
• Perform source-to-target reconciliation between SAS and GCP platforms.
• Investigate and resolve data inconsistencies and migration issues.
• Support automated testing and monitoring of data pipelines.
Graduate in Computer Science, Data Science, or related field. 6-8 years of experience in data engineering or related field.