What are the responsibilities and job description for the SENIOR INFORMATICA DEVELOPER position at VeriiPro?
Roles And Responsibilities
- Design, develop, maintain, and optimize ETL processes using Informatica Intelligent Data Management Cloud (IDMC).
- Build, maintain, and support data integration workflows, mappings, and pipelines.
- Design and implement scalable data warehouse solutions using dimensional data modeling principles.
- Develop and maintain ETL processes for data migration, transformation, and integration from multiple source systems.
- Integrate enterprise applications using REST APIs and Salesforce/SQL connectors.
- Perform ETL testing, troubleshoot defects, and ensure data accuracy and integrity.
- Collaborate with business analysts, architects, developers, and QA teams to deliver data integration solutions.
- Monitor production ETL processes, investigate issues, and ensure high system availability.
- Optimize ETL performance, database queries, and data processing workflows.
- Mentor junior developers by providing technical guidance and best practices.
- Participate in Agile ceremonies and contribute throughout the Software Development Life Cycle (SDLC).
- Maintain technical documentation and support continuous process improvements.
- Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
- 7 years of experience in Informatica development and enterprise ETL solutions.
- Strong experience with Informatica Intelligent Data Management Cloud (IDMC) or Informatica Cloud.
- Expertise in ETL architecture, data integration, and database design.
- Strong knowledge of data warehousing concepts, BI architecture, and dimensional data modeling.
- Advanced SQL skills with experience designing and optimizing complex queries.
- Experience with REST APIs and integrating enterprise applications.
- Experience using Salesforce and SQL connectors for data integration.
- Experience with Azure DevOps and Agile software development practices.
- Knowledge of database conversion, migration, and ETL optimization techniques.
- Familiarity with scripting languages such as PowerShell, Python, Shell, or similar.
- Strong analytical, troubleshooting, and problem-solving skills.
- Excellent communication and collaboration skills.
- Experience with cloud-based data integration and modern data platforms.
- Knowledge of performance tuning for ETL workflows and databases.
- Experience with CI/CD pipelines for ETL deployments.
- Informatica certifications are a plus.
- Experience working in enterprise-scale data warehouse environments.