Logo
EXL Service

Lead Assistant Manager - Informatica Developer

EXL Service, Pittsburgh, PA


Company Overview and Culture

EXL (NASDAQ: EXLS) is a leading data analytics and digital operations and solutions company. We partner with clients using a data and AI-led approach to reinvent business models, drive better business outcomes and unlock growth with speed. EXL harnesses the power of data, analytics, AI, and deep industry knowledge to transform operations for the world's leading corporations in industries including insurance, healthcare, banking and financial services, media and retail, among others. EXL was founded in 1999 with the core values of innovation, collaboration, excellence, integrity and respect. We are headquartered in New York and have more than 55,000 employees spanning six continents. For more information, visit http://www.exlservice.com.

We are seeking a highly skilled Informatica ETL Developerwith 5-7 years of experience, preferably in the credit card or banking industry, to join our dynamic team. The ideal candidate will have expertisein Informatica PowerCenterand experience in ETL developmentfor financial data environments. This role involves designing and implementing data pipelines to support critical banking processes, ensuring data integrity, performance optimization, and compliance with industry regulations.

Key Responsibilities:

  • Design, develop, and implement efficient ETL workflows using Informatica PowerCenter, specifically for credit card and banking systems.
  • Create and maintain ETL mappings, sessions, and workflowsto extract, transform, and load data from various financial data sources.
  • Collaborate with business analysts, data architects, and stakeholdersto understand and fulfill business requirements in the context of banking and credit card systems.
  • Perform data quality checks, data validation, and troubleshooting of ETL processes to ensure the accuracy and integrity of financial data.
  • Develop solutions to integrate and transform large volumes of data from banking systems, credit card transaction databases, and other financial platforms.
  • OptimizeETL processes for performance and scalability, considering the complexities of financial data.
  • Troubleshoot and resolve data pipeline and ETL performance issues, ensuring the availability of critical financial data for reporting and analysis.
  • Work closely with data governanceteams to ensure that the data used in financial reporting meets compliance and security standards.
  • Document all ETL processes and workflows to ensure they align with auditing and regulatoryrequirements.


Required Skills and Qualifications:

  • 5-7 yearsof hands-on experience in ETL developmentusing Informatica PowerCenterin banking/credit cardenvironments.
  • Individual with experience in Mainframe/AS400 as a source system to enhance data integration and reporting processes.
  • Strong knowledge of SQLand experience working with relational databasessuch as Oracle, SQL Server, MySQL, or similar.
  • Experience with credit card transaction data, banking systems, and financial data models.
  • Familiarity with data governance, data securitystandards, and regulatory compliance in the banking/credit card industry.
  • Experience in integrating data from multiple financial sources such as transaction logs, payment systems, and customer information systems.
  • Experience with Agile/Scrummethodologies in a financial services setting.
  • Proficiencyin ETL performance tuningand troubleshooting in high-volume financial data environments.
  • Strong understanding of data warehousing conceptsand data modelingin the context of banking data.
  • Experience with scheduling toolssuch as Control-M, AutoSys, or others for managing ETL workflows.
  • Excellent analytical and problem-solving skills in a fast-paced, financial services environment.


Education:

  • Bachelor's Degree in Computer Science, Information Technology, Engineering, or a related field.
  • Additionalcertification in Banking Technologyor Financial Data Managementis a plus.


Good to Have Skills:

  • Experience with cloud platformssuch as AWS, Azure, or Google Cloudfor banking data environments.
  • Knowledge of big data tools(e.g., Hadoop, Spark) or cloud data serviceslike Redshift, Snowflake, BigQueryfor financial data processing.
  • Programming knowledge in PL/SQL, Python, or other scripting languages.
  • Familiarity with banking reporting toolsand regulatory reporting requirements.
  • Knowledge of data privacy regulations(e.g., PCI-DSS, GDPR) and ensuring compliance in ETL processes.


Soft Skills:

  • Strong communicationand collaboration skills with experience working in cross-functional banking teams.
  • Ability to effectively prioritize and manage multiple financial data projects.
  • Strong attention to detail, particularly in the context of sensitive financial data.


EEO/Minorities/Females/Vets/Disabilities

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


Apply Now