DWH / EDW / BI / ETL Modeler / Architect / Developer / Analyst
Company Description
We are looking for FTE candidates for a premier IT Consulting company, TATA Consultancy Services (www.tcs.com).
Job Description
Data 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 Information
Saviance 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.