Senior Data Engineer (Informatica & Databricks)

APARNA YAVAGAL

Singapore PR

Email: ******.*******@****.***.**

Linked-in: https://www.linkedin.com/in/aparnayavagal

Hand Phone: +65 93394437

Seeking Data Engineer role

12+ years, experience as Informatica Developer\IDMC, Databricks, Pyspark, Genie AI Integration, AWS, Oracle SQL, UNIX shell scripting.

CDI-IDMC R41 certified – June 2024

Databricks Associate Data Engineer Certification – Taking on 11thoct, 2026

Technology Skills at a glance:

Operating Systems\Cloud

RHEL 7.9, AIX, AS400, Azure, WIN-NT, DOS

Languages

SQL, PL/SQL, Shell Scripting, Python

RDBMS

Oracle 9i/10g/19.2.1

Data Warehousing Tools

Informatica 9.x, 10.4, 10.5.5, Power BI, Business Objects, Toad, Power BI, Ab Initio

MS Office suite

Excel, Word, PowerPoint

Soft Skills

Team player, attention to detail, positive attitude, problem solver (passionate about Troubleshooting)

Experience at a glance:

1.

Oct 2025- Till date

Helius technologies – For Synapxe

2.

Nov 2023 – Oct 2025

JonDavidson for UOB

3.

April 2022 – Oct 2023

LTI Mindtree Limited, Singapore

4.

Sep 2021 – April 2022

Canarys APAC Pte., Ltd.

5.

May 2015 – Aug 2021

Maternity Leave

6.

June 2012 - April 2015

NETS, Singapore

7.

March 2012 – June 2015

IBM, Singapore

8.

Jan 2012 – Feb 2012

Between Jobs

9.

Oct 2010 – Dec 2011

NETS, Singapore

10.

Jan 2009 – Sep 2010

Maternity Leave

11.

Jan 2005 – Dec 2008

Srishti IT Solutions (p) Ltd. (SITS), Bangalore, India

Achievements 2015 - 2025:

•Trained and Certified in Cloud Data Integration Developer R41, Informatica certified professional – June 2024.

•Have been trained on Microsoft Azure DevOps from Canarys, India Feb 2021 – Aug 2021

•Completed associate Data Analyst Course with NTUC Learning Hub (SGUS) Nov 2020 – Aug 16 2021

•Trained on Hadoop and big data technology (PIG and HIVE) in 2016

Certifications:

1.Cloud Data Integration Developer R41, Informatica certified professional (June 2024).

2.Oracle Certified Professional (OCP) (Nov2009)

3.PowerCenter8 Mapping Design (July2010) and

4.PowerCenter8 Architecture and Administration (Aug2010)

ETL Summary:

•10+ years exp as Informatica developer with excellent troubleshooting skills.

•Experience in Datawarehousing (DWH) and ETL-Informatica.

•Experience in Informatica 10.x,9.x, 8.x, Business Objects XI r2/r3 and Oracle 9i/10g/11g/19c.

•Have involved in all phases of SDLC.

•Designed and developed Informatica mappings to load data from Source systems.

•Developed mappings to extract data from flat files and load to Staging area in Oracle database.

•Developed mappings to extract data from staging area and load to Dimensions and Facts.

•Involved in tracking, monitoring of daily ETL loads, resolving issues in Production.

•Finding new areas for improvement and suggesting the steps for enhancements.

•Designed complex mappings and expertise in performance tuning.

•Optimized session performance by eliminating performance bottlenecks (Mapping bottleneck).

•Prepared test cases and tested mappings thoroughly.

•Involved in Informatica Administration activities including installing/uninstalling on production/UAT/SIT/PROD box.

•Maintain database using stored procedures, functions, triggers and other PL/SQL objects to perform various database activities.

•Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.

•Excellent written and verbal communication skills.

Professional Experience:

Helius technologies – For Synapxe

October 2025 – Till date

AS Data Engineer – Tech Lead

Managed and mentored 2 team members, assigning tasks and conducting thorough checks to maintain accuracy and efficiency.

Designed and deployed ETL pipelines in Databricks processing 2TB+ daily data, reducing runtime by 30%.

Migrated legacy workflows to Informatica IDMC, cutting maintenance costs by 15%.

Automated anomaly detection with Genie AI, improving data quality checks by 25%.

Developed Python scripts for batch and streaming data ingestion, achieving 90% faster query response.

Implemented Python-based monitoring tools to track pipeline health and reduce downtime.

Supported migration of on-premise data warehouse to AWS cloud infrastructure.

Jon Davidson – For UOB Singapore November 2023 – October 2025

As ETL Developer

Job responsibilities as ETL Developer (Informatica 10.4/10.5.5, Oracle SQL 19.2.1, AS400, RHEL 7.9)

Involved in AML E2E projects for UOB.

Develop /enhance current BAU DW mappings/sessions/workflows in informatica for various Projects for End-to-End Recon (E2E Recon) for TM & KYC projects14+ countries like MY/HK/OB/TH/TC/ID/PH/SG/TW/VN and DCRP (support).

Databricks for data integration, transformation, and processing.

Consistently delivered code and related documents on time for every project.

Integrate data from various sources AS400/Oracle/Flat files into dev environments, ensuring data consistency and quality, into various targets Oracle/Flat files.

Implement automation for routine tasks, such as deployment tasks, sanity check, string replacements using UNIX shell scripts.

Identify and resolve data-related issues and provide support to ensure data availability and integrity.

Laise with client for requirements, issues and fixes.

Prepare data for Unit Testing.

Involved in Development Master (Dev Master), Technical Design Document (TDD S523), Unit Testing (UT) and UT Document (SB002) and deployment document Preparation.

Resolve JIRA’s during SIT, UAT, MR.

Any other ad hoc tasks as assigned by the PIC.

Aware of IDMC concepts CDI-PC to migrate from on-prem to IDMC, Data Masking, Synchronisation Task, Replication Task, CAI.

LTIMindtree April 2022 – October 2023

As Specialist – Cloud and Infra Services – For Citibank, Singapore

Job responsibilities as ETL Admin for GCB and GPA Projects.

Abinitio Software Installation and upgrade.

Server License key installation.

Resolve tickets with the SLA timeframe.

Query>IT, Express>IT Installation and upgrade.

Control Center Installation, adding, removing users.

Setup-MFS filesystem, project directory creation.

War file deployment, start/stop Tomcat.

Upgrade Tomcat/Apache instances.

EME upgrade, start and stop EME services.

Deployed code migration across multiple environments like SIT/UAT/PROD

Created new projects in the EME and User administration tasks like adding, removing, and modifying users.

Changed permissions of the project owner of the projects on the EME

Monitored any specific alerts for space usage, package installed on the server, memory, processes etc.

Coordinate with UNIX SA team to install Ab Initio products like Co>op, Express IT, Ab Help, CC, oracle client, etc. on the AI servers.

Well versed in UNIX commands and UNIX architecture.

UNIX shell scripting skills to automate time consuming jobs.

Strong knowledge on AIR commands, Metadata hub and Co-Operating system

Resolved all the software related issues like EME connection issues, GDE logins and any unexpected environment parameter issues faced by the developers.

Have done Health Check of file space, CPU utilization and memory on AI servers through custom scripts and AppDynamics and other monitoring tools – KSH Reporting

Health Check of AI services through custom scripts and AppDynamics and other Monitoring tools.

Troubleshoot bridge and reporting services on AI servers.

Incident management and problem management Co-ordinate with AI vendors

Security Management and User Administration in Control Center

Have done extensive troubleshooting issues related to Installation, upgrade, SSL Certs.

Mentored, educated and encouraged team regularly to be their best.

Canarys APAC Pte., Ltd. Sep 2021 – April 2022

As DevOps Consultant (freelance)

1.Conduct Azure workshop

2.Trained on Azure Devops, project creation, CI/CD execution, Artifactory

3.Self-Learning Agile, Docker & Kubernetes.

4.Have knowledge on creating Organisations, Project, adding Users, setting access levels and permissions

5.Have in-depth knowledge in creating Epics, Feature, User Story/PBI, tasks and other work items

6.Have knowledge in creating sprints/Iteration and assigning work items to it.

7.Have knowledge in creating Area Paths/ Teams

8.Have knowledge in cloning Repositories, creating branches, committing and making pull requests

9.Have knowledge in creating pipelines, implementing CI/CD, deploying to various deployment groups

10.Have knowledge in creating Test case, Test plans and Test Suites.

11.Have also created pipelines\CLI to store artifacts into Azure Artifacts.

NETS, Singapore June 2012 - April 2015

Powercenter Developer

•Involved in BAU activities (Informatica Jobs and BO reports)

•Level 2 Production Support

•Develop end to end small sized projects using Informatica 9.x

•Developed BO reports BOXI r3 using as per user's requests

•Automation of manually done monthly reports

•Interaction with clients during critical issues

•Involved in Informatica Administration activities.

•Involved in enhancement of existing mappings and workflows.

Project 1. MConnect Refersh

The purpose of this project was to prepare the MConnect Database so that the users get the required data. The users can view the transaction data and view/download invoices.

•Designed and developed Informatica Mappings to load data from Source systems to DWH.

•Creation of Transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in the Informatica Designer.

•Developed SCD type II to meet the business requirements.

•Used shell scripts for automating file copy from SFTP server.

Project 2. iNETS Invoice Billing

The purpose of this project is to automate invoice generation of iNETS merchants. Earlier, the finance team did it manually.

•Created mappings using most of the Informatica transformations for populating target table in efficient manner.

•Designed and Deployed UNIX Shell Scripts.

IBM, Singapore March 2012 - May 2012

As Consultant - ETL

Project 1. StarHub Postpaid

•Understanding of data fields / definitions

•Design and building of the staging datamart for model development/integration

•Data Transformation and Loading

•Data Testing at Target systems

•Roll-in

NETS, Singapore Oct 2010 - Dec 2011

As System Analyst

Project: Bank Interchange Fee

•Analysed the functional specs provided by the data architect and created technical specs documents for all the mappings.

•Develop logical and physical data models that capture current state/future state data elements.

•Converted the Logical design to Physical design, Constraints, Indexes, created Automated scripts, defined storage parameters for the objects in the Database.

•Designed and developed Informatica Mappings to load data from Source systems DWH.

•Extensively used Power Center to design multiple mappings with embedded business logic.

•Creation of Transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in the Informatica Designer.

•Developed mappings, sessions and workflows (ETL) for SCD types II to meet the above requirements.

•Designed and Deployed UNIX Shell Scripts.

•Created standard monthly reports using Business Objects XI 2.

Srishti IT Solutions (p) Ltd. (SITS), Bangalore, India Jan 2005 - Dec2008

As Sr. Software Engineer

•Involved in requirements gathering during enhancements.

•Prepared test cases and performed Unit Testing for Mappings.

•Involved in optimizing mappings and sessions.

•Assisted in UAT.

•Environment: Informatica 8.1.1, Business Objects XI, Oracle 10g on Linux

Education:

Master of Computer Application 2001 to 2004 Karnataka, India

Bachelor of Business Administration 1998 to 2001 Karnataka, India

Contact this candidate