Python , web scrapping data conversion VBA

Company Description:

WNS, part of Capgemini, is an Agentic AI-powered leader in intelligent operations and transformation, serving more than 700 clients across 10 industries, including Banking and Financial Services, Healthcare, Insurance, Shipping and Logistics, and Travel and Hospitality. We bring together deep domain excellence – WNS’ core differentiator – with AI-powered platforms and analytics to help businesses innovate, scale, adapt and build resilience in a world defined by disruption.Our purpose is clear: to enable lasting business value by designing intelligent, human-led solutions that deliver sustainable outcomes and a differentiated impact. With three global headquarters across four continents, operations in 13 countries, 65 delivery centers and more than 66,000 employees, WNS combines scale, expertise and execution to create meaningful, measurable impact.

Job Description:

Location : Gurgaon

Hybrid working

UK time zone

Exp : 5+ Yrs

 

 

Skills and Experience

 

Must-Have Skills

 

  • 5+ years of hands-on experience in Data Engineering, Data Automation, or Data Pipeline development.
  • Strong Python expertise with experience building and maintaining production-grade data pipelines.
  • Data ingestion experience using APIs, web scraping, and file-based sources (Excel, HTML, JSON, XML).
  • Strong working knowledge of Pandas, NumPy, Requests, BeautifulSoup, Selenium.
  • Solid understanding of data pipeline architecture, modular design, reusability, and performance optimization.
  • Experience with workflow orchestration concepts such as scheduling, dependencies, retries, and monitoring.
  • Hands-on experience with logging, alerting, error handling, and monitoring for production workflows.
  • Proficiency with Git and strong coding, testing, and documentation standards.
  • Strong understanding of data quality, validation, governance, and schema evolution.
  • Ability to troubleshoot and resolve production data pipeline issues independently.

 

Nice-to-Have Skills

  • Experience with Decisions or similar workflow automation platforms.
  • Exposure to PySpark or distributed data processing frameworks.
  • Experience working with on-premise enterprise data ecosystems.
  • Experience mentoring junior engineers or influencing engineering best practices.
  • VBA

 

Key Responsibilities

 

  • Design and develop scalable, reusable data collection systems using APIs, web scraping, and file-based ingestion (e.g., Excel, HTML, JSON).
  • Lead development of Python-based data ingestion and automation methods for diverse data sources.
  • Integrate ingestion pipelines with enterprise data storage and processing layers, ensuring reliability, performance, and maintainability.
  • Ensure data quality, governance, and cross-system consistency in collaboration with backend, analytics, and UI teams.
  • Productionize Python-based analytical models for scalable, reliable execution in operational environments.
  • Enable end-to-end automation of data pipelines and workflows with minimal manual intervention.
  • Establish and enforce development standards including code structure, testing, documentation, logging, and error handling.
  • Contribute to internal workflow orchestration and Decisions-based transformation solutions.

 

Technical Environment

 

  • Python-based custom data pipeline framework
  • API-driven data access and web scraping
  • Decisions workflow automation (nice to have)
  • Internally managed workflow orchestration services

 

Qualifications:

Bachelor’s degree in Computer Science, Information Technology, Engineering, Mathematics, or a related fieldMaster’s degree in a relevant discipline is preferred but not mandatoryEquivalent practical experience in data engineering or data automation will be considered in lieu of formal education

 

Back to blog

Other Jobs To Apply

No other job posts for this day.

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...