Informatica PowerCenter

Role: Informatica PowerCenter Developer
EXPERIENCE RANGE: 6 - 8 Years
Skills: Informatica PowerCenter, PL/SQL
Participates in ETL Design of new or changing mappings and workflows with the team and prepares technical specifications.
Creates ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter 10.x and prepare corresponding documentation. Designs and builds integrations supporting standard data warehousing objects (type-2 dimensions, aggregations, star schema, etc.).
Performs source system analysis as required.
Works with DBAs and Data Architects to plan and implement appropriate data partitioning strategy in Enterprise Data Warehouse.
Implements versioning of the ETL repository and supporting code as necessary.
Develops stored procedures, database triggers and SQL queries where needed.
Implements best practices and tunes SQL code for optimization.
Loads data from SF Power Exchange to Relational database using Informatica.
Works with XMLs, XML parser, Java and HTTP transformation within Informatica.
Works with Informatica Data Quality (Analyst and Developer)
Primary skill is Informatica PowerCenter
Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.