Location: Chicago, IL (need to report at client office from day 1)
Job Description
- Strong in SQL and Data warehouse concepts Hands on experience working in a datawarehouse environment
- Write complex SQLs to analyze/profile datasets and identify patterns
- Recommend solutions based on data analysis
- Demonstrate strong analytical and problem solving skills and be quick to identify design related concerns
- Provide Data Requirements
- Collaborate with Subject Matter experts and Business partners in gathering data requirements
- Work independently and demonstrate strong understanding of existing Datamodel and ETL processes
- Experience providing data flow diagram, table structure and ETL specifications including transformation rules required for source to target mapping
- Identify ETL dependencies and help orchestrate a sequence of data loads in the ETL pipeline
- Demonstrate good communication and presentation skills with the ability to articulate data requirements, design concerns, etc.
- Demonstrate strong negotiation skills while working with developers, architects to solution the data needs.
- Validate the accuracy, integrity and quality of Data developed
- Support defects triage
- Participate in the SIT, UAT defects triage and help set up a defect resolution path
- Assess defects on their impacts and help set up priorities
Mandatory Skills
SQL
ETL
IBM DataStage