About Us
Solytics Partners is a Global Analytics firm, recognized with multiple industry awards for innovation and excellence. Our team comprises experts with deep domain knowledge in risk, analytics, AI/ML, AML/FCC, and fraud. By converging this expertise with cutting-edge technologies like AI, Machine Learning, Generative AI, and Large Language Models (LLMs), we deliver powerful automated platforms and incisive point solutions. Our offerings enable clients to streamline and future-proof their risk, AML, and analytics processes, comply seamlessly with global regulations, and safeguard financial systems. Whether it’s solving complex challenges or driving operational efficiency, Solytics Partners is committed to empowering organizations with transformative tools to stay ahead in an evolving regulatory landscape.
Job Summary:
Every EMoT implementation starts with getting the client's data in cleanly. You will write and own the ETL scripts that move customer, account and transaction data from client source systems into EMoT. Each client runs a different stack, so you will adapt quickly to new tools while leading a small team of ETL developers.
Key Responsibilities:
- Write, test and maintain ETL scripts and pipelines that load client data into EMoT's data model.
- Analyse client source systems (core banking, cards, payments, trade finance, KYC) and build source-to-target mappings with the BA.
- Build data quality checks: completeness, reconciliation of counts and amounts, duplicates, referential integrity, reference data validation
- Set up batch and incremental loads; schedule, monitor and handle failures and reruns.
- Tune SQL and pipeline performance for high transaction volumes.
- Run historical data migration for go-live and look-back analysis.
- Work with client IT teams on data extracts, file formats, connectivity and security requirements.
- Support QA and client UAT with data validation and defect fixes.
- Create reusable ETL templates and accelerators to shorten future implementations.
- Lead, review and mentor a small team of ETL developers; own estimates and delivery timelines for the data workstream.
Key Requirements:
Must have:
- 5+ years in ETL or data engineering, with hands-on script writing.
- Expert SQL and stored procedures on at least one major database (Oracle, SQL Server, PostgreSQL or similar).
- Scripting in Python and/or shell for data processing and automation.
- Experience with source-to-target mapping, data reconciliation and data quality controls.
- Ability to pick up a client's ETL tool quickly and work across different stacks
Good to have:
- Hands-on with more than one ETL or orchestration tool: Informatica, Talend, SSIS, ODI, Apache Airflow, NiFi.
- Big data and cloud: Spark/PySpark, Hadoop, AWS Glue, Azure Data Factory, Databricks, Snowflake
- Banking data experience, especially core banking systems (Finacle, Flexcube, T24 or similar).
- Prior AML, fraud or regulatory reporting implementations.
- Experience leading a delivery team on client projects.