SysMind Tech
ETL Informatica Developer
SysMind Tech, Weehawken, New Jersey, United States,
Title: ETL Informatica DeveloperLocation: Weehawken, NJ(Day 1 ONSITE)
Job Description:Design and develop ETL workflows, mappings, and sessions using Informatica PowerCenter to extract, transform, and load data from various sources into target systems.Perform data profiling and analysis to understand the structure, quality, and completeness of source data.Develop and maintain technical documentation, including mapping specifications, data lineage, and data dictionary.Collaborate with data architects, data modelers, and other stakeholders to design and implement data integration solutions.Participate in code reviews, unit testing, and system testing to ensure high-quality deliverables.Identify and troubleshoot ETL performance issues and implement optimizations to improve processing times.Ensure adherence to best practices, standards, and guidelines for ETL development and maintenance.Provide support and maintenance for existing ETL processes and resolve production issues in a timely manner.Requirements:
Bachelor's degree in Computer Science, Information Technology, or a related field.3+ years of experience in ETL development using Informatica PowerCenter.Strong knowledge of SQL and data warehousing concepts.Experience with Oracle or other relational databases.Understanding of ETL performance optimization techniques.Strong analytical and problem-solving skills.Ability to work independently and as part of a team.Excellent communication and interpersonal skills.
Job Description:Design and develop ETL workflows, mappings, and sessions using Informatica PowerCenter to extract, transform, and load data from various sources into target systems.Perform data profiling and analysis to understand the structure, quality, and completeness of source data.Develop and maintain technical documentation, including mapping specifications, data lineage, and data dictionary.Collaborate with data architects, data modelers, and other stakeholders to design and implement data integration solutions.Participate in code reviews, unit testing, and system testing to ensure high-quality deliverables.Identify and troubleshoot ETL performance issues and implement optimizations to improve processing times.Ensure adherence to best practices, standards, and guidelines for ETL development and maintenance.Provide support and maintenance for existing ETL processes and resolve production issues in a timely manner.Requirements:
Bachelor's degree in Computer Science, Information Technology, or a related field.3+ years of experience in ETL development using Informatica PowerCenter.Strong knowledge of SQL and data warehousing concepts.Experience with Oracle or other relational databases.Understanding of ETL performance optimization techniques.Strong analytical and problem-solving skills.Ability to work independently and as part of a team.Excellent communication and interpersonal skills.