ETL Informatica Developer

Sysco

Sysco Associate Apply – Click Here

Company: CORP Enclave

Location: US-TX-Houston

Zip Code: 77077

Minimum Level of Education: High School or Equivalent

Minimum Years of Experience: 6

Position Type: Exempt

Travel Percentage: 0

More information about this job:

OVERVIEW:

At Sysco, we offer our associates the opportunity to grow personally and professionally, to contribute to the success of a dynamic organization, and to serve others in a manner that exceeds their expectations. We are looking for talented, hard-working individuals to join our team. Come grow with us and let us show you why good things really do come from Sysco.

POSITION SUMMARY:

Informatica ETL Developer to do design, development, maintenance and production support.

RESPONSIBILITIES:

  • Work with initiative leads, product teams, technical leads, architects, subject matter experts, developers, technical support groups and test teams to deliver value to the business.
  • Review and accept software and interface design and requirements.
  • Refine and decompose requirements to the level of detail required to initiate development.
  • Deliver ETL and related components as specified in the design, functional and non-functional requirements, within established budget, time and quality standards.
  • Design, prototype, develop, test, and document existing and new ETLs, and related components; make recommendations for related functions that result in a more cost effective product delivery.
  • Perform unit testing of ETLs and related components and document test results.
  • Complete code reviews for ETLs and related components, and complete documentation of issues identified and action items.
  • Correct testing defects and support all testing, including but not limited to: Development Integration Testing, System Testing, User Acceptance Testing, End-to-End Testing, and Performance Testing.
  • Perform troubleshooting on ETLs and related components
  • Identify application bottlenecks and opportunities to optimize performance
  • Provide resolution to an extensive range of complicated ETL-related problems, proactively and as issues surface.
  • Informatica PowerCenter base system configuration and support including installation, upgrades, performance tuning, etc.
  • Perform code version control activities.

    Education and / or Experience:

  • Minimum six (6) years of current and hands-on experience with Informatica PowerCenter (including 2 years of v 9.x or higher) design, development and performance tuning
  • Minimum six (6) years of current and hands-on experience with complex SQL and high-volume Relational databases and SQL Query performance tuning
  • Minimum six (6) years of current and hands-on UNIX shell scripting experience.
  • Minimum two (2) years of current and hands-on experience with an enterprise job scheduler (Control-M, Autosys, Redwood, etc).
  • Minimum two (2) years of Informatica PowerCenter system maintenance, installation and upgrade experience
  • Minimum two (2) years of current and hands-on experience with code / version management tools.
  • Minimum 7 years of current and hands-on experience with SQL and Relational databases
  • Experience working with dedicated and matrixed resources

    Professional Skills:

    Analytics and Insight

  • Strong analytical and problem solving skills
  • Ability to manage multiple priorities and meet critical deadlines
  • Demonstrated delivery of multiple complex projects
  • Strong supply chain experience in a multisite organization
  • Can quickly frame ambiguous problems and drive to tangible insight
  • Synthesizes complex information from multiple sources to influence decisions Communication
  • Excellent verbal and written communication skills. Ability to communicate effectively with team members, stakeholders, and Sr. management on both business and IT sides.
  • Strong credibility and self-confidence in executive level communication Business Partnership
  • Excellent customer service skills
  • Ability to establish / build cross divisional relationships / collaboration
  • Demonstrated partnership with business clients and value proposition of projects/portfolio.
  • Able to quickly build strong working relationships with business leaders
  • Change management experience delivering results within a large organization
  • Works productively across the enterprise and partners with others to achieve shared goals Process and Tool Development
  • Can manage and improve information processes/tools to support operational decisions
  • Informatica Grid architecture configuration and support
  • Informatica S3/Redshift connector/integration experience
  • Experience with AWS technologies: Lambda, Data Pipeline, EMR/Python, S3, Redshift, Athena
  • Experienced Agile team member and with Agile development methodology Able to develop and deploy best practices across the organization
  • Experience with Tableau and Business Objects Team Leadership
  • Can scope and structure work effectively for team; adapts to changing demands
  • Able to establish executional standards and hold people accountable for delivering results
  • Promotes team effectiveness, morale and productivity
  • An effective coach and developer of people

    Physical Demands:

  • The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations will be made to enable individuals with disabilities to perform the essential functions of this job.
  • While performing the duties of this job, the employee is regularly required to sit, stand, walk and use hands and fingers to operate a computer keyboard, mouse, and telephone to talk and hear. The employee is frequently required to sit and reach with hands and arms. The employee must occasionally lift and/or move up to 20 pounds.

    Working Conditions:

  • This position can be performed from the Corporate facility.
  • Must be able to travel to Sysco facilities or operating companies up to 10%.
  • The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations will be made to enable individuals with disabilities to perform the essential functions of this job.
  • The noise level in the work environment is usually moderate.

    NOTICE: The above statements are intended to describe the general nature of the environment and level of work being performed by this job. This job description in no way states or implies that these are the only tasks to be performed by the employee in this job. He or she will be required to follow any other instructions and to perform any other job related duties requested by his or her supervisor.

    Reasonable accommodations will be made to enable individuals with disabilities to perform the essential functions. This job description supersedes prior job descriptions.

    Applicants must be currently authorized to work in the United States.

    Sysco is proud to be an Equal Opportunity and Affirmative Action employer, and considers qualified applicants without regard to race, color, creed, religion, ancestry, national origin, sex, sexual orientation, gender identity, age, disability, veteran status or any other protected factor under federal, state or local law.

    This opportunity is available through Sysco Corporation, its subsidiaries and affiliates.

    Employment Type: Full Time

  • To apply for this job please visit the following URL: http://itjobpro.com/116464 →