Senior ETL Informatica IICS developer
Apply NowCompany: SysMind Tech
Location: Chicago, IL 60629
Description:
Job ID
283532
Job Title
Senior ETL Informatica IICS developer
Skill
Digital : Informatica Product 360
Skill Type
Marketable
Minimum Experience
7 - 12 Years
Salary
$120K
Location
Chicago, IL
Roles & Responsibilities
5 to 7 years of relevant 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 (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.
Generic Managerial Skills
Excellent written/verbal communication skills
Excellent team player
Consensus building skills
Independently manage Stakeholder Meetings
Detail-oriented
Excellent visual, written and verbal communication skills, along with presentation and negotiation skills
The ability to effectively take direction and work both collaboratively and autonomously.
Strong problem-solving skills
String desire to provide new solutions, which are cost effective and deliver quicker Time to market.
283532
Job Title
Senior ETL Informatica IICS developer
Skill
Digital : Informatica Product 360
Skill Type
Marketable
Minimum Experience
7 - 12 Years
Salary
$120K
Location
Chicago, IL
Roles & Responsibilities
5 to 7 years of relevant 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 (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.
Generic Managerial Skills
Excellent written/verbal communication skills
Excellent team player
Consensus building skills
Independently manage Stakeholder Meetings
Detail-oriented
Excellent visual, written and verbal communication skills, along with presentation and negotiation skills
The ability to effectively take direction and work both collaboratively and autonomously.
Strong problem-solving skills
String desire to provide new solutions, which are cost effective and deliver quicker Time to market.