We are seeking an experienced Senior Informatica Developer to design, develop, implement, and maintain enterprise data integration and ETL solutions. The ideal candidate will have strong expertise in Informatica PowerCenter, data warehousing, SQL, performance tuning, and data quality management. The candidate will collaborate with business analysts, data architects, database administrators, and other technical teams to deliver reliable and scalable data solutions.
Design, develop, test, and deploy ETL workflows using Informatica PowerCenter.
Develop complex mappings, mapplets, sessions, workflows, and reusable transformations.
Analyze business requirements and translate them into technical specifications.
Develop and optimize SQL queries, stored procedures, and database objects.
Perform ETL performance tuning and troubleshoot data integration issues.
Integrate data from multiple sources, including relational databases, flat files, APIs, and enterprise applications.
Support data warehouse, data mart, and business intelligence initiatives.
Implement data validation, data cleansing, reconciliation, and quality checks.
Monitor production ETL jobs, investigate failures, and resolve incidents.
Work with Oracle, SQL Server, DB2, Teradata, or other enterprise databases.
Participate in code reviews, unit testing, system integration testing, and deployment activities.
Maintain technical documentation, data mappings, and operational procedures.
Collaborate with cross-functional teams and mentor junior developers.
Follow data governance, security, and development standards.
Strong experience with Informatica PowerCenter and ETL development.
Advanced SQL and PL/SQL programming skills.
Experience with data warehousing concepts, dimensional modeling, and data integration.
Knowledge of relational databases such as Oracle, SQL Server, DB2, or Teradata.
Experience with ETL optimization, debugging, and production support.
Familiarity with Unix/Linux shell scripting.
Understanding of data quality, data profiling, and data reconciliation.
Experience with scheduling tools such as Autosys, Control-M, or similar tools.
Proficiency in SDLC, Agile methodologies, version control, and deployment processes.
Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field, or equivalent practical experience.
