A direct client of the A.C. Coy Company located in the South Hills area of Pittsburgh, Pa. is seeking an ETL Developer. The ETL/ODI Developer’s role is to strategically design, write, test and implement database extract, transform and load application software. This includes researching, designing, documenting, and modifying software specifications throughout the production life cycle. This individual must ensure high performing application code that enforces data integrity by applying ETL design best practices, query performance tuning and software error handling. S/he is also responsible for defining standards and compiling to existing standards in the development of both database applications and data integration efforts. Above all, this individual makes certain that the database design and coding solutions meet our business objectives while establishing and maintaining a high level of user trust and confidence. This individual must also demonstrate a willingness to work with and mentor associates of varying levels of technical expertise within the organization.
Provide first-level application support: Resolve problems and answer questions related to the database and layered products; contact vendor support when necessary; facilitate application development and customer problem resolution with optimum speed and efficiency.
Database application performance monitoring and tuning: monitor performance of application; identify problems and implement coding solutions.
Maintain data integrity via application coding standards and data validation.
Install and upgrade software on PC and server utilized to develop database programs, data extraction, transformation and load applications.
Provide database design: Research and recommend optimal table and index design criteria balancing scalability, data integrity and maintainability; publish entity relationship and data flow diagrams, design standards and work with development staff; standardize environment and improve efficiency.
Provide database development: Develop application code using database programming languages and scripting languages to support application releases; analyze business requirements for application releases and, based on findings, provide recommendations for solution and estimates of work.
Perform application refreshes on request: Plan and coordinate data refreshes at predefined times from one environment to another at the request of the application development staff.
Conduct research and make recommendations on new software products and new features available after software upgrades.
Develop utilities for automatically monitoring failures in data replication processes and data integrity.
The most pressing issue for businesses today is the quest for growth, and more than innovation, operations or even customer relationships, CEOs are looking for talent and leadership to secure and sustain it. People are truly an organization’s greatest asset.
With an active nationwide database of more than 500,000 seasoned professionals, A.C.Coy employs the latest tools to manage effective recruit...ing. The technology helps to quickly identify and contact the right candidates with the skills and experience clients need.
The tools that A.C.Coy uses provide a unique perspective regarding culture, performance, leadership, and team "fit". And our integration methodology ensures that new leaders are integrated quickly and successfully without breaking stride.