Data Warehouse Consultant Job at Mastech Inc. in Dallas

Mastech Digital is an IT Staffing and Digital Transformation Services company.

Mastech Digital provides digital and mainstream technology staff as well as Digital Transformation Services for all American Corporations. We are currently seeking a Data Warehouse Consultant for our client in the Financial Services domain. We value our professionals, providing comprehensive benefits and the opportunity for growth. This is a Contract position, and the client is looking for someone to start immediately.

Duration: 2+ Months Contract with possible extension

Role: Data Warehouse Consultant

Primary Skills: Data Warehouse

Role Description: The Data Warehouse Consultant must have 9+ years of experience. We are looking for a local candidate who is comfortable going onsite to Dallas, Texas location.

Required Experience and Skills:

1. 5-9 years of experience in the implementation of Data warehouse/BI solutions.
2. Expertise in SSIS, DW / BI and SQL.
3. Knowledge of Scheduling Tools (Tivoli, Autosys etc.), Data Modeling, Project Management.
4. Well versed with knowledge of Data warehousing concepts including: SCDs, star schema, hierarchy, aggregation.
5. Should have expertise in ETL tools like SSIS, RDBMS (at least one) like Oracle, Teradata, SQL Server, DB2 and considerable experience in Testing which activities like creating system/integration/performance test plan, performing system/integration/performance testing, defect tracking, root cause analysis of defects, support user acceptance testing (UAT) and facilitate UAT sign off, Deployments/Migrations across Environments.
6. Should be well versed with Performance Tuning Techniques in SSIS and RDBMS.

Required Skills (Top two are absolutely must haves):

1. 8+ years of overall software development experience is required primarily with Data warehouse applications.
2. 3+ years of hands-on development experience in Cloud-based data warehouse platform – primarily AWS Redshift.
3. 3+ years of development experience with Python scripting experience.
4. 2+ years of development experience with ETL tools (Informatica, Azure Data Factory, etc.).

Other desired attributes are:

1. Experience with Moving Legacy DBs to Cloud.
2. Strong knowledge and experience in data modeling & design with relational and NoSQL DBs.
3. Demonstrated expertise in performance tuning in various DB environments.
4. Experience building and scaling distributed, highly available systems in cloud env (Azure/AWS).
5. Expertise in understanding complex business needs, analyzing, designing, and developing solutions.
6. Communication and professional skills and the ability to establish relationships across business units.

Education: Bachelor’s degree in Computer Science, Electrical/Electronic Engineering, Information Technology or another related field or Equivalent

Experience: Minimum 9+ years of experience

Relocation: This position will not cover relocation expenses

Travel: No

Local Preferred: Yes

Note: Must be able to work on a W2 basis (No C2C)

Recruiter Name: Parth Mishra

Mastech Digital is an Equal Opportunity Employer - All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.

#J-18808-Ljbffr