Data Analyst Analysis

Aishwarya Shrikanth

ETL Dev/QA - Data Analyst– Informatica PC/IDMC/ICEDQ/SQL/Tableau

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

Mobile : +1-732-***-****

Location: Phoenix, AZ

Summary

A detail-oriented IT Professional with 5+ Years of experience in Data Analysis and ETL Process. Expertise in handling SDLC / Agile data warehouse implementations with Handson proficiency in Informatica PowerCenter, IDMC, ICEDQ, Oracle/PostgreSQL, Tableau and Unix Scripting. Willing to learn and work on new opportunities and also eager to bring my Analytical skills and proactive ETL Dev / QA approaches to enhance operational efficiency.

Key Skills

• ETL – Informatica PowerCenter (PC)

• ETL – Informatica Intelligent Data Management Cloud (IDMC)

• Integrity Check Engine for Data Quality (ICEDQ)

• Oracle SQL Scripting

• Unix Shell Scripting

• PostgreSQL

• MS SQL Server

• Salesforce Developer Console

• Tableau

• Autosys

• Agile Methodology

• JIRA / Trello / Confluence

• Micro Focus Application Lifecycle Management (ALM)

• Lawson Portal

• Microsoft Office Applications

Professional Experience (Last 3)

ETL – Analyst / Developer / QA Tester Wells Fargo Apr 2023 – Jan 2025

• Determine the architecture of Banker-Customer-Opportunity-Interaction-ClientGroup- RelatedClient Relationships, enabling effective ETL processes including data analysis, profiling, implementation, and validation.

• Conduct business and data analysis based on functional specifications, ensuring thorough validation with business users and team leads.

• Prepare detailed ETL Low-Level Design and Source to Target Transformation Mapping (STTM) through comprehensive data analysis, securing approvals from technical leads and project teams.

• Engineer end-to-end code using pertinent technologies (Informatica Power Center 10.5.3, Informatica IDMC, Unix scripting, Oracle SQL Developer 23.1.0, Salesforce, and Autosys) in alignment with design specifications, documenting artifacts such as database scripts and unit test documents for peer review.

• Facilitate the development and migration of Informatica PowerCenter (PC) into Informatica Cloud (IDMC) while executing unit testing.

• Perform QA testing of developed modules (ETL components and SQL views) by analyzing requirements, preparing mockup data for diverse data scenarios, and creating thorough test case documentation for review and results uploading to Micro Focus ALM application.

• Automate QA testing utilizing Integrity Check Engine for Data Quality (ICEDQ) by creating comprehensive rules via complex Oracle SQL queries, validating Informatica PowerCenter and IDMC mapping changes, focusing on data reconciliation, count, null validation, duplicates, and audits.

• Migrate customer, lead (opportunities), and contact data from Practice Finance Salesforce Cloud to newly established Customer Relationship Salesforce Sandboxes (DEVSIT, UATCOPY) using Informatica Power Center 10.5.3, scheduling jobs through Autosys JIL script.

• Create metadata and generate parameter files using Shell Scripts to facilitate unit testing of developed modules.

ETL - Data Analyst Numpy Ninja

Sep 2022 – March 2023

• Analyze Diabetes and Hospital Database Models, creating PostgreSQL-based SQL and PL/SQL scripts aligned with business requirements for the development team.

• Develop comprehensive code utilizing relevant technologies (Informatica Power Center 10.2, Python scripting, PostgreSQL) following design specifications, documenting artifacts including unit test scripts, design documents, and schedules.

• Participate actively in peer reviews, Scrum backlog refinement, and daily stand-up meetings in accordance with Agile methodologies.

• Design and develop views, triggers, functions, and stored procedures as per functional requirements for application development, conducting peer reviews as necessary.

• Collaborate with clinical datasets to devise a KPI dashboard for ICU Sepsis patients, employing advanced Tableau visualization features to enhance data representation.

• Identify and determine SIRS criteria using Tableau, creating insightful dashboards for identified patients.

• Analyze the impact of demographic parameters on sepsis incidences, elucidating significant correlations.

• Identify dominant biomarkers correlated with Sepsis occurrences through detailed data analysis.

• Lead and participate in organization-wide SQL and Tableau-based hackathon events, fostering collaborative learning and innovation.

ETL / SQL Developer Gatix E Solutions

Apr 2021– Aug 2022

• Completed training in ETL Informatica and Oracle PL/SQL, complemented by Python-based scripting and Business Objects

• Developed Informatica mappings to monitor long-running sessions through the utilization of the Informatica OPB Metadata repository.

• Implemented Unix scripts to generate and dispatch alert emails to the support team regarding long-running sessions.

• Contributed to documentation, developing high-level design (HLD), low-level design (DLD), and tool templates for submission to the organization's tools group.

• Engaged in dimensional modeling, designing and developing STAR schemas for enhanced data analytics.

• Create and implement new database scripts for establishing additional fact and dimension tables in ORACLE databases.

• Design and create tables, views, functions, and stored procedures to meet functional requirements.

• Formulate optimized SQL queries for seamless integration with other applications.

• Establish new parameter files, XML source mappings, sessions, and workflows, executing unit and integration testing.

• Conduct technical walkthroughs of completed designs with peer groups to ensure compliance with standards.

Other Experiences

Process Associate Accenture

• Managed invoice processing for accounts Receivable under Lawson Portal and ensured they are processed within the time frame agreed under the service level agreement

• Received payments, posted transactions and monitored accounts for past-due issues.

• Assessed interest charges and transmitted related invoices.

• Reconciled accounts on a monthly basis and checked records for accuracy. Education

University : University of Madras

Degree : Bachelors in Commerce, Accounting and Business Management

Contact this candidate