Tech Lead - Data Analyst - Cincinnati, OH - Georgia IT Inc.
Cincinnati, OH
About the Job
Job Title : Tech Lead - Data Analyst
Location : Cincinnati, OH
Salary : DOE (salary Plus benefits)
Position Type : Fulltime
Interview : Phone
(US Citizens/ GC/GC-EAD/TN/E3 preferred)
No sponsorship available for this job, direct hire and NO 1099 or C2C
Job Description
Technical/Functional Skills
Roles & Responsibilities: Essential Duties & Responsibilities
Location : Cincinnati, OH
Salary : DOE (salary Plus benefits)
Position Type : Fulltime
Interview : Phone
(US Citizens/ GC/GC-EAD/TN/E3 preferred)
No sponsorship available for this job, direct hire and NO 1099 or C2C
Job Description
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 Required8-10 Years.
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
- 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
Source : Georgia IT Inc.