Senior Informatica Developer

PEOPLECORP AMERICA; Austin (TX); On-site; USD 100,000 - 130,000; Full time

Job summary

A leading company is seeking a Senior Informatica Developer to enhance their data transformation processes. The role requires extensive experience in ETL automation, SQL script development, and collaboration within agile teams. Candidates must possess strong technical skills and a bachelor's degree in a relevant field, as well as the ability to manage multiple projects effectively.

Qualifications

• 10+ years developing ETL mappings with Informatica Power Center.
• 5+ years acquiring and integrating data from Oracle, SQL Server, Excel.
• 5+ years designing efficient Oracle SQL scripts.

Responsibilities

• Data acquisition for multiple uses and automation with Informatica.
• Develop complex SQL scripts for dimensional modeling.
• Collaborate on data design and implementation.

Skills

Informatica Power Center

SQL

Data Analytics

Data Integration

Communication

Technical Writing

Education

Bachelor’s degree in Computer Science

Tools

Visio

Erwin

JIRA

Tableau

HTML/CSS

Job description

Job Description:

Our Direct Client is seeking an experienced, full-time, dedicated Candidate, with skills and expertise as described in the requirement below.

Responsibilities:

Client is looking for an experienced Senior Informatica Developer who will be part of a development effort utilizing an agile methodology currently in use at the client's system. Responsibilities include:

1. Data acquisition from various sources for multiple uses.
2. Developing complex SQL scripts to transform source data into a dimensional model, creating views and materialized views in Oracle.
3. Developing automation with Informatica Power Center to extract and transform data from external sources.
4. Collaborating with the Data Engineering Team on data design and implementation.
5. Verifying and validating SQL scripts, Informatica automation, and database views.
6. Creating automated verification and validation processes.
7. Participating in all sprint ceremonies.
8. Working with Architects and Data Engineering Team on implementation strategies.
9. Enhancing and maintaining Java-based Tableau dashboards.
10. Developing mockups and validating with customers.
11. Addressing technical issues collaboratively.
12. Assisting with tool implementation and configuration.
13. Producing technical documentation as needed for DD&I efforts.
14. Participating in requirements and design sessions.
15. Interpreting business requirements and proposing enhancements.
16. Performing other duties as assigned.

Skills Required / Desired:

• 10+ years developing mappings and workflows for ETL automation using Informatica Power Center.
• 5+ years acquiring and integrating data from sources like Oracle, SQL Server, Excel, Access for Tableau visualization.
• 5+ years designing efficient Oracle SQL scripts.
• 5+ years as a system analyst in data analytics or warehousing projects.
• Technical writing and diagramming skills, proficiency with modeling tools (Visio, Erwin) and MS Office.
• 4+ years planning and delivering software platforms used organizationally.
• 4+ years on an agile sprint team.
• Proven ability to write efficient, testable code following best practices.
• Understanding security principles related to healthcare data.
• Experience with software components for performance metrics and BI environments.
• Excellent communication skills.
• Ability to manage multiple responsibilities effectively.
• Bachelor’s degree in Computer Science, Information Systems, or related field, or equivalent experience.

Preferred Skills:

• Experience scripting with Python.
• Healthcare industry experience.
• Experience with JIRA, government agencies, PII/PHI data, HL7 data.
• Web development skills using HTML/CSS.
• Knowledge of Web Services (REST, SOAP).
• Experience creating dashboards with Tableau.

Location: 800 Corporate Drive, Suite 301-500, Stafford, VA, 22554

Phone: [phone] | Fax: [phone]