*Please find the requirement below , If you find yourself comfortable with the requirement please reply back with your updated resume with details to this email id **abha...@idctechnologies.com* <abha...@idctechnologies.com> *and I will get back as soon as possible.*
*Job Title: Data Analyst (PL/SQL Expertise required)* *Location: Lewisville, TX* *Contract Duration: 12+ months* *Interview Mode: Telephonic* *Job Description:* • Exploring and examining the mortgage banking data coming from multiple disparate sources. • Unwinding the existing logic in SQL Server/Oracle to fit in to new ICDW model and create STT (Source to Target) documents • Prepare a Base Query and the transformation logic for the respective target Integration Tables/Semantic views • Developing Source to Target Mapping for the incoming data, certifying the quality of data in tables and files and also in getting the reporting requirement from business to incorporate it to SQL logic • Creating databases, users, tables, triggers, macros, views, stored procedures, functions, Packages, joins and hash indexes in Teradata database • Performance analysis, monitoring and SQL query tuning using EXPLAIN PLAN, Collect Statistics, Hints and SQL Trace both in Teradata as well as Oracle • Reviewing the referential and historical integrity of data warehouse information • Coordinate with key stakeholders, subject matter experts, application owners, IT and other analysts for business requirements gathering and analysis. • Help specify acceptance criteria for test data and ensure test data sampling meetings testing requirements • Ability to interface directly with Senior Business Stakeholders. • Intermediate level experience in MS Excel * Reply with below details with updated resume if you are interested.* JOB TITLE FULL NAME EMAIL ID CURRENT LOCATION WORK/VISA STATUS PRIMARY CONTACT NUMBER WILLING TO RELOCATE BEST TIME TO CALL AVAILABILITY SALARY/RATE EXPECTATION (W2/1099/C2C) TOTAL IT EXPERIENCE *Thanks & Regards,* Abhay Tiwari *IDC TECHNOLOGIES INC* | *1851 McCarthy Boulevard, Suite 116, Milpitas, CA , USA, 95035* *Phone No.: 408-457-9399 ext-2033 I Email: **abha...@idctechnologies.com* <abha...@idctechnologies.com>* I * *Gtalk: **abhaytiwari9...@gmail.com* <akt....@gmail.com> *LinkedIn ID: *https://www.linkedin.com/profile/view?id=198619619&trk *=nav_responsive_tab_profile**I* <https://www.linkedin.com/profile/view?id=198619619&trk=nav_responsive_tab_profileI> *Web: **www.idctechnologies.com* <http://www.idctechnologies.com/> "Under Bill s. 1618 Title III passed by the 105th U.S. Congress this mail cannot be considered spam as long as we include a way to be removed from our mailing list. Simply send us an e-mail with REMOVE in the subject and we will gladly REMOVE you from our mailing list." -- You received this message because you are subscribed to the Google Groups "SAP or Oracle Financials" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-or-oracle-financials+unsubscr...@googlegroups.com. To post to this group, send email to sap-or-oracle-financials@googlegroups.com. Visit this group at http://groups.google.com/group/sap-or-oracle-financials. For more options, visit https://groups.google.com/d/optout.