Summary
Overview
Work History
Education
Skills
Websites
Certification
Timeline
Generic

Avani Jammu

Summary

With over 8 years of expertise and a strong background in designing, implementing, and testing data integration solutions. Extensive ETL experience using Informatica PowerCenter for data extraction, transformation, and loading. Skilled in handling complex transformations such as update strategies, routers, XML, and normalizers. Expertise in Slowly Changing Dimensions (SCD), Change Data Capture (CDC), and Dimensional Data Modeling. Proficient in SQL with the ability to write complex queries using analytical functions, views, and triggers. Hands-on experience in performance tuning at various levels including SQL override, sources, targets, transformations, and sessions. Well-versed in using Lookup caches (Static, Dynamic, Persistent) and debugging Informatica mappings. Familiar with automation scheduling tools such as Stonebranch Universal Automation Center and Autosys for ETL job automation and file processing through Unix Shell Scripting. Consistently delivers high-quality results by meticulously crafting data mapping, design, and unit test documents. Strong analytical mindset and excellent communication skills. Thrives in Agile (SCRUM) methodology and excels at collaborating with teams. Detail-oriented with exceptional project management skills. Proactive approach to identifying and addressing issues while optimizing processes and supporting team objectives. Expertise in data mining, warehousing, and analytics. Quality-driven and hardworking with excellent communication skills contributing to successful project management.

Overview

8
8
years of professional experience
1
1
Certification

Work History

Data Engineer

LTIMindtree - Working for Lincoln Financial Group
03.2022 - Current
  • Involved and contributed to multiple data integration projects in various spaces - eCommunications, Salesforce, Auto QDIA, Secure Act, Director PathBuilder Income, Plan Expense Account for Director
  • Interacted with product owners and cross-functional teams to document business requirements and transform them into technical requirements
  • Collaborated with system architects, design analysts, and others to understand business and industry requirements.
  • Design and develop Informatica ETL processes (mappings, queries, workflows, data objects) to support data loading and processing based on business rules
  • Streamlined complex workflows by breaking them into manageable components for easier implementation and maintenance.
  • Led the end-to-end implementation of several high-impact projects from development to deployment and post-launch support stages.
  • Implemented validations and data cleansing using Informatica and Shell scripts
  • Designed and developed mappings using Source Qualifier, Expression, Lookup, Normalizer, Router, Aggregator, Filter, Sequence Generator, Stored Procedure, Update Strategy, Joiner and Rank, Transaction Control transformations
  • Monitored the performance and tuned SQL queries and Informatica ETL processes
  • Implemented complex business rules in Informatica PowerCenter by creating reusable transformations and robust Mapplets
  • Worked with Static, Dynamic, and Persistent Cache in lookup transformation for better throughput of Sessions
  • Coordinated with the Quality Assurance team on test execution
  • Coordinated with DevOps and support teams and ensured projects are successfully deployed
  • Knowledge Transfers to Support team
  • Provide support for non-Prod environments
  • Manage releases of changes to ETL, scripts, DDL, and scheduling components from Development to Test to Production
  • Automated routine tasks using Python scripts and reduced manual errors.
  • Environment: Informatica PowerCenter, Windows, Unix, Oracle 12, SQL Developer, Microsoft SQL Server, IBM DB2, DbVisualizer, Python, Autosys, Stonebranch, Gitlab, JIRA

ETL Developer

Innovcentric Consulting
10.2016 - 09.2023
  • Worked as Informatica developer for Banking and Retail Clients

Education

Bachelor of Technology - Computer Science

Andhra University
05-2011

Skills

  • ETL development
  • Data Warehousing Solutions
  • Strategic Problem Analysis
  • Cross-Functional Team Engagement
  • Data modeling
  • Database Performance Improvement
  • SQL Proficiency
  • ETL Tools: Informatica PowerCenter, Informatica Intelligent Cloud Services (IICS)
  • Databases: Oracle, Microsoft SQL Server, IBM Db2
  • Experienced with AWS Cloud Solutions
  • Experienced in C and Python Programming
  • Experienced with Scheduling Tools: Stonebranch and Autosys
  • Experienced in Windows and Unix Systems
  • Tools: DbVisualizer, Oracle SQL Developer, WinSCP, PuTTY

Certification

AWS Partner: Technical Accredited

Timeline

Data Engineer

LTIMindtree - Working for Lincoln Financial Group
03.2022 - Current

ETL Developer

Innovcentric Consulting
10.2016 - 09.2023

Bachelor of Technology - Computer Science

Andhra University
Avani Jammu