Akshata

Hands-on Developer with 4+ years of experience in handling complex Integration and Migration ETL frameworks with understanding of technologies and development methodologies. Proficient in Informatica 9.x & 10.x, Oracle SQL and UNIX, with experience designing mappings, sessions, workflows and ETL processes using Informatica PowerCenter. Experienced in extracting data from multiple sources, transforming data and loading Operational Data Store/staging areas and DataWarehouses.

Experienced with Filter, Router, Joiner, Aggregator, Expression, Sequence Generator, Connected & Unconnected Lookup, Union and Update Strategy transformations.

Experience implementing SCD Type-1 and Type-2, Fact Loading, dimensional modeling, parameter/variable driven incremental loads and performance tuning. Experienced in troubleshooting Informatica jobs, resolving UAT/production issues, peer review, knowledge transfer and SQL/UNIX based validation. Strong knowledge of IICS (Informatica Intelligent Cloud Services).

Informatica Developer - Sagility

(2023-10)

Project 1 — CAN Financial | December 2024 – Present. Objective: Cleanse, standardize and synchronize provider-related data across multiple systems based on business rules to minimize inaccuracies in claims payments.

• Developed Informatica mappings to load data from files/Oracle to target Oracle databases.
• Created mappings using Filter, Router, Joiner, Aggregator, Expression, Update Strategy, Lookup and Union transformations.
• Implemented SCD Type 1 and Type 2 for change data capture in dimension tables.
• Created Mapplets and reusable transformations; worked with connected, unconnected and dynamic lookups and Informatica versioning concepts.
• Debugged and troubleshot mappings, workflows and session failures; performed unit testing and SQL-based data validation.
• Analyzed and tuned source, target and mapping performance using data-flow and transformation analysis.
• Configured database connections, monitored jobs, used Workflow Manager, Session Logs and Informatica Debugger.
• Prepared SQL queries to verify dimensional/fact tables and target data; performed source-to-target column mapping and coordinated with BA/Development teams.

Informatica Developer - Sagility

(2023-10 - 2024-12)

Project 2: Medtronic. Worked on SCD Type 1 mappings. Business users supplied files that were loaded into staging tables; business logic was applied while loading data from staging to target tables.

• Created mappings to implement business rules using Informatica PowerCenter.
• Implemented SCD Type 1 and Type 2 strategies for dimension tables.
• Used Source Qualifier, Filter, Aggregator, Expression, Sorter, Joiner, Update, Lookup and Union transformations.
• Performed Informatica mapping performance tuning using parameter files, variables and dynamic cache.
• Worked on loading .CSV files to tables on SQL Server using Informatica transformations.
• Created ETL mappings, sessions and workflows as required; created staging areas and loaded raw data for cleansing.
• Performed requirement study, workflow/job execution, SQL validation of dimensional and fact tables, and source-to-target column mapping.
• Worked with team members to support development activities and resolve ETL issues.

ETL Developer — Informatica & Teradata - Influencer Lab

(2022-09 - 2023-09)

Client: CVS Caremark

• Understood technical and functional design documents and implemented business logic according to client requirements.
• Created Informatica PowerCenter mappings using Expression, Joiner, Sorter, Unconnected Lookup and Update Strategy transformations.
• Designed mappings and sessions based on user requirements and ETL rules to load data from flat files to target tables.
• Created sessions and workflows using Informatica Workflow Manager.
• Implemented SCD Type 1 and Type 2 to maintain historical data.
• Contributed to unit testing using sample data, prepared unit test cases and identified source, target and mapping bottlenecks.

Bachelor - Computer Science - Kuvempu University (2019 - 2022)