Overview
Skills
Job Details
Role: Senior Data Scientist (ETL, Informatica Cloud)
Location: Austin, TX (Remote)
Duration: 1-4 Years
Overall Experience :15+ Years
Summary:
Perform complex Data Scientist work. Analyze information in the client 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.
Required Skills:
- 8 Years of Design and develop Extraction, Transformation, Load (ETL) processes for enterprise data warehouse using Informatica; Deep hands-on expertise with Informatica ETL processes, development, data management, data profiling, data flows, data relationships, and data quality standards and processes
- 8 Years of Hands-on 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 Years of Experience in Data Science
- 8 Years of Hands on experience with data modeling preferably in a data warehouse environment
- 8 Years of Experience with Informatica product suite in the Informatica cloud
- 8 Years of 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 Years of Experience with detecting and providing solutions to addressing mismatched data in case management systems
Preferred Skills:
- 5 Years of More than one type of RDBMS (DB2, SQL Server, Oracle)
- 5 Years of Erwin or other equivalent data modeling tools
- 3 Years of Experience in Amazon Web Services
- 2 Years of Experience with detecting and providing solutions to addressing mismatched data in case management systems