Position: Informatica Power Center Developer
Location: Columbus, OH (Onsite) – local or EST
Duration: 6 months
Description:
- 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)
Education: At least a bachelor’s degree (or equivalent experience) in Computer Science, Software/Electronics Engineering, Information Systems, or closely related field is required.
Thanks, and regards
Ganesh Gorak
Itech Us Inc
—
