Job Description

<div>
 <p>
  <strong>
   Role: Informatica/ETL PowerCenter Developer
  </strong>
 </p>
 <p>
 </p>
 <p>
  <strong>
   Primary Skills: Informatica
  </strong>
 </p>
 <p>
 </p>
 <p>
  <strong>
   Role Description:
  </strong>
  The
  <strong>
   Informatica/ETL PowerCenter Developer
  </strong>
  would need to have at least 5-7 years of experience.
 </p>
 <p>
 </p>
 <p>
  <strong>
   Responsibilities and Qualifications:
  </strong>
 </p>
 <p>
 </p>
 <p>
  - Participates in ETL Design of new or changing mappings and workflows with the team and prepares technical specifications.
 </p>
 <p>
  - Creates ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter 10.x and prepare corresponding documentation.
 </p>
 <p>
  - Designs and builds integrations supporting standard data warehousing objects (type-2 dimensions, aggregations, star schema, etc.).
 </p>
 <p>
  - Performs source system analysis as required.
 </p>
 <p>
  - Works with DBAs and Data Architects to plan and implement appropriate data partitioning strategy in Enterprise Data Warehouse.
 </p>
 <p>
  - Implements versioning of the ETL repository and supporting code as necessary.
 </p>
 <p>
  - Develops stored procedures, database triggers and SQL queries where needed.
 </p>
 <p>
  - Implements best practices and tunes SQL code for optimization.
 </p>
 <p>
  - Loads data from SF Power Exchange to Relational database using Informatica.
 </p>
 <p>
  - Works with XML's, XML parser, Java and HTTP transformation within Informatica.
 </p>
 <p>
  - Works with Informatica Data Quality (Analyst and Developer)
 </p>
 <p>
  - Primary skill is Informatica PowerCenter
 </p>
 <p>
  - 5-7 years of experience.
 </p>
 <p>
 </p>
 <p>
  <strong>
   Top Three Skills Required
  </strong>
  :
 </p>
 <p>
 </p>
 <p>
  - Informatica PowerCenter, Informatica Data Quality.
 </p>
 <p>
 </p>
 <p>
  <strong>
   Education:
  </strong>
  Bachelor&rsquo;s degree in Computer Science, Electrical/Electronic Engineering, Information Technology or another related field
 </p>
 <p>
  <strong>
   Experience:
  </strong>
  Minimum 5-7 years
 </p>
</div>