1 month ago
Hyderābād, IndiaStaff+
Responsibilities
- Analyze SAS programs, PROC SQL code, and SAS datasets for migration support.
- Convert SAS transformation logic into dbt models and SQL transformations.
- Support migration from legacy SAS environments to Google Cloud Platform.
- Develop and maintain ELT pipelines using dbt and BigQuery.
- Build reusable transformation models and data ingestion and processing workflows.
- Support batch and incremental data processing requirements.
- Develop SQL transformations for Bronze, Silver, and Gold data layers.
- Implement business rules, dimensional models, fact tables, and dimension tables.
- Perform source-to-target validation and reconciliation and investigate data quality issues.
- Support automated testing using dbt tests.
- Manage data engineering projects, provide strategic guidance, oversee the data engineering team, and improve data processes.
Requirements
- Knowledge of SQL, data warehousing concepts, ETL/ELT development, data validation and reconciliation, and data pipeline development.
- Experience or knowledge with Google Cloud Platform, BigQuery, Cloud Storage, Dataproc, and Cloud Composer (Airflow).
- Experience with dbt, Git, GitHub, and basic to intermediate Python.
- Understanding of SAS datasets, PROC SQL, SAS ETL concepts, and SAS code analysis.
- Understanding of star schemas, dimension and fact tables, source-to-target mapping, and data lineage concepts.
Tech Stack
Categories
Data Engineering
About EXL
EXL provides data analytics, AI, and digital operations services for enterprises in insurance, healthcare, banking, and other regulated industries. It delivers consulting, managed services, and technology platforms to improve decision-making, risk management, and operational efficiency. Founded in 1999 and headquartered in New York, EXL is a public company listed on the NASDAQ (ticker: EXLS).