Job Description
Eeking a Specialist with 5 to 7 years of experience in Informatica Power Center ANSISQL and Dimensional Data Modeling within the IDMC skill cluster family
Job Description
Design develop and optimize Informatica Power Center mappings and workflows to support enterprise data integration requirements Utilize ANSISQL for data extraction transformation and loading processes ensuring accuracy and efficiency Apply dimensional data modeling techniques including star and snowflake schemas to build scalable and maintainable data warehouse solutions Collaborate with crossfunctional teams including data architects and business analysts to understand data needs and deliver effective ETL solutions Monitor and troubleshoot Informatica Power Center workflows and sessions to ensure high availability and performance Maintain comprehensive documentation related to data integration processes Informatica environments and data models Stay current with the latest Informatica Intelligent Data Management Cloud IDMC features and industry best practices to continuously improve integration workflows
Roles and Responsibilities
Manage and administer Informatica Power Center environments including installation configuration and patching Develop test and deploy ETL workflows and mappings to meet evolving business requirements Implement and support dimensional data models to facilitate accurate business intelligence and reporting Perform root cause analysis and resolve issues related to data integration and workflow failures Collaborate with database administrators to ensure data integrity and consistency across systems Participate in code reviews testing and deployment activities following established change management protocols Provide technical guidance and mentoring to junior team members on Informatica tools and best practices Coordinate with stakeholders to gather requirements provide status updates and deliver highquality data integration solutions
Job Description
Design develop and optimize Informatica Power Center mappings and workflows to support enterprise data integration requirements Utilize ANSISQL for data extraction transformation and loading processes ensuring accuracy and efficiency Apply dimensional data modeling techniques including star and snowflake schemas to build scalable and maintainable data warehouse solutions Collaborate with crossfunctional teams including data architects and business analysts to understand data needs and deliver effective ETL solutions Monitor and troubleshoot Informatica Power Center workflows and sessions to ensure high availability and performance Maintain comprehensive documentation related to data integration processes Informatica environments and data models Stay current with the latest Informatica Intelligent Data Management Cloud IDMC features and industry best practices to continuously improve integration workflows
Roles and Responsibilities
Manage and administer Informatica Power Center environments including installation configuration and patching Develop test and deploy ETL workflows and mappings to meet evolving business requirements Implement and support dimensional data models to facilitate accurate business intelligence and reporting Perform root cause analysis and resolve issues related to data integration and workflow failures Collaborate with database administrators to ensure data integrity and consistency across systems Participate in code reviews testing and deployment activities following established change management protocols Provide technical guidance and mentoring to junior team members on Informatica tools and best practices Coordinate with stakeholders to gather requirements provide status updates and deliver highquality data integration solutions
Apply for this Position
Ready to join ? Click the button below to submit your application.
Submit Application