BigTapp Analytics - Informatica Specialist - Intelligent Data Management Cloud (4-6 yrs)

Job Description :

We are seeking a skilled Informatica IDMC (Intelligent Data Management Cloud) Specialist to join our team. The ideal candidate will have extensive experience with Informatica's data management tools and a deep understanding of data integration, data quality, and data governance.

This position requires someone who is detail-oriented, possesses excellent problem-solving skills, and can effectively collaborate with both technical and non-technical stakeholders. Collaborate with Solution/data Architects and Business Analysts to design end-to-end solutions, evaluate IDMC services, and recommend suitable options.

Roles & Responsibilities :

- Design, develop, and implement data integration solutions using Informatica IDMC.

- Manage and optimize data workflows, ensuring data accuracy, consistency, and reliability.

- Plan and develop ETL (Extract, Transform, Load) processes, data preparation, and aggregation from various sources to MSSQL database/PostgreSQL DB.

- Create, maintain, and optimize ETL and other Informatica processes to adapt to evolving needs and requirements.

- Develop and manage Informatica configurable artifacts including code, environment, configuration files, and documentation.

- Plan Informatica ETL unit, SIT (System Integration Testing), and UAT (User Acceptance Testing) tests.

- Possess familiarity with stored procedures, functions, inline SQL, and database structures.

- Provide post-production application support as required.

- Adhere to established standards and best practices while contributing to process improvements.

- Ensure compliance with data governance and security policies.