The Role
Develops and executes ETL test cases, validates source-to-target mappings, and performs complex SQL-based data validation across environments. Creates Python automation scripts for data cleansing and testing, conducts data profiling and quality checks, analyzes root causes, and tracks defects using test management tools. Supports Power BI data modeling and visualization, gathers client requirements, documents projects, and works within Agile/Scrum teams. Requires strong business analysis, data warehousing, Oracle and SQL Server expertise.
Summary Generated by Built In
Python & Power BI - JOB DESCRIPTION ;EXL (NASDAQ:EXLS) is a leading operations management and ;analytics company that helps businesses enhance growth and profitability in the face of relentless competition and continuous disruption. Using our proprietary, award-winning Business EXLerator Framework™, which integrates analytics, automation, benchmarking, BPO, consulting, industry best practices and technology platforms, we look deeper to help companies improve global operations, enhance data-driven insights, increase customer satisfaction, and manage risk and compliance. EXL serves the insurance, healthcare, banking and financial services, utilities, travel, transportation and logistics industries. Headquartered in New York, New York, EXL has more than 24,000 professionals in locations throughout the United States, Europe, Asia (primarily India and Philippines), Latin America, Australia and South Africa. ;EXL Analytics provides data-driven, action-oriented solutions to business problems through statistical data mining, cutting edge analytics techniques and a consultative approach. Leveraging proprietary methodology and best-ofbreed technology, EXL Analytics takes an industry-specific approach to transform our clients’ decision making and embed analytics more deeply into their business processes. Our global footprint of nearly 2,000 data scientists and analysts assist client organizations with complex risk minimization methods, advanced marketing, pricing and CRM strategies, internal cost analysis, and cost and resource optimization within the organization. EXL Analytics serves insurance, healthcare, banking, capital markets, utilities, retail and e-commerce, travel, transportation and logistics industries. ;Please visit www.exlservice.com for more information about EXL Analytics. ;Role Overview and Responsibilities:Develop and execute test cases for ETL ProcessesProficient in SAS by developing programs, data transformation and Data testing.Business Analysis understanding with Power BI Data modelling and SQL knowledge.Exposure on Python for Automation and Data cleansing & standardization.Analyze ETL requirements and source-to-target mappings (STTM) to design comprehensive test scenarios and test casesWrite and run complex SQL queries for data validation across different environments. ;Log and track defects using tools like Jira, ALM, Bugzilla etc.Create automated test scripts using PythonValidate data quality, data profiling, and data cleansing processes across source and target systems.Review and validate source-to-target data mappings and transformation logic. ;Good Communication and exposure with client related requirement gathering.Finance Analysis reporting management & quicker solutions providing attitude.Project and Automation Documentation and Log tracker management skills.Business Data modelling and Power BI/Tableau Visualization Experience. ;Required Skills & Experience: ;5+ years of Business analysis experience with a minimum of 2+ years of python, power bi and SQL. ;Mandatory Oracle & SQL ServerStrong expertise in writing and optimizing SQL queries, sub queries and complex joins & stored procedures validations. (Oracle, SQL Server, PostgreSQL, etc.). ;Understanding data warehouse concepts (fact/dimension tables, star/snowflake schema). ;Working exposure to test the data ingestion/curation pipelines. ;Knowledge of data profiling, data quality checks, and root cause analysis ;Experience with test management tools (JIRA, Quality Center, Azure DevOps, Rally etc.,).Proficient in analyzing data issues and tracing root causes. ;Working exposure with agile/scrum methodologies. ;Outstanding written and verbal communication skills ;What do we offer: ;EXL Analytics offers an exciting, fast paced and innovative environment, which brings together a group of sharp and entrepreneurial professionals who are eager to influence business decisions. From your very first day, you get an opportunity to work closely with highly experienced, world-class analytics consultants. You can expect to learn many aspects of businesses that our clients engage in. You will also learn effective teamwork and timemanagement skills - key aspects for personal and professional growth. Analytics requires different skill sets at different levels within the organization. At EXL Analytics, we invest heavily in training you in all aspects of analytics as well as in leading analytical tools and techniques. We provide guidance/ coaching to every employee through our mentoring program wherein every junior level employee is assigned as a senior level professional as advisors. Sky is the limit for our team members. The unique experiences gathered at EXL Analytics sets the stage for further growth and development in our company and beyond
About the TeamEXL is the indispensable partner for leading businesses in data-led industries such as insurance, banking and financial services, healthcare, retail and logistics. We bring a unique combination of data, advanced analytics, digital technology and industry expertise to help our clients turn data into insights, streamline operations, improve customer experience, and transform their business. Our partnerships with clients are built on a foundation of collaboration – and we’ve been chosen as a partner by nine of the top ten leading US insurance companies, nine of the top 20 global banks, and six of the top ten US health care payers. We function as one team to make your goals our goals, whether that’s unlocking the value of generative AI or embedding analytics into workflows that reduce risk or power your growth. Clients choose EXL as their transformation partner for many reasons. Our geographic diversity make talent all over the world instantly accessible. Digital accelerators enable unmatched speed-to-value, letting you realize results fast. It’s our people that truly set us apart, though, including the 1,500 data scientists we have dedicated to our generative AI practice. And our more than twenty years of experience in delivering business services, garnering stellar client references, and maintaining a solid balance sheet are reassuring to our C-suite clients. Find out for yourself why clients, employees, and analysts think we’re some of the best in the business. Contact us to see how we can help you achieve your goals.
Skills Required
- 5+ years of business analysis experience
- 2+ years of experience with Python, Power BI, and SQL
- Proficiency in SAS programming, data transformation, and data testing
- Strong Oracle and SQL Server experience
- Expertise writing and optimizing complex SQL queries, subqueries, joins, and stored procedure validations
- Understanding of data warehouse concepts, including fact and dimension tables and star or snowflake schemas
- Experience testing data ingestion and curation pipelines
- Knowledge of data profiling, data quality checks, and root cause analysis
- Experience with test management tools such as Jira, Quality Center, Azure DevOps, or Rally
- Experience analyzing data issues and tracing root causes
- Working exposure to Agile/Scrum methodologies
- Strong written and verbal communication skills
- Power BI or Tableau data modeling and visualization experience
- Client-related requirements gathering experience
EXL Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about EXL and has not been reviewed or approved by EXL.
-
Healthcare Strength — Medical plan options include HSA, HRA, and PPO choices, with additional health-related programs such as disability coverage and an employee assistance program. Feedback suggests these options provide meaningful flexibility and coverage breadth for many roles.
-
Leave & Time Off Breadth — Up to 20 days of paid time off, plus federal holidays and paid sick and safe time, are highlighted. Feedback suggests this leave structure is a notable benefit alongside core compensation.
-
Retirement Support — A traditional and Roth 401(k) with up to a 3% company match and full vesting after one year is described. Feedback suggests this match and vesting timeline help bolster long-term savings.
EXL Insights
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
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.
