Hiring for ETL Informatica Developer

at  PATH INFOTECH PTE LTD

Degree in Computer Science, Computer Engineering or equivalent.

• Expertise in using Informatica PowerCenter tools for data integration and ETL processes.
• Knowledge of Informatica Designer, Workflow Manager, and Repository Manager.
• Experience with creating and managing ETL mappings, sessions, and workflows.
• Proficiency in designing and developing data transformations.
• Strong SQL skills for database querying and manipulation.
• Understanding of relational database concepts and performance tuning. And also familiarity with data warehousing concepts, star schema, snowflake schema, and data marts.
• Ability to optimize ETL processes for performance and efficiency.

Good to have: * Understanding of AWS Glue components like Crawlers, Jobs, Triggers, and Data Catalog.

• Experience in creating and managing ETL jobs using AWS Glue Studio.
• Proficiency in Python, especially with PySpark, for writing ETL scripts in AWS Glue.
• Familiarity with other AWS services like S3, Redshift, RDS, and Lambda for integration with AWS Glue.
• Understanding of IAM roles and permissions for secure access to AWS services.
• Skills in planning and executing data migration from Informatica to AWS Glue.
• Ability to translate Informatica workflows and mappings into AWS Glue jobs.
• Experience with AWS CodePipeline or similar tools for automating deployment and integration processes

Job Type: Contract
Contract length: 12 months
Pay: $7,500.00 - $8,500.00 per month
Work Location: In perso

Please refer the Job description for details