ETL Developer Job in Baltimore, Maryland US

ETL Developer

The ETL Developer is responsible for programming, debugging and testing of ETL-based internet applications in an ETL development environment, and generally responsible for database design and system testing. The Developer usually works with minimum supervision, conferring with their Technical Lead on unusual matters. An ETL Developer possesses and applies a broad knowledge of the principles, practices, and procedures related to data security to the completion of moderately difficult assignments. Essential Job Functions Reviews ETL mappings, workflows, etc for compliance to CMS standards. On-call operational support for production systems. Performance tuning of ETL transformations and workflows. Provides support for, and automation of, routine Informatica procedures. Tool configuration and maintenance for server and desktop. Management and maintenance of Informatica software releases. Codes, tests, debugs, implements, and documents highly complex programs. Develops complex test plans to verify logic of new or modified programs. Designs systems and programs to meet highly complex business needs. Prepares detailed specifications from which programs are developed and coded. Creates appropriate documentation in work assignments such as program code, and technical documentation. Gathers information from existing systems, analyzes program and time requirements. Prepares time estimates and justifications for assigned tasks and provides recommendations to project managers. Supports project personnel in resolving fairly complex program problems. Works with client and management to resolve issues and validate programming requirements within their areas of responsibility. Provides technical advice on complex programming. May serve as technical project lead; provides leadership and work guidance to less experienced personnel. Conducts quality assurance activities such as peer reviews. Provides consulting services in a technical and/or managerial capacity to management and technical staff. May represent company in presentations or conferences involving customers, co-contractors, suppliers, competitors, academia or the public. Qualifications Basic Qualifications Bachelor's degree or equivalent combination of education and experience Bachelors degree in computer science, mathematics or related field preferred Nine or more years of programming or testing experience Experience working with appropriate programming languages, operating systems and software Experience working with relational databases to facilitate programming software Other Qualifications Strong skills in programming - ETL development with experience using advanced object-oriented design (OOD) tools and software 3+ years using Informatica software, including 1+ years administrative support and 2+ years developing ETL routines 2+ years experience in administration of Cognos, Microstrategy, Business Objects, or SAS Experience with Oracle 9i or higher Experience with troubleshooting the DB2Connect gateway product for DB2 Experience with troubleshooting Connect Direct for the mainframe Experience with troubleshooting ODBC problems for Windows 2000 desktop and server environments Experience creating and providing design artifacts for technical reviews of business intelligence application and models Demonstrate prior experience with other large/government agencies through a portfolio of experiences and references to those clients Strong personal computer and business solutions software skills Strong analytical and problem solving skills for design, creation and testing of programs Good interpersonal skills to interact with customers and team members Good communication skills to work effectively with team members, support personnel, and clients Good leadership skills to guide and mentor the work of less experienced personnel Ability to work as part of team and independently