Data Warehouse Sql Server

Surya Sri Lakshmi Indukuri

***************.********@*****.***

SUMMARY

●IT Professional with 7+ years’ experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Financial Sectors.

●Strong experience in Extraction, Transformation and Loading (ETL and ELT) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manager), Power Exchange, Power Connect as ETL tool on Oracle, SQL Server Databases and flat files and dbt(ELT) on Snowflake Data Warehouse.

●Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.

●Good understanding of DataVault modeling principles and methodologies.

●Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.

●Create and execute manual test cases/scenarios, perform tests including functional, integration, and regression performance and create test reports subsequently communicating reports to stakeholders.

●Create test strategies for manual execution and automation scope in collaboration with team members and business partners to ensure test coverage.

●Extensively worked preparing test cases during integration of various data sources like Oracle, DB2, SQLServer, Flat Files and Mainframe into Warehouse.

●Experience with running workflows using Autosys.

●Do CODE Builds and Deploy using Jenkins and UDeploy in Non Prod regions.

TECHNICAL SKILLS

●Database: SQL SERVER 2008 R2/2012/2016, Oracle

●ETL Tools: Informatica Power Center

●Cloud Technologies: Snowflake and dbt

●Languages: UNIX, SQL, PL/SQL and SnowSQL

●Others: GITHUB, Autosys, Jenkins and Udeploy

●HP QUALITY CENTER and JIRA

●Mainframe: JCL, SEQUENTIAL files.

EDUCATIONAL QUALIFICATION

●Bachelor’s Degree, Computer Science Engineering, 2009

PROJECT EXPERIENCE

Bank Of America Mar 22 - Mar 24

Role: Software Engineer.

Responsibilities:

●Developed ETL programs using Informatica to implement business requirements.

●Communicated with business customers to discuss the issues and requirements.

●Loading data into snowflake tables from the internal stage using snowsql.

●Used SNOWFLAKE FLATTEN table function to produce a lateral view of VARIANT, OBJECT and ARRAY columns.

●Involved in building the ETL architecture and Source to Target mapping to load data into the Data warehouse.

●Created mapping documents to outline data flow from sources to targets.

●Wrote PL/SQL procedures for data migration and validation.

●Design, develop, and maintain database objects such as tables, views, stored procedures, functions, and triggers using PL/SQL.

●Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.

●Understand the business rules completely based on High Level document specifications and implement the data transformation methodologies.

●Created SLA documents by coordinating with up/down stream applications.

●Team player, motivated, able to grasp things quickly with analytical and problem solving skills.

Wells Fargo Mar’20 – Oct’21

Role: Software Engineer.

Responsibilities:

●Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.

●Parsed high-level design specification to simple ETL coding and mapping standards.

●Designed and customized data models for Data warehouse supporting data from multiple sources in real time.

●Extracted the data from the flat files and other RDBMS databases into the staging area and populated onto the Data warehouse.

●Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.

●Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.

●Developed mapping parameters and variables to support SQL override.

●Created mapplets to use them in different mappings.

●Developed mappings to load into staging tables and then to Dimensions and Facts.

●Used existing ETL standards to develop these mappings.

●Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.

●Created sessions, configured workflows to extract data from various sources, transformed data, and loaded into data warehouse.

●Involved in Performance tuning at source, target, mappings, sessions, and system levels.

●Prepared migration document to move the mappings from development to testing and then to production repositories.

●Analyze the source data using SQL queries and prepare the test scripts based on requirement.

●Track the defects/bugs using ALM and JIRA and discuss with the developer team during meetings.

●Prepared migration document to move the mappings from development to testing and then to production repositories.

CITI. Jun’16 – Feb’20

Role: Software Engineer

Responsibilities:

●Using Informatica PowerCenter created mappings and mapplets to transform the data according to the business rules.

●Used various transformations like Filter, Router, Expression, Lookup (connected and unconnected), Aggregator, Sequence Generator, Update Strategy, Joiner, Normalizer, Sorter and Union to develop robust mappings in the Informatica Designer.

●Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.

●Documented Informatica mappings in Excel spreadsheet.

●Extracted data from Flat files, DB2, SQL and Oracle to build an Operation Data Source. Applied business logic to load the data into Global Data Warehouse.

●Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time.

●Written documentation to describe program development, logic, coding, testing, changes and corrections.

●Created a detailed Unit Test Document with all possible Test cases/Scripts.

●Conducted code reviews developed by my teammates before moving the code into QA.

●Migrated the code into QA (Testing) and supported QA team and UAT (User).

●Provided support to develop the entire warehouse architecture and plan the ETL process.

●Modified existing mappings for enhancements of new business requirements.

●Works as a fully contributing team member, under broad guidance with independent planning & execution responsibilities.

Contact this candidate