• Business Intelligence Specialist Advisor - DW and ETL Jobs in United States Of America - 25311194

  • NTT Data Vertex Software Inc.
  • United States Of America, Usa
  • Save Job
  • 8 - 11 Years
  • Posted : above 1 month

Job Description:

Location Addison, TX, US

Company NTT DATA Services

Req ID 70896

At NTT DATA Services, we know that with the right people on board, anything is possible The quality, integrity, and commitment of our employees are key factors in our companys growth, market presence and our ability to help our clients stay a step ahead of the competition By hiring the best people and helping them grow both professionally and personally, we ensure a bright future for NTT DATA Services and for the people who work here

NTT DATA Services currently seeks a Business Intelligence Specialist Advisor - DW and ETL to join our team in Addison, Texas (US-TX), United States (US)


Design, develop and maintain Data Ware house solution to meet Organization BI Requirements
Drive Business/functional requirements meetings with Business partners and translate the requirements to Technical specification to build Business Intelligence Solution
Create and understand existing design patterns for Data Ware house layers including Source, Staging, Storage and Presentation Layers using either of SQL, Oracle, Teradata, Netezza or other DW hosting platforms
Involve in new and existing ETL (Extract, transform, load) packages design to extract data from Source repository (flat files, excel files, and other heterogeneous data sources) such as Mainframe, SQL server, DB2 and other operational databases
Create designs, data validations, and integration testing using development life cycle of Data Ware House and ETL packages Expertise in one or more of following ETL Tools (DataStage, SSIS, Informatica etc)
Create complex stored procedures, user defined functions, and use T-SQL (Structured Query Language) or PL/SQL to evaluate results for the BI reports
Perform SQL Query tuning and optimizing queries for reports that may take longer in execution while performing operations such as data reconciliation, validation and error handling after extracting data into the DataWarehouse (SQL/DB2)
Design Dataware house presentation layer as per reporting requirement hence need to have solid understanding of reporting and visulization tool like Cognos, Business Object, Tableau, Microsoft Power BI Etc
Resolve high priority break fixes and support enhancement requests for enterprise Data Ware house environment during business-critical hours in an expeditious manner

Basic Qualifications
Bachelors Degree
Minimum 8 years of experience in a business intelligence environment, developing Reporting and ETL Solutions using either of Informatica, Data Stage or Microsoft SSIS ETL tools
Minimum 5 years of experience in designing Data Ware House Solutions including Data Migration, Extract Transform and Load process and Reporting
Minimum of 3 years of experience in writing TSQL Query and optimization of T SQL query in SQL Server/ Oracle/Netezza environment
At least 3 years of experience working with multiple data sources, including both structured and unstructured data

Preferred Qualifications and Skills
Bachelors Degree in Computer Science, Engineering, Math, Statistics or equivalent
2 Year of experience on Data hosting appliance like Teradata, Netezza and/or other RDBMS platforms
2 Year of experience working in Client facing role and good communication skills
1 years experience operating and managing Big Data environments in Cloud environment (AWS/Azure/Horton Works/Data Lake)

This position is only available to those interested in direct staff employment opportunities with NTT DATA, Inc or its subsidiaries Please note, 1099 or corp-2-corp contractors or the equivalent will NOT be considered We offer a full comprehensive benefits package that starts from your first day of employment

About NTT DATA Services

NTT DATA Services partners with clients to navigate and simplify the modern complexities of business and technology, delivering the insights, solutions and outcomes that matter most We deliver tangible business results by combining deep industry expertise with applied innovations in digital, cloud and automation across a comprehensive portfolio of consulting, applications, infrastructure and business process services

NTT DATA Services, headquartered in Plano, Texas, is a division of NTT DATA Corporation, a top 10 global business and IT services provider with 118,000 professionals in more than 50 countries, and NTT Group, a partner to 88 percent of the Fortune 100 Visit nttdataservicescom to learn more

NTT DATA, Inc (the Company) is an equal opportunity employer and makes employment decisions on the basis of merit and business needs The Company will consider all qualified applicants for employment without regard to race, color, religious creed, citizenship, national origin, ancestry, age, sex, sexual orientation, gender identity, genetic information, physical or mental disability, veteran or marital status, or any other class protected by law To comply with applicable laws ensuring equal employment opportunities to qualified individuals with a disability, the Company will make reasonable accommodations for the known physical or mental limitations of an otherwise qualified individual with a disability who is an applicant or an employee unless undue hardship to the Company would result


Nearest Major Market Dallas
Nearest Secondary Market Fort Worth
Job Segment Business Intelligence, Consulting, Database, Oracle, Data Warehouse, Technology

Profile Summary:

Employment Type : Full Time
Eligibility : Any Graduate
Industry : Software Services, Internet/Dot com/ISP
Functional Area : IT Software : Software Products & Services
Role : Data Warehousing
Salary : As per Industry Standards
Deadline : 03rd Jun 2020

Key Skills:

Why not try out our free online tutorials and gain an edge?

People who search this job also searched for the following Keywords

Salary trends based on over 1 crore profiles

View Salaries

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status