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