Senior Consultant, Informatica
Crossvale
full-time
Posted on:
Location Type: Remote
Location: Remote • 🇺🇸 United States
Visit company websiteJob Level
Senior
Tech Stack
ETLInformaticaOraclePostgresSQL
About the role
- Lead the design and implementation of Informatica‑based data integration, ETL/ELT, and data quality solutions.
- Analyze client requirements and translate them into scalable and maintainable technical designs.
- Configure, develop, and optimize mappings, workflows, and sessions in Informatica tools.
- Collaborate with architects, data engineers, and business stakeholders to define target data architectures and integration patterns.
- Support data migration initiatives, including source analysis, mapping, transformation rules, and validation.
- Implement and enforce best practices for performance tuning, error handling, and reusability in Informatica projects.
- Prepare technical documentation, solution designs, and deployment guides.
- Provide guidance, mentoring, and code reviews for junior consultants and developers.
- Participate in pre-sales activities: effort estimation, solution proposals, demos, and client workshops.
- Troubleshoot complex issues across environments (dev/test/prod) and ensure stable operations after go-live.
Requirements
- 5+ years of hands‑on experience with Informatica tools
- Strong SQL skills and experience with major relational databases (e.g., Oracle, SQL Server, PostgreSQL, DB2).
- Experience working in data warehousing, BI, or data migration projects.
- Good understanding of data integration patterns, data modeling concepts, and data quality principles.
- Experience working in client‑facing consulting roles, including workshops and stakeholder management.
- Strong problem‑solving skills and ability to work independently and in teams.
Benefits
- Competitive salary and OTE.
- 100% remote work with flexible schedules.
- 15 days PTO + 8 paid holidays.
- Company-paid life insurance, health, vision, and dental coverage.
- 401(k) with a 4% match contribution.
- Travel up to 20% as required for client engagements.
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
InformaticaETLELTSQLdata integrationdata qualitydata modelingperformance tuningdata migrationrelational databases
Soft skills
problem-solvingmentoringstakeholder managementcollaborationindependent workteamworkcommunicationguidance