Share this Job

Informatica Tech Lead

Apply now »

Date: Jan 17, 2019

Location: Worcester, MA, US

Company: NTT DATA Services

Req ID: 36353 


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 Informatica Tech Lead to join our team in Worcester, Massachusetts (US-MA), United States (US).




  • Provide ETL Development expertise in relational database management concepts and data warehousing best practices and tools using Informatica Version 9.5x and above.
  • Adhere to ETL design standards, procedures and best practices in Informatica; transformations, mappings, sessions, workflows, implementing business rule as per requirement, building RTM, data model documentation and data integration strategy.
  • Development of Source-to-Target mapping design specifications, data dictionaries, review database schemas
  • Develop and test Extract, Transformation, and Loading (ETL) modules based on design specifications using Informatica Version 9.5x and above.
  • Review of Informatica ETL design documents and working closely with development to ensure correct standards are followed.  This could be automated using mappings to parse code and report on exceptions.


Performance tuning of Informatica mappings.

  • Support development teams with troubleshooting issues.  On Call Support as required during the week ends and off hours.
  • Scheduling jobs through scheduling tool (i.e. IBM Maestro, Tivoli or Autosys or similar tools) for monthly and daily job cycles.
  • Root Cause analysis for ETL job failures/Data issues raised by business.
  • End of Life system verification and upgrades. Perform regression testing and approve the overall upgrade or setup.
  • Mentor and monitored offshore and onsite development teams with regular calls on the commonly raised issues and propose permanent fixes.
  • Service Now (or similar tools like JIRA, Remedy) ticket handling and problem ticket analysis.


Required Skills:

  • Strong experience in Informatica and ETL
  • Strong database analysis skill using SQL / PLSQL / Stored Procedures / Views / Materialized Views.
  • Oracle and SQL database hands-on experience. Should be proficient in writing stored procedures, good SQL Queries using Oracle.
  • Proficient in building staging environments, Operational Data Stores (ODS) and Data Marts.
  • Strong Unix shell scripting.
  • Demonstrated skill and ability in the development of data warehouse projects/applications (Oracle & SQL Server)
  • Strong analytical skills and eagerness to learn domain and functional aspects
  • Excellent communication skills, both verbal and written


Education and Certifications

  • Bachelor’s degree in Technology or Engineering or equivalent combination of education and work experience.


Nice to have:

  • Oracle Hyperion product suite
  • SAS Administration


Must Have:

  • 5+ Informatica Power Center-Informatica Mart
  • 5+ years ETL design and development- Informatica


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 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: Worcester

Job Segment: Database, Oracle, Developer, ERP, Consulting, Technology