Job Title: ETL Informatica PowerCenter consultant
Location: Texas Only – Local Candidates Required
Interview type : Onsite F2F interview required
Requirement | Mandatory |
Local to Texas | ✔ Required |
Face-to-face interview | ✔ Required |
Healthcare experience | ✔ Required |
State/government client experience | ✔ Required |
Visa Copy | ✔ Required |
Job Description:
8+ | ETL development using Informatica PowerCenter or IICS |
8+ | Data acquisition/integration across Oracle, SQL Server, Excel, Access, PDF |
8+ | Complex SQL (Oracle and/or Snowflake) development |
Systems analysis experience in analytics, PM systems, or data warehouse | |
Technical writing, diagramming, and modeling tools (Visio, ERWin, MS Office, MS Project) | |
Experience delivering platforms across multiple business units | |
Responsibilities:
· Serve as technical lead on data integration projects within an agile delivery model.
· Develop and automate ETL workflows and mappings using Informatica PowerCenter and/or IICS.
· Acquire data from various source systems including: Oracle, SQL Server, Excel, Access, PDF, external datasets, and cloud sources.
· Develop and optimize complex SQL scripts for Oracle and/or Snowflake, including views and materialized views.
· Validate and test ETL workflows, database logic, and automation scripts.
· Create automated testing and validation solutions for data pipelines.
· Participate in Agile ceremonies including sprint planning, daily stand-ups, and retrospectives.
· Collaborate closely with architects, data engineers, and business users to align technical solutions with requirements.
· Prepare technical documentation, design diagrams, and system specifications.
· Assist in deployment and configuration of development tools and environments.
· Support internal and external product consumers and stakeholders.
· Maintain compliance with data governance and security requirements including PII/PHI handling.
Thanks & Regards,
Harshith Reddy
Talent Acquisition Specialist
Email: harshithb@usmsystems.com
Connect me on LinkedIn If I missed your call : linkedin.com/in/harshith-reddy-bachupally-445599235
