SQL Developer - SSIS

company banner
APN Software Services, Inc
SQL; ETL; SSIS
Full Time, Contract Independent, Contract W2, C2H Independent, C2H W2
Depends On Experience
Telecommuting not available Travel not required

Job Description

SQL Developer III

Alpharetta GA

8 months extendable contract

 

Seeking candidates with at 8-10 years’ experience and strong in the development of SSIS Packages

All candidates must be available to interview in person within 24 - 48 hours of the request, there can be no exceptions

 

Job Description

This job is responsible for providing data analysis and data sourcing design and implementation of data sourcing/integration into the reporting databases from various data sources.

This job will primarily focus on developing interfaces to collect data from various internal systems that will include master data and transactional data, design & develop reliable/accurate/robust processes to share/exchange data with external vendor solutions.

 

The role includes:

• Ensuring data integration/ETL is implemented & monitored successfully, to enable data quality, availability, data freshness and performance requirements to support reporting

• Monitoring daily/other database jobs and data loads and proactive resolution of issues to ensure maximum uptime/availability of database for reporting

• Support in designing & developing the databases and data sourcing/ETL requirements for efficient use in reporting and BI

 

This may involve working with Philips internal business process owners, business SME's (i.e. subject matter experts) and IT teams to manage data loads or other database activities, analysis of the reporting/ business intelligence tools to ensure optimal use of database and external vendors/solution providers for integration of data to and from Philips systems .

This position requires little supervision and participates in team strategizing, and vision execution/ implementation of the reporting & BI strategies supporting from a database stand point, collaborates with other team members/BAs in supporting shared/common reporting needs and projects.

 

ETL Design & Implementation –80% of time includes the following activities:

• Implement, maintain and enhance ETL solution fulfilling data quality, availability, data freshness and performance requirements, working with the business analysts to understand the business requirements to be fulfilled by the data, assessing requirements for completeness and accuracy.

• Develop methods for integrating different data sources so they work properly together, such as customizing standard source system/product databases to fit specific needs. Analyze and interpret all complex data on target system and analyze and provide resolutions to all data issues and coordinate with analysts to validate all requirements.

• Design & develop reliable, accurate and robust processes to share/exchange data with external vendor solutions on a near real time and/or batch basis. Ensure all data is transferred and imported successfully into the vendor solution and outputs imported successfully and completely into relevant Philips systems.

• Perform tests and validate all data flows and prepare all ETL processes according to business requirements and incorporate all business requirements into all design specifications. Perform root cause analysis on all processes and resolve all production issues and validate all data and perform routine tests on databases and provide support to all ETL applications.

• Monitor all business requirements and validate all designs and schedule all ETL processes and prepare documents for all data flow diagrams, technical and system specifications documents for all ETL processes.

 

Support Database Design, Management– 20% of time includes the following activities:

• Support design & development of dimensional and normalized data models describing data elements and how they are used, following standard data modeling practices for a Data Warehousing and Business Intelligence platform. Write and code logical and physical database descriptions and specify identifiers of database creating a data dictionary.

• Analyze, consolidate and tune database for optimal efficiency, monitor systems and platforms for availability, Monitor database jobs for timely and accurate completion, and monitor capacity and performance of database and jobs for effective uptime and response time to the consumers of the data.

• Work as part of a project team to coordinate database development and determine project scope and limitations. Review project requests describing database user needs to estimate time required to accomplish project.

 

Thanks and Regards,

Imran (EMU) Shikalgar

APN Software Services, Inc

39899 Balentine Drive, Suite 385, Newark, CA 94560

Phone: 510-402-4704 Fax 510-623-5055

Imran@apninc.com (Google Hangouts)

Posted By

Imran Shikalgar

Contact


Company Information

At APN we strive to be the best in the industry. We enjoy a challenge, embrace competition and we are committed to providing the finest services to our clients. We are a close-knit team of high-tech professionals. We place strong emphasis on continuing education for our consultants, and we sponsor various training programs, which relate to consultant's growth, client projects and current technology requirements. In addition to competitive pay, APN Software Services Inc. provides free career advice, resume counseling, interview assistance and much more!
Dice Id : apn
Position Id : 184274

Similar Positions at APN Software Services, Inc

Software Developer - Java
  • Pittsburgh, PA
  • 22 hours ago
Software Engineer
  • Blue Bell, PA
  • 5 days ago
Software Engineer
  • Sunnyvale, CA
  • 5 days ago