Informatica Developer - Purchase, United States - Ampcus

    Ampcus
    Ampcus Purchase, United States

    1 month ago

    Default job background
    Description
    Informatica Developer

    Hybrid Schedule/Partial Remote: Candidate must be willing to work in the office three days per week (Tuesday, Wednesday, Thursday) in one of the following locations: Alpharetta, GA; Boston, MA; Charlotte, NC; Chicago, IL; Colorado Springs, CO; Conshohocken, PA; Dallas, TX; Florham Park, NJ; Jacksonville, IL; Lenexa, KS; Lubbock, TX; Mt Juliet, TN; New Hyde Park, NY; New York, NY; Purchase, NY; Topeka, KS

    The Informatica Developer will be primarily responsible for developing and supporting ETL code in Informatica PowerCenter for an enterprise data warehouse.

    ROLE RESPONSIBILITIES
    • Develop new ETL and enhancements and modify existing code using Informatica PowerCenter. Work independently to develop, configure, and unit test programs from specs (source to target mappings)
    • Work closely with data architects, reporting team and application team on ETL development efforts
    • Design and document ETL solutions for projects, estimate work effort and provide status of tasks
    • Provide technical support for the administration and production support of Informatica
    • Provide first and second level troubleshooting, and baseline and operational support
    • Adhere to best practices and methodologies for ETL development team
    • Present all work in design and code review sessions to senior team members
    • Prepare documents that describe, and support code developed
    • Identify improvements to the data warehouse environment. Work with the team to implement these solutions
    • Escalate issues to the right party when required
    • Excellent analytical, organization, presentation, and facilitation skills; ability to handle multiple tasks under tight deadlines
    • Working knowledge of Kimball design methodology
    • Knowledge of testing tools and techniques
    • Window environment experience
    • Query Surge experience
    REQUIRED TECHNICAL QUALIFICATIONS (in order of level of need)
    • 5+ years of hands-on experience in ETL development for a data warehouse
    • 5+ years of hands-on experience in development, maintenance, and enhancements of Informatica Mappings, Workflows, and processes
    • Expertise with integration technologies and processes
    • Experience working with complex SQL
    EDUCATION REQUIREMENTS
    • Bachelor's degree in Computer Science, MIS, related field, or equivalent experience
    please send your resume to