Core Technologies

* DBT (Data Build Tool)
* Google BigQuery
* SQL
* Python
* PySpark
* Git

GCP Services

* BigQuery
* Cloud Storage
* Dataproc
* Cloud Composer (Airflow)
* Dataflow
* IAM

SAS Technologies

* SAS Base
* SAS Enterprise Guide
* PROC SQL
* SAS Macros
* SAS Data Sets

Data Engineering

* ETL / ELT Development
* Data Warehousing
* Data Pipeline Design
* Performance Optimization
* Data Validation & Reconciliation

Data Modeling

* Star Schema
* Snowflake Schema
* Dimensional Modeling
* Source-to-Target Mapping

RESPONSIBILITIES

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.

Cloud Platform Development

* Build and manage solutions using:
* BigQuery
* Cloud Storage
* Dataproc
* Cloud Composer (Airflow)
* Dataflow
* Support data security, access controls, and governance requirements.

Collaboration & Delivery

* Work closely with Data Architects, Business Analysts, Data Modelers, and QA
teams.
* Participate in design reviews and sprint planning sessions.
* Estimate effort and provide technica

📌 Manager (Hyderabad)
🏢 EXL
📍 Hyderabad