EPRO Services, Inc.

Informatica Developer at Monterey CA - Contract

Reposted 3 Days Ago

Be an Early Applicant

Monterey, CA, USA

In-Office

Expert/Leader

Professional Services • Industrial • Manufacturing

The Role

Designs and develops ETL processes using Informatica to integrate data from Oracle, SQL Server, VSAM and sequential files into a data warehouse. Implements data cleansing, transformations, stored procedures, error logging, auditing and test plans. Manages development and testing tasks, performance tuning, and ensures lifecycle adherence and timelines.

Summary Generated by Built In

Company Description

E*Pro /Sensiple Consulting service offerings include contingent Staff Augmentation of IT professionals, Permanent Recruiting and Temp-to-Hire. In addition, our industry expertise and knowledge within financial services, Insurance, Telecom, Manufacturing, Technology, Media and Entertainment, Pharmaceutical, Health Care and service industries ensures our services are customized to meet specific needs. For more details please visit our website www.epro-tech.com.

Job Description

Title: Informatica Developer

Location: Monterey CA

Duration: Longterm Contract

Must:

· 10+ Informatica Experience

Functions:

· Manages development and testing tasks and ensuring adherence to previously agreed to timelines communicating status.

· Evaluates the integration a various data sources like Oracle, SQL server, VSAM and sequential files into staging area and recommends and/or implements efficiencies.

· Develops ETL processes using Informatica, ETL control tables, error logging, auditing, data quality, etc.

· Implements data cleanup procedures, transformations, scripts, stored procedures, and execution of test plans for loading the data successfully into the targets

Skills:

· Performance tuning and end-to-end lifecycle experience with Enterprise wide data warehouse.

· Strong Informatica technical knowledge in the areas on Informatica Designer Components -Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor.

· Good knowledge of analytical and logical conceptual level programming skills;

· Strong Oracle Database technical knowledge in the areas of general SQL and PL/SQL;

· Should have thorough understanding of Entire life cycle of Software and various Software Engineering Methodologies

Thanks
Lalitha T

Sr.IT Recruiter
SENSIPLE | E*PRO Technologies

Email: tlalitha @ epro-consulting.com

Additional Information

All your information will be kept confidential according to EEO guidelines.

Skills Required

10+ years Informatica experience
Hands-on ETL development using Informatica (mappings, mapplets, workflows)
Experience integrating data from Oracle, SQL Server, VSAM and sequential files
Strong Oracle Database knowledge including SQL and PL/SQL
Experience with ETL control tables, error logging, auditing and data quality processes
Performance tuning and end-to-end enterprise data warehouse lifecycle experience
Ability to implement data cleanup, transformations, scripts, stored procedures, and execute test plans
Thorough understanding of software development life cycle and methodologies
Analytical and logical conceptual programming skills

View all jobs at EPRO Services, Inc.

View EPRO Services, Inc. Profile

Report Job

Am I A Good Fit?

beta

Get Personalized Job Insights.

Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company

6 Employees

Year Founded: 2011

What We Do

EPRO Services, Inc. is a leading provider of superior waterproofing and contaminant protection systems designed to keep building structures dry and safe. Founded in 1993, the company specializes in building envelope protection, offering a comprehensive range of solutions including vapor intrusion mitigation, air barrier systems, and leak repair services for a variety of site conditions across the United States and Canada.