…

Strategic professional, offering over 3

decades of expertise with a strong SRINIVASARA RAO PAVULURI
commercial / business acumen,
targeting strategic assignments in
Supply Chain Management, PROFILE SUMMARY
Operations Management and  Demonstrated a successful track record of 13+ years in developing & supporting
Administration & Security. business applications with a focus on cloud-based data integration solutions using
Informatica PowerCenter, Informatica BDM, IICS, DBT, UNIX, SQL, Hive, Snowflake,
Redshift and Teradata
CONTACT ME AT
 Proven expertise in designing, developing & implementing ETL processes with a strong
pavuluri_sri2000@yahoo.co.in understanding of data warehousing concepts & hands-on experience in data modeling

+91-9686313712  Created & optimized complex SQL queries for data extraction & transformation; in-
depth knowledge of data integration, data quality and data governance best practices

 Experience in troubleshooting and resolving data integration issues to ensure seamless

CORE COMPETENCIES data flow with expertise in various databases, including Oracle, SQL Server & Teradata
 Data Integration Solutions
 Possess a deep comprehension of business requirements, adept at identifying
 Advanced Informatica Expertise potential gaps and skilled in collaborating with stakeholders to resolve issues
 Performance Optimization
 Proficient in developing UNIX shell scripts to execute jobs and crafting intricate SQL
 Designing and Configuration queries to retrieve data from various source tables and views
 ETL Process Enhancement
 Possess a wealth of experience utilizing Informatica Workflow Manager tools for data
 Business Requirements Analysis migration, integration & cleansing and executing ETL processes for data warehouses
 Troubleshooting & Debugging
 Demonstrate exceptional leadership & communication skills, with a track record of
 Cloud Integration addressing technical challenges and resolving issues across all organizational levels
 Project Execution
 Collaborative team player with exceptional interpersonal skills, possessing an in-depth
 Data Governance & Security understanding of fundamental business processes and a proven track record of
delivering successful project implementations.
 Unix Shell Scripting & Automation
 Complex SQL Query Writing
KNOWLEDGE PURVIEW
 Informatica Workflow Manager Tools
 Extensive experience in build models, snapshots, source, seeds, macros in DBT
 Data Migration, Cleansing, Warehousing  Writing UNIX shell scripts to run the jobs in PMCMD command line
 Extraction, transformation and loading of data directly from different source systems
 Leadership & Mentorship
like flat files and relational databases.
 Cross-functional Coordination  Informatica Workflow Manager tools: Task developer, Workflow Designer and Worklet
 Preparing the low-level Design Specifications for ETL Coding and mapping standards
 Performing implementation, documentation, testing & updating as it relates to the
business requirements
TECHNICAL SKILLS
WORK EXPERIENCE
 Informatica PowerCenter 10.5 Jul’11 – Till Date: Accenture
 Informatica Cloud (IICS)
Informatica Lead
 DBT (Data Build Tool) Client: Kaiser
 Informatica BDM
 Leading the analysis of business requirements and generating comprehensive functional
 AWS (Amazon Web Services) requirement documents
 Actively contributing to ETL technical design discussions and produced detailed high-level
 Redshift | Snowflake | Teradata technical design documents
 Oracle 19C | SQL, PL/SQL  Conducting a thorough analysis of source-to-target mapping provided by data analysts and
generated comprehensive function and technical design documents
 UNIX Shell Programming  Retrieving large volumes of data from data files and Hive using Informatica BDM mappings
 Putty | Tivoli | Git  Designed intricate Informatica mappings incorporating Lookup, Joiner, Sorter, Aggregator,
and Router transformations to efficiently extract, transform, and load data
 Generating Informatica workflows linked to the mappings using Designer
 Effectively scheduling Informatica jobs utilizing Tivoli
 EDUCATION &  Conducting comprehensive performance tuning of Informatica code, employing industry-
CERTIFICATIONS standard optimization techniques
 Master of Computer Applications from  Providing extensive support during QA/UAT/PROD deployments, ensuring timely bug fixes
Bharathidasan University  Developing UNIX shell scripts to facilitate file transfer, archiving, and email notifications
 Performing comprehensive code reviews adhering to ETL / Informatica standards and
 AWS Associate certification industry best practices

 Informatica Power Center Certified Senior Informatica Developer

Developer 10 Client: PL Life

 Involved in the ETL technical design discussions and prepared ETL high level technical
design document.
SOFT SKILLS  Involved in the analysis of source to target mapping provided by data analysts and
prepared function and technical design documents.
 Extracted high volume/High Frequency of data sets from AMZON S3 files, Redshift using
Analytical Team Building Informatica mappings.
 Created complex Informatica mappings using Lookup, joiner, Sorter, Aggregator, and
Router transformations to extract, transform and loaded data.
 Developed Informatica MCTs associated with the mappings using Data integration.
 Created Synchronization Task and Replication tasks and PowerCenter tasks.
High Integrity Problem Solving  Created Synchronization Task ,Replication tasks .
 configured task flow and linear tasks
 configured hierarchical schema
 Spearheaded the design, development, and enhancement of ETL processes utilizing the
Communication Leadership DBT (Data Build Tool).
 Functioned as a Snowflake and DBT Analytics Engineer, specializing in data analysis and
optimization
 Successfully executed two proof-of-concepts, transitioning from Informatica Cloud to DBT
 Offered technical assistance to the team throughout the data migration process
 Strategically planned & executed data migration projects, ensuring timely service delivery
 Established and optimized DBT with Snowflake, encompassing the creation of models,
snapshots, sources, seeds, and macros
 Developed .yml files at the schema level to incorporate comprehensive test validation in
DBT; successfully executed incremental load processes utilizing DBT.
 Constructed robust pipelines in DataOps and GitLab to facilitate seamless code
deployment across QA and production environments

Informatica Developer
Client: AXA

 Led the successful conversion from Informatica Cloud to DBT for 2 POC projects, resulting
in improved data analytics capabilities and streamlined data integration processes
 Provided technical guidance and support during data migration activities, ensuring smooth
and efficient data transfer
 Implemented incremental load using DBT, reducing processing time and improving overall
data integration efficiency
 Played a key role in designing and loading data into the data warehouse using ETL,
ensuring accurate and efficient data integration
 Developed mappings using various Informatica transformations, such as Filter, Expression,
Aggregator, Source Qualifier, Lookup, Router, and Update Strategy, resulting in effective
data transformation and loading
 Implemented Slowly Changing Dimensions, including Type 2 Dimension for historical
changes, ensuring accurate & comprehensive data representation in the data warehouse