Informatica Developer - IT

Job Description

What a typical day looks like: Analyze data requirements, data model and determine the best methods in extracting, transforming, and loading the data into the data warehouse and other system integration projects Perform source system analysis and design the extract logic Architect the solution, Code Design, Implement and continuously expand data pipelines by performing extraction, transformation and loading activities Investigate data to identify potential issues within ETL pipelines Write SQL scripts to perform data comparison checks to unit test data integration jobs Prepare high- and low-level design documentation Write Shell scripts or Python scripts for various in-house automation activities The experience were looking to add to our team: Any Bachelor or Master degree with Min 4 to 6 years of experience in Data Warehousing environment with very strong knowledge of Data Integration, migration & replication by using Informatica PowerCenter/products, Oracle, Snowflake & Unix shell scripting Proficient in Data modelling & Strong Exposure to Data Warehousing Concepts. Implementation of larger Data Warehousing/Data Lake projects Hands on experience in SQL query tuning, query re-writing & fine tuning Preferred to have exposure on cloud data integration tools Able to write the complex Unix shell and Python scripts. Hands on experience of Informatica Power Center and other products, preferred to have worked on CDC (Change Data Capture) environment Experience in handling various file types for sending/receiving data (CSV/API/XML/JSON/AVRO) Good knowledge in end-to-end Data Migration process Exposure to ERPs such as BaaN, ERP have greater advantage Must have good communication and problem-solving skills Design and Develop Informatica mappings, mapplets and workflows using Informatica products Coach and guide other members in the team and implement best practices and automate some of routine day to day activities Prepare High & Low-level design documents and Test cases for various Data Warehousing projects ? Good Written & Verbal Communication.