ETL Data Integration Developer III

• Responsible for the operational support of Informatica environment including but not limited to automation, job scheduling, dependencies, monitoring, maintenance, patches, upgrades, security, and administration
• Administers systems performance including on-going optimization and tuning of Informatica environment
• Supports and enhances existing Informatica environment and develops new, complex ETL processes to support additional design, development and deployment of the Enterprise Data Warehouse, and Data Marts
• Assists data warehouse team in completing current data warehouse initiative projects
• Analyzes and evaluates data sources
• Designs and implements complex ETL processes
• Applies subject expertise in evaluating business operations and processes
• Identifies areas where technical solutions would improve business performance
• Consults across business operations, providing mentorship, and contributing specialized knowledge
• Ensures that the facts and details are correct so that the project’s/program's deliverable meets the needs of the department, organization and legislation's policies, standards, and best practices
• Provides training, recommends process improvements, and mentors junior level staff, department interns, etc. as needed
• Performs other duties as assigned

• Bachelor's Degree in Statistics or Related Field
• 5 years of experience in Informatica ETL Developer role in Data Warehouse projects, Enterprise Data Warehouse, Online Analytical Processing (OLAP) and dimensional data modeling
• At least 3 years of proven development experience in design and development of ETL/Data Integration and Informatica Power Center Suite
• Experience with Erwin data modeling toolset
• Experience working in a PL-SQL environment
• Expert in database concepts, logical/physical design and development
• Strong experience and comprehensive proficiency with Informatica in an Oracle Data Warehouse/BI environment
• Experience in documenting requirements and negotiating commitments
• Strong project life cycle experience
• Strong database development skills including the ability to analyze, create and optimize complex SQL queries and stored procedures, working on relational databases especially Oracle & MS SQL Server
• Proficient in data analysis and problem solving
• Possess excellent communication skills, both written and verbal
• Thorough knowledge of Systems Development Life Cycle (SDLC)
• Must develop, foster and maintain an open, professional relationship with IT staff, management and business customers
• Excellent verbal and written communication skills
• Strong organizational and documentation skills
• Strong Understanding of DW/BI concepts
• Good knowledge of Software Development Lifecycle
• Understanding of development lifecycle methodology and ability to successfully deliver Informatica assignments
• Healthcare domain
• Proven ability to perform technology needs assessment and evaluate solution options
• The capability of performing interface analysis at the detail level
• A solid understanding of software development life cycle
• and broad-based knowledge of application systems technologies

Master's Degree in Statistics

• Paid Time Off (PTO)
• Tuition Reimbursement
• Retirement Plans
• Medical, Dental and Vision
• Wellness Program
• Volunteer Time Off (VTO)