kurapati sumalatha

Project 1: Client: ITC (Block Rock {Lifestyle}); Role: ETL Developer; Data Sources: SQL; Environment: Informatica PC, Informatica Intelligent Cloud Services (IICS), Informatica Data Management Cloud (IDMC)
Delivered daily and weekly status updates to Project Managers, ensuring the timely resolution of issues and clear communication of progress across both the PowerCenter and IICS environments.
Designed ETL mappings using Informatica PowerCenter Designer tools, including Source Analyzer, Warehouse Designer, and Mapping Designer, to define and map data between various source and target systems.
Leveraged IICS Cloud Data Integration for integrating data from both cloud and on-premises sources, creating mappings to transform and load data into cloud-based systems.
Utilized Transformation Developer to design and implement transformations such as Joiner, Filters, Router, Expression, and Aggregator, to handle complex business logic and data processing.
Designed and managed ETL workflows using IICS Workflow Manager, automating data extraction, transformation, and loading processes to streamline operations and minimize manual intervention.
Developed and automated cloud-based ETL workflows using Informatica IDMC, including task flows, transformations, and performance monitoring.
Used PowerCenter Workflow manager for session management, database connection Management and scheduling of jobs to be run.
Handled Slowly Changing Dimensions (SCD) to maintain complete historical data for accurate reporting and analysis.
Performed unit testing to validate data transformation logic and ensure data integrity and accuracy across both systems.

Project 2: Customer: Amazon; Industry Domain: Finance; Project Type: Automation Development; Environment: Quicksight, Python, Snowflake, Redshift, AWS cloud, Amazon internal; ETL and scheduling tools; Role / Responsibilities: ETL Developer
Interacted with business users for requirement gathering and user story creation.
Designed user specific reports for daily/bi-weekly/monthly asset status, verifying all parameters to conclude amortizations status of assets mapped across globe.
Created ETL workflow to copy files from S3 bucket and load them to redshift table for transformations and load processed data back to S3.
Dynamic dashboards to pull data from multiple sources, redshift, S3 files and excel sheets for easy single point analysis of Amazon Finance team.
Created interactive dashboards that is flexible to be used by different finance teams to analyses different accounts at one place.
Developed ETL workflows to load and integrate data into Snowflake for high-performance cloud-based reporting and analysis.
Created dynamic filter page that pops values based on user choice.
Interacted with users on regular basis to take their inputs and ensure dashboards to meet their business requirements.
Used internal scheduler to automate ETL pipeline, dashboard data update and delivery of processed data to user on daily (every 4hours), bi-weekly and monthly basis.
Brief Description of Project: The Project deals with the development of automation process to fetch finance data from multiple sources and design intuitive dashboards for business user’s analysis of accounting transactions. This is currently a manual process by Finance team, which is planned to be automated to improve accuracy and save many man-hours of efforts.

Project 3: Client: Holland American Food Co., USA; Role: ETL Developer; Data Sources: Oracle; Environment: Informatica PowerCenter, Oracle, UNIX and Control-M, IICS
Analyzed business requirements and developed ETL mappings and workflows.
Implemented transformations such as Source Qualifier, Filter, Expression, Router, Aggregator, Sorter, and Lookup.
Managed sessions, database connections, and job scheduling using PowerCenter Workflow Manager and Control-M.
Worked on Informatica IICS for cloud data integration and automation of ETL workflows.
Handled Slowly Changing Dimensions (SCD) to maintain historical data.
Identified and resolved bottlenecks to optimize performance and reduce response times.
Monitored and troubleshot ETL jobs using Control-M to ensure timely data processing.
Resolved production job failures and coordinated service restarts for minimal downtime.
Created and managed complex IICS task flows to streamline Oracle data processing, including error handling, data validation, and performance optimization for cloud-based ETL operations.
Participated in daily scrum meetings and status calls to communicate progress, issues, and production support updates effectively.
Project 4: Client: Johnson & Johnson, USA {Customer One Source Data Warehouse}; Role: ETL Developer/ PL/SQL; Data Sources: Oracle, Flat Files; Environment: Informatica PowerCenter, Oracle, UNIX, Autosys, Snowflake
Participated in requirement-gathering sessions and Scrum calls to understand business needs.
Identified and documented detailed business rules for ETL and PL/SQL design.
Designed and developed ETL mappings and transformations using Informatica PowerCenter.
Utilized transformations such as Source Qualifier, Expression, Aggregator, Lookup, Filter, Router, Joiner, and Update Strategy.
Developed and optimized PL/SQL stored procedures, functions, and packages for data extraction, transformation, and aggregation from Oracle sources.
Developed and optimized ETL workflows in Informatica PowerCenter to load and transform data into Snowflake efficiently.
Integrated Snowflake as a cloud data warehouse to enable scalable analytics and reporting.
Worked with Autosys for job scheduling and monitored concurrent and sequential session executions.
Monitored and managed ETL jobs and session executions using Autosys, ensuring smooth production operations, timely data availability, and minimal downtime.
Troubleshot and resolved production issues, performed testing of ETL workflows, and coordinated with teams to maintain data accuracy and support timely report delivery.