Job description

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

gatheringourvoice.org 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, gatheringourvoice.org 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, gatheringourvoice.org is the ideal place to find your next job.