*Need GC,USC or GC EAD's*
USG direct client is looking for *Tech Lead - Data Analyst *at *Cincinnati, OH* *Role: **Tech Lead - Data Analyst* *Location: **Cincinnati, OH* *Interview: Phone/Skype* *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.* *Roles & Responsibilities : Essential Duties & Responsibilities* *· **Gathering Requirements and design of technical specification documents. * *· **Identify Use cases from requirements and write Use Case Specifications* *· **Create Mapping documents, ETL technical specifications and various documents related to data migration.* *· **Write complex SQL Queries to test the Datastage ETL process * *· **Ensuring project delivery on committed date* *· **Reviewing designs with the rest of the project team as appropriate* · *Link business processes to organizational objectives, perform critical path analysis, and identify opportunities for business process improvement* *Please share your updated resume at **[email protected]* <[email protected]>* or feel free to contact me at **614-401-5194* -- You received this message because you are subscribed to the Google Groups "Oracle-HRMS-India" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/oracle-hrms-india. For more options, visit https://groups.google.com/d/optout.
