Sr. Informatica Developer/ Lead (PWX/CDC)

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, implementation, and support of Informatica ETL solutions using PowerCenter and PowerExchange CDC. Responsibilities include data mapping, change-data-capture pipelines, performance troubleshooting, migrations to production, documentation, and collaboration with analysts and cross-location teams. Work with Oracle, Unix, and data warehouse environments; support SAP/AS400 extraction.
Summary Generated by Built In
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

  • 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

Qualifications

  • 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
  • Experience in performance trouble shooting and remediation

Additional Information

Connect with me at https://www.linkedin.com/in/mir-hasham-ali/ (For Direct Clients Requirements)


** U.S. Citizens and those who are authorized to work independently in the United States 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 Holder can apply.
  3. Please mention your Visa Status in your email or resume.

** All your information will be kept confidential according to EEO guidelines.

Skills Required

  • Bachelor's degree in Computer Science or related field, or equivalent experience
  • 4+ years development, maintenance and enhancement experience in Informatica PowerCenter
  • 4+ years experience with PowerExchange CDC tools and extracting data from SAP, Oracle, AS400
  • 3+ years experience developing and maintaining Informatica mappings, workflows, and processes
  • Experience developing and deploying Informatica in Unix and Oracle 11g environments
  • Good knowledge of Data Warehouse (DWH) concepts
  • Experience in performance troubleshooting and remediation
  • Should have worked in a multi-location delivery environment
  • Experience with Netezza and other databases
  • Professional Informatica certification
  • Strong analytical, written, and verbal communication and interpersonal skills
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

SonSoft Inc. Logo SonSoft Inc.

Sr. Informatica Developer/ Lead (PWX/CDC)

Information Technology • Professional Services • Software • Consulting
In-Office
New York, NY, USA
87 Employees

SonSoft Inc. Logo SonSoft Inc.

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

Information Technology • Professional Services • Software • Consulting
In-Office
New York, NY, USA
87 Employees

MetLife Logo MetLife

Technical Functional Analyst

Fintech • Information Technology • Insurance • Financial Services • Big Data Analytics
Hybrid
New York, NY, USA
43000 Employees
90K-117K Annually

MetLife Logo MetLife

AMS Unit Leader - 18678

Fintech • Information Technology • Insurance • Financial Services • Big Data Analytics
Remote or Hybrid
United States
43000 Employees
56K-99K 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