Cloudious
-
- Primary skill on development experience on informatica B2B dx, DT scripts, real time integrations using mq, api, http transformations- Experience in Informatica PowerCenter development- Participates in ETL Design of new or changing mappings and workflow s 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 wareho using 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.- Impl ements 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 using Informati ca connecting to different types of sources (Flat file, Relational DB, XML etc..)- Works with XML s, XML parser, Java and HTTP transformation within Informatica.- Works with Informatica Data Quality (Analyst and Developer)