ETL Developer
Primary Location – Baltimore, MD V-Soft Consulting is an end-to-end recruiting and staffing solution provider known for our ability to provide highly qualified consultants for any project at any scale. What makes us different? Our expertise is derived from over 20 years of delivering world-class IT staffing, consulting, engineering and managed services to Fortune 1000 and mid-market companies in the U.S., Canada, and Asia. V-Soft is a trusted partner with experience across diverse technology stacks to help business get IT done. Like what you hear? Apply with V-Soft today! V-Soft Consulting is currently hiring for an ETL Developer for our premier client in Baltimore, MD. This is a 3-year contract position in the health insurance industry. WHAT YOU’LL NEED: Education and Experience » - A Bachelor’s Degree from an accredited college or university in Engineering, Computer Science, Information Systems, Business or other related Discipline
- A Master’s Degree is preferred
- A minimum 8 years’ experience developing, maintaining and enhancing Informatica mappings, workflows and processes is preferred
- A minimum 6 years’ experience in enterprise application analysis and development
- A minimum 4 years’ hands-on experience in ETL design, development, performance tuning, monitoring and supporting using Informatica
- A minimum 4 years’ experience architecting ETL solutions and data conversion strategies of disparate systems and creating data mapping and modeling for data migrations is preferred
- A minimum 4 years’ hands-on experience using Informatica PowerCenter (6 years preferred)
- A minimum 4 years’ experience as a database developer utilizing SQL
- A minimum 2 years’ hands-on experience creating complex and efficient SQL queries, stored procedures, triggers and
- functions (4 years preferred)
- A minimum 2 years’ hands-on experience in ETL platform administration and integration for performance monitoring and analysis
- A minimum 2 years’ ETL related experience in HealthCare EDI or Health and Human Services applications is preferred
- Experience establishing and maintaining reporting databases and data warehouses
- Experience with the State Based Marketplace solutions in Healthcare IT or Health and Human Services domains is preferred
- Experience analyzing, converting and transforming EDI transaction sets, such as the 834 and 999, IRS datasets such as the H36, H41, 1095-A, 1095-B and SBMI is preferred
- Experience in quality assurance, quality control and compliance processes of large scale Healthcare IT Systems is preferred
- Experience working with the Project Management Office (PMO) processes, policies and procedures is preferred
Knowledge, Skills and Abilities » - Knowledge in the Affordable Care Act (ACA) eligibility rules is preferred
- Demonstrated ability to manage multiple critical priorities and tight deadlines
- Demonstrated analytical and problem solving skills
WHAT YOU’LL DO: Job Responsibilities » - Design, develop, automate, support and monitor performance tuning using Informatica
- Develop stored procedures, triggers and functions in SQL in PostgreSQL or other databases
- Architect Extract, Transform and Load (ETL) solutions and data conversion strategies for integrating disparate systems
- Create data mapping and modelling for data migrations
- Create end-to-end solution for ETL transformation jobs that involve writing Informatica workflows and mappings, SQL procedures and functions
- Develop, maintain, and enhance Informatica Mappings, Work-flows and processes
|
