Home

Samyuktha Ramoju - ETL Developer

[email protected]

Location: Okemos, Michigan, USA

Relocation: yes

Visa: H1B

Samyuktha Ramoju Email:[email protected] | 972-220-8508 ________________________________________ CAREER SUMMARY I am a highly skilled Senior ETL Developer with 8 years of experience. I have a deep expertise in Informatica PowerCenter and Informatica Cloud IICS, enabling me to efficiently manage and transform complex data sets. I'veexcelled in managing healthcare, retail and telecommunication projects and datasets, demonstrating exceptional problem-solving abilities and architectural skills. ________________________________________ SKILLS AND STRENGTHS ETL Tools - Informatica PowerCenter 10.2, Informatica Cloud (IICS), Informatica Data Quality IDQ Scripting - Unix scripting, Python Cloud - AWS, Snowflake BI/Reporting Tools - Power BI, SAP Crystal Reports Databases - Oracle 21c, MS SQL Server, DB2 Version Control -GitHub, BitBucket Tools - Visual Studio, TOAD, UC4, Control- M, ServiceNow, JIRA, Azure DevOps ________________________________________ PROFESSIONAL ACCOMPLISHMENTS Successfully automated data integration tasks using Informatica Cloud, leading to a 40% increase in workflow efficiency and reducing manual effort by 25%, which significantly streamlined project timelines. Successfully enhanced data accuracy and reliability through rigorous analysis and quality checks, which resulted in a 35% increase in data precision and a more streamlined data validation process. Proficient in designing and optimizing ETL jobs to efficiently load external data feeds into Data Warehouse and DataMart tables. AWS Certified Cloud Practitioner. Oracle Cloud Infrastructure Foundations Certified Associate. ________________________________________ WORK HISTORY SAP Senior ETL Developer Client: United Healthcare November 2020 - Current Extensively used transformations like Expression, Filter, Joiner, Lookup, Router, Sequence Generator, Sorter, Update Strategy, Union Transformations in Informatica Cloud (IICS) to build high performing Data Integration mappings. Managed complex database systems, ensuring the integrity and security of sensitive healthcare data. Designed workflows to extract data from Oracle, CSV, Flat Files (Fixed Width and delimited) to Oracle databases and Snowflake. Streamlined data integration processes through the development of shell scripts for pmcmd, parameter file management, and automated file transfers, reducing operational time and enhancing efficiency. Designed transformations utilizing Snowflake architecture, ensuring adherence to HIPAA standards through the integration of robust encryption protocols and stringent access control mechanisms. Implemented Performance tuning techniques by identifying and resolving the bottlenecks in source, target, transformations, mappings and sessions to improve Pipeline performance. Developed SAP Crystal Reports for visualization of Key Performance Indicator of end users. Implemented data synchronization tasks within IICS to keep data in Snowflake and Oracle databases synchronized in near real-time, ensuring consistency between the two instances. Implemented Data purge rules and archival process for data retention and governance. Client: Juniper NetworkJune 2018 October 2020 Led data migration from an On-Premises MySQL database to On Demand Oracle database, utilizing Informatica PowerCenter for ETL processes and JIRA for agile project management. Consistently performed reviews and updates on established data models to align with evolving business needs and data source modifications. Maintained documents for Design reviews, Engineering Reviews, ETL Technical specifications, Unit test plans, Migration checklists and Schedule plans. Using Informatica PowerCenter created complex mappings with Connected Lookups, SQL& Custom Transformations for loading the data in expected format of SAP payroll system. Involved in Performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volumes of data. Developed Dashboard reports using PowerBI by gathering requirement on direct interactions with Business/Operation teams. Worked on developing Star Schema, Snowflake Schema, Fact Table, Dimension Table, Data Modelling and Physical Modelling using Erwin. Pole to Win ETL Developer Client: Nationwide Mutual Insurance Company September 2017 May 2018 Worked on all PowerCenter Designer client tools like Source Analyzer, Target Designer, Mapping Designer and Mapplet Designer. Developed Informatica workflows to send data to Splunk servers periodically for monitoring and dashboard input. Analyzed Session log files to resolve errors in mapping and managed session configuration. Developed a standard ETL framework to enable the reusability of similar logic across the board. Modified parameter file configuration in UNIX scripts to handle additional data source column. Designed processes to send reports to multiple downstream systems using SFTP, direct database data loads. Electronic Corporation of India (ECIL) January 2016 May 2017 Associate Software Developer Optimized stored procedures and packages by reviewing the long running queries using AWR and ADDM reports. Employed Git-based version control systems to proficiently manage code repositories and foster seamless collaboration within the development team, ensuring efficient and coordinated project workflows. Enhanced Android applications performance and streamlined UI page integrations by effectively implementing Espresso and for unit testing. ________________________________________ EDUCATION Bachelor of Technology in Information Technology, JNTUH, India Keywords: user interface access management business intelligence microsoft