What are the responsibilities and job description for the ETL Informatica Developer with IDQ position at PRO IT Inc.?
ETL Informatica Developer
Columbus OH
Fulltime Role with TCS
Skill: ETL Informatica Developer
- Hands-on experience in application development projects ETL and Informatica.
- Experience in Data Analysis, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Integration and Metadata Management Services and Configuration Management.
- Informatica PowerCenter, Informatica Data Quality (IDQ) as ETL tool for extracting, transforming, loading, and cleansing data from various source data inputs to various targets, in batch and real time.
- Experience in writing complex SQL queries to pull the data from multiple source tables or views.
- Experience in extraction, transformation and loading of data directly from different source systems like flat files and relational databases.
- Experience with Informatica Designer tools like Mapping and Workflow Designer.
- Experience in Data Migration, Data Integration, Data Cleansing ETL processes for Data warehouses.
- Experience in creating databases, tables, schema, stages, file formats, pipes in snowflake.
- Proven track record of creating clear, concise deliverable that reflect a deep understanding of business needs and out of the box software functionality.
Roles & Responsibilities:
- Experience in Data Analysis, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Integration and Metadata Management Services and Configuration Management.
- Plan, facilitate, and conduct requirements gathering sessions, meetings, and presentations.
- Experience interacting with business SMEs from various groups to elicit requirements.
- Leads complex user-centered design analysis activities including the following: conceptual design (including UCD and end-to-end experience design), interaction design (including information architecture and workflow analysis) and visual design (including page design and rapid prototyping).
- Performs multiple aspects of requirements specifications including functional and non-functional specification development. Successfully uses appropriate methodologies and techniques for assigned projects.
- Lead requirement teams per the assigned development project. Develop requirements documentation inclusive of user stories, process flows, mock-ups, data flows and gaps/decision documents.
Job Type: Full-time
Pay: $105,164.00 - $110,000.00 per year
Benefits:
- 401(k) matching
- Dental insurance
- Health insurance
- Paid time off
Compensation Package:
- Yearly pay
Schedule:
- 8 hour shift
Ability to Commute:
- Columbus, OH 43226 (Required)
Ability to Relocate:
- Columbus, OH 43226: Relocate before starting work (Required)
Work Location: In person
Salary : $105,164 - $110,000
