Sr. Informatica Developer/ Lead (PWX/CDC) ( USC & GC ) ONLY

SonSoft is an IT Staffing and consulting firm and duly organized under the laws of the Commonwealth of Georgia. We are growing at a steady pace specializing in the fields of Software Development, Software Consultancy and Information Technology Enabled Services.

• + years development, maintenance and enhancement experience in Informatica PowerCenter,

• Informatica Job Purpose: Independently handle the Informatica PWX/CDC projects from requirement gathering till project closure

• 3+ years of experience in development, maintenance, and enhancement of Informatica Mappings, Work-flows, and processes

• 4+ yrs. experience in Power Exchange CDC tools and should have worked extracting data from different source system like SAP, Oracle, and AS400 etc.

• Good Knowledge on DWH concepts

• Experience in developing and deploying Informatica in Unix and Oracle 11g database environment

• Experience in performance trouble shooting and remediation

Responsibilities:

• Designs, develops, modifies, configures, debugs Informatica workflows using Informatica PowerCenter and PowerExchange CDC tools

• Design technical and Business solutions in our change data capture technologies.

• Build 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

• Analyses 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-through as needed to communicate design/coded solution 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, 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 analyst and other project team members

• Performs migration of workflows from development/Test to production environment and provide post-deployment support

• Documents all technical specifications and associate project deliverables

• Should have worked in multi-location delivery environment

• Preferred worked with multiple databases like Netezza,Oracle etc.

Skills/Qualifications: Bachelor's Degree in computer science/related field or equivalent experience,Professional Informatica certification a PLUS. Should have Strong Analytical and interpersonal skills with good written and verbal communication.

** U.S. citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time.

Note:-

• This is a Full-Time Permanent job opportunity for you.
• Only US Citizen, Green Card Holdercan apply.
• No ,  , H4-EAD & L2-EADTN Visa, GC-EAD OPT-EAD & H1B Consultants please.

• Please mention your Visa Status in your email or resume.