*Job Title : Tech Lead - Data Analyst * *Work Location : Cincinnati, OH*
*Duration: Long Term* Relevant Experience (Yrs) : 8-10 Years Technical/Functional Skills : 8+ yrs of Rich Banking Domain knowledge (Wholesale/Commercial Lending knowledge is a +) MUST have Good SQL knowledge to do data analysis and write complex CTE/recursive queries and must have Data Modeling/Data wearhouse/Datamart design knowledge. Having ETL (Datastage preferable) development exp is must. 8+ years of experience in System Analysis, Design, Development, and implementation. and should have experience in leading the entire project from requirements gathering through prod implementation. Experience in creating Stored Procedures, Packages, Functions, Triggers, Materialized Views, Cursors and other database objects using SQL, PL/SQL. Experience in creating DDL, DML and Transaction queries in SQL. Experience in full life-cycle database including data architecture, logical and physical design, data modeling, and implementation. Writing scripts for collection of statistics, reorganization of tables and indexes, and creation of indexes for enhancing performance for data access. Experience in design of Data Warehouse/Data Mart, Star Schema, Snowflake, Erwin & Slow changing dimensions. Familiar with Data warehousing tools. Used ETL tools as Datastage. Experience in Unit Testing, System Testing and User Acceptance Testing, creating test cases using Mercury Testing Tools. Excellent verbal and written communication skills. Experience Required 8-10 Years. *Roles & Responsibilities : Essential Duties & Responsibilities* 1. Gathering Requirements and design of technical specification documents. 2. Identify Use cases from requirements and write Use Case Specifications 3. Create Mapping documents, ETL technical specifications and various documents related to data migration. 4. Write complex SQL Queries to test the Datastage ETL process 5. Ensuring project delivery on committed date 6. Reviewing designs with the rest of the project team as appropriate 7. Link business processes to organizational objectives, perform critical path analysis, and identify opportunities for business process improvement Generic Managerial Skills : Work as team player Excellent communication and interpersonal skills Education : Bachelors or Masters -- *Warm Regards* *Faiz Shaik* *Pace Computer Solutions Inc* *(**An Inc 500 Company**)* *10500 Little Patuxent Pkwy, Suite 310* *Columbia, MD 21044* *Phone*# 443-539-0949 *209 *Fax*# 443-539-0292 Toll Free # 1-877-225-PACE f...@pace-solutionsinc.com www.pace-solutionsinc.com ****** PACE Selected for the 2009 & 2010 Best of Columbia Award by the US Commerce Association ****** *Pace Computer Solutions, Inc. is a registered user of E-Verify* The contents of this message and any attachments are intended solely for the addressee(s) named in this message. This communication is intended to be and to remain confidential and may be subject to privilege. If you are not the intended recipient of this message, or if this message has been addressed to you in error, please immediately alert the sender and then destroy this message and its attachments. Do not deliver, distribute or copy this message and/or any attachments and if you are not the intended recipient, do not disclose the contents or take any action in reliance upon the information contained in this communication or any attachments. -- You received this message because you are subscribed to the Google Groups "IT RECURITER" group. To unsubscribe from this group and stop receiving emails from it, send an email to it-recuriter+unsubscr...@googlegroups.com. To post to this group, send email to it-recuriter@googlegroups.com. Visit this group at https://groups.google.com/group/it-recuriter. For more options, visit https://groups.google.com/d/optout.
