EXL

Assistant Manager

EXL  •  Bengaluru, IN (Onsite)  •  2 days ago
Apply
AI can make mistakes so check important info. Chat history is never stored.

Job Description

Core Technical Skills

  • Strong Python programming experience
  • Advanced SQL
  • DBT development
  • Google BigQuery
  • PySpark
  • Data engineering and ETL/ELT pipeline development
  • Data validation and reconciliation
  • Data migration experience

Python Libraries & Frameworks

  • Pandas
  • NumPy
  • PyArrow
  • Pytest
  • Great Expectations or similar data quality framework
  • Google Cloud Python SDK

GCP Services

  • BigQuery
  • Cloud Storage
  • Cloud Composer / Airflow
  • Dataproc
  • Dataflow
  • IAM
  • Cloud Logging and Monitoring

SAS Migration & Code Conversion

  • Analyse existing SAS datasets, SAS programs, PROC SQL, Data Steps, and SAS macros.
  • Convert SAS business logic into Python, SQL, PySpark, and DBT models.
  • Support migration of historical and incremental SAS data into GCP.
  • Document SAS-to-GCP transformation logic and technical conversion rules.
  • Assist in identifying reusable patterns for SAS macro conversion.

Python Data Engineering

  • Develop Python-based data processing, automation, and validation scripts.
  • Build reusable Python frameworks for data ingestion, transformation, and reconciliation.
  • Use Python libraries such as Pandas, NumPy, PyArrow, and Google Cloud SDK.
  • Automate data quality checks, file processing, metadata extraction, and exception reporting.
  • Develop utilities to compare SAS outputs with GCP outputs.

DBT & BigQuery Development

  • Develop and maintain DBT models for transformation logic.
  • Convert SAS PROC SQL logic into DBT SQL models.
  • Implement DBT tests for data quality, uniqueness, referential integrity, and business rules.
  • Support Bronze, Silver, and Gold layer implementation in BigQuery.
  • Optimize SQL queries and BigQuery tables for performance and cost efficiency.

GCP Data Pipeline Development

  • Build scalable data pipelines using GCP services such as:
  • BigQuery
  • Cloud Storage
  • Cloud Composer / Airflow
  • Dataproc
  • Dataflow
  • Cloud Functions
  • Develop batch and incremental data processing workflows.
  • Support orchestration, monitoring, and production deployment of pipelines.
  • Implement secure data movement from legacy SAS platforms to GCP.

Data Quality, Validation & Reconciliation

  • Perform source-to-target reconciliation between SAS and GCP.
  • Validate record counts, financial totals, business rules, and derived metrics.
  • Investigate and resolve data mismatches and transformation defects.
  • Build automated reconciliation reports using Python and SQL.
  • Support SIT, UAT, regression testing, and production validation.

Graduate in Computer Science, Data Science, or related field. 2-3 years of experience in data engineering or related field.

EXL

About EXL

Choosing a digital partner is about more than capabilities — it’s about collaboration and character.

Unrealistic overhauls and off-the-shelf products ignore what matters most — your unique needs, culture, goals, and your legacy data and technology environments.

At EXL, our collaboration is built on ongoing listening and learning to adapt our methodologies. We’re your business evolution partner—tailoring solutions that make the most of data to make better business decisions and drive more intelligence into your increasingly digital operations.

Whether your goals are scaling the use of AI and digital, redesign operating models, or driving better and faster decisions, we’re here to partner with you to help you gain—and maintain—competitive advantage with efficient, sustainable models at scale.

Our expertise in transformation, data science, and change management helps make your business more efficient and effective, improve customer relationships and enhance revenue growth. Instead of focusing on multi-year, resource- and time-intensive platform designs or migrations, we look deeper at your entire value chain to integrate strategies with impact.

We use our specialization in analytics, digital interventions, and operations management—alongside deep industry expertise — to deliver solutions that help you outperform the competition.

At EXL, it’s all about outcomes—your outcomes—and delivering success on your terms. Share your goals with us and together, we’ll optimize how you leverage data to drive your business forward.

For more information, visit www.exlservice.com.

Industry
Consulting & Advisory
Company Size
10,000+ employees
Headquarters
New York, NY
Year Founded
Unknown
Social Media