SSIS ETL Lead / 3228 Job in White Plains 10601, New York US
Position Description
SSIS ETL Lead / 3228
Position Description:
At APS Healthcare, we are passionate about changing behaviors of all constituents in the healthcare system to improve health, optimize clinical quality, and reduce associated costs. Our mission, quite simply, is to improve the health of those we serve. Our Corporate IT team is essential to support this mission. Care to join this exciting team?
We are looking for a Sr. ETL Developer who will be a team player to work alongside and mentor junior/mid developers to provide complex program design, coding, testing, documentation, development, and maintenance for healthcare related software programs.
The Sr. ETL Developer will assist with the creation and maintenance of entire information systems and individual programs to meet the users evolving needs. Possess great attention to detail while also being flexible to adapt to a dynamic environment and changing priorities. Performs original program creation as well as the ability to troubleshoot and problem solve existing programs. Takes ownership of their work adhering to HIPAA regulations and strives to promote exceptional work ethics. Expected to maintain and adhere to company-wide and departmental polices, standards, and operational guidelines. Occasionally interacts with various Operations personnel and IT development staff to determine user requirements for software maintenance.
Responsibilities include:
• Knowledge of the Informatica platform and the Informatica PowerCenter data integration platform is critical.
• Ability to interpret a variety of instructions provided in written, oral, diagram, or schedule form including the aptitude to take non-technical requirements and convert them into technical requirements
• Works effectively under broad, general direction and ability to take initiative and work with minimal supervision
• Research and document user requirements and system specifications
• Occasionally work in coordination with Analysts on larger projects
• Design and develop complex program logic addressing specific programming needs
• Mentor and provide technical guidance to fellow engineers with the appropriate techniques required to fulfill project assignments
• Maintain, adapt, and update existing systems to meet user requirements and to enhance program efficiency
• Prepare specifications and programs of a highly technical or complex nature
• Automate new and/or existing procedures as assigned
• Experience with creation and testing of code and libraries to implement functionality
• Translate business requirements and functional specifications into detailed system and program design specifications
• Undertake program design activities including definition of data and error message arrangements
• Modify and document new and existing program code to correct errors or to enhance a program's capabilities
• Create/Troubleshoot program code for the existing applications using APS selected software development tools
• Analyze objectives and problems specified by analysts and/or designers
• Test programs, new and existing, to insure they perform as expected
• Proficient at preparing lifecycle documentation for newly created and existing software programs including changes that reflect new user requirements and error corrections/bugs discovered after testing phase
• Complete programming assignments in a timely manner
• Analyze proposed changes at a system level and recommend designs and solutions that minimize impact to interfacing systems while maximizing code re-usability and maintaining business value
• Prepare reports on the status, operation, and maintenance of system software for use by computer equipment suppliers, systems designers, other programmers and computer operators
• Utilize strong product knowledge to analyze new product requirements and coordinate the activities of the development team
• Ensure programming and testing activities are conducted per APS Healthcare, Inc. software development process methodology
• Demonstrate expertise in a variety of the field concepts, practices, and procedures that rely on extensive experience and judgment to plan and accomplish goals
• Preferred experience in Healthcare, specifically including Enrollment and Claims
Required Skills:
• 7+ years' experience with Informatica
• 7+ years' experience developing medium to large complexity Data Warehouse solutions
• 5+ years ETL experience pulling information from MS SQL Server
• 5+ years Advanced SQL coding skills required
• 5+ years Strong SQL and Analytical skills are required
• 5+ years experience with Microsoft SQL Server DTS/SSIS platforms
• 5+ years Programming skills in MS stored procedures
• Strong background and passion for data quality and data governance
• Solid understanding of both transactional and relational databases
• Experience working with Healthcare data is a must
• Experienced in Erwin or similar data modeling tool
• Experience with database tuning and performance.
APS Healthcare is an Equal Opportunity Employer and participates in the E-Verify program.