Application Designer(S1100192)

Pontoon Solutions

Project Role : Application Designer

Project Role Description : Assist in defining requirements and designing applications to meet business process and application requirements.

Must have Skills : Informatica PowerCenter

Good to Have Skills : No Function Specialization

Key Responsibilities :

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 10x 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

Technical Experience:

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

Professional Attributes :

Works with DBAs and Data Architects to plan and implement appropriate data partitioning strategy in Enterprise Data Warehouse

Works with Informatica Data Quality Analyst and Developer

Primary skill is Informatica PowerCenter

Educational Qualification:

Minimum 15 years of full time education

Additional Info :

Understand the business requirement or the downstream process requirement

• Experience

  8 - 12 Years

• No. of Openings

  1

• Education

  Any Bachelor Degree

• Role

  Application Designer

• Industry Type

  IT-Hardware & Networking / IT-Software / Software Services

• Gender

  [ Male / Female ]

• Job Country

  India

• Type of Job

  Full Time

• Work Location Type

  Work from Office