Sr. Informatica ETL Developer
Apply now »Date: Nov 21, 2019
Location: Charlotte, NC, US
Company: NTT DATA Services
Req ID: 68144
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 Sr. Informatica ETL Developer to join our team in Charlotte, North Carolina (US-NC), United States (US).
- Gather business requirements and review the specs with business and partner system teams
- Carryout Impact Analysis and prepare the Impact Analysis document
- Prepare the SLA, System Interface Agreements and FSD document
- Prepare and maintain source to target mapping specifications, detailing integration and transformation logic, using applicable standards
- Develop ETL mappings using Informatica tools to extracts, transform and load data as per specifications
- Develop and test ETL jobs using Informatica and Teradata
- Create autosys jobs for scheduling the batch process by considering the SLAs and dependencies
- Strong database skills, experience in writing queries, Data Mining experience and exposure to ETL development are preferred
- Good understanding and experience in Unix Operating system commands and File System management
- Perform peer document reviews and code reviews to ensure adherence to user requirements as well as applicable standards and conventions
- Perform required testing of developed procedures and mappings
- Assist client team during during integration and User Acceptance testing and code deployment to higher environments
- A strong background working across various teams such as Infrastructure, QA, Configuration Management, Database Administration, Unix Admin and Production Control teams
- Coordinate with the offshore team during the entire life cycle of the project
- Mentoring and providing technical inputs to the individual team members for improved performance
- 5 or more years of IT development experience required
- 3 or more years of Informatica development experience. Eg: Power Center Designer, Power Exchange, Workflow manager and Workflow monitor
- 2 or more years of Teradata experience. Experience with various tolls such as BTEQ, MLOAD, FASTLOAD, FAST EXPORT, TPT etc in large Data Warehouse environments preferred
- Experience with Teradata, Teradata tools such as Loading utilities, Tables and Stored Procedures. Understanding of the roles and user assignments
- Experience in Unix systems, writing shell scripts that control job execution
- 3 or more years of experience in software development methodology life cycle - including business planning, data analysis, process analysis and design, business and functional requirements analysis, use case analysis, system design, development using various tools and techniques, testing and implementation
- 3 or more years of experience working in and/or dynamic cross competency teams using a structured project development methodology
- Applicants should be able to develop application domain knowledge and provide subject matter expertise as needed over time
- Good written and presentation skills
- Undergradute degree or equivalent combination of education and work experience. Engineering Graduate degree preferred
Basic Qualifications:
Qualification:
- 5 years of IT development experience required
- 3 years of Informatica development experience. Eg: Power Center Designer, Power Exchange, Workflow manager and Workflow monitor
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: Charlotte
Job Segment:
Developer, Database, Consulting, Business Intelligence, Data Warehouse, Technology