Company Overview and Culture 

EXL (NASDAQ: EXLS) is a global analytics and digital solutions company that partners with clients to improve business outcomes and unlock growth. Bringing together deep domain expertise with robust data, powerful analytics, cloud, and AI, we create agile, scalable solutions and execute complex operations for the world’s leading corporations in industries including insurance, healthcare, banking and financial services, media, and retail, among others. Focused on creating value from data for driving faster decision-making and transforming operating models, EXL was founded on the core values of innovation, collaboration, excellence, integrity and respect. Headquartered in New York, our team is over 40,000 strong, with more than 50 offices spanning six continents. For information, visit www.exlservice.com.

For the past 20 years, EXL has worked as a strategic partner and won awards in its approach to helping its clients solve business challenges such as digital transformation, improving customer experience, streamlining business operations, taking products to market faster, improving corporate finance, building models to become compliant more quickly with new regulations, turning volumes of data into business opportunities, creating new channels for growth and better adapting to change. The business operates within four business units: Insurance, Health, Analytics, and Emerging businesses. 

Role and Responsibilities:

• Designed and Implemented ETL Processes:Spearhead the design and implementation of robust ETL solutions using Ab Initio software to ensure efficient data and selection, transformation and loading processes this included creating scalable and maintainable data pipelines that supported critical data-driven decisions.
• Performance Optimization:Regularly perform tuning and optimization of ETL processes to improve performance, reducing data processing time significantly and enhancing system reliability.
• Data Quality Assurance:  Implement data quality checks within the ETL workflows to ensure the accuracy and integrity of data, which reduce data discrepancies and improve trust in data-driven insights.
• Collaboration and Requirements Gathering:Work closely with Business analysts and other stakeholders to translate business needs into technical specifications ensuring that all data solutions were aligned with business objectives and user needs.
• Technical Leadership and Training:Provided technical guidance and training to junior developers fostering a collaborative team environment and enhancing overall team productivity and knowledge on Ab-Initio tools and best practices.
• Innovative Data Solutions:Introduced new techniques and components within Ab Initio suite such as the use of Meta-Environment (EME) for better meta data management which streamlines data operations and supported compliance with data governance standards.
• Continuous improvement:  Actively contributed to continuous improvement initiatives by proposing and implementing system enhancements that improve data processing workflows and reduced costs.

Candidate Profile:

Required Qualification and Skills:

• Experience in the Analysis, Design and Development of Data warehousing solutions and in developing strategies for Extraction, Transformation and Loading (ETL) mechanism using Ab Initio
• Solid experience as an RDBMS developer, with stored procedures, query performance tuning and ETL
• Hands-on experience creating graphs to meet complex business requirements
• Strong US healthcare experience
• Experience in handling Generic graphs, Plans, PSETs and complex ab initio graphs
• Extensive understanding on MFS, PDL is required
• Should have good understanding of SQL and ability to write simple/complex SQL's as per requirement.
• Experience with SQL performance tuning
• Familiar with basic unix commands (awk, sed, grep, find,etc) and 1-2 years experience writing unix scripts
• Experience with Express>IT, Conduct>IT, continuous flows will be preferred
• Experience integrating with Hadoop environment