About Us: Keynetx, Inc. is an established, trusted provider of solutions for the business and technological challenges that companies from a variety of industries face. Keynetx custom tailors its plans to each client - this means that Keynetx solutions are structured to be highly effective within the boundaries of set budgets and deadlines. This Keynetx customer-focused approach ensures high quality, cost-effective services including information technology (IT) system analysis, strategy, development, implementation, and maintenance; infrastructure services; enterprise application services; data analysis and reporting; and IT staffing and outsourcing. Keynetx prides itself on being more than just another IT services company. Keynetx is staffed with technology specialists, each with at least five years of IT experience who are skilled in their field and professional in demeanor.
Job Description:
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