Job Title | SQL Developer |
Project Location | Austin, TX |
Duration | 3+ Months Contract |
Interview Mode: Phone+ F2F- Must be Local
Visa: Any
Job Description
Project: What these people are doing are going into the data marts within the data warehouse, pulling the data using ETL/ SQL, and using SSIS to integrate the data into Salesforce. This is all done in a Visual Studio environment which is why he wants someone with Visual Studio experience. Visual Studio is just a set of tools for creating software, from the planning phase through UI design, coding, testing, debugging, analyzing code quality and performance, deploying to customers, and gathering telemetry on usage.
Requirements
· Collaborate with Product Leads and BI Analysts to understand business requirements
· Collaborate with data source experts to establish data sources
· Develop logical and physical data models and maintain Entity Relationship Diagrams and related documentation
· Conduct data profiling to ensure data quality and data integrity is maintained at all times
· Develop and support self-monitoring, robust, scalable data pipelines
· Provision data structures such as fact and dimension tables and other objects as needed
· Develop on going incremental updates to the data mart(s)
· Manage database supporting elements including schemas, tables, views,
Qualifications/Skills
· MIS/CIS/CS Degree or 5-8 years relevant experience
· 3+ years Data Engineering
· Experience modeling Star Schemas structures using Ralph Kimball methodology
· Experience developing robust and scalable data integration data pipelines
· Experience using SSIS or similar ETL platform
· Familiarity with Javascript API, Rest API and Data Extract API
· Experience writing and troubleshooting complex SQL queries.
· Familiarity of Amazon Web Services (AWS) such as S3
· Working knowledge of Snowflake highly desirable
· Familiarity with Salesforce data structures highly desirable
Note: We are Working with tier-1 Vendor.
Thanks & Regards,
Udbhav Mathur
Talent Acquisition Specialist
Email:- umathur@tekshapers.com
Gtalk: udbhav.intime
Tekshapers Inc. – WMBE Firm
1441 E. Maple Rd, Suite # 301, Troy, MI 48083
Certification: WMBE Certified | E-Verified Company | ISO 9001:2008
You received this message because you are subscribed to the Google Groups "Entry level IT Jobs in US + H1B visa sponsor" group.
To unsubscribe from this group and stop receiving emails from it, send an email to entry-level-it-jobs-in-us-h1b-visa-sponsor+unsubscribe@googlegroups.com.
To post to this group, send email to entry-level-it-jobs-in-us-h1b-visa-sponsor@googlegroups.com.
Visit this group at https://groups.google.com/group/entry-level-it-jobs-in-us-h1b-visa-sponsor.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment