Asha Rani

Results-driven Data Engineer with 5 years of experience designing, building, and optimizing large-scale data pipelines and analytical platforms within the banking and financial services domain. I am skilled in end-of-end data engineering—from ingestion and ETL development to data modeling, data warehousing, and real-time processing—ensuring high data quality, security, and compliance. Strong expertise in data platforms (Informatica Power center, Hadoop/UNIX/SQL/Spark SQL), big data technologies, and distributed systems.

Adept at collaborating with cross-functional teams, improving data governance, and driving data-driven decision-making across the organization.

Senior Data Engineer - LTI Mindtree - Bengaluru, India

(2022-09 - 2025-01)

Banking domain project providing output in the form of text files to the Netreveal downstream application. Based on given Business logic Spark SQLs are created to apply transformations on source data and output in the form of text files is generated and provided to Downstream for consumption to assign Risk Ratings to the customers based on certain Criteria.

• Requirements were received from clients through the STTM process.
• Developed ETL mappings using Informatica to implement the business requirements.
• A thorough review of the STTMS is conducted, and any necessary corrections are communicated to the management team.
• The code is developed in accordance with the specified requirements utilizing Spark SQL, which includes the creation of intermediate Hive Source Tables and the generation of target files through Informatica.
• Participation in team code reviews is actively undertaken.
• Unit testing is performed using Unix Commands to ensure the accuracy of the data loaded into the target files.
• In terms of production-related activities, change requests (CRs) are raised, and follow-ups with the support team are conducted to secure the necessary approvals, ensuring that the production environment is adequately prepared.
• The data produced in the target files within the production environment undergoes a revalidation process using Unix commands.
• Hands-on experience in CA Wade scheduler.

Software Engineer - Spider focus solutions - Bengaluru, India

(2019-04 - 2022-08)

Hyundai Motor India Engineering is a leading manufacturer of Automobiles in entire South Korea. Hyundai has multiple data warehouses, and the aftermarket parts group has its own data warehouse. The data warehouse consists of data for sales and marketing and forecast and planning operations. This data warehouse was expanded by adding functionality from many other source systems.

• Developed ETL mappings using Informatica to implement the business requirements.
• Communicated with clients to discuss the issues and requirements.
• Used Informatica Power Centre for (ETL) extraction, transformation, and loading of data from heterogeneous source systems into the target database.
• Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.
• Reviewed and analyzed functional requirements, mapping documents, problem-solving, and troubleshooting.
• Performed unit testing at various levels of ETL and was actively involved in team code reviews.
• Worked extensively with connected lookup Transformations using dynamic cache.
• Getting incremental data on daily basis and sending it to the target.
• Done extensive testing and wrote queries in SQL to ensure the loading of the data.
• Perform unit testing at various levels of the ETL.
• Developed and implemented the coding of Informatica Mapping for the different stages of ETL.
• Experience with Informatica Designer Components - Source Analyzer, Transformation Developer, Mapplet, and Mapping Designer.
• Developed complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Sorters, Joiners, Routers, Union, Update Strategy, and Aggregators.
• Fixed the invalid mappings and troubleshot the technical problems of the database.

Bachelor of Engineering - ECE - R.L. Jalappa Institute of Technology (2016)