We are looking for FTE candidates for a premier IT Consulting company, TATA Consultancy Services (www.tcs.com).
Job DescriptionData Modeler - 2 positions at Des Moines / Charlotte
• Should have 9 - 11 years of total experience with 6-7 years of full time Data modeling experience • Should have knowledge of 3NF and Dimensional modeling and deal with their challenges • Sound knowledge in EDW, design experience of complex model in EDW in banking domain. • Teradata and MS SQL Server implementation knowledge for modeling • Experience in Metadata in context to data modeling and Data architecture • Hands on experience in Teradata physical implementation for large environments and analyzing performance issues to suggest alternative paths to achieve required throughput
BI Solution Architect - 1 position at Des Moines / Charlotte
• Should have 10+ years of total experience with 6-7 years of full time Data and BI architecture experience • Expertise in BI product stacks such as Teradata, SQL Server, BI Reporting , AbInitio and underlying architecture • Able to understand current architecture and recommend end-to-end BI and EDW architecture • Overall responsibility for architecture and design, development, integration testing and implementation of data warehousing solution • Conduct BI Blueprint study, assess readiness and recommend BI road map • Implement strong BI processes, architecture standards and industry best practices • Monitor industry trends and identify emerging technologies for adoption
Data Analyst - 4 positions at Des Moines / Charlotte
• Should have 8+ years’ experience with 5 years of experience as Data Analyst for Data Warehouse projects. • Should have hands on experience in Data Mapping, Data Analysis, and Data flow analysis in a complex data Warehouse project. • Hands on experience in Teradata SQL, and query analysis. • Be able to identify relevant data sources, design and implement software / procedures to extract and process data for EDW project. • Ability to interpret results and find insights in data. Review and analyze data from multiple internal and external sources • Analyze complex data systems and document data elements, data flow, relationships and dependencies for data • Partners with Business Analysts, Business users and other stakeholders to define, capture, discuss and communicate requirements in a structured form (e.g. User Stories, Test Cases, Data Flow Diagrams, and Acceptance Criteria etc.).
Semantic Developer - 2 positions at Des Moines / Charlotte
• 10+ years overall experience working on software development projects preferably with an emphasis on data warehouse / business intelligence projects • 5+ Year Strong Technical Skills in Teradata. Must have working knowledge of Oracle and MS SQL Server. • Extensively worked on development and implementation of data marts, data structures, functions, data warehouse fact & dimension tables, views, and indexes • Demonstrated skills in working with multiple groups to create data warehouse designs based on business and data requirements and conducting reviews • Demonstrated skills working with multiple groups to define key reporting metrics, identify current database sources, assess the status of existing reporting capabilities and work with teams on go forward solution • Demonstrated ability to lead meetings and effectively interact with Business Analysts, Project Managers, ETL developers, Quality Assurance and other end users regarding data needs • Excellent at writing complex SQL queries with Inner and Outer Joins, Aggregate Functions, Set Operators, Sub queries, System Calendar, Ranking Functions, Stored Procedures, Data Types, Logical and Conditional Expressions, Macros, Derived Tables, CASE expressions, Views, String Functions and Relational Concepts. • Demonstrated experience with SQL performance tuning
Qualifications#DWH / #EDW / #BI / #ETL #Modeler / #Architect / #Developer / #Analyst
Additional InformationSaviance Technologies is an EEO employer, employing over 500 professionals across more than 5 offices and 3 global delivery centers in the U.S, UK and India. We offer a very attractive benefits package which includes Medical, dental and vision insurance and compares well with the best in the industry. We deliver a full portfolio of services that includes Application Development & Management, Mobile Testing Services, Enterprise Software Solutions, Engineering Services, Full Spectrum of Microsoft Technology Solutions, Business Intelligence & Data Warehousing, Global Infrastructure as well as Professional Services. Our mission is to ‘To provide world class Staff Augmentation Services to our clients to enable them to win and grow by using our talent and experience in technological services, intuitive strategies and focused execution'.
For immediate consideration please send a Microsoft word copy of your resume to [email protected]. Please include the job title, authorization to work, interview/project availability and contact information. Call us now - we guarantee an interview, provided you have the right set of skills and attitude.
Skills Required
- 9–11 years of total experience for Data Modeler roles
- 10+ years of total experience for BI Solution Architect and Semantic Developer roles
- 8+ years of experience for Data Analyst roles
- 6–7 years of full-time data modeling experience
- 6–7 years of data and BI architecture experience
- 5 years of data analysis experience on data warehouse projects
- 5+ years of strong Teradata technical experience
- Expertise in 3NF and dimensional data modeling
- Enterprise data warehouse design experience, preferably in banking
- Teradata and Microsoft SQL Server implementation experience
- Experience with data modeling metadata and data architecture
- Hands-on Teradata physical implementation in large environments
- Experience analyzing and tuning Teradata and SQL query performance
- Experience with BI product stacks, BI reporting, and Ab Initio
- Ability to design, integrate, test, and implement data warehousing solutions
- Experience conducting BI blueprint studies and developing BI roadmaps
- Experience with data mapping, data analysis, and data flow analysis
- Ability to identify data sources and develop extraction and processing procedures
- Experience documenting data elements, relationships, dependencies, and data flows
- Experience developing data marts, fact and dimension tables, views, indexes, functions, and data structures
- Working knowledge of Oracle and Microsoft SQL Server
- Advanced SQL skills including joins, aggregations, subqueries, ranking functions, stored procedures, macros, views, and conditional expressions
- Ability to collaborate with business analysts, project managers, ETL developers, QA, business users, and stakeholders
- Experience defining reporting metrics and evaluating reporting capabilities
What We Do
Saviance is a US Healthcare IT Service provider focusing on Patient Engagement with Innovative Products and Solutions like Patient Intake Tablet, iHealthConnect Wellness Portal, Mobile Applications, Actionable Analytics and ICD-10 Testing Services. Incorporated in 1999 in New Jersey, with over 15 years of excellent industry track record, Saviance offers services & solutions that enable enterprises to achieve critical objectives. Saviance is a Gold Category Corporate Member with Healthcare Information Management Systems Society (HIMSS), member of mHealth Alliance and Corporate member of NJ-HITEC. We are awarded by INC. 5000 as one of the fastest growing privately held companies in North America. Saviance is also ranked among the Fast 50 Asian American Businesses in the United States by USPAACC (US Pan Asian American Chamber of Commerce) and selected as a 2014 "Top Business" recipient by https://www.linkedin.com/redir/general-malware-page?url=DiversityBusiness%2ecom%2e A certified Minority Business Enterprise recognized by NMSDC, Saviance is also partner with leading global brands such as Microsoft, Amazon Web Services, Apple, Samsung and Red Hat.







