SRINIVASU MUTYALA

Environment: Informatica 10.4 & IICS, AWS S3 bucket, AWS DMS task, Oracle, PostgreSQL, WinSCP, Unix.

• Lead a team of Informatica developers in designing, developing, and implementing ETL solutions for large-scale data integration projects.
• Collaborated with business analysts and stakeholders to gather and analyse requirements, ensuring alignment with business objectives.
• Optimized existing ETL processes, resulting in a 20% improvement in data load performance.
• Developing CDC mappings and experience using number of transformations like Expression, Reusable Sequence Generator, Java transformation, Router, Update Strategy, Filter and Oracle database system and flat files.
• Responsible for Analysing, developing, Extraction, loading and Transformation process using ELT tool Informatica.
• Participating in requirement, design, and code reviews.
• Leading onshore and offshore developers on various initiatives.
• Work effectively in a collaborative team environment and effectively demonstrate team building attitude and skills
• High level of proficiency with database and data warehouse development including replication, staging, ETL, stored procedures, partitioning, change data capture, triggers, scheduling tools, cubes and data marts. Environment: Informatica 10.4, Azure Data Factory,Azure Synapse Analytics, Azure Data Lake & BLOB, Azure SQL, Microsoft SQL Server Management Studio v19.0.2, AWS S3 bucket, AWS DMS task, PostgreSQL, Aurora MySQL, OGG, WinSCP, Unix.

• Implemented performance tuning techniques on mappings, sessions and workflows to improve throughput rate of ETL process.
• Performed unit testing on the developed code to identify any bugs or issues prior to deployment.
• Optimized existing ETL processes by applying different techniques like partitioning, indexing.
• Worked closely with database administrators team while developing database objects such as triggers, cursors, required for ETL development activities.
• Participated actively in weekly meetings held between IT team members discussing about new initiatives taken up by organization concerning Data Warehousing technologies like SSIS,Informatica, Azure Data Factory
• Developed ETL processes and objects such as jobs, transformations, mappings, sessions using Informatica PowerCenter 9.6.

Environment: Informatica 10.4 and Oracle, Azure Synapse Analytics, Azure Data Lake & BLOB, Azure SQL, Azure data factory, WinSCP, Unix.

• Configurations of Oracle's Business Intelligence Applications Configuration Manager (BIACM) for financial Analytics.
• Created Mappings using various transformations like Lookup, SQL Transformation, Router, Joiner, Aggregator and Expression.
• Created sessions and workflows.
• Converting Informatica mappings with help of Infa2 ODI Jar file application/tool.
• Manually added other ODI functionality and utilities based on client additional requirements after converting informatica mappings into ODI mappings.
• Good Understanding on ODI Navigators like Designer, Topology, Operator and Security Navigator.
• Sound knowledge on knowledge modules like RKM, LKM, CKM, IKM, and JKM.
• Analyzingle for Analysing, developing, Extraction, loading and Transformation process using ELT tool ODI.

Environment: Oracle Data Integrator (ODI), Informatica 9.5, Oracle, WinSCP, Unix.

• Worked with multiple sources such as Relational databases, Flat files like Csv, txt files.
• Extraction, Transforming and Loading data into target tables.
• Created new models for the data sources – flat files, Oracle.
• Did reverse engineering for the data sources and targets.
• Database Query tuning and Implementation.
• Debug the sessions by utilizing the log of the sessions.
• Resolved ODI related issues faced by the team members.
• Automated the export/import of scenarios across the environments (Development, Test and production)

Environment: ODI11g, Oracle 11g,windows

Environment: Hadoop Hive, HBase, Sqoop,ODI11g, Oracle 11g

• Created Mappings using various transformations like Lookup, SQL Transformation, Router, Joiner, Aggregator and Expression.
• Handled slowly changing dimensions of Type 2 to populate current and historical data to Dimensions and Fact tables in the data warehouse.
• Attending Client meetings.
• Used Debugger to test the mappings and fixed the bugs.
• Involved in Unit testing and supporting UAT testing.
• Debug the sessions by utilizing the log of the sessions.
• Performed unit testing at various levels of ELT flows.

Environment: Informatica 9.0.1, Oracle 11g.