Nageswara Reddy

Dynamic ETL Test Lead at Accenture Service PVT.LTD. with proven expertise in data validation and SQL scripting. Adept at mentoring teams and enhancing data integration processes, achieving significant improvements in data accuracy. Strong leadership and analytical skills drive successful project outcomes in agile environments. Seasoned ETL Test Lead with a strong background in data warehousing, testing methodologies, and defect management. Demonstrates adeptness in leading teams to conduct thorough ETL testing, and ensure high-quality data integration. Known for problem-solving skills, ability to streamline processes, and commitment to meet project deadlines. Previous work has significantly improved the data accuracy and efficiency of ETL processes.

NCAP (KP)

Tools: Azure Data Factory, IICS, Synapse, Hadoop - Hive, Zeppelin, JIRA, HP ALM, Qtest

Kaiser Permanente (KP), the largest non-profit health plan in the United States, leads and mentors a team of data engineers and database administrators, understands the requirements of the project based on the data model, builds and manages data infrastructure like data lakes, warehouses, and pipelines, is involved in Sprint Planning and creating stories and subtasks in JIRA, loads Hive data into Synapse using Azure Data Factory, creates its own data flows to perform full data comparison, validates various frameworks through IICS, writes the scripts to validate the transformation rules, analyzes the metadata and mapping document, prepares the traceability matrix, and tracks defects in ALM PBM EDW Development, Accenture Service PVT LTD, Wellcare, Hadoop, Informatica BDE, Hive, Greenplum, Autosys, UNIX, HP ALM, and Wellcare Health Plans, which focuses exclusively on providing government-sponsored managed care services, understands the requirements of the project by analyzing BRD, HLD, and LLD, is involved in Test Estimation and Test Plan preparation, tracks the daily project status, and updates it in the daily status calls, writes the scripts to validate the transformation rules, analyzes the metadata and mapping document, prepares the traceability matrix, tracks defects in ALM, and reviews the queries and other documentation

Responsibilities:-

• Lead and mentor a team of QA engineers, and provide technical guidance and expertise
• Understanding the requirements of the project based on the data model provided by the business
• Involving test planning, design, executing jobs, and reviewing the testing documents created by the team, also reviewing the system integration testing results, and deploying the code
• Involved in sprint planning and creating stories and subtasks in JIRA for the team; monitor the percentage of completion on daily status and update the product owner in the daily scrum call
• Loading Hive data into Synapse (SQL Server) using Azure Data Factory, and comparing the data between Hadoop and Synapse as per the business requirements
• Creating my own data flows to perform a full data comparison against business rules in Azure Data Factory, as well as in the DE tool
• Validating various frameworks through IICS.
• Writing the scripts to validate the Transformation Rules applied to the columns
• Analyzing the metadata, mapping document, and creating the test cases and test scripts
• Preparation of the Traceability Matrix.
• Tracking defects in ALM for raising, verifying, closing, and re-opening of defects
• Reviewing the queries written by other team members
• Providing the KT sessions to the team members on healthcare domain knowledge

Informatica Power Center, BDE, Azure Data Factory, IICS, Databricks, Hadoop, Greenplum, Oracle, SQL Server, Synapse, UNIX, Databricks, Autosys, HP ALM, JIRA, Qtest, Zeppelin, Data Engineering, Healthcare

• Lead and mentor a team of ETL testers and database administrators.
• Lead the Test Planning, design, executing jobs and review the testing documents.
• Tested and deployed subject areas like PBM, ESA, Claims, etc.
• Designing, building, and maintaining high-quality reusable data products.
• Involved in ETL processes, data integration, and data transformation workflows.
• Provide support to collaborators throughout the development lifecycle.
• Experience in doing data validations, count validations, DDL check, etc.
• Experience of working in an agile environment and self-managing teams.
• Collaborating and engage with BI & analytics and the business team.
• Involved in supporting adhoc data requests from the client.
• Expertise in Migrating data into Cloud Azure data Factory – Synapse from Hadoop – Hive.
• Performing Design, Development & Deployment using Azure Services.
• Good at Team Management and Preparing regular Status trackers.