drjobs Database Architect 2 - Informatica ETL

Database Architect 2 - Informatica ETL

Employer Active

1 Vacancy
drjobs

Job Alert

You will be updated with latest job alerts via email
Valid email field required
Send jobs
Send me jobs like this
drjobs

Job Alert

You will be updated with latest job alerts via email

Valid email field required
Send jobs
Job Location drjobs

Austin - USA

Monthly Salary drjobs

Not Disclosed

drjobs

Salary Not Disclosed

Vacancy

1 Vacancy

Job Description

Current Texas Residents OnlyDA2 Closes 05/03
Location: remote within Texas

In addition to meeting the minimum required skills the client is seeking a candidate with the following:
  • More than one type of RDBMS (DB2 SQL Server Oracle)
  • erwin or other equivalent data modeling tools
  • Experience in Amazon Web Services
  • Texas Workforce Commission experience
3. Scope/Description of Services
The Worker(s) will provide the following services:

Perform Database Architect work as a member of the Data Governance team overseeing one or more projects concurrently. Design develop and test Extraction Transformation Load (ETL) processes for the data warehouse. Develop and document ETL processes to extract data from existing systems into the data warehouse.
Document the asis schemas currently in use at TWC. Perform other analysis and documentation tasks as required to facilitate and support TWC s Enterprise Data Warehouse. Define and document the technical architecture.
Perform other analysis and documentation tasks as required. Perform other duties as assigned to maintain operations.

FORM A
Worker Minimum Requirements

As stated in Section 11 Response Format complete the number of years for the candidate s skill/experience for each requirement and ensure to merge the Worker resume after Form A.
Minimum Requirements: Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will not be considered for this opportunity. Years leave no
blanks) Years Skills/Experience Vendor Comments (as
applicable) 47 Design and develop Extraction Transformation Load (ETL) processes for enterprise data warehouse using Informatica; Deep handson expertise with Informatica ETL processes development data management data profiling data flows data relationships and data quality standards and processes 47 Handson experience with data warehouse development and testing (relational and dimensional) and proven evidence to implement using databases like Oracle SQL Server etc. but preferably Oracle 47 Analyzing and generating technical requirements and design 47 Hands on experience with data modeling preferably in a data warehouse environment 47 Experience with Informatica product suite in the Informatica cloud 47 Creating source to target mapping database documentation 47 Assist with migrating data from legacy database to new target database
Preferred: Years Skills/Experience Vendor Comment (as
applicable) 3 More than one type of RDBMS (DB2 SQL Server Oracle) 3
erwin or other equivalent data modeling tools
2 Experience in Amazon Web Services Texas Workforce Commission experience


Employment Type

Full Time

Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.