SonSoft Inc. Logo

SonSoft Inc.

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

Reposted 2 Months Ago
Be an Early Applicant
In-Office
New York, NY, USA
Senior level
In-Office
New York, NY, USA
Senior level
Lead design, development, deployment, and support of Informatica PowerCenter and PowerExchange (CDC) workflows. Perform data mapping, extraction from sources (SAP, Oracle, AS400), DWH loading, performance troubleshooting, migration to production, and documentation. Collaborate with analysts and teams across locations to implement change data capture solutions and post-deployment support.
The summary above was generated by AI
Company Description

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.

Job Description

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

Qualifications

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:-

  1. This is a Full-Time Permanent job opportunity for you.
  2. Only US Citizen, Green Card Holdercan apply.
  3. No ,  , H4-EAD & L2-EADTN Visa, GC-EAD OPT-EAD & H1B Consultants please.
  4. Please mention your Visa Status in your email or resume.

Similar Jobs

14 Minutes Ago
Remote or Hybrid
USA
110K-170K Annually
Senior level
110K-170K Annually
Senior level
Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
Delivers virtual and occasional onsite cloud security training covering Falcon Cloud Security, CNAPP, CSPM, CWPP, containers, and incident response. Develops curricula, certification exams, and hands-on labs; maintains expertise in cloud threats and CrowdStrike products; and supports broader endpoint, identity, logging, and SIEM topics. Requires strong technical education, cloud security, communication, project management, AI technology, and occasional travel experience.
Top Skills: AksAWSAzureBashCi/CdCiemCloudFormationCnappCrowdstrike Falcon Cloud SecurityCspmCwppDevsecopsDockerEksGCPGkeKubernetesLaceworkOracle CloudOrca SecurityPowershellPrisma CloudPythonSIEMSysdigTerraformWiz
An Hour Ago
Hybrid
New York, NY, USA
150K-178K Annually
Senior level
150K-178K Annually
Senior level
Artificial Intelligence • Fintech • Machine Learning • Mobile • Payments • Retail • Software
Leads lifecycle marketing quality, messaging, creative strategy, program delivery, capacity planning, and team development. Oversees campaign workflows, contractor and agency relationships, AI-assisted marketing adoption, and cross-functional alignment. Acts as the Director’s operating partner while coaching teams on messaging, testing, and marketing craft. Requires strong lifecycle marketing expertise, consumer messaging judgment, program management, marketing-platform fluency, and experience leading teams.
Top Skills: Ai AgentsBrazeIterableSalesforce Marketing Cloud
An Hour Ago
Hybrid
New York, NY, USA
188K-313K Annually
Senior level
188K-313K Annually
Senior level
Big Data • Fintech • Information Technology • Business Intelligence • Financial Services • Cybersecurity • Big Data Analytics
Leads market planning and growth strategy for TransUnion’s Life Insurance business. Develops market-informed priorities, go-to-market strategies, value propositions, and thought leadership; translates insurance, actuarial, underwriting, and data concepts into executive recommendations. Partners with sales, analytics, product, and senior leadership to validate opportunities, reposition solutions, manage dependencies, and drive strategic initiatives. Represents the company in customer and industry engagements, with approximately 10–20% external engagement.
Top Skills: Consumer Data AnalyticsPredictive AnalyticsThird-Party Data Partnerships

What you need to know about the NYC Tech Scene

As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.

Key Facts About NYC Tech

  • Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
  • Key Industries: Artificial intelligence, Fintech
  • Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
  • Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account