> Markdown version of [/jobs/ext/4724546-sr-informatica-developer-lead-pwx-cdc-usc-gc-only](https://www.wearedevelopers.com/jobs/ext/4724546-sr-informatica-developer-lead-pwx-cdc-usc-gc-only). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Sr. Informatica Developer/ Lead (PWX/CDC) ( USC & GC ) ONLY - **Company:** SonSoft Inc. - **Location:** New York, NY, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Data Analysis, IBM System I, Unix, Databases, Data Cleansing, Extract Transform Load (ETL), Data Mapping, Data Recovery, Data Retrieval, Data Warehousing, Logical Data Models, Oracle Databases, Oracle (Applications), SAP (Applications), SQL Stored Procedures, Data Import/Export, Informatica Powercenter, Netezza, Change Data Capture, Information Technology - **Published:** November 15, 2026 - **Apply:** https://www.adzuna.com/details/5921094499 ## About the Role * + 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, 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. ## Description * 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.