Vacancy expired!
- Responsibilities
- Work with Business Analyst to design dimensional model and source to target (ETL) specifications documentation
- Analyze and understand source data and business processes that may affect the model
- Analysis of Source system data, including data profiling
- Creates DDLs for creating/modifying database objects
- Documents Source to Target ETL Specifications
- Creates Technical specifications that show data flow process
- Design and optimize views
- Develop Informatica mappings to load source data into the data warehouse, works with data architect to design and schedule workflows
- Required
- Informatica ETL
- Microsoft SQL Server knowledge
- SQL programming
- Data profiling/analysis
- Data modelling experience
- Preferred
- Tableau, Cognos or similar reporting tools
- Oracle
- Erwin or similar data modeling tools
Vacancy expired!