The Sr Data Warehouse Developer will provide design and development support for the Warehouse Analytical Reporting System (WARS). Position involves implementing complex ETL code, creating and executing test plans and performing data analysis to gain an understating of how the enterprise uses the data. It includes providing day-to-day support for operational data warehouse environment plus providing resource estimates, and tracking status within the project. Successful candidates must complete required design deliverables to meet the business requirements and communicate project/issue status in a reliable and accurate manner through appropriate tools and processes. Also requires ensuring compliance with standard software development practices, processes and enterprise standards as well as working within IT team to follow the full lifecycle development process working with project management, QA, development and technical operations.
Roles and Responsibilities:
* Database analysis and design using Oracle Designer
* Identification of primary, foreign, unique and check key constraints on tables
* Creation or alteration of database tables, constraints, indexes, triggers, sequences, views, roles, synonyms and database links
* Creation and modification of PL/SQL procedures and SQL scripts
* Maintenance of database data integrity
* Performance tuning of SQL statements, including utilization of explain plans
* Utilize Toad and SQL Plus for data analysis
* Actively participate in relational and star schema table design sessions and technical meetings to consult and affirm approach to satisfy user requirements
* Create, modify, test and document ETL mappings, transformations and workflows utilizing Informatica software
* Create and modify UNIX shell scripts
* Design, develop, test, document and deploy standard and recurring summary, analytical, Corporate, & Executive Business Objects reports to include tabular, drilling, and charting techniques and to support business and financial communities.
* Develop Business Objects dashboards and cockpits, utilizing interactive metric trends, gauges, charts and speedometers to assist in providing barrier analysis to business and financial communities.
* Modify joins and contexts as necessary to maintain the validity and integrity of more than fifty Business Objects universes and hundreds of reports
Minimum Qualifications:
To be considered for this position, you must minimally meet the knowledge, skills, and abilities listed below:
* High School diploma
* 10 years relevant experience.
* 5 + years strong Oracle database experience including SQL, PL/SQL, and database design in a data warehouse environment.
* Experience in tuning complex SQL
* 5+ years experience in Data Warehouse development tools including ETL.
* Solid demonstrated experience with Informatica and Business Objects.
* Experience with TOAD and/or SQL Plus
* Must be able to obtain and maintain SECRET clearance (interim to start).
* US Citizenship required.
Preferred Qualifications:
Candidates with these desired skills will be given preferential consideration:
* Bachelors degree in Computer Science, Math, Statistics or Engineering.
* 7 years of relevant experience.
* Experience with Unix shell scripts.
More... |