DevOps Engineer

Responsibilities: Work on analysis, design, development, implementation, testing, and support of data warehousing and data integration solutions using Informatica tools (Power Centre, Power Exchange, Informatica Cloud Services (IICS), and SQL, PL/SQL), migration to the Snowflake Cloud database, Proficient use of power centre tools (Designer, Workflow Manager, Workflow Monitor, Repository Manager), IICS, and databases like Oracle, Teradata, SQL Server, and DB2 on Windows and Unix environments, develop queries, complex views, materialised views, and other database objects using SQL, Work on migration from Informatica 10.2 to Informatica Cloud (IICS) upgrade , Implement the business rules by create re-usable transformations (Expression, Aggregator, Unconnected and Connected Lookup, Router, Rank, Update Strategy, Union, Stored Procedure) and develop Mapplets and Mappings in Informatica Power Centre and IICS , XML files, JSON, and relational databases, data warehousing concepts like star schema, snowflake star schema, dimensions, and fact tables, Handle different types of slowly changing dimensions (CDC), ETL/DWH testing using Informatica Power Centre 10.2 and IICS. Bachelor Degree In Technology or Computer Science or Related Field with Relevant Industry Experiences