157 Informatica Jobs in Chennai

• 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.