Job Description :
Job Description:

Job Title: Tech Lead - Data Analyst
Relevant Experience (Yrs: 8-10 Years
Education: Bachelors or Masters
Work Location: Cincinnati, OH

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 ware house/DataMart design knowledge. Having ETL (Data stage 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 Data stage.
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 Data stage 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
Generic Managerial Skills:
Work as team player
Excellent communication and interpersonal skills

Please share your updated resume at or feel free to contact me at