Sonoma Consulting
Sr. Informatica Developer
Sonoma Consulting, New Brunswick, New Jersey, us, 08933
Halo Group is a premier provider of IT talent. We place technology experts within
the teams of the world’s leading companies to help them build innovative
businesses that keep them one step closer to their customers and one step
ahead of the competition. We offer a meaningful work environment for
employees, attractive and interesting engagements for consultants, and cutting-edge
digital innovation for our customers.
We delight in helping our customers execute their digital vision. Big projects or
small, Halo Group knows that by combining the highest quality talent with our
unwavering support, we will become an invaluable extension of the team. Halo
Group's experienced consultants in Detroit, Atlanta and Dallas specialize in all
areas of product/project governance, UX/UI, multi-platform applications, quality
assurance/testing, cloud computing, and data analytics.
Job Description
- Designs, develops, modifies, configures, and debugs Informatica workflows using Informatica PowerCenter and PowerExchange CDC tools. - Designs technical and business solutions in our change data capture technologies. - Builds infrastructure to extract and format captured change data and provide that data to other Informatica components and products. - Expertise in handling data recovery, solution designing, production implementation, testing, and support of interfaces PWC and PWX. - Responsible for the development/customization of interfaces, conversions, and enhancements. - Analyzes existing applications and systems and formulates logic for new systems, devises logic procedures, logical database design, performs coding and tests/debugs programs. - Performs technical walk-throughs as needed to communicate design/coded solutions and to seek input from team members. - Implements data clean-up procedures, data import/export utilities, transformations, scripts, stored procedures, and execution of test plans for loading the data successfully into the targets. - Performs data analysis, data mapping, and data loading. - Responsible for the development and documentation of deliverables, and specifications on a project-by-project basis as defined in the IT Methodology, in collaboration with business analysts and other project team members. - Performs migration of workflows from development/test to production environment and provides post-deployment support. - Documents all technical specifications and associated project deliverables. - Should have worked in a multi-location delivery environment. - Preferred experience with multiple databases like Netezza, Oracle, etc. Qualifications
-
Bachelor's Degree in computer science/related field or equivalent experience. - Professional Informatica certification a PLUS. - 4+ years of development, maintenance, and enhancement experience in Informatica PowerCenter. - 3+ years of experience in development, maintenance, and enhancement of Informatica mappings, workflows, and processes. - 4+ years of experience in Power Exchange CDC tools and should have worked extracting data from different source systems like SAP, Oracle, and AS400. - Good knowledge of DWH concepts. - Experience in developing and deploying Informatica in Unix and Oracle 11g database environment. - Experience in performance troubleshooting and remediation. Additional Information
** U.S. Citizens and those who are authorized to work independently in the United States are encouraged to apply. We are unable to sponsor at this time. This is a Full-Time / Permanent job opportunity. Only U.S. Citizens, Green Card Holders, GC-EAD, H4-EAD & L2-EAD can apply. ** All your information will be kept confidential according to EEO guidelines.
#J-18808-Ljbffr
- Designs, develops, modifies, configures, and debugs Informatica workflows using Informatica PowerCenter and PowerExchange CDC tools. - Designs technical and business solutions in our change data capture technologies. - Builds infrastructure to extract and format captured change data and provide that data to other Informatica components and products. - Expertise in handling data recovery, solution designing, production implementation, testing, and support of interfaces PWC and PWX. - Responsible for the development/customization of interfaces, conversions, and enhancements. - Analyzes existing applications and systems and formulates logic for new systems, devises logic procedures, logical database design, performs coding and tests/debugs programs. - Performs technical walk-throughs as needed to communicate design/coded solutions and to seek input from team members. - Implements data clean-up procedures, data import/export utilities, transformations, scripts, stored procedures, and execution of test plans for loading the data successfully into the targets. - Performs data analysis, data mapping, and data loading. - Responsible for the development and documentation of deliverables, and specifications on a project-by-project basis as defined in the IT Methodology, in collaboration with business analysts and other project team members. - Performs migration of workflows from development/test to production environment and provides post-deployment support. - Documents all technical specifications and associated project deliverables. - Should have worked in a multi-location delivery environment. - Preferred experience with multiple databases like Netezza, Oracle, etc. Qualifications
-
Bachelor's Degree in computer science/related field or equivalent experience. - Professional Informatica certification a PLUS. - 4+ years of development, maintenance, and enhancement experience in Informatica PowerCenter. - 3+ years of experience in development, maintenance, and enhancement of Informatica mappings, workflows, and processes. - 4+ years of experience in Power Exchange CDC tools and should have worked extracting data from different source systems like SAP, Oracle, and AS400. - Good knowledge of DWH concepts. - Experience in developing and deploying Informatica in Unix and Oracle 11g database environment. - Experience in performance troubleshooting and remediation. Additional Information
** U.S. Citizens and those who are authorized to work independently in the United States are encouraged to apply. We are unable to sponsor at this time. This is a Full-Time / Permanent job opportunity. Only U.S. Citizens, Green Card Holders, GC-EAD, H4-EAD & L2-EAD can apply. ** All your information will be kept confidential according to EEO guidelines.
#J-18808-Ljbffr