EXL

Lead Assistant Manager

EXL  •  Pune, IN (Onsite)  •  2 hours ago
Apply
Save Job
Mark Applied Mark Interviewed Mark Offered
Hide Job Report Job
AI can make mistakes so check important info. Chat history is never stored.

Job Description

Data Engineering

  • SQL
  • Data Warehousing Concepts
  • ETL/ELT Development
  • Data Validation and Reconciliation
  • Data Pipeline Development

Cloud Technologies

  • Google Cloud Platform (GCP)
  • BigQuery
  • Cloud Storage
  • Cloud Composer (Airflow)

Development Tools

  • DBT (Data Build Tool)
  • Git/GitHub
  • Python (Basic to Intermediate)

SAS Knowledge

  • Understanding of SAS datasets
  • PROC SQL
  • SAS ETL concepts
  • SAS code analysis

Data Modeling Understanding

  • Star Schema
  • Dimension and Fact Tables
  • Source-to-Target Mapping
  • Data Lineage Concepts

SAS Migration Support

  • Analyze SAS programs, PROC SQL code, and SAS datasets.
  • Assist in converting SAS transformation logic into DBT models and SQL transformations.
  • Support migration of data from legacy SAS environments to GCP.
  • Participate in code conversion, testing, and reconciliation activities.

Data Pipeline Development

  • Develop and maintain ELT pipelines using DBT and BigQuery.
  • Build reusable transformation models following DBT best practices.
  • Implement data ingestion and processing workflows.
  • Support batch and incremental data processing requirements.

Data Transformation & Modeling

  • Develop SQL-based transformations for Bronze, Silver, and Gold layers.
  • Implement business rules and data quality validations.
  • Support dimensional models, fact tables, and dimension tables.
  • Assist Data Modelers and Architects in implementing target-state data models.

Data Quality & Testing

  • Perform source-to-target validation and reconciliation.
  • Support automated testing using DBT tests.
  • Investigate and resolve data quality issues.
  • Ensure completeness, accuracy, and consistency of migrated data.

GCP Development

  • Work with GCP services including:
    • BigQuery
    • Cloud Storage
    • Dataproc
    • Cloud Composer (Airflow)

Graduate in Computer Science, Data Science, or related field. 3-4 years of experience in data engineering or a 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
Website
exlservice.com
Social Media