Computer Aid, Inc.

  • Informatica Developer

    Location US-PA-Camp Hill
    Employment Type
  • Position Description/Responsibilities (CCC/Vendor)

    Location: Harrisburgh

    Duration: 6-12 mos (likely to go long term).



    Informatica Developer:


    Strong Informatica and SQL skill set required.

    Position typically requires 2-5 years of programming and related experience as outlined above

    Design, develop, and support ETL processes using Informatica and SSIS (SQL Server Integration Services) tools.

    Review and analyze business data requirements for data warehousing projects, applications, and Business Intelligence (BI) and Business Objects (BO) Reporting Systems. Review and analyze Extract, Transform, and Load (ETL) requirements for database, application, and reporting projects.


    Responsible for analysis, design, programming, testing and implementation for new and existing business application software, and production support for systems with medium complexity. 


    The incumbent must be capable of working at a broad technical level in all phases of the application systems project life-cycle, and must be able to apply business knowledge and technical skills to systems developmen




    • Review and understand business data related ETL requirements for database, application and reporting projects.
    • Develop and make enhancement on new and existing data systems.
    • Participate in the development plans and resource estimation for task planning.
    • Assist with the development of logical data models.
    • Provide Production Support for Production applications.
    • Monitor production jobs and resolve any issues in a timely manner.
    • Partner with other IT areas in resolving issues and improving processes
    • Develop Informatica or SSIS ETL Workflows.
    • Develop ETL code both in Informatica and at the shell script level.


    Skills and Knowledge:

    • Excellent Customer Relations – forms productive relationships with customers and development teams.
    • Excellent writing and communication skills.
    • Excellent analytical skills.




    Strong knowledge of ETL concepts especially as applied to Informatica and SSIS.

    Strong knowledge of data analysis, data transformation, conceptual data modeling, data transformation and metadata management.

    Strong knowledge of data design for various applications.

    Strong knowledge of SQL.

    Good knowledge of various RDBMS, Mainframe

    Good knowledge of Project Life Cycles methodologies.

    Strong verbal and written communication skills.

    Strong knowledge of Unix and Unix Shell scripting

    Experience with Enterprise Scheduling tools such as Control-M is a plus



    Position Requirements/Technical Skills (CCC/Vendor)

    Looking for a developer with SQL, Informatica, Mainframe and COBOL skill sets.


    Company Overview (CCC Only)


    Computer Aid, Inc. (CAI) is an innovative solutions company managing engagements with numerous Fortune 1000 companies and government agencies. CAI is headquartered in Allentown, Pennsylvania with a staff of over 4,200 professionals working at locations around the world in a variety of industries.  Our services leverage technology to provide outstanding customer experiences that generate new value for our clients, our employees, and our greater communities.  


    CAI is building a culture of continued learning, support, and personal development in a collegial environment. We also strive to make a positive impact on our surrounding communities through various outreach programs. We make a positive difference for our associates and the communities in which we serve.


    Our mission: Provide industry-leading services and an incredible workplace for our associates, while making an impact on our communities. 


    CAI is an Equal Opportunity/Affirmative Action employer. Minorities, women, veterans and individuals with disabilities will receive consideration and are encouraged to apply.

    For more information on our professionals, services, and industries we support, please see our website




    Status of Your Application:

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