ETL- IICS Developer

Company: Diverse Lynx
Location: Remote
Posted on: January 26, 2023

Job Description:

Position : ETL- IICS Developer
Location : Remote
Type : Contract

JD:

5 to 7 years of relevent exp in ETL technology

Couple of years of hands-on exp with Informatica 9.6 and above

2 plus years of hands-on exp with cloud ETL (IICS)

Hands-on exp in unix commend and scripting

Develop, unit test and system test integration components.

Provide feedback to Data Architects on the scalability of data models.

Maintain consistency in naming standards and ensure standards are followed.

Develop stored procedures, user defined functions in SQL Server using secure coding techniques that guard against SQL injection attacks.

Ensure adherence to data management/governance policies, processes, and standards.

Develop reconciliation & balancing scripts between source applications and the data platform to track accuracy of data loads.

Develop parameterized rollback scripts to restore prior batches in case of errors in data loads.

Develop data pipelines to ingest source data into the Data Platform using relational drivers as well as application delivered APIs. Build ETL to centralize data into the Data Vault environment.

Create support documentation describing the functionality of the integrations.







Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.

Keywords: Diverse Lynx, Eugene , ETL- IICS Developer, IT / Software / Systems , Remote, Oregon