Senior Informatica Developer

Posted 6 Days Ago
Be an Early Applicant
Lexington, MA, USA
In-Office
Senior level
Information Technology • Professional Services • Software • Consulting
The Role
Design, develop, test, and maintain ETL processes using Informatica. Create data mappings and technical specifications, schedule and support production ETL jobs, perform root cause analysis, validate data flows, and collaborate with analysts and metadata management to handle large data volumes and resolve data issues.
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

PRINCIPAL RESPONSIBILITIES AND DUTIES:
Coordinate with ETL team to implement all ETL procedures for all new projects and maintain effective awareness of all production activities according to required standards and provide support to all existing applications.
Understanding business requirements and validate all designs and schedule all ETL processes and prepare documents for all data flow diagrams.
Documents all technical and system specifications documents for all ETL processes and perform unit tests on all processes and prepare required programs and scripts.
ETL Design all data mapping techniques for all data models in systems.
Supports the ongoing ETL implementation when needed. Performs upgrades, patches, and operational tasks as directed.
Analyze and interpret all complex data on all target systems and analyze and provide resolutions to all data issues and coordinate with data analyst to validate all requirements, perform interviews with all users and developers.
Perform tests and validate all data flows and prepare all ETL processes according to business requirements and incorporate all business requirements into all design specifications.
Perform root cause analysis on all processes and resolve all production issues and validate all data and perform routine tests on databases and provide support to all ETL applications.
Develop and perform tests on all ETL codes for system data and analyze all data
Provide support to all ETL schedule and maintain compliance to same and develop and maintain various standards to perform ETL codes and maintain an effective project life cycle on all ETL processes.
Collaborate with Metadata Manager and perform tests and provide update to all ETL activities within schedule and provide support to all large data volumes and assist in data processing.

Additional Information

NOTE : ONLY GCEAD , GC AND CITIZEN 

Skills Required

  • Experience with Informatica ETL development and implementation
  • Designing ETL processes, data mapping, and data flow diagrams
  • Authoring technical and system specification documentation
  • Unit testing, validating data flows, and performing root-cause analysis on ETL processes
  • Support and maintain production ETL schedules and perform upgrades/patches
  • Experience handling large data volumes and coordinating with data analysts/metadata management
  • Must be GCEAD, Green Card holder, or US Citizen (no sponsorship)
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

Square Logo Square

Account Executive

eCommerce • Fintech • Hardware • Payments • Software • Financial Services
Hybrid
Boston, MA, USA
12000 Employees
123K-223K Annually

Leader Bank Logo Leader Bank

Desktop Support

Fintech • Insurance • Payments • Social Impact • Financial Services
Hybrid
Arlington, MA, USA
420 Employees
50K-70K Annually

HiBob Logo HiBob

Technical Support

HR Tech • Information Technology • Professional Services • Sales • Software
Remote or Hybrid
United States
1350 Employees
103K-129K Annually

ServiceNow Logo ServiceNow

Keynote Production Lead

Artificial Intelligence • Cloud • HR Tech • Information Technology • Productivity • Software • Automation
Remote or Hybrid
Waltham, MA, USA
29000 Employees
102K-179K 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