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.
Additional Information** 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.
Skills Required
- 3+ years developing Informatica mappings, workflows, and processes
- 4+ years PowerExchange (PWX) CDC experience extracting from SAP, Oracle, and AS400
- Experience with Informatica PowerCenter
- Experience deploying and running Informatica on Unix and Oracle 11g
- Good knowledge of data warehousing (DWH) concepts
- Experience in performance troubleshooting and remediation
- Experience with data analysis, data mapping, data loading, and ETL testing
- Experience migrating workflows from development/test to production and providing post-deployment support
- Bachelor's degree in computer science or related field or equivalent experience
- Must be U.S. Citizen or Green Card holder (no visa sponsorship)
- Experience working in multi-location delivery environments
- Experience with Netezza and multiple databases
- Professional Informatica certification
- Strong analytical and interpersonal skills with good written and verbal communication
What We Do
SonSoft Inc. is a global consulting and IT services firm specializing in software development, software consultancy, and Information Technology Enabled Services (ITES). The company provides a range of expertise including business consulting, systems integration, application development, and product engineering, helping clients re-engineer and re-invent their businesses to compete in a changing marketplace.







