Urgent Requirement of ::::: ETL Developer and data Analyst ::::: Cincinnati, OH ::::::: 12 Months Contract

 

Hi,

Hope you are doing great!

Please find the requirement below , If you find yourself comfortable with the requirement please reply back with the your updated resume and I will get back to you or I would really appreciate if you can give me a call back at my contact number 408-693-3170.

 

Role:           ETL Developer and data Analyst

Location:   Cincinnati, OH

Duration:   12 Months Contract

MOI:          Telephonic + Skype

 

Exp. Required:     7+ years preferred

 

Should have exp. In Banking & Finance

 

Require:  SQL, ETL Data Analyst

 

Technical Requirement          
• 6+ years of experience in System Analysis, Design, Development, and implementation.
• 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) knowledge is plus.
• 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.

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
Link business processes to organizational objectives, perform critical path analysis, and identify opportunities for business process improvement

 

Thanks and Regard's

www.enterprisesolutioninc.com

Arpan Chandra Technical Recruiter Enterprise Solution Inc. Office: 408-693-3170 E-Mail : arpan@enterprisesolutioninc.com

 

 

--
You received this message because you are subscribed to the Google Groups "US Jobs: Requirements, Clients and Consultants" group.
To unsubscribe from this group and stop receiving emails from it, send an email to recruiters-r-us+unsubscribe@googlegroups.com.
To post to this group, send email to recruiters-r-us@googlegroups.com.
Visit this group at https://groups.google.com/group/recruiters-r-us.
For more options, visit https://groups.google.com/d/optout.