Job Description

Job Description: Hands-on experience on ETL Tools like Informatica cloud (IICS) & Informatica Power Center. Hands-on experience in Loading data from Json\xml source files. Should have experience in developing application integration using SOAP/REST APIs, APIs leveraged to integrate multiple systems. Should be well versed with Different file Formats for parsing files like Flat File, XML also should work with service connectors. Knowledge of Data warehousing concepts, SCD types, Data modeling, etc. Understand ETL specifications and provide the best implementation methods. Create design documents, and mappings, prepare test cases, etc. Knowledge of performance tuning methods, mapplets, worklets, Stored procedures, Data Modelling & Data Mappings. Strong functional understanding of RDBMS DWH-BI conceptual knowledge. Strong T-SQL/PLSQL Skills and performance tuning capabilities. Strong knowledge of cloud computing architecture, technical design, and implementations including infrastructure as a Service (IaaS), Platform as a Service (PaaS) and Software as a Service (SaaS) delivery models. Excellent knowledge on Informatica platform as a whole and the integration among different Informatica components and services. Data Modeling experience, understanding of Azure/AWS/GCP concepts, Salesforce, Data Lake or other operational or warehouse data stores is a plus. Knowledge and experience with full SDLC lifecycle Experience with Lean / Agile development methodologies Mandatory Skills: IICS, Oracle Database, PL/SQL Good to Have Skills: Communication & Analytical skills Leadership Ownership Coordination