ETL Developer (Expert Level III) (Albany, NY, US)


Req ID:  97282

NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now.

We are currently seeking a ETL Developer (Expert Level III) to join our team in Albany, NY, USA.
Daily Tasks include:


Perform analysis, design, development and implementation, including data analysis, data access, data structures, data transformation, data reporting solutions and user documentation.
Act as the primary ETL technical liaison working with technical infrastructure teams to resolve problems and implement solutions to technical issues impacting application performance.
Manage and administers ETL solutions for medium to large scale OLTP and OLAP projects.
Monitor daily ETL jobs and processes that identify load and performance issues and determine the resolution and revise the incorrect operational processes.
Communicate and coordinate with members of the development team to work across multiple projects.
Explore, actively support and work on new technology initiatives that may be of interest to the organization.
Actively participate in troubleshooting any technical issues that the program may have.
Other duties as assigned.


 

Minimum Qualifications:


More than seven (7) years of experience working on complex projects with 2 or more years in a leadership role as a Developer.
More than (7) years of experience in analysis, design, development, testing and implementation of data integration solutions using PL/SQL & relational databases.
Five or more years of hands-on experience in implementing and maintaining data integration processes using Informatica suite of products such as Informatica PowerCenter and/or Informatica Data Quality.


 

Preferred Qualifications:


Seven years or more of hands-on experience using ETL tools like Informatica PowerCenter to migrate data from various sources and targets including databases, flat files, and XML files, UNIX shell scripts.
Seven or more years of experience developing complex SQL, PLSQL objects with Oracle 11g or higher such as stored procedures, triggers, packages, materialized view and using Oracle supplied utilities including: SQL Loader, external tables, and Oracle built in packages to migrate data.
Five or more years of experience with Data Quality processes, approaches, measurement techniques and business cases for data profiling, data cleansing, standardization, match and merge functionality using tools such as Informatica Data Quality.
Seven years or more experience in implementing concepts such as Slowly Changing Dimension (SCD Type) and Change Data Capture (CDC) functionality in both an OLTP (Relational Modeling) and OLAP (Dimensional Modeling) environments.
Seven or more years of experience writing complex UNIX scripts to validate and ftp files, and for scheduling / automating ETL processes.
Seven years or more of experience in performance tuning SQL scripts, complex PL/SQL objects such as procedures, functions, triggers, packages, tables, views and indexes.
Experience with implementing ETL solutions for medium to large scale OLTP and OLAP projects
Experience in writing technical specifications including ETL source to target mapping documents, ETL design documents, implementation documents.
Experience in New York State or New York City government.
Experience with Health & Human services applications.

About NTT DATA Services

NTT DATA Services is a global business and IT services provider specializing in digital, cloud and automation across a comprehensive portfolio of consulting, applications, infrastructure and business process services. We are part of the NTT family of companies, a partner to 85 % of the Fortune 100.

NTT DATA Services is an equal opportunity employer and will consider all qualified applicants for employment without regard to race, gender, disability, age, veteran-status, sexual orientation, gender identity, or any other class protected by law.
post tech jobs

- Tech Jobs New York, NY

- Tech Jobs Houston, TX

- Tech Jobs Austin, TX

- Tech Jobs Chicago, IL

- Tech Jobs Santa Clara, CA

- Tech Jobs Atlanta, GA

Top Tech Jobs

IT jobs, Tech Jobs, USA tech job board that makes Tech and IT job search easier and faster. Search tech jobs from reputable tech companies and recruiters in USA

Tech Jobs Post is a technology niche job board with focus in IT jobs, Software engineering, Mobile Applications development, Tech support and telecommunications. Tech Jobs Post is designed to simplify tech recruitment for employers and recruiters. It offers the right tool for recruiting tech professionals.

For tech job seekers, Tech Jobs Post makes their job search easy by giving them the right tool that simplify their job search and allow them to connect with tech recruiters and employers. Thousands of technology job openings in tech fields such as IT, engineering, telecommunication and Mobile App development are published daily. Our job search tool makes these jobs more accessible to job seekers.

Technology job recruiters are always looking for skilled tech candidates to fill their job vacancies. Some employers are even willing to pay relocation cost for the right candidates. However, according to some tech job recruiters, filling some mission-critical tech positions can be somewhat challenging. This has compelled technology recruiters and employers to create more attractive incentives aimed at attracting the best and brightest technology professionals.

TechJobsPost.com serves as recruitment platform designed to speed up tech recruitment process.