PRAVALLIKA MADADI
ETL/Data Engineer
Dallas,TX
Summary
Experienced ETL/Data Engineer working with Kaiser through TCS on health care projects using Informatica Suite, SQL,Snowflake and Teradata. Experienced Tableau/MicroStrategy/Business Objects Developer worked with Cigna through CGI on Pharmacy benefit and specialty pharmacy Applications using tools like Informatica PowerCenter and IDQ. Solid experience and background in Job scheduling tools like Autosys, Control-M and incident management with Service now. Masters graduate in Computer and Information Systems from Southern New Hampshire University Seasoned development professional well-versed in extraction, transformation and loading management. Collaborative team player with excellent project management skills. Knowledgeable about defining requirements, mitigating risk, and developing standards. Talented Informatica Developer with good requirements gathering, mapping and logic design skills. Detail-oriented and thorough with good grasp of business processes and needs developed over 8 years in Data Integration field.
Overview
8
8
years of professional experience
5
5
years of post-secondary education
Work History
ETL Informatica Developer-Kaiser Permanente
TATA Consultancy Services
8 2022 - Current
- Developed, tested, and implemented ETL processes using Informatica PowerCenter to extract, transform, and load data from multiple sources into data warehouses and data marts
- Designed and optimized complex ETL mappings and workflows, ensuring efficient data processing and integration
- Utilized SQL to query and manipulate data, validate ETL processes, and troubleshoot data-related issues
- Conducted data analysis and profiling to understand data sources and requirements, improving data quality and consistency
- Implemented error handling and logging mechanisms to ensure smooth ETL operations and quick resolution of issues
- Collaborated with business analysts and stakeholders to gather requirements and translate them into technical specifications for ETL solutions
- Monitored and tuned ETL performance to optimize processing time and resource utilization
- Managed and resolved incidents and service requests using ServiceNow, ensuring timely and effective solutions to minimize business impact
- Coordinated with cross-functional teams to address and troubleshoot production support issues, maintaining system stability and performance
- Implemented and enforced ITIL best practices for incident management, change management, and problem management to improve service delivery and efficiency.
Data Engineer- Apple
Ventois Inc.
08.2019 - 07.2022
- Developed and maintained complex SQL queries and stored procedures in Teradata for large-scale data processing.
- Optimized database performance by designing efficient data models and tuning SQL queries to handle large volumes of data.
- Ensured seamless data migrations and transformations across systems, managing ETL (Extract, Transform, Load) processes to maintain data integrity and flow.
- Performed regular monitoring and maintenance of the backend data environment to ensure availability, security, and performance.
- Leveraged Snowflake as a cloud-based data warehouse to store, manage, and analyze enterprise-level datasets.
- Developed and optimized data pipelines, ensuring data was properly transformed and loaded for analysis.
- Built scalable analytical models to support data-driven decision-making and improved operational efficiency.
- Integrated data from various sources into Snowflake to create comprehensive, unified datasets for business intelligence purposes.
- Created and maintained interactive dashboards in Tableau, providing key stakeholders with real-time data insights and visualizations.
- Developed reporting solutions that provided actionable insights, improving decision-making processes across departments.
- Collaborated with business users to gather requirements and design Tableau dashboards tailored to specific business needs.
- Ensured data consistency and accuracy in reports by continuously validating and refining data models and visualizations.
ETL Informatica Developer-Cigna
Ventois Inc.
06.2019 - 08.2020
- Responsible for maintenance of Informatica Suite and ensuring platform availability 24/7 by working with various teams
- Raised service now Change requests with appropriate backup procedures, alerts, and service monitoring in informatica
- Interacted with Product owner, Project Design Authority for Mapping document and design process of the project
- Parsed high-level design specification to simple ETL coding and mapping standards
- Designed and customized data models for Data warehouse supporting data from multiple sources on real time
- Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse
- Monitor system integrity through daily system checks, to ensure a high standard of service is provided to clients
- Escalate issues, Coordinate with different teams and remediation steps effectively and in a timely manner
- Perform troubleshooting analysis and resolution of critical applications and batch processes
- Support the Client Reporting Production Environment as a priority
- Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions
- Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting
- Create change management strategy
- Identify, analyze, prepare risk mitigation tactics
- Identifying and manage anticipated resistance
- Developed Transformation Logic to cleanse the source data of inconsistencies before loading the data into staging area which is the source for stage loading
- Participated in the full development life cycle within the reporting framework, from developing business intelligence requirements to QA and production deployment
- Written SQL Scripts and PL/SQL Scripts to extract data from Databases.
Informatica/Microstrategy Developer-Centene Corporation
Ventois Inc.
04.2017 - 04.2019
- Created Microstrategy schema and application objects such as attributes, metrics, prompts, filters and hierarchies
- Designed, developed and maintained micro strategy dashboards using desktop, web and debugged the reports
- Coordinated with Microstrategy administrators for scheduling reports and dashboards using narrow cast servers
- Experience in Informatica 10.1.1 using components such as Mapping Designer, different types of Transformations such as (Source Qualifier, Filter, Aggregator, Router, Update Strategy, Lookup, Union)
- Troubleshoot production issues and provide fix for business within appropriate time frame and continuously delivering code in the ongoing sprints.
ETL Tester
Enquero Inc.
10.2016 - 03.2017
- Used TestNG annotations like groups, parameters, Data Providers to group the ETL test cases, test methods, test suits for regression and functional testing
- Designed ETL Test Suite, Test Cases and Test Scenarios for functional modules in Selenium and involved in the use of Cucumber Step Definition, Scenarios and Features
- Performed Parallel and Cross Browser testing using Selenium Grid on different browsers like Internet Explorer, Chrome, Safari and Firefox where multiple tests were run at the same time
- Developed BDD (Behavior Driven Development) using Cucumber (Features, Scenarios and Step Definitions)
- Executed SQL queries to verify data integrity, data validation and data design
- Used AutoIT in automation for Mouse movements, Keystrokes, Window control manipulations and print pop-ups which is not possible using selenium WebDriver.
Education
Master of Science - Computer and Information Systems
Southern New Hampshire University
07.2015 - 05.2016
Bachelor of Technology - Electronics and Instrumentation Engineering
Kakatiya Institute of Technology and Sciences
06.2010 - 05.2014
Skills
Unix
Linux
C
C
Java
CSS
JavaScript
HTML5
JSON
Eclipse
svn
Git
Bit bucket
SQL developer
MySQL
Oracle 10g
SQL server 2012
Teradata SQL Assistant
Informatica Power Center
Informatica MDM
Informatica IDQ
Informatica Data Governance
Tableau
MicroStrategy
Snowflake
Business Objects
Scripting Languages
Data Warehousing
Business Intelligence
Scheduling Tools
Projects
Sparking Cleaning Services Web application, Developed web application project by using Spring Framework and Apache Tomcat. User can create own profile by sign up, search the services, request the services. Centralized Database for Wildwood apartments, Developed centralize Database using SQL server to store and retrieve the Tenants information. Analyzed the current design and the problem facing and build the logical model. Using normal forms, the database is optimized and increased performance. For securing user information, multiple authorizations were provided based on the priority.
Timeline
Data Engineer- Apple
Ventois Inc.
08.2019 - 07.2022
ETL Informatica Developer-Cigna
Ventois Inc.
06.2019 - 08.2020
Informatica/Microstrategy Developer-Centene Corporation
Ventois Inc.
04.2017 - 04.2019
ETL Tester
Enquero Inc.
10.2016 - 03.2017
Master of Science - Computer and Information Systems
Southern New Hampshire University
07.2015 - 05.2016
Bachelor of Technology - Electronics and Instrumentation Engineering
Kakatiya Institute of Technology and Sciences
06.2010 - 05.2014
ETL Informatica Developer-Kaiser Permanente
TATA Consultancy Services
8 2022 - Current