Senior Informatica IDQ Consultant

15 Jan 2022


  • "Extract, Transform, Load Senior Developer (Senior ETL Developer) is a technical IT Position within Emerson reporting to a Data Services Manager. The Senior ETL Developer is a technical expert focused on working on Data Migration Tools to extract from one or more business application sources into Data staging areas, build rules to transform source data structures to target data structures. A Senior ETL developer is responsible for designing the data staging, and transformation, testing and troubleshooting during the course of implementation before it goes live
  • Senior ETL Developer is expected to utilize various data extraction and manipulation tools to interact with ERP and other business applications to extract data for transformation and to support data migration work for ERP projects & day-to-day business support. The Senior ETL Developer is expected to be technically competent in scripting, and programming with knowledge of SQL, Data structure and processes. Guide ETL Developers in executing their responsibilities in development of scripts to analyze data and in analytical techniques for interrogating legacy system data. Review work quality and ensure overall quality of deliverables.
  • Senior ETL developers are responsible for designing and creating the data staging area and all related extraction, transformation and load of data functions in Client. After the groundwork has been laid, developers also must test their designs to ensure the system runs smoothly. Perform gap-analysis on data requirements against current legacy data structure and capabilities. Work with implementation team to detail data cleansing and enrichment requirements
  • Furthermore, developers must be experts at taking a big-picture view of a Clients data situation - data modeling. This means developers need to be able to read, analyze and digest what Client wants to accomplish with its data, and design the best possible ETL process around those goals.
  • 8-10 years of relevant experience in Data Warehouse Environment
  • 5-7 years of working experience on Informatica PowerCenter;
  • 2+ years working experience on Informatica IDQ
  • Should have good understanding of various components such as Informatica Designer, Workflow Manager, Workflow Monitor, Repository Manager and the Administrator Console
  • Hands on experience with ETL architecture design, ETL standards and processes, develop ETL mapping document between source and target data elements etc.
  • Should have good understanding of Data Integration and Data Warehousing Fundamentals
  • Define ETL standards and processes
  • Working knowledge of Advanced Transformations, Techniques & Reusability Features
  • Knowledge of Performance Tuning, Design Principles & Caches
  • Should be able to understand business requirements, create technical specifications and implement the same using Integration technologies
  • Should have a good understanding of testing concepts for testing developed code and code optimization
  • Exposure to other Informatica suite of products such as Informatica Power Exchange and Informatica EDC
  • Ability to communicate and articulate technical information across various organizational levels
  • Strong thought leadership abilities and a highly innovative problem solver
  • High reasoning aptitude and ability to quickly understand complex operating environments
  • Highly innovative problem solver with strong analytical and customer service abilities required. "

  • ID: #31651424
  • State: Virginia Richmond 23173 Richmond USA
  • City: Richmond
  • Salary: $74.37 hr
  • Job type: Contract
  • Showed: 2022-01-15
  • Deadline: 2022-03-15
  • Category: Et cetera