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 Processes Proficient 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 cases Write 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 Python Validate 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 Server Strong 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
