Sr. Informatica Developer/ Lead (PWX/CDC)

Company Description

Sonsoft , Inc. is a USA based corporation duly organized under the laws of the Commonwealth of Georgia. Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development, Software Consultancy and Information Technology Enabled Services.

Job Description

Job Duties:

• 4+ 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

Qualifications

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.

Key Skills: Sr. Informatica Developer/ Lead

Additional Information

Note:-
This is a Full-Time & Permanent job opportunity for you.
Only US Citizen, Green Card Holder, GC-EAD, H4-EAD & L2-EAD can apply.
No OPT-EAD, H1B & TN candidates please.
Please mention your Visa Status in your email or resume.