Srinivas E Email & Phone Number

Gather business requirements and translate them to technical requirements.Identify data sources, collect data, source missing data, analyze data to find answers to specific questions.Research existing database methods and create a study for suggested changes.Analyze data for inconsistencies, data gaps, and data governance failures.Engage in cleaning and managing datasets, running database queries, and recommends corrective measures toimprove data governance where necessary.Work closely with stakeholders from other departments to ensure accurate reporting of data flow impacts and projectportfolio data.Work with large data sets with ability to extract, review, and understand material.Develop ETL workflow, to pull from different sources, transform and load the same into SQL Databases.Optimized SQL queries, stored procedures for maximum efficiency.

Everett, Washington, United States

Gather business requirements and translate them to technical requirements.Create scripts which pulls data from upstream source streams and include business logic & transformations to meetthe requirements.Modify the existing SQL scripts to incorporate the new business changes and validate the same.Create stories and tasks in ADO and update them on daily basis.Develop new test case scripts for the team on request for new validation requests from business.Execute the onboarded testcases for release validation tests for every release and generate reports for downstreampartners.Use the processed data to generate Metrics and compare between previous vs new release and send reports tobusiness.Test the developed SQL scripts in the INT environment.Replicating problems at testing labs and delivering resolutions accordingly in a timely manner

Atlanta, Georgia, United States

Gather business requirements and translate them to technical requirements.Create database objects tables, indexes, views, store procedures, and functions for data extraction from staging tablesto dimension tables and fact tables.Develop ETL workflow, to pull from different sources, transform and load the same into Databases.Use various advanced SSIS functionalities like complex joins, conditional splitting, and column conversions for betterperformance during package execution.Create and Improve performance of T-SQL stored procedures.Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.Work on upgrading of Oracle databases from 11g to 12c.Work on building and rolling out new 12c databases for Test/Dev/QA environments.Generate server-side PL/SQL scripts for data manipulation and validation and materialized views for remoteinstances.Participate in the full development life cycle, end-to-end, from design, implementation, and testing, to documentation,delivery, support, and maintenance and producing comprehensive, usable dataset documentation and metadata usingJIRA.Maintain all the source code in the GIT. Help team member while pushing their code changes using GIT.

Gather business requirements and translate them to technical requirements.Create database objects tables, indexes, views, store procedures, and functions for data extraction from staging tablesto dimension tables and fact tables.Set up Development, Test and Production environments.Develop ETL workflow, to pull from different sources, transform and load the same into Databases.Use principles of Normalization to improve the performance. Involved in ETL code using PL/SQL to meetrequirements for Extract, transformation, cleansing and loading of data from source to target data structures.Design SSIS packages for synchronizing the data between two different servers.Use the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.

India

India

India

India