Test Data Management (TDM) - Data Warehouse ETL Developer

Zions Bancorporation   •  

Salt Lake City, UT

5 - 7 years

Posted 247 days ago

This job is no longer available.


  • Provide assessments of technical options as needed for large data and subsets
  • Work with analysts to understand functional and non-functional requirements
  • Understand and evaluate the relevant architecture and design documentation
  • Create detailed design specifications and development plans
  • Create technical proposal documentation and end user documentation
  • Work on database, generate SQL DDLs and procedures to support IM OPTIM development
  • Understand and implement different data masking technical on IBM OPTIM
  • Develop IBM OPTIM objects (e.g. extract, convert, insert) and the relevant scripts/functions to support those, as per the design specification
  • Write and execute unit test cases; identify and fix defects
  • Identify any potential issues and riskassociated with specific development activities
  • Automate test data mining for stakeholder groups and functional areas
  • Perform other duties as assigned


  • Requires a Bachelor's degree in Computer Science, Information Systems or a related field
  • 4+ years experience with analyzing, designing and developing of ETL systems, data warehouse applications and systems, relational databases; i.e. DB2 or Oracle, SQL, database design, ETL languages.
  • At least 2 years of experience with IBM OPTIM test data management on distributed 
  • Familiar with Unix/AIX, ANSI SQL, PL/SQL,Db2 SQL and Shell scripting
  • Ability to coordinate with stakeholders and gather information and data requirements
  • Experience in generating production-like and reusable test data that meets complex business data rules between integrated applications
  • Experience in sampling application data to meet business data rules of integrated systems
  • Experience in data profiling, sub setting, obfuscation, and test data fabrication
  • Experience validating test data copied to numerous test systems
  • Experience with automated data extraction and injection to support an iterative, repeatable process to support end to end testing of key business processes
  • Preferred experience in banking or financial services domain
  • A combination of education and experience may meet requirements.

Job Number:  040037