*

Ravalli Tadakamalla

ETL Informatica Developer

Mobile: +1-614-***-****

Email: adznm4@r.postjobfree.com

Professional Experience:

Around 6 years of experience in Data Warehousing, ETL development and business analysis, My expertise in Informatica PowerCenter and IICS, combined with my experience working with RDBMS like Oracle, SQL Server, and MySQL. I have a proven track record of designing, developing and implementing complex ETL processes, as well as expertise in data modeling, SQL writing and performance tuning.

Good experience with Informatica tools using CDC (change data capture).

Experience in integration of various data sources like Oracle, SQL server, Flat files.

Exposure in writing SQL using analytical functions like Ranking, case statement etc., also in writing optimize SQL query.

Excellent experience in designing and development of ETL Methodology using Informatica PowerCenter 10.4, 9.6.1/9.1.1 and Informatica Cloud IICS

Interacted with end-users to identify and develop Business Requirement Document (BRD) and transform it into technical requirements.

Experience in Debugging and Performance tuning of targets, sources, mappings and sessions in Informatica.

Expert in writing SQL query using multiple databases like ORACLE, SQL Server etc.

Experience in integration of various data sources into staging area.

Extensive experience with Data Extraction, Transformation, and Loading (ETL) from Multiple Sources.

Designed and developed complex mappings, Mapplets, tasks and workflows and tuned it.

Experience in Debugging and Performance tuning of targets, sources, mappings and sessions in Informatica.

Good understanding of the Data modeling concepts like Star-Schema Modeling, Snowflake Schema Modeling.

Experience in integration testing, supported User for UAT testing.

Experience in Performance tuning of ETL process using pushdown optimization and other techniques.

Created debugging and performance tuning of sources, targets, mappings, transformations and session.

Hands on experience working on Waterfall Model as well as Agile Model.

Quick learner and can work well under pressure, also a team player and enjoy collaborating with others to find creative solutions to complex problems. 2

Education:

B. tech in Electronics and Communication Engineering from Jawaharlal Nehru Technological University, India

Technical Skills:

ETL Tools Informatica PowerCenter 10.4/9.6/9.1.1, Informatica Cloud IICS Database Oracle 18c/12c/11g, SQL Server 2014/2017

DB Tools MySQL, Oracle SQL Developer, TOAD

Data Modeling Logical/Physical/Dimensional, Star/Snowflake Star Schema Other Tools Control M, AutoSys, BitBucket, Rally, JIRA, Putty, WinSCP, Rally, Notepad++

Projects:

Client: Anthem, Inc

Location: Atlanta, Georgia

Duration: Jan 2021 to current

Project Name: Consolidated data warehouse

Anthem, Inc. operates as a health benefits company in the United States. The company offers a spectrum of network-based managed care health benefit plans to large and small groups, individuals, Medicaid, and Medicare Worked with business analyst for requirement gathering, business analysis, testing, business process descriptions, scenarios and workflow analysis. Responsibilities:

Created Technical Design Document from business requirements document (BRD).

Analyzed business and system requirements to identify system impacts.

Created the Detail Technical Design Documents which have the ETL technical specifications for the given functionality.

Prepared source to target mapping and conducted meetings with the business to understand data

/ transformation logic.

Analyzed the existing mapping logic to determine the reusability of the code.

Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables.

Done the extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.

Created Unit test plans and did unit testing using different scenarios separately for every process. Involved in System test, Integration test and supported the UAT for the client.

Performing ETL and database code migrations across environments using deployment groups.

Populating the business rules using mappings into the target tables.

Involved in end-to-end system testing, performance and data validations. 3

Managed performance and tuning of SQL queries and fixed the slow running queries in production.

Created batch scripts for automated database build deployment.

Modified UNIX scripts to run informatica workflow.

Used CI/CD pipeline to secure code in Bitbucket

Ensured acceptable performance of the data warehouse processes by monitoring, researching and identifying the root causes of bottlenecks.

Environment: Informatica PowerCenter 10.4, IICS, SQL, Oracle 18c, TOAD, Control M, Rally Client: Truist Banks, Inc. Atlanta, GA

Location: Atlanta, Georgia

Duration: Sept 2019 to Jan 2021

Project Name: Integrated Data Mart

BB&T and SunTrust formed Truist with a shared purpose—to inspire and build better lives and communities. Truist offers a wide range of services including retail, small business and commercial banking; asset management; capital markets; commercial real estate; corporate and institutional banking; insurance; mortgage; payments; specialized lending; and wealth management. The project is aimed at developing dashboard and reports for their huge customer base that will be helpful for long-term decision-making, strategic plans, support and solutions giving stakeholders ability to access, analyze and help stakeholder to automate extract process for down-line application. Responsibilities:

Worked with the business team to gather requirements for projects and created strategies to handle the requirements.

Used Informatica PowerCenter for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.

Designed and developed complex mappings using Mapping Designer to move data from multiple sources and transformed data into a common target area such as Data Marts and Data Warehouse.

Used transformations like Aggregators, Sorter, Dynamic lookups, Connected & unconnected lookups, Filters, Expression, Router, Joiner, Source Qualifier, Update Strategy, sequence Generator.

Prepared Technical Design documents and Test cases.

Created Sessions and Workflows and extracted data from various sources, transformed data according to the requirement and loaded into data warehouse.

Performed Unit and Integration Testing to ensure the successful execution of data loading process.

Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.

Extensively worked on Unit testing for the Informatica code using SQL Queries and Debugger.

Used PMCMD command to run workflows from command line interface.

Improved performance testing in Mapping and the session level.

Documented Mappings, Transformations and Informatica sessions.

Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations.

4

Extensively used mapping parameters, mapping variables and parameter files

Involved in troubleshooting the loading failure cases, including database problems.

Worked on tuning SQL statements

Environment: Informatica PowerCenter 9.6.1, SQL, Oracle 12c, SQL Server 2017, Control-M, JIRA Client: HD Supply Holding

Location: Atlanta, GA

Duration: Sept 2017 to Sept 2019

Project Name: Omega data integration

HD Supply Holdings, Inc. is a holding company. The Company, through its subsidiaries, operates as an industrial distributor of products specializing in maintenance, repair & operations, infrastructure & power, and specialty construction. It sells its products primarily through a professional sales force, print catalog, and e-commerce channels to approximately 500,000 customers consisting of contractors, maintenance professionals, homebuilders, industrial businesses, and government entities Responsibilities:

Analysis, requirements gathering, functional/technical specification, development, deploying and testing.

Extensive use of Informatica Tools like Designer, Workflow Manger and Workflow Monitor.

Used transformations like Aggregators, Sorter, Dynamic lookups, Connected & unconnected lookups, Filters, Expression, Router, Joiner, Source Qualifier, Update Strategy, sequence Generator.

Used Workflow Manager/Monitor for creating and monitoring workflows and worklets.

Used mapping parameters, mapping variables and parameter files

Worked on tuning SQL statements

Prepared Test Cases and performed system and integration testing

Created and Monitor the Sessions.

Created Informatica mappings to load the data from staging to dimensions and fact tables.

Conducting unit testing and Prepared Unit Test Specification Requirements.

Configured the mappings to handle the updates to preserve the existing records using update strategy transformation.

Used most of the transformations such as the Aggregators, Filters, Routers, Sequence Generator, Update Strategy, Rank, Expression and lookups (connected and unconnected) while transforming the Data according to the business logic.

Involved in troubleshooting the loading failure cases, including database problems.

Created sessions, reusable worklets and workflows in Workflow Manager

Improved performance by identifying the bottlenecks in Source, Target, Mapping and Session levels.

Environment: Informatica PowerCenter 8.6, Cognos 9, WinSCP, Oracle 12c, TOAD, Putty, AutoSys, UNIX, Erwin 7.5

Contact this candidate