Informatica Developer
Prasanna DubbaUnited StatesSENIORPosted 49m ago
Informatica PowerCenterETLData IntegrationIICSIDMCOracleTeradataDB2/MVSAzureSynapseSQLHadoop/HDFSUNIX/LinuxShell ScriptingAgile
About the Role
We are looking for a seasoned Informatica Developer to lead and contribute to the development and maintenance of data integration and ETL processes using Informatica PowerCenter. This role will focus on designing and optimizing data workflows, implementing data transformation and quality processes, managing metadata, resolving performance issues, and collaborating with cross-functional teams while mentoring junior developers.
Key Responsibilities
• Design, develop, and maintain complex data integration workflows using Informatica PowerCenter to extract, transform, and load data from diverse sources into target systems
• Lead and design the development of ETL processes, mappings, and workflows, ensuring efficient data movement and transformation
• Develop and implement data transformation logic, including data cleansing, enrichment, and validation, to meet business rules and requirements
• Optimize ETL processes, SQL queries, and mapping for improved performance and scalability. Monitor and resolve performance bottlenecks
• Implement data quality checks, validation rules, and error handling mechanisms to maintain data integrity throughout the integration process
• Manage metadata associated with ETL processes, maintaining documentation and ensuring accurate lineage and impact analysis
• Mentor junior developers and collaborate with cross-functional teams and stakeholders to drive data integration initiatives
Requirements
• Bachelor's degree required; Master's degree in a related field preferred
• 7+ years of experience in a similar role
• 7+ years of experience with Informatica PowerCenter/PowerExchange
• Hands-on experience with IICS (IDMC)
• Hands-on experience with Oracle and Teradata; DB2/MVS preferred
• Experience with Azure and Synapse
• Strong SQL skills
• Knowledge of Hadoop/HDFS
• Knowledge of UNIX/Linux and shell scripting
• Experience working in an Agile environment