Database / Report Developer

Company Name:
The Bowdoin Group
Company Description:
This company is a non-profit organization that owns several hospitals including community and specialty hospitals, a managed care organization, a physician network, community health centers, home care and other health-related entities. In addition to being one of Boston's best companies to work for, they are also a national leader in biomedical research.
Job Description:
This position requires a highly motivated, energetic, and positive person who will help remediate the clinical data warehouse as part of the organization's Healthcare Enterprise Solution implementation. Incumbent will work as part of a team remediating the clinical, operational and financial data warehouse for the implementation.
The incumbent will work under the guidance of the analytics team as an individual contributor and as part of a team. This position will supplement the internal data warehousing team and will be responsible for developing Informatica code to move and source files to remediate current data warehouse targets and create new ones where appropriate.
Responsibilities include creating Informatica code and modules, interpreting and adhering to specifications, working in a team development environment, leveraging best practices, elegantly handling errors and ensuring on time delivery of code.
Principal Duties and Responsibilities
Functioning as part of a broader team to remediate Enterprise Data Warehouse
Critically evaluate information gathered from multiple sources, reconcile conflicts, and decompose high-level information into details
Ensures that development solutions meet defined technical, functional, and service level ?requirements and standards
Provides consistent quality in handoffs between development to deployment and ?operations while incorporating continuous process improvement and feedback
Develop and Performance-tune ETL(Informatica) packages to extract, transform and load source to target stores
Execute unit testing of ETL(Informatica) packages
Participates in meetings, gathering requirements, discussing the issues to be resolved
Acquire in depth impact analysis for projects assigned
Gathers Requirements and models stage and dimensions in the database environment
Proactively communicate and collaborate with internal customers to analyze information needs and requirements and raise any blockers or concerns to project manager
Work with project team and management to identify and document benefits, costs and risks associated with solution alternatives, while balancing stakeholder expectations regarding project timeline, cost, and scope.
Develop test strategies and plans and works with technical team to conduct system tests
Has responsibility for the security of medical and financial confidential information
Communicate project status and prepare project administrative materials as needed
Provide quality customer service and serve as an exemplary representative of Information Systems. On-going communication, feedback and follow-through with customers/peers are essential.
Proven track record, and have prior experience working in a complex systems environment
Strong communication skills and proven ability to work with hospital staff at all levels
Ability to multi-task and manage competing demands to successful completion
Three years of experience in ETL methodology for supporting Data Extraction, Transformations and Loading with Informatica PowerCenter in an enterprise team development environment
Experience in source systems analysis and data extraction from sources including flat files and databases
Experience in optimizing data loads
Performance Tuning for ETL processes
Proficiency with Informatica workflow manager, workflow monitor, server manager
Creating, scheduling and controlling workflows, tasks, and sessions
Experience in shell scripting and automation of ETL processes
Hands on experience in design of Data Warehouse/Data Mart, Star Schema, Snowflake Schema, ODS, ETL process
Experience in coding using SQL, Procedures/Functions, triggers and Packages
Team player, ability to work individually and meet tight deadlines
Informatica 9.x/8.x/7.x/6.x PowerCenter, WorkFlow Manager, WorkFlow Monitor, Designer, Server Manager, Repository Manager
Oracle and SQL Server databases
Shell Scripts, SQL, PL/SQL
Oracle Designer, Reports, TOAD 10/9/8.x/7.x, SQL Loader, Erwin, PVCS VM and PVCS Tracker, DBVisualizer
Windows and Sun operating systems
Strong experience with relational database management systems (RDBMS), and an understanding of relational database design
Knowledge of PC applications, e.g., Microsoft Office Suite and Project, PowerPoint
Ability to be flexible, versatile and adaptable both in day-to-day activities conducted in a multi-site environment

Don't Be Fooled

The fraudster will send a check to the victim who has accepted a job. The check can be for multiple reasons such as signing bonus, supplies, etc. The victim will be instructed to deposit the check and use the money for any of these reasons and then instructed to send the remaining funds to the fraudster. The check will bounce and the victim is left responsible.