*Smoking Hot Requirement for Systems Analyst with Data warehouse Experience || Bellevue, WA || 6+ Months Contract Possible to Ext*
******For Immediate feedback please forward your resume to b...@catstaffing-us.com ****** Job Title : Systems Analyst with Data warehouse Experience Location : Bellevue, WA Duration : 6+ Months Contract Possible to Ext *Today Interview* Job Requirements- • Take all the data flowing in from prepaid and postpaid (monthly contracts) from the client’s 1,700 stores and 17,000 dealers and changes to customer records and store it all in the one big integrated data store. • Work with the business and development teams to design the interfaces and document them into FSD and TDD’s • Experience working with big data, millions of transactions, and tables with 5 million rows and be able to help work through design issues • Participate in the business analysis and technical design sessions with business and technical staff todevelop requirements documents and ETL specifications • Will need strong design skills focused on scalability, performance, and data integration • Understand data analysis and data acquisition • Understand data, data sources, and help to define quick ways to get data • Experience with high volume, transaction based systems with millions of records/transaction a day (they are dealing with scalability and performance issues in support of real time data) • Ability to apply business rules and process data for mission critical financial information • Experience writing and understanding SQL and understanding ETL development tools • Experience in logical and physical database design and implementation • Experience with SOA and Enterprise Service Platforms • Financial, telecom, or retail IT experience • Exposure building Data Flow Diagrams, Process Models, ER diagrams, Dimensional Data Models, Context Models, Event Modeling, State Modeling, Process Decomposition, and Use Case Scenarios • Demonstrate thorough working knowledge of the system development life cycle • Technical writing skills producing clear and unambiguous deliverables • Experience working withOracle (v 10 or 11g), SQL, and/or Informatica and worked with various data sources (data aggregation) in support of data warehouse or analytics for business purposes • Understand Informatica workflows using Informatica as an ETL tool • Ability to design and develop ETL mappings for source systems data extractions, data transformations, data staging, movement, and aggregation and be able to develop standard and re-usable mappings and mapplets using various transformations such as expression, aggregator, joiner, source qualifier, router, lookup, and filter • Ability to write and modify SQL stored procedures and/or be able to write queries in Microsoft SQL Server to create and upload data into tables • Experience with the design and integration withSOA and enterprise service platforms; need to understand service models • Ideal to have a development background • Must be articulate and have very strong communication skills Looking forward to hear from you Regards, Ben Smith Tel: (201) 257-5081 x 351 | Fax: (201) 342-2385 Email: b...@catstaffing-us.com | b...@catinc.com 411 Hackensack Avenue, 7th Floor Hackensack, NJ 07601 Visit us at - www.catamerica.com -- You received this message because you are subscribed to the Google Groups "SAP BASIS" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-basis+unsubscr...@googlegroups.com. To post to this group, send email to sap-basis@googlegroups.com. Visit this group at http://groups.google.com/group/sap-basis?hl=en. For more options, visit https://groups.google.com/groups/opt_out.