Sravanthi Molakalapalli

ETL Professional with over 11 years of experience in IT industry. Expertise in documenting Business requirements, FRDs, data Mapping documnet, and designing, developing, and implementing data integration solutions using Informatica PowerCenter, Informatica CDI-PC, Informatica Cloud (IICS) for Business application systems for Insurance, Banking, Retail, and Finance Domain. Good knowledge of SDLC and Data Warehouse/Data Mart, ODS, OLTP and OLAP implementations, spanning project scope, requirements gathering, data modeling, effort estimation, ETL design/development, testing, implementation, and production support.

Strong grasp of Star Schema, Snowflake Schema, and FACT/Dimension modeling. Demonstrated ability to deliver projects on time, troubleshoot complex ETL issues, and optimize performance — reducing data latency by 40%.

Experience in managing, scheduling, and monitoring Informatica workflows using enterprise scheduling tools.

Data Engineer at Nationwide (2022-03 – Present)

Lead end-to-end ETL pipeline delivery as ETL Data Developer/Engineer, translating policy and Claims related data into scalable source-to-target designs.

• Worked on creating ETL pipelines to implement Slowly changing dimensions (SCD2) to capture historical changes of policies, renewals, claims and losses and transform this information for business reporting and analysis, handbooks for SDLC governance and production readiness.
• Collaborate with stakeholders/product owners to gain clear understanding of business needs, objectives, and constraints; communicate with business and technical teams to deliver functional requirements and maintain project documentation.
• Monitor production jobs/workflows, troubleshoot critical failures, analyze logs, and coordinate with the team for timely incident resolution.
• Support CI/CD pipeline implementation and release automation using Harness and GitHub to promote ETL changes across Dev, Test, and higher environments.

Technology Analyst at Wells Fargo (2019-02 – 2022-03)

• Worked on creating ETL mappings for handling batch process for Customer due diligence application and worked on rewriting the existing realtime pubsub to Websphere to end to end ETL mappings.
• Participated in requirement discussions with business teams and inter application teams.
• Integrated Informatica with JMS message queue (WebSphere Application Server) to successfully send messages to the queue.
• Automated the ETL batch jobs using AutoSys scheduler and monitored jobs; prepared deployment packages/artifacts and Work Requests across environments.

ETL Developer at PostHoldings (2018-02 – 2018-11)

• Worked on enhancements on existing ETL mappings to ingest data from multiple sources like flat file, XML, database tables.
• Implemented Slowly changing dimensions (SCD2) to capture historical changes in orders and shipping locations
• Created sessions and batches for incremental staging loads, and performed Unit, Integration, System, Performance testing and developed shell scripts to archive files and logs.
• Provided ongoing production support and updated existing mappings to meet new business requirements.

Sr. Informatica Developer at Ameriprise Financial (2016-09 – 2018-01)

• Worked on API based ETL flows with legacy mainframe systems and automate ETL job triggers, and used error-handling strategies to route mapping errors to an error table.
• Worked with high volume of data for batch processing and building JASON/REST payloads for API.
• Coordinated UAT with business users to complete acceptance testing within timelines and documented production support handoff materials.

Informatica Developer at News America Marketing (2016-01 – 2016-08)

• Coordinated with source system owners on day-to-day ETL progress monitoring and Star Schema data warehouse design and maintenance.
• Designed Informatica mappings and Led code reviews per ETL/Informatica standards and contributed to ETL design standards and best practices.
• Generated and analyzed daily, quaterly, semi annual, annual reports using BusinessObjects, and developed UNIX shell scripts to automate database processes and data conversion.

ETL/Informatica Developer at Patni Computer Systems (2009-07 – 2011-03)

• Worked with Workflow Manager, Workflow Monitor, and Worklet Designer to create, edit, and run workflows, tasks, and shell scripts; tuned session performance via partitions, cache sizing, and commit intervals.
• Identified integrity constraints and evaluated applications for functionality, data accuracy, and system impact; applied Data Flow Diagrams, Data Dictionary, and Entity Relationship modeling techniques.
• Extracted data from DB2, SQL Server, Excel, and Flat Files into the Data Warehouse using Informatica, and built re-usable transformations and mapplets; developed UNIX shell scripts for process automation.

Database Developer at Couth IT (2008-01 – 2009-06)

• Created new tables, indexes, and views for new features, and altered tables for change-request features.
• Wrote queries, stored procedures, triggers, and functions; managed test data updates between development and production databases.
• Reported bugs, tracked regression on bug fixes, and documented processes and data flow for future reference.

Bachelor's degree in Electronics and Communications Engineering – JNTU, Hyderabad (2003 – 2007)