Overview
On Site
Full Time
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - 6+ month(s)
Skills
SQL
ETL
Informatica
Insurance
P&C
Job Details
Role: Informatica Technical Lead
Location: Worcester, MA (Onsite)
Duration: 6+ months contract
Required Skills:
- Minimum 10 years of overall experience.
- Strong experience on ETL Power Center, Oracle, Hadoop, SQL,
- Experience in P&C Insurance domain required.
- Responsible to build any standalone codes apart from re-usability concept
- Responsible for working database connectivity and its plug-in's (MLoad, FLoad and Stream) to ETL tools.
- Responsible to see seamless data flow between ETL data warehouse and Big Data hub.
- Document the technical specifications, detail designs and STM (source to target mapping) for build, based on the business requirements.
- Perform system impact analysis for all types of Application Enhancements including Database, ETL and Mainframe components.
- Responsible for writing metadata of all data elements of both new and enchantment projects.
- Responsible to work closely with Line of Business (LoB) and Testing Center of Excellence (TCoE) to assist in developing data validations
- Interpreting incoming data, analyzing results using statistical techniques and providing ongoing project reports to the management.
- Build ETL code using Informatica (ETL tool) Power Center to extract data from heterogeneous systems like Oracle, DB2, Mainframes,
- Teradata, SQL Server, flat files etc., and transform it as per the business requirement and finally load into Data Warehouse.
eye
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.