Test Data Management Lead

Test Data Management Lead

Job Description:

ARE YOU READY to step up to the New and take your technology expertise to the next level.
There is never a typical day at Accenture, but that's why we love it here! This is an extraordinary opportunity to build a rewarding career at Accenture Technology. Working in highly collaborative teams for world-leading clients, we'll nurture your talent in an inclusive culture that values diversity. Whatever your work and life goals, we'll help you achieve them sooner.

Who We Are:

Accenture Technology - is an exciting place to be! Accenture helps companies rotate to New IT with services that drive continuous quality and efficiency and shape their digital future. We offer entire breadth and depth of services across broad array of applications, digital technologies and industries delivered under flexible business arrangements. With 1000+ clients served globally and 30+ delivery centers, there will be many opportunities for you to help drive greater productivity and shift to continuous testing all while managing digital transformations.

The value for our clients and our people

For our clients, the Network provides the strength of our geographic diversity, greater resilience, and seamless access to the deepest industry knowledge, the latest in Gen AI solutions, and tech expertise from around the world.

For our people, it brings an opportunity to shape truly boundaryless career paths in a highly collaborative team of experts where they can learn from each other and solve the world's most complex client challenges.

The Work:

• Lead the analysis, estimation, design, development, testing, and implementation of data masking, data sub-setting, and synthetic data creation & provisioning solutions.

• Collaborate closely with the Test Manager/Test Lead from the planning stages to analyze and define Test Data Strategy and Test Data Requirements.

• Conduct pilot and implementation phases of Test Data Management systems for various clients.

• Interview client development teams, DBAs, and leads to understand current practices and derive solutions for test data challenges related to DevOps and Test Automation efforts.

• Provide complete solutions and design TDM frameworks, including data pattern derivation, database repository for capturing metadata, and rules engine for data elements and attributes.

• Utilize extensive knowledge in reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters, etc., in Tableau.

• Design and deploy rich graphic visualizations with dynamic page designs and control using Tableau.

• Create ETL mappings, mapplets, and workflows using Informatica Power Center to move data from multiple sources into target areas.

• Perform data quality profiling, planning, expression rules, and creating scorecards.

• Configure schema components, staging and landing tables, base objects, Lookups, and subject areas.

• Implement Data Warehouse solutions with a strong understanding of Data Warehouse concepts, data modeling using star schema/snowflake modeling for OLAP systems, ER Diagrams, Fact & Dimensions tables.

• Develop stored procedures, functions, triggers, cursors, joins, and SQL Queries with PL/SQL, and work with tools like TOAD, SQL Developer, SQL*PLUS.

• Use Control M, DAC, and Informatica Scheduler tools to organize and schedule jobs.

• Work with UNIX shell scripting, Windows Batch Scripting, FTP connections, and multiple platforms like Windows NT, Windows Server, and various UNIX environments.

• Coordinate offshore and onshore teams and work with databases installed on Oracle, SQL Server, and mainframe systems.

• Demonstrate excellent analytical and problem-solving skills, strong interpersonal and communication skills, and the ability to work effectively as part of a team.

• Be self-motivated, a quick learner, and adaptive to new and challenging technological environments.