Senior Oracle Data Warehouse Architect/Developer
Chicago, IL 12 months SUMMARY: The Data Warehouse Architect/Developer will work closely with Risk IT and Risk IT business teams to understand requirements and handles data warehouse design/development and reporting. RESPONSIBILITIES: Work closely with Risk IT and Risk IT business teams to understand requirements and provide solution architecture design and technical specifications Ensure high quality and performance in the data architecture and data management results in delivering robust solutions to customers and clients Responsible for all activities including business analysis, data acquisition and access analysis and design, database and load optimization, ETL development and system implementation. Develop the detailed project plans for data requirements gathering, data modeling and database design, development and implementation. Facilitate JAD session with Risk IT and Risk IT business teams, walkthroughs/reviews for data requirements gathering, data models and database designs. Oracle OLAP experience is a must. Must be an expert on Oracle data warehousing design, ETL development, using parallel operations, partitioning, and materialized views. REQUIRED SKILLS: 10 years plus expert experience in Oracle architectural design and data management, configuration, logical & physical data modeling, backend processes and engineering. Strong experience in Star schemas slowly changing dimensions, table/index/materialized views partitioning and logs utilization. Proven track record of database performance tuning. Expert level on Query rewrite, Query Equivalence and Star Transformation. Experience designing, developing and deploying complex data warehouse ETL workflows with large data volumes. Experience in data warehousing, job scheduling, data profiling, data cleansing, data quality validation and testing. Possess strong communication and client management skills, and ability to effectively handle multiple tasks simultaneously DESIRED SKILLS: Experience in financial industries preferred in derivatives brokerage firm Oracle 11g experience is highly desirable. EDUCATION: BS in Computer Science or in a relevant field Mansoor Techgene Solutions LLC (A Minority Certified Company) 1304 W Walnut Hill Ln, Suite # 245 || Irving, TX 75038. Ph: 214-347-8810 || Fax: 972-692-5824 Email: <mailto:[email protected]> [email protected] <http://www.techgene.com/> www.techgene.com. || Y! : konnect2mansoor. <http://www.linkedin.com/in/reachmansoor> www.linkedin.com/in/reachmansoor
<<image001.gif>>
<<image003.jpg>>
