Green Card
Corp-Corp
W2-Contract
Consulting/Contract
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 10th Nov 2021
8 years of experience.
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)