Developer
Apply NowCompany: Tata Consultancy Services
Location: Columbus, OH 43230
Description:
Skill: ETL Informatica Developer
Roles & Responsibilities:
Salary Range - $90,000-$110,000 a year
#LI-NS2
- 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 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.
Salary Range - $90,000-$110,000 a year
#LI-NS2