ETL informatica developer (IDQ is must)

About Capgemini <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

With more than 170,000 people in over 40 countries, Capgemini is one of the world's foremost providers of consulting, technology and outsourcing services. The Group reported 2014 global revenues of EUR 10.5 billion. Together with its clients, Capgemini creates and delivers business and technology solutions that fit their needs and drive the results they want. A deeply multicultural organization, Capgemini has developed its own way of working, the Collaborative Business ExperienceTM, and draws on Rightshore®, its worldwide delivery model.

Learn more about us at http://www.capgemini.com/ .

 

Rightshore ® is a trademark belonging to Capgemini

Capgemini is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity/expression, age, religion, disability, sexual orientation, genetics, veteran status, marital status or any other characteristic protected by law.

 

ETL informatica developer (IDQ is must)

 

Duties & Responsibilities:

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;

Counsels team members on the evaluation of data using the Informatica Data Quality (IDQ) toolkit. Applies data analysis, data cleansing, data matching, exception handling, and reporting and monitoring capabilities of IDQ;

Performs technical walk-through as needed to communicate design/coded solution and to seek input from team members;

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.

Skill, Experience & General information Required:

 

experience at Enterprise-level ETL development and ETL architecture using Informatica and understanding the COBOL file structures;

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

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;

Good knowledge of Erwin model generation tools (logical and physical);

Data analysis, data mapping, data loading, and data validation;

Understand reusability, parameterization, workflow design, etc.;

Support other ETL developers; providing mentoring, technical assistance, troubleshooting and alternative development solutions;

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

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

 

Location : San Ramon, California