Candidate Information Title Senior Data System Integration Target Location US-TX-Austin Email Available with paid plan Phone Available with paid plan	20,000+ Fresh Resumes Monthly     View Phone Numbers     Receive Resume E-mail Alerts     Post Jobs Free     Link your Free Jobs Page     ... and much more Register on Jobvertise Free
Search 2 million Resumes Keywords: City or Zip:	Related Resumes Senior big data engineer San Marcos, TX Data Center System Management San Antonio, TX System Architect Senior Leander, TX Senior Data Engineer Austin, TX Data Engineer Senior Austin, TX Senior Executive, CSuite, Leader, Health System, Entrepeneur New Braunfels, TX Senior data analyst Austin, TX

PROFESSIONAL SUMMARYSKILLSETEDUCATIONMobile : PHONE NUMBER AVAILABLEEmail: EMAIL AVAILABLELinkedin: https:// LINKEDIN LINK AVAILABLE Experienced Senior Data Warehouse Analyst with a solution-oriented approach and 5 years of professional work experience. Extensive experience in writing complex SQL queries for business logic validation and transformations. Solid understanding of data warehousing concepts, including star and snowflake schemas. Proficiency in system integration testing, with a focus on SQL query development and execution. Thorough knowledge of Agile (Scrum) software development methodologies. Hands-on experience with star schema/snowflake schema analysis and source system evaluation. Skilled in requirement analysis, test case preparation, execution, and defect management processes. Expertise in data modeling and proficient in transformations. Strong ability in preparation of test data according to transformations. Familiarity with ETL processes in system integration testing. Experienced in HP-ALM Test Management tool for efficient test case management. Proven track record in writing test cases for initial and incremental loads, as well as SCD Type 2 testing. Testing experience with Informatica Power Center. Proficient in UNIX commands and Windows operating systems. Excellent documentation and presentation skills. Effective collaboration with project teams for scoping, prioritization, and issue resolution. Active involvement in daily standup meetings, Scrum meetings, sprint reviews, and mapping document walkthrough calls. Skills : ETL Testing, Data Modelling, Data Warehousing, MySQL Databases Worked On : SQL Server, Oracle, Teradata Programming Languages : SQL Tools : SQL Server Management Studio, Oracle SQL Developer, Teradata SQL Assistant, Beyond Compare tool, Defect Management Tool : HP Quality Center, HP ALM Operating System. : Unix & Windows Cloud Technologies : AWS Master of Science in Computer Science from Texas A&M University, Kingsville, Texas, May 2024(Expected). Bachelor of Technology in Computer Science(2012-2016) from J Bhaskar Rao Institute Of Engineering And Technology, Hyderabad.Description:Mphasis Pvt LtdMar 2021-Oct 2021F&G is the Insurance company, which gets its revenue by selling the policies. F&G needs agents or brokers to sell policies. NTT is one of the FGL agent, which is a Third-Party Administrator. All the policy administration work is handled by NTT. F&G is associated with Mphasis for Testing requirements and similarly with other vendors like DTCC. Roles and Responsibilities: Running the Informatica Jobs in SIT Environment to load the Data from source to Target. Preparation of Test Data as part of Incremental load Testing when source data is not available. Raising the Defects while executing the Initial and Incremental load Testing. Attending the calls with Dev team to discuss about the Defects that found during the SIT and Re- Testing them once they got fixed. Attending the Test case walk through calls along with Test Lead with BA Team. Going through the Mapping Document and analyzing the requirements. Understanding the Business Requirements which exists in Mapping Document. Writing the required SQL to verify the Source and Target Data. Raising the Defects in HP-QC according to Mismatches. Project #1PRUDENTIAL LIFE INSURANCEDatabases Oracle, TeradataDomain  InsuranceDuration  Oct 2019 to Feb 2021.Description:WIPRO TechnologiesJan 2017- Feb 2021Prudential is a leading life insurance and financial services institution in the United States, offering a diverse range of financial products and services both domestically and internationally. Renowned for its extensive portfolio, Prudential ranks as the second-largest institution by revenue. Specializing in retirement solutions, Prudential offers the following primary products:1) Defined Contribution Plan2) Defined Benefit Plan3) Non-Qualified PlanRoles and Responsibilities: Analyzed mapping documents to discern project requirements and ensure alignment with business objectives. Interpreted and translated business requirements outlined in mapping documents into actionable testing strategies. Developed SQL queries to validate source and target data, ensuring data accuracy and integrity. Prepared test data for incremental load testing to evaluate system performance and reliability. PROFESSIONAL EXPERIENCE Participated in various testing phases including Functional, Non-Functional, System Integration Testing (SIT), and User Acceptance Testing (UAT). Conducted comprehensive verification of audit fields during incremental load testing to maintain data traceability and compliance. Identified and documented defects during initial and incremental load testing phases, facilitating prompt resolution and improving system robustnessProject #2WALGREENSDatabases SQL Server, Oracle Environment  Informatica, HP QC Domain  RetailDuration Jan 2017 to Sep 2019Description:Implemented Sales Data Warehouse project to analyze sales of major brands and promotional schemes, utilizing historical data from various Walgreen stores. Generated comprehensive reports using Business Objects to analyze sales and profits on a monthly and yearly basisRoles and Responsibilities: Execute Informatica jobs in SIT Environment for data loading. Prepare test data for Incremental load Testing. Proficient in creating, reviewing, and executing Test cases using HP-QC Test Management Tool. Validate source and Target data through test case execution. Report defects in HP-QC based on discrepancies. Participate in Test case, Defect validation, and Defect Triage meetings. Attend Daily Standup, Sprint Planning, and Sprint Review meetings, updating status in Team Foundation Server. Conduct test case walkthroughs with Business Analysis Team. Engage in Performance Testing for Informatica job execution time evaluation. Conduct Sanity Testing by reviewing Informatica Mapping and Workflow Details. Collaborate with BA & Dev teams to resolve issues effectively.