ETL - Informatica, IPC/IICS
Chicago,IL
Hybrid , initial remote upto 3 months
Full Time
No C2C
No H1B
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 (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.
Develop & test mappings/mapplets in IICS cloud data integration to process data
Build task flows to integrate data, command decision task etc.. To build flows
work with multiple sources & targets like google cloud storage, PostgreSQL, Oracle, Flat file, Google big query
Build Mass and File ingestion tasks in mass ingestion
Perform data transformations
Use parameter files and generate parameterized components
Configure connections, shared sequences etc. in different orgs/environments
Export and deploy task flows in different orgs/environments
Job Type: Full-time
Pay: $61,626.19 - $118,550.51 per year
Benefits:
- 401(k)
- 401(k) matching
- Dental insurance
- Health insurance
Schedule:
- 8 hour shift
Experience:
- IICS: 4 years (Preferred)
- IPC: 4 years (Preferred)
Work Location: On the road
Please Note :
ajayjain.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, ajayjain.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, Site.com is the ideal place to find your next job.