Posted in Other 2 days ago.
Type: Full Time
NTT DATA's Client is currently seeking a Informatica Developer with 5+ years of experience in Informatica to join their team in Roseville, California (US-CA), United States (US).
The Informatice Developer will:
Participate in ETL Design of new or changing mappings and workflows with the team and prepares technical specifications.
Create ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter and prepare relevant documentation.
Design and build integrations supporting standard data warehousing objects (type-2 dimensions, aggregations, star schema, etc.).
Perform source system analysis as required.
Work with DBAs and Data Architects to plan and implement appropriate data partitioning strategy in Enterprise Data Warehouse.
Implement versioning of the ETL repository and supporting code as necessary.
Develop stored procedures, database triggers and SQL queries where needed.
Implements best practices and tunes SQL code for optimization
Basic Qualifications: (what are the skills required to this job with minimum years of experience on each)
Minimum 5+ years of experience in Informatica
Minimum 3 years of experience interacting with Oracle database
Degree: Bachelors in Computer Science or equivalent work experience
The Company is an equal opportunity employer and makes employment decisions on the basis of merit and business needs. The Company will consider all qualified applicants for employment without regard to race, color, religious creed, citizenship, national origin, ancestry, age, sex, sexual orientation, genetic information, physical or mental disability, veteran or marital status, or any other class protected by law. To comply with applicable laws ensuring equal employment opportunities to qualified individuals with a disability, the Company will make reasonable accommodations for the known physical or mental limitations of an otherwise qualified individual with a disability who is an applicant or an employee unless undue hardship to the Company would result.