Job Description :
Job Title: ETL Teradata/Informatica Developer
Location: Richmond, VA(onsite)
Duration: 12 months+
Note: Please don''t send the resumes who are incomfort to share the passport details.
Send resumes to at nexusitinc dot com.
Job description:
· Experience in Informatica Toolset is must. Ex: Power Center Designer, Power Exchange, Workflow Manager and Workflow Monitor.
· Create and maintain source to target mapping specifications, detailing integration and transformation logic, using applicable standards.
· Create ETL mappings using Informatica tools to extracts, transform, and load data as per specifications.
· 3 or more years of experience in the 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’ experience working in and/or dynamic cross-competency teams using a structured project development methodology.
· Experience with various tools such as BTEQ, MLOAD, FASTLOAD, FAST EXPORT, TPT etc. in large Data Warehouse environments is preferred.
· Experience with Oracle 11g, Oracle Tools such SQL Loader, External Tables and Stored Procedures and ProC programs.
· Experience in UNIX systems, writing Shell Scripts that control Job Execution.
· 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.
· Strong Database skills, experience in writing queries, Data Mining experience, and exposure to ETL development are preferred.
· 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.
· Applicants should be able to develop application domain knowledge and provide subject matter expertise as needed over time.
Basic Qualifications:
· 5 or more years of IT development experience required.
· 5 or more years of Teradata experience.
· 3 or more years of Informatica development experience.