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.

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.

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