drjobs Data Scientist - Big Data Engineer - Informatica ETL

Data Scientist - Big Data Engineer - 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, TX - USA

Monthly Salary drjobs

Not Disclosed

drjobs

Salary Not Disclosed

Vacancy

1 Vacancy

Job Description

US Residents OnlyDS3 Closes 05/09
Location: Remote

Scope/Description of Services
The Worker(s) will provide the following services:
Perform complex Data Scientist work. Analyze information in TWC s Enterprise Data Warehouse and design develop and test processes for the data warehouse. Develop and document processes to extract data from the data warehouse for accurate reporting. Conduct complex data analysis and visualization tasks along with gathering determining data quality/profiles data cleansing and preparing data from various sources. Perform other analysis and documentation tasks as required to facilitate and support the Enterprise Data Warehouse. Define and document the technical architecture. Provide a written report of assessment methodology findings gap analysis conclusions and recommendations for a more robust method of reporting data. Communicate with the project stakeholders management and other relevant parties to discuss methodology approach and schedule. Perform other duties as assigned to maintain operations. Eight years Informatica ETL experience minimum.

TWC to obtain expert services to:
  • Assess TWC s Workforce Innovation and Opportunities Act (WIOA) customer data contained in TWC s Virtual One Stop case management system for potential data quality issues impacting TWC s ability to produce WIOA performance data that is consistent accurate and reliable including production of U.S. Department of Labor Participant Individual Record Layout (PIRL) Reports for submission in the Workforce Integrated Performance System (WIPS).
  • Assess and evaluate the current analytics model used to create data (files/detail tables) merge data process and calculate data and produce outcomes data that reliably supports tracking performance outcomes for WIOA services provided by the State and its twentyeight 28 Local Workforce Development Boards.
  • Provide a written report containing the assessment methodology findings conclusions and recommendations for corrective actions. The report would also include a proposed specific resolution plan that contains specific actionable tasks to implement in order to effectively resolve identified findings.
Required
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) 8 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 8 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 8 Experience in Data Science 8 Hands on experience with data modeling preferably in a data warehouse environment 8 Experience with Informatica product suite in the Informatica cloud 8 Experience devising and utilizing algorithms and models to mine data; perform data and error analysis to improve models; clean and validate data for uniformity and accuracy 3 Experience with detecting and providing solutions to addressing mismatched data in case management systems
Preferred
Years Skills/Experience Vendor Comment (as
applicable) 5 More than one type of RDBMS (DB2 SQL Server Oracle) 5 Erwin or other equivalent data modeling tools 3 Experience in Amazon Web Services 2 Experience with detecting and providing solutions to addressing mismatched data in case management systems

Employment Type

Full Time

Company Industry

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.