Connecting Odds
HCLTech

Lead Consultant(Development)

HCLTech
Sholinganallur, Tamil Nadu, IndiaPosted about 1 month agoDiscoveredMatch locked
Full-time7+ years exp

Role Purpose

The Migration ETL Developer will play a critical technical role in core banking transformation programmes, focusing on the design, development, and execution of secure, high-quality data migration flows into target systems such as Temenos T24. Using

Informatica PowerCenter and Informatica Intelligent Data Management Cloud (IDMC)

, the developer will ensure efficient extraction, transformation, cleansing, and loading of sensitive banking data while maintaining strict compliance with data governance and privacy standards.

Key Responsibilities

  • Design, develop, and maintain

robust ETL workflows

using

Informatica (on-premise and cloud - IDMC

) to support large-scale data migration from heterogeneous source systems.

  • Experience in using Powerexchange to access Mainframe source system would be an added advantage.
  • Implement scalable data integration jobs covering

extract, transform, cleanse, enrich, and load (ETL/ELT)

processes within both batch and near-real-time environments.

  • Conduct

data profiling

to assess source data quality, uncover inconsistencies, duplicates, missing values, and structural anomalies affecting migration integrity.

  • Collaborate with Business Analysts and Data Architects to interpret mapping specifications and translate them into executable ETL logic.
  • Perform

reconciliation and delta analysis

between source and target systems to validate completeness, accuracy, and consistency of migrated datasets.

  • Troubleshoot and resolve performance bottlenecks, connectivity issues, and job failures across development, testing, and production environments.
  • Securely handle

client-sensitive data

in line with Swiss banking regulations (FIDLEG, MAR, GDPR) and Julius Baer's internal data protection policies.

  • Document ETL designs, data lineage, interface specifications, and support operational handover post-go-live.
  • Participate in agile sprints, code reviews, testing cycles (SIT/UAT), and production cutover activities.

Essential Qualifications

  • Minimum

7-10 years of ETL development experience

in enterprise banking or financial services environments.

  • Proven hands-on expertise with

Informatica PowerCenter

and

Informatica Cloud (IDMC preferred)

, including connectors, taskflows, and monitoring dashboards.

  • Strong skills in

SQL, PL/SQL

, and relational databases (Oracle, Microsoft SQL Server, DB2).

  • Demonstrated experience in

data profiling, quality assessment, and reconciliation techniques

.

  • Solid understanding of dimensional modelling, metadata management, and CDC (Change Data Capture) concepts.
  • Familiarity with DevOps practices, CI/CD pipelines, and version control (Git).

Preferred Attributes

  • Prior involvement in

core banking migrations

(e.g., to T24, FinSuite, or equivalent).

  • Exposure to cloud platforms (

AWS, Azure

) and integration with IDMC.

  • Basic knowledge of banking domains: client master, accounts, holdings, transactions, limits.
  • Awareness of Swiss regulatory requirements impacting data handling and reporting.

Technical Accountabilities

  • Deliver high-performance, well-documented ETL solutions meeting functional and non-functional requirements.
  • Ensure all data movements are

auditable, reversible, and error-handled

according to bank standards.

  • Guarantee successful end-to-end data reconciliation across migration waves.

Not included in the source posting: about the role, benefits.

Skills

etlsqlawsazureci-cddevopsgitagilego

Who can apply

The employer didn't state any visa, work authorization, citizenship or clearance requirements in this posting. Confirm with the employer before applying.

Read automatically from the employer's posting text. Always confirm with the employer — requirements can change after a job is published.

Apply