SonSoft Inc. Logo

SonSoft Inc.

Senior Informatica Developer

Reposted One Month Ago
Be an Early Applicant
In-Office
Lexington, MA, USA
Senior level
In-Office
Lexington, MA, USA
Senior level
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.
The summary above was generated by AI
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 

Similar Jobs

10 Minutes Ago
Easy Apply
Remote or Hybrid
USA
Easy Apply
134K-168K Annually
Senior level
134K-168K Annually
Senior level
Cloud • Information Technology • Security • Software • Cybersecurity
Lead insider risk detection engineering and investigations using EDR/XDR, UEBA, SIEM, and SOAR tools. Refine detection rules, reduce alert noise, close coverage gaps, manage investigations, develop playbooks, document evidence, mentor analysts, and collaborate discreetly with HR, Legal, business leaders, and executives. The role also requires investigative workflow automation using Python or JavaScript and ownership of scalable security processes.
Top Skills: Ai/MlCertEdr/XdrJavaScriptNistNsaPythonSIEMSoarUebaZscaler Cyberrisk ProtectionZscaler Data ProtectionZscaler Zero Trust Networking
15 Minutes Ago
Remote or Hybrid
US
78K-108K Annually
Mid level
78K-108K Annually
Mid level
Information Technology
Provides Microsoft core infrastructure support for managed-services customers in a reactive break/fix environment. Troubleshoots Windows Server, Active Directory, domain controllers, Group Policy, DNS, DHCP, SCCM, endpoint management, Azure, and Microsoft 365 issues. Manages case queues, resolves incidents, documents solutions, communicates with customers, meets SLAs, participates in on-call support, contributes to infrastructure projects, mentors peers, and identifies customer needs.
Top Skills: Active DirectoryAzureDhcpDnsDomain ControllersEndpoint ManagementGroup PolicyHybrid InfrastructureMicrosoft 365SccmWindows Server
16 Minutes Ago
Remote or Hybrid
US
107K-150K Annually
Senior level
107K-150K Annually
Senior level
Information Technology
Installs, customizes, upgrades, patches, maintains, and troubleshoots IBM z/OS and ISV products in managed mainframe environments. Supports disaster recovery, performance optimization, database and infrastructure administration, security, customer incidents, change control, and ServiceNow requests. Plans transitions and technical projects, develops automation scripts and documentation, supports proposals and service scoping, and mentors technical staff while maintaining customer relationships.
Top Skills: AIBmcBroadcomCaClistCompuwareDatabasesFtpIbm ServerpacIbm Z/OsJclLrsMainframe SystemsNetwork HardwareRexxRocket SoftwareScriptingServicenowSftpSyncortUnix Systems ServicesZ/Osmf Configuration Assistant

What you need to know about the Boston Tech Scene

Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.

Key Facts About Boston Tech

  • Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
  • Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
  • Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
  • Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account