Data Architect

DESCRIPTION
The Data Architect role will be responsible for analysing test data needs and developing applications and tools to support these needs for integrated systems using existing and emerging technology platforms.

RESPONSIBILITIES

- Create an end-to-end vision of the integrated systems and translate into test data needs.
- Develop solutions that enable faster and better test data creation prior to test execution.
- Build self service solutions using existing and emerging technologies and enable the development and testing teams to create and load test data on their own.
- Create and maintain system and environment landscapes that are LOB specific, data flow diagrams and data definitions. 5. Actively participate in the TDM agile development sprint team and deliver valuable products for end users.
- Address issues with Data movement (Validation, Clean-up and Mapping) during testing.
- Develop integrated test data creation strategy for all platforms involved in the project or release.
- Understand changes to the environments and reflect them in test data creation processes.
- Identify and mitigate data integrity issues while testing across multiple integrated systems.
- Automate data creation, setup and implement automated refresh for regression ready test data.

SKILLS

REQUIRED QUALIFICATIONS

- 5 years of experience in IT industry with Data Analyst/Architecture/Data Modeling background
- 2 years of experience developing in an Agile Scrum environment
- Excellent knowledge of Relational Database Management Systems (Oracle, SQL Server, TeraData, DB2) and/or Data Modeling concepts
- 1 year of Scripting experience with Automation tools (such as VB, QTP, and Selenium)

PREFERRED QUALIFICATIONS

- IBM Optim, Ab Initio, and VersionOne tools knowledge is a plus
- Knowledge of programming in UNIX, MVS/Mainframe systems, ETL and SQL technologies
- Knowledge of Big data/Hadoop
- Knowledge of data masking/scrubbing/obfuscation techniques
- Proficiency in MS Office and Visio
- Knowledge of Financial Services/Home Loans/Mortgage/Auto Finance Businesses

Synectics is an Equal Opportunity Employer.