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

Posted 13 Days Ago
Be an Early Applicant
New York, NY, USA
In-Office
Senior level
Information Technology • Professional Services • Software • Consulting
The Role
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.
Summary Generated by Built In
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.

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
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
87 Employees
Year Founded: 2007

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.

Similar Jobs

CoreWeave Logo CoreWeave

Technical Program Manager

Cloud • Information Technology • Machine Learning
In-Office
5 Locations
1450 Employees
157K-210K Annually

BAE Systems, Inc. Logo BAE Systems, Inc.

Software Engineer

Aerospace • Hardware • Information Technology • Security • Software • Cybersecurity • Defense
Hybrid
Endicott, NY, USA
40000 Employees
79K-135K Annually

CoreWeave Logo CoreWeave

Staff Engineer

Cloud • Information Technology • Machine Learning
In-Office
4 Locations
1450 Employees
207K-275K Annually

CoreWeave Logo CoreWeave

Network Engineer

Cloud • Information Technology • Machine Learning
In-Office
4 Locations
1450 Employees
207K-270K Annually

Similar Companies Hiring

Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees
Kepler  Thumbnail
Fintech • Software
New York, New York
6 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account