• ETL Developer Analyst II

    Posted Date 3 weeks ago(2/26/2019 10:28 AM)
    Requisition ID
    Position Type
    Temporary Full-Time
    Job Locations
  • About Us

    PCM is one of the fastest-growing value added direct marketers of technology solutions for business, government and educational institutions as well as consumers. We’ve built an environment that is fast-paced, growing and continually changing with the needs of industry. Our rapid growth and expansion has created numerous career and advancement opportunities. 


    Providing IT solutions nationally since 1987, PCM, Inc. is an industry recognized, publicly traded, value-added direct marketer of technology products, services and solutions to businesses, government, education, and individual consumers. Fully accredited and authorized by major manufacturers including HP, Apple, Cisco, Microsoft, Dell, and 1500 others, PCM offers product and service solutions through field sales, call center, and eCommerce venues. With annual sales of $1.5B+ , 3000 employees and over 400,000 products available, PCM delights in serving small, medium and enterprise level businesses. 


    PCM is an exciting and rewarding place to work.




    ETL Informatica Programmer Analyst II


    PCM is in search of an ETL Programmer Analyst for a contract to hire opportunity with client in Mechanicsburg, PA. We are looking to fill this position immediately.


    Under the direction of the Director of IT, the Programmer Analyst II is responsible for application development in a team environment.


    • Read, validate, and process files provided by outside entities
    • Generate data and corresponding output files
    • Provide results reports, which keep our business, informed about the success or failure of the file exchanges.
    • Take direction from Senior team members
    • Code, Debug and Test
    • Implement enhancements, new features and on going maintenance to the current system
    • Maintain a positive attitude
    • Other duties as assigned




    • Strong SQL development capabilities – familiar with DB2 databases is preferred but not required
    • Understanding of data warehouse star schema concepts
    • Prior experience using an ETL tool like Pentaho Kettle or Informatica
    • Prior experience developing stored procedures
    • Interest in working with file import/export and data transformation
    • Self Starter With a Positive Attitude

    (*no sponorship provided on this position)



    Why work for Us?

    PCM Offers:

    We offer an environment for career-driven individuals seeking to make a solid contribution to our company objectives and their own career enhancement. If you want to work in a challenging, performance-based environment and be rewarded for your efforts, then PCM is the place to build your career.



    PCM is more than an IT provider: we are a trusted technology partner for thousands of businesses across the country specializing in cloud, data center, mobility, networking, security, and software solutions.

    PCM: The right technology, delivered! 


    We are an equal employment opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, national origin, disability status, protected veteran status or any other characteristic protected by law.


    Disclaimer: PCM extends offers of employment only to qualified candidates who have applied for a position using our official application through our career site, iCims.  Please be on alert for possible fraudulent offers of employment or "phishing" actions that may come from individuals or entities impersonating PCM.  PCM will not solicit money or banking information from applicants.  Once employment has been confirmed and as part of the onboarding process, new hires will receive instructions from PCM to set up their direct deposit information from our payroll department.


    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed

    Connect With Us!

    Not ready to apply? Connect with us for general consideration.