Ab Initio Developer, Healthcare Analytics

Hartford, CT, USA ● Virtual Req #26383
Tuesday, April 23, 2024

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

To view our total rewards offered click here —> https://www.exlservice.com/us-careers-and-benefits
Base Salary Range Disclaimer: The base salary range represents the low and high end of the EXL base salary range for this position. Actual salaries will vary depending on factors including but not limited to: location and experience. The base salary range listed is just one component of EXL's total compensation package for employees. Other rewards may include bonuses, as well as a Paid Time Off policy, and many region specific benefits. 
Please also note that the data shared through the job application will be stored and processed by EXL in accordance with the EXL Privacy Policy. 

Application & Interview Impersonation Warning – Purposely impersonating another individual when applying and / or participating in an interview in order to obtain employment with EXL Service Holdings, Inc. (the “Company”) for yourself or for the other individual is a crime.  We have implemented measures to deter and to uncover such unlawful conduct.  If the Company identifies such fraudulent conduct, it will result in, as applicable, the application being rejected, an offer (if made) being rescinded, or termination of employment as well as possible legal action against the impersonator(s).

EXL may use artificial intelligence to create insights on how your candidate information matches the requirements of the job for which you applied. While AI may be used in the recruiting process, all final decisions in the recruiting and hiring process will be taken by the recruiting and hiring teams after considering a candidate’s full profile. As a candidate, you can choose to opt out of this artificial intelligence screening process. Your decision to opt out will not negatively impact your opportunity for employment with EXL.

Other details

  • Pay Type Salary
  • Min Hiring Rate $90,000.00
  • Max Hiring Rate $110,000.00
Location on Google Maps
  • Hartford, CT, USA
  • Virtual