Job Description

Position: ETL Informatica Developer

Location: Columbus, OH (Onsite)

Duration: FTE/ Direct Hire

Job Description:

• 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:

• Plan, facilitate, and conduct requirements gathering sessions, meetings, and presentations.
• Experience interacting with business SME’s 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.

Salary Range - $80000-$110,000 a year

Job Tags

Similar Jobs