ETL Informatica Developer-IT

To Support Data Integration Engineer – Informatica PowerCenter Primary tool : Informatica PowerCenter and exposure of Informatica’s other products and cloud-based data integration tools like Matillion

1. 3 to 5 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 2. Proficient in Data modelling & Strong Exposure to Data Warehousing Concepts. 3. Implementation of larger Data Warehousing/Data Lake projects 4. Strong hands-on experience on Databases including PL/SQL & SQL 5. Hands on experience in SQL query tuning, query re-writing & fine tuning 6. Preferred to have exposure on cloud data integration tools 7. Able to write the complex Unix shell and Python scripts 8. Good Written & Verbal Communication.

1. Hands on experience of Informatica Power Center and other products, preferred to have worked on CDC (Change Data Capture) environment 2. Strong knowledge of Oracle, SQL server, postgres & Snowflake database and write/optimizing complex SQL queries 3. Experience with scripting languages such as Unix Shell and Python 4. Strong knowledge of data analysis, data transformation, conceptual data modelling, data transformation and metadata management. 5. Preferred to have knowledge on Qlik Replicate, Big data, APIs, and Cloud data integration tools experience 6. Experience in handling various file types for sending/receiving data (CSV/API/XML/JSON/AVRO) 7. Should be proficient enough to design and develop ETL for any data warehouse projects 8. Should have very good technical skills to optimize/tune the SQL queries or workflow to reduce cycle times to process huge data set 9. Understanding of industry standards for data security and privacy 10.Must have good communication and problem-solving skills 11.Design and Develop Informatica mappings, mapplets and workflows using Informatica products 12.Share the workload and flexible enough to get into other technologies as applicable and need basis 13.Coach and guide other members in the team and implement best practices and automate some of routine day to day activities 14.Prepare High & Low-level design documents and Test cases for various Data Warehousing projects.