Job Description |
5 to 7 years of relevent exp in ETL technology |
Coupe 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. |