US Citizen
Green Card
EAD (OPT/CPT/GC/H4)
H1B Work Permit
Corp-Corp
W2-Permanent
W2-Contract
Contract to Hire
Consulting/Contract
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 22nd Mar 2024
Oracle SQL and PL/SQL Data Warehouse Engineer
Location: Hybrid 3x a week onsite in Chicago IL (local only)
Interview Mode: Virtual Interview
Type: 12-18 month Contract
Work authorization: Cannot work with OPT or CPT
Must have old LinkedIn with good connection
Description
Experienced both in the specific business domain and the software engineering domain. These candidates are not only technology intensive but also possess experience of the specific business area. Have worked on similar projects and have a proven history of delivering high impact business solutions in the specific business area. Responsible for the technical vision, high-level architecture, design, and implementation of complex systems and applications. Ability to interact and communicate effectively with senior level business teams to ensure optimal results. Aside from the business specific knowledge, the individuals will also possess a complete understanding and mastery of the enterprise software development lifecycle.
Specifically, this candidate should be able to perform in the following activities:
1. Strong in SQL and Data warehouse concepts – Hands on experience working in a datawarehouse environment
a. Write complex SQLs to analyze/profile datasets and identify patterns
b. Recommend solutions based on data analysis
c. Demonstrate strong analytical and problem solving skills and be quick to identify design related concerns
2. Provide Data Requirements
a. Collaborate with Subject Matter experts and Business partners in gathering data requirements
b. Work independently and demonstrate strong understanding of existing Data model and ETL processes
c. Experience providing data flow diagram, table structure and ETL specifications including transformation rules required for source to target mapping
d. Identify ETL dependencies and help orchestrate a sequence of data loads in the ETL pipeline
e. Demonstrate good communication and presentation skills with the ability to articulate data requirements, design concerns, etc.
f. Demonstrate strong negotiation skills while working with developers, architects to solution the data needs.
3. Validate the accuracy, integrity and quality of Data developed
4. Support defects triage
a. Participate in the SIT, UAT defects triage and help set up a defect resolution path
b. Assess defects on their impacts and help set up priorities
5. Guide the production support team on unforeseen issues, ETL abends