Role: Informatica Developer

Permanent position

Hyderabad location

Shift : 3pm to 12am

Hybrid

5+ years of strong prior working experience in ETL tools and 5+ years working experience in IDMC/IICS Design, development, and testing of Informatica mappings and workflows Experience in Informatica Intelligent Cloud services Create Informatica mappings with transformations likes Editor, Source Qualifier, Joiner, Router, Update Strategy, Filter & work with sessions, workflows, mapplets Work with Power Center Mapping Designer, Workflow Manager, Workflow Monitor, Repository etc.

Testing and scheduling workflows Participates in the development and implementation of various database objects and data schemas. Strong Knowledge of SQL, Unix/Linux, Shell Scripting, PL/SQL Ability to import / export data using data loaders.

Ability to user various database utilities for data loading Experience in Datawarehouse projects along with designing Data Models.

Knowledge of object-relational mapping (ORM) Develop business critical Informatica entities using IDMC/IICS Informatica Intelligent Cloud Services (CDI - (cloud data integration), Monitor, CAI - (cloud application integration)). Conduct requirements analysis, design, and implementation activities in full lifecycle reporting and analytics solutions. Should be familiar with bulk loading concepts, external tables and advanced snowflake concept etc Extensive experience in: Experience in DWH and any ETL tools Informatica Batch dbms utilities knowledge Secondary skills: Experience in Sybase, SQL Server, DB2 data warehousing concepts knowledge Unix Shell Scripting Job Schedulers