kurapati sumalatha

<p>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)<br>
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.<br>
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.<br>
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.<br>
Utilized Transformation Developer to design and implement transformations such as Joiner, Filters, Router, Expression, and Aggregator, to handle complex business logic and data processing.<br>
Designed and managed ETL workflows using IICS Workflow Manager, automating data extraction, transformation, and loading processes to streamline operations and minimize manual intervention.<br>
Developed and automated cloud-based ETL workflows using Informatica IDMC, including task flows, transformations, and performance monitoring.<br>
Used PowerCenter Workflow manager for session management, database connection Management and scheduling of jobs to be run.<br>
Handled Slowly Changing Dimensions (SCD) to maintain complete historical data for accurate reporting and analysis.<br>
Performed unit testing to validate data transformation logic and ensure data integrity and accuracy across both systems.</p>

<p>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<br>
Interacted with business users for requirement gathering and user story creation.<br>
Designed user specific reports for daily/bi-weekly/monthly asset status, verifying all parameters to conclude amortizations status of assets mapped across globe.<br>
Created ETL workflow to copy files from S3 bucket and load them to redshift table for transformations and load processed data back to S3.<br>
Dynamic dashboards to pull data from multiple sources, redshift, S3 files and excel sheets for easy single point analysis of Amazon Finance team.<br>
Created interactive dashboards that is flexible to be used by different finance teams to analyses different accounts at one place.<br>
Developed ETL workflows to load and integrate data into Snowflake for high-performance cloud-based reporting and analysis.<br>
Created dynamic filter page that pops values based on user choice.<br>
Interacted with users on regular basis to take their inputs and ensure dashboards to meet their business requirements.<br>
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.<br>
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.</p>

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