Job Title: Informatica Developer
Location: Remote
Duration: Long Term contract
Mandatory Skill: PowerCentre & Azure Databricks
Responsibilities
Ability to be flexible and work independently;Experience with requirement analysis, design, development, testing and documentation including version control practices and technologies;Design, develop and unit test Informatica ETL processes;Communicate with business users to collect and understand requirements, socialize ideas among peers, and document work products;8 + yrs. experience in developing, testing, deploying, maintaining and supporting Informatica PowerCenter solutions preferably on DB2 database;Experience with Informatica workflow scheduling using tools;Perform systems/data analysis to implement Informatica mappings and workflows, shell scripts and stored procedures;Experience in analyzing SQL plan;Experience with batch scripting (on Windows);Strong skills in writing Stored Procedures, Packages, triggers, Views;Provide performance improvement related guidance to the Informatica team members.
Requirements
Design, create, manage and troubleshoot Informatica workflow processes;Hands on Experience in Azure DatabricksShould have experience in scheduling the Informatica mapping using the Informatica workflow manager;Should have knowledge of Data Modeling / Data warehouse Designing concepts;Experience in analyzing SQL plan;Document details of Informatica processes and coding;Strong skills in writing Stored Procedures, Packages, triggers, Views;Provide performance improvement related guidance to the Informatica team members;Should be good hands on experience in Informatica 9.x (4+ years);Developing web service integrations on Informatica Cloud Integration Hub (Current Version);Perform systems/data analysis to implement Informatica mappings and workflows, shell scripts and stored procedures;Flexibility and the ability to work independently;Hands-on experience in Oracle & SQL;Design, develop and unit test Informatica ETL processes;Experience with requirement analysis, design, development, testing and documentation including version control practices and technologies;Communicate with business users to collect and understand requirements, socialize ideas among peers, and document work products.