ETL Informatica IICS developer - Chicago, United States - Tata Consultancy Services

Description

• Hands-on exp with Informatica 9.6 and above
• 2 plus years of hands-on exp with cloud ETL (pre with IICS)
• Hands-on exp in unix commend and scripting
• 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.
• Develop, unit test and system test integration components.
• Create support documentation describing the functionality of the integrations.
• 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.