We are Hiring Senior/Lead Informatica Technical Consultant for our client in Quincy MA. If the below Job description is suitable for you then submit the resume with DL,Visa and Linkedin.
Job Description:
IICS Tech lead
Job Summary
Should have strong development experience in Informatica power center and Integrating Informatica Cloud (RCS)
Have to assist BCBSMA in developing project specific deliverables from the enterprise data warehouse environment.
Depending on the requirements of the individual project, the resource will be required to perform one, some or all of the activities identified below.
Create/Enhance ETL jobs as needed to load external feeds into warehouse tables/data mart tables.
Experience : 10 to 12yrs.
Required Technical Skills : ETL Validation ,AWS ,AWS Cloud ,IICS Domain Skills : Payer ,Claims
Roles & Responsibilities
Should have strong development experience in Informatica power center and Integrating Informatica Cloud (IICS)
Have to assist BCBSMA in developing project specific deliverables from the enterprise data warehouse environment.
Depending on the requirements of the individual project, the resource will be required to perform one, some or all of the activities identified below.
Create/Enhance Ell jobs as needed to load external feeds into warehouse tables/data mart tables.
Work with an agile team to deliver and evolve the data platform services
Provide technical support to User Acceptance and integration testing environments by researching suspected anomalies and periodically refreshing the environments.
Performance tuning Eli process and user quenes.
Develop the production process to automate the ETL and create documentation to transition the process to the Production team
Should have experience distributed databases particularly in designing and implementing ETL processes understanding of data models and data flow
Experience in data modelling, schema designing, data loading, data replication, SQL Query writing and optimization on distributed databases preferably on Cloud Technologies.
Working experience with distributed databases on cluster/platform.
Experience with AWS technologies
Experience in working in Agile methodology
Proficiency in understanding relational, star schema and dimensional data model so Excellent oral and written communication
Ability to handle multiple priorities and meet deadlines.