Sr. Informatica ETL Developer

Analysis, Analyst, Database, DB2, Developer, Development, HTTP, IBM, IMS, Informatica, Iterative, Linux, Manager, Oracle, PostgreSQL, Research, SalesForce, Security, Shell Scripting, SQL, SQL Server,
Contract Corp-To-Corp, Contract W2, C2H Corp-To-Corp, 12+Months
Telecommuting not available Travel not required

Job Description

Job Description

Please send resume at or at

Requisition ID: 


Job Title: 

Sr. Informatica ETL Developer 

Number of Openings: 


Job Category: 


Employment Type: 

C2C/ C2H

San Jose, CA 

Duties and Responsibilities: 

  • Based on assignment, requires the technical ability to work in at least one data discipline including data design, data movement, data infrastructure platforms, and data analytics
  • Provides data design/data movement services to help develop solutions that improve overall quality of data and support enterprise data strategies
  • Uses applied analytics to enable data driven decisions by applying innovative analytic techniques, and providing exploratory research and analysis
  • Develops data access related to storing, retrieving or acting on housed data
  • Ensures work and/or the work of their teams are in compliance with enterprise policies and policies and standards within their domain of expertise and area of responsibilities
  • Design and execute the policies, practices, and procedures that support data quality, data security, data governance, data standardization & integration
  • Translates functional and technical requirements into detailed design
  • Develops for technical data platforms such as DB2, SQL, IMS across multiple operating systems
  • Defines, designs, and documents conceptual and logical data models
  • Uses Informatica toolset to develop applications and deploy data integration/data quality applications
  • Tests data requirements for the movement, replication, synchronization and validation of data
  • Provides support for data movement solutions including extract, transformation, load (ETL)
  • Understands data infrastructure needed to support data services and automation
  • Proactively increase knowledge in the data industry, its related technologies and tools in order to work on a wide variety of assignments and products
  • Provides product and/or process subject matter expertise necessary to support design, development, testing and execution of technology solutions
  • Exhibits DevOps mindset where team is accountable for product from inception to sunset

Additional Details: 
  • Job may require travel via commercial transportation and/or driving motor vehicles
  • Job may require irregular work hours and travel outside normal business hours

The Automation Center of Excellence is looking for a highly motivated developer with a hacker mentality, focused on implementing new/innovative solutions for improving quality, speed & efficiency of IT. As an automation specialist, your daily job will be a combination of designing, building and maintaining automation solutions. You will get an opportunity to work with and learn on a variety of technologies and frameworks that are essentially boundless. 

Key Skills and Abilities: 

- Possesses advanced technical knowledge and skills developed through implementation and service experience with PowerCenter and Linux shell scripting. 

- Development experience with SQL development (DB2, Oracle or SQL). 

- Development experience with FTP technology. 

- Enjoys working with others one-on-one and in group settings, both face-to-face and virtually-leveraging technological capabilities.

- Serve as a mentor and coach to the developer community, fostering a deeper knowledge on industry best practice, standards, and new features of Informatica. 

- Strong written and oral communication skill. 

- The ability to demonstrate critical thinking to determine root cause analysis. 

- Provides technical direction for, and consults on, complex business problems. 

- Provide high level design solutions, problem resolution, long-term maintenance, and enhancement services. 

Additional Responsibilities: 

- Development experience with Developer/Analyst using profiling. 

- Understands best practices and integration patterns across multiple application environments. 

- Developed and teach the Informatica State Farm classes; Informatica @ State Farm; Informatica Profiling, Informatica Performance tuning and various developer forums. 

- Facilitate communication between the developer community and product support team as concerns or tool issues arise. 

- Provide guidance and best practices for testing data movement solutions. 

- Advanced problem determination and resolution of complex scenarios with our ETL developers related to Informatica, scripting, security, database query development, performance, issuance, etc. 

- Collaborate with the solution designers to create a data integration solution. Ensure data movement process design incorporates and adheres to the industry recommended data integration design patterns. 

- Author technical documents that support a self-service model for providing support of the product. 

- Serve as coaching resource to developer community by identifying and coordinating resolution for developer guidance and documentation gaps. 

- Provide Iterative design and/or reviews of the integration solution to arrive at the most optimized integration. 

- Identify reusability across projects by leveraging and customizing the data integration patterns and designing reusable framework. 

- State Farm vendor liaison with the Customer Satisfaction manager of Informatica. 

- Research new functionality within the product suite and promote effective usage of the Informatica tool by increasing understanding of functionality within the developer community. 

- Participate in various proof of concepts (POC) to determine the use of Informatica within State Farm. 

- Work with ETL developers on creating data maps in PowerExchange to interact with GDGs, PDS, and VSAM files on the IBM Mainframe. 

- SQL and database knowledge to extract or load data from a relational databases such as, Oracle, DB/2, PostgreSQL, and SQL Server. 

- Familiarity with additional different types of data stores (i.e. XML, Web services, Salesforce, JSON, CSV, VSAM, GDG and HTTP). 

Technical Skills: 

Informatica PowerCenter ( Extract Transformand Load (ETL) 

Informatica Developer 

Informatica Analyst (Profiling, ETL, Quality, Business Rules, Data Services) 

Shell Scripting, Data Integration (DB2, Oracle, SQL Services, Salesforce, XML, Mainframe, HTTP, SFTP, Web services) 



Dice Id : 10117771
Position Id : 6991
Have a Job? Post it