Healthcare Informatica/ETL Architect

$140,000 - $160,000

Full Time

  • Work from home


ETLINFORMATICAdata warehouseArchitechhealtcare

Job Description

ETL Architect /Lead with Healthcare Location: Boston , MA Duration : Fulltime
Who We Are!

ITC Infotech a wholly owned ITC ltd company is a leading global technology services and solutions provider, led by Business and Technology Consulting. ITC Infotech provides business-friendly solutions to help clients succeed and be future-ready, by seamlessly bringing together digital expertise, strong industry specic alliances and the unique ability to leverage deep domain expertise from ITC Group businesses. The company provides technology solutions and services to enterprises across industries such as Banking & Financial Services, Healthcare, Manufacturing, Consumer Goods, Retail, Travel and Hospitality, through a combination of traditional and newer business models, as a long-term sustainable partner.
Your X-Factor Work ethic - You are a consummate professional
Communication - You have excellent written and verbal communication skills for coordination across projects and teams.
Impact - You are a critical thinker with an emphasis on creativity and innovation.
Passion - You have the drive to succeed paired with a continuous hunger to learn.

ETL Architect with Health care experience:
  • Must have 13+ years of Informatica ETL architecture, design, DW, & end-to-end SDLC project implementation experience. You are expected to have solid experience with agile and waterfall project delivery.
  • Must have 5+ years of Implementation experience with Health Care domain
  • Must have solid experience with hospitals, health plans, claims process, members, healthcare data analysis skills, due diligence, System Design, Software development, Database management, Testing, & Production Support.
  • Extensive experience in INFORMATICA Architecture, Power exchange ETL, design, development, and CDC implementation
  • Must have the experience to work with customers for ETL requirements gathering, mapping, and translating the same with the rest of the team for delivery(must have on/offshore delivery management skills)
  • Must be able to review the low-level design, job sequence, schedules, and test results—guide team with test data and different test scenarios.
  • Stakeholder management and act as a single point of contact for business partners and the IT department.
  • Capable of preparing technical documentation, design specification, deployment and user guides, guide project plans, preparing RFP, Proposal activity, and status reports for clients/senior management and team members to ensure the project's efficiency and effectiveness.
  • Identify data quality issues and support data governance initiatives by leading necessary activities, including data profiling.
  • Complete understanding of the project from scratch and promptly communicate with the client on the current behavior for DWH.
  • Experience with queries, data warehouse architecture, data quality, and data profiling; strong understanding of database concepts such as referential integrity, indexes, and keys
  • Must be able to support production issues with RCA. Informatica Admin Tasks when required.
  • Analyze current issues, and lessons learned and come up with improvements/solutions (People, Process, and Technology)
Additional Responsibilities
  • We need to have a solid account overview and support account management
  • Handling the Onsite & Offshore Team, support billing, SOW, RFP, and new opportunities

*ITC Infotech (USA), Inc., considers all applications for employment without regard to race, color, creed, religion, sex, sexual orientation, national origin, age, handicap or disability, marital status, status as a Vietnam-era or special disabled veteran, or any other legally protected classifications in accordance with state, federal and local law.  The Company also provides “reasonable accommodations” to qualified individuals with disabilities, in accordance with the Americans with Disabilities Act and applicable state and local laws.*