Senior Informatica Developer

Sonsoft Inc; Lexington (MA); On-site; USD 90,000 - 135,000; Full time

Job summary

A growing technology firm in Massachusetts seeks an experienced professional to coordinate ETL procedures and support data analysis efforts. The ideal candidate will have strong skills in documenting technical specifications, performing unit tests, and troubleshooting data issues. Responsibilities include managing ETL processes for projects, ensuring compliance, and collaborating with teams to validate business requirements. This position offers an opportunity to work with complex data systems in a dynamic environment.

Qualifications

• Experience coordinating with ETL teams and implementing ETL procedures.
• Ability to document technical specifications and perform unit tests.
• Strong analytical skills for data analysis and troubleshooting.

Responsibilities

• Coordinate ETL procedures for new projects and maintain production awareness.
• Validate business requirements and schedule ETL processes.
• Perform root cause analysis and resolve production issues.
• Design data mapping techniques for data models across systems.
• Support ongoing ETL implementation, perform upgrades and patches as directed.
• Analyze complex data, resolve data issues, and coordinate with data analysts and users.
• Test and validate data flows, align ETL processes with business requirements.
• Perform root-cause analysis on processes and support ETL applications in production.
• Develop tests for ETL code and maintain data analysis workflows.
• Support ETL scheduling, enforce standards, and manage project lifecycle.
• Collaborate with Metadata Manager and assist with large data volumes and data processing.

Job 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.