Informatica Developer

Company: Tata Consultancy Services
Location: Dallas
Posted on: August 7, 2022

Job Description:

Responsibilities:

• Good Knowledge in Data Warehouse and Database concepts.
• Expert in Informatica Power center concepts.
• Gather requirements to define data definitions, transformation logic, and data model logical and physical designs, data flow, and process.
• Design, develop, and test data processes per business requirements, following the development standards and best practices as well as participate in code peer reviews to ensure our applications comply with best practices.
• Work with business analysts to gather business requirements from end users and translate them into technical specifications.
• To be responsible for providing technical guidance / solutions.
• Provide estimates for development.
• Test solutions to validate whether requirements have been met; develop test plans, test scripts, and test conditions based on the business and system requirements.
  Skills:
  
  • Experience in ETL development using Informatica PowerCenter, PowerCenter 9.x, 10.x
  • Experience in Designing Extract Load Transform ETL solutions for data migration or data integration
  • Experience in Structure Query Language SQL
  • Strong Informatica technical knowledge in the areas on Informatica Designer Components -Source Analyzer, Mapping Designer & Mapplet Designer, Transformation Developer, Workflow Manager, Workflow Monitor.
  • Analyze, design, implement and test medium to complex mappings independently. Ability to design and implement easily scalable ETL components
  • Strong SQL and related skills. Ability to develop and implement complex procedures and packages using Oracle PL/SQL.
  • Experience in parameter file concepts.
  • Experience in transformations like Source qualifier, joiners, union, aggregator, sorter, expression, transaction control, XML transformation, lookups, etc
  • Experience with Informatica Advanced Techniques Dynamic Caching, Memory Management, Parallel Processing to increase Performance throughput
    
    
    
    "All offers of employment extended to applicants will be conditional and will require, among other things, that the recipient of the offer of employment submit proof that s/he is fully vaccinated at that time or will submit such proof prior to determining a start date . Individuals with medical issues or sincere religious beliefs that prevent them from getting the vaccine may request an exemption from the vaccine requirement. To the extent State legislation or executive action purports to limit TCS's ability to require vaccination for individuals who object on a basis other than medical issues or sincere religious beliefs, individual requests for an exception to TCS's generally applicable vaccination policy pursuant to relevant State regulation will be evaluated on a case-by-case basis. Individuals who receive an exemption from vaccination for any reason may be required to comply with other Covid precautions."

Keywords: Tata Consultancy Services, Dallas , Informatica Developer, IT / Software / Systems , Dallas, Texas