Informatica Developer - ETL/SQL

Job Description : Responsibilities : - Design and develop ETL mappings, workflows, and sessions using Informatica PowerCenter. - Implement complex data transformations and business logic. - Optimize ETL processes for performance and scalability. - Develop and maintain technical documentation for ETL processes. - Extract data from various sources (databases, flat files, APIs) and load it into target systems. - Implement data quality checks and data cleansing routines. - Troubleshoot and resolve data integration issues. - Write and optimize SQL queries for data extraction and transformation. - Work with relational databases (Oracle, SQL Server, etc.). - Understand and implement database concepts like indexes, partitions, and constraints. - Collaborate with data analysts and business users to understand data requirements. - Communicate effectively with team members and stakeholders. - Participate in code reviews and provide constructive feedback. - Deploy and maintain Informatica workflows and sessions. - Monitor ETL processes for performance and errors. - Troubleshoot and resolve production issues. Qualifications : Experience : - 5-7 years of experience in Informatica PowerCenter development. Technical Skills : - Strong proficiency in Informatica PowerCenter (Designer, Workflow Manager, Repository Manager). - Expertise in SQL and relational database concepts. - Experience with data warehousing concepts and ETL best practices. - Familiarity with Unix/Linux environments. - Experience with scripting languages (e.g., Shell scripting, Python) is a plus. - Experience with cloud-based data integration platforms (e.g., IICS) is a plus. Education : - Bachelor's degree in Computer Science, Information Systems, or a related field. Preferred Qualifications : - Experience with Informatica Data Quality (IDQ). - Experience with Informatica MDM (Master Data Management). - Experience with cloud data warehousing solutions (e.g., Snowflake, Redshift). - Experience with Agile/Scrum methodologies. (ref:hirist.tech)

Location: mumbai, IN

Posted Date: 4/7/2025