Share this Job

SQL Server Technical Lead

Apply now »

Date: Jul 11, 2019

Location: Phoenix, AZ, US

Company: NTT DATA Services

Req ID: 53152 

 

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 company’s 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 SQL Server Technical Lead to join our team in Phoenix, Arizona (US-AZ), United States (US).

 

 

Technical Duties:
As a SQL Server Technical Lead you will be responsible for the following:

- Understand the existing data warehouse/databases, inbound data files and data ingestion process.
- Document gaps in the current process
- Create/Redesign data warehouse and data marts (as needed) to allow for automated data ingestion from multiple files in different formats.
- Create databases, staging tables, target tables, indexes, data dictionary, metadata tables, archive and error tables
- Develop ETL processes/jobs including data transformations for inbound and outbound data files
- Develop ETL processes/jobs to handle data files – xls/xlsx, txt/csv, xml/json
- Design and build dimensions and fact tables in SQL Server Analysis Services (SSAS)
- Rewrite/Create SSRS reports aligned to modified schema and databases
- Continuous Integration and Build Automation
- Design and build functionality to expose data as APIs
- Provide maintenance and support production databases
- Develop and deliver the artifacts in Agile methodology
- Ability to adapt quickly to an existing, complex environment and learn new concepts / software technologies as needs arise 
- Adaptable and flexible meet demands, being relentless and passionate to get the job done
- Collaborative team player with communication skills to match
- Strong time management skills including multi-tasking in fast-paced development environments while keeping the attention to details, high standards for quality

 

Technical Skills Required

 

- Expert Knowledge of Integration Services (SSIS), Extracting, Transforming and Loading (ETL) data from excel, pipe delimited, csv files to MS SQL Server by using SSIS services
- Experience with Data Modeling and in developing UML diagrams including Use Case diagrams, Class diagrams, Interaction diagrams, State diagrams and Deployment diagrams.
- Expert knowledge on SQL Server 2012/2008 RDBMS database development including T-SQL.
- Proficient with SQL
- 5+ years of .NET Development experience
- Experience with analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
- 5+ years of experience developing reports on SSAS & SSRS on SQL Server 2012/2008. Experience and understanding of SSAS, OLAP cube and architecture.
- Experience in designing and building dimensions and cubes with star schema using SQL Server Analysis Services (SSAS)
- 5+ years of experience in enhancing and deploying the SSIS Packages from development server to production server.
- Experience on application servers like IIS.
- Proficient in tools like Visual Studio, VSTS (Visual Studio Team Services), TFS (Team Foundation Server)/Azure DevOps.
- Familiarity with Agile methodology for project
- Experience of working with teams across other geographies in onshore/offshore model

 

Optional/Good to Have:
- Understanding of Non-Relational databases
- Knowledge of Big Data and Hadoop ecosystem – HDFS, Hive, Pig etc.
- Experience with a healthcare based Integration platform e.g. Corepoint

 

Functional Skills (Optional)

- Domain knowledge of Healthcare specially Payer 
- Good understanding of Membership, Claims, Pharmacy orders

 

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 nttdataservices.com 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: Phoenix

Job Segment: Database, SQL, Consulting, Developer, XML, Technology