Senior Informatica Developer

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:

1. 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.
2. Understand business requirements and validate all designs, schedule all ETL processes, and prepare documents for all data flow diagrams.
3. Document all technical and system specifications for all ETL processes, perform unit tests on all processes, and prepare required programs and scripts.
4. Design all data mapping techniques for all data models in systems.
5. Support ongoing ETL implementation when needed, performing upgrades, patches, and operational tasks as directed.
6. Analyze and interpret all complex data on all target systems and provide resolutions to all data issues; coordinate with data analysts to validate all requirements and perform interviews with all users and developers.
7. Perform tests and validate all data flows, preparing all ETL processes according to business requirements and incorporating all business requirements into all design specifications.
8. Perform root cause analysis on all processes, resolve all production issues, validate all data, and perform routine tests on databases while providing support to all ETL applications.
9. Develop and perform tests on all ETL codes for system data and analyze all data.
10. Provide support to all ETL schedules and maintain compliance; develop and maintain various standards to perform ETL codes and maintain an effective project life cycle on all ETL processes.
11. Collaborate with Metadata Manager, perform tests, provide updates to all ETL activities within schedule, and support large data volumes while assisting in data processing.