Informatica ETL Developer - Contractor/CIM

Angajator: American Greetings
Domeniu:
  • IT Hardware
  • IT Software
  • Tip job: full-time
    Nivel job: 1 - 5 ani experienta
    Orase:
  • BUCURESTI
  • Actualizat la: 28.11.2022
    Scurta descriere a companiei

    The Bucharest Office is one of AG’s IT Centers that offers support for the Corporation Teams in the Data warehouse, System Engineering, QA Automation Engineering, Web & Mobile Development arias.

    We are a young, ambitious and dynamic team, growing together with the company through high trainings offered by our specialists in a variety of technologies across all platforms.

    Cerinte

    Nice to have the following:
    • Bachelor’s degree or higher, preferably with a data warehouse or relational database specialization or similar experience;
    • At least 3 years experience in data modeling for Data Warehousing;
    • At least 3 years experience performing ETL/data integration tools like Informatica Cloud (IICS) or Informatica PowerCenter;
    • At least 5 years experience in SQL with a common RDBMS like SQL Server, Oracle, Teradata or Snowflake;
    • High skills in performance tuning (ETL/DB);
    • Experience with any other ETL tool such as Microsoft SSIS, BODS;
    • Experience with PL/SQL is a plus;
    • Experience with any Big Data tool is a plus;
    • Strong written & verbal English communication skills;
    • Flexible, motivated, positive and team-oriented attitude; excellent interpersonal skills, able to work effectively with team members in a remote capacity;
    • Proven Code, Process and Data Analytic skills;
    • Desire to improve analytical abilities and critical thinking;
    • Willingness to occasionally travel to the United States.

    Responsabilitati

    Duties and Responsibilities:
    • Work closely with the client to understand and clarify the technical requirements;
    • Review and analyze source data, analyze and document data flows, validate mapping specifications and business rules from data source to target;
    • Design, develop, test ETL workflows, mappings;
    • Database design and modeling, performance optimization, implementation of packages and stored procedures;
    • Develop and test shell scripts (medium level);
    • Write technical documentation;
    • Provides support, maintenance and issue investigation and resolution; fix issues identified and raised by the client within the agreed SLAs;
    • Translate functional specifications into technical requirements;
    • Occasional primary support rotation on EDW processes (after Training); minimize disruption to the business.

    Alte informatii

    The American Greetings Enterprise Data Warehouse team is looking for the right person to become part of its team. This person will be a self-motivated individual ready to support and enhance our BI environment, is eager to learn new technologies and is open to possessing wide set of technical skills/knowledge. They will work in concert with DBA’s, Business Analysts, Business Users and other Technical staff. Increasing responsibilities in this person’s daily activities will include general programming in various ETL tools as well as various database utilities, EDW support, PL/SQL development, learning from senior team members, rotations for Primary Support, troubleshooting performance issues, analyzing/resolving technical and/or data issues, Unix Shell & Utilities, Windows Script/PowerShell. The successful candidate will participate in similar analysis/development roles on assigned Projects.

    About American Greetings

    American Greetings is a creator and manufacturer of innovative social expression products that assist consumers in enhancing their relationships to create Happiness, Laughter and Love.
    American Greetings’ major greeting card lines are American Greetings, Carlton Cards, Gibson, Recycled Paper Greetings and Papyrus. We also own large web collections of greetings on the Web.

    Headquartered in Cleveland, Ohio, American Greetings has offices worldwide in Canada, UK - Europe, Australia, Asia and generates annual revenue of approximately $ 1.9 billion.

    Our websites: americangreetings.com, americangreetings.ro, bluemountain.com, jacquielawson.com.

    The Bucharest Office is one of AG’s IT Centers that offers support for the Corporation Teams in the Data warehouse, System Engineering, QA Automation Engineering, Web & Mobile Development arias.

    We are a young, ambitious and dynamic team, growing together with the company through high trainings offered by our specialists in a variety of technologies across all platforms:
    • Oracle, PL/SQL, Informatica, SSIS, BODS, Teradata, ETL, Snowflake, Unix/Shell Scripting, QlikView, Cloudera – Data Warehouse;
    • Python, Java, C#, JavaScript, HTML, CSS, Endeca, SAP, Node JS, Android, iOS, Angular, Web dynpro, ABAP, SSIS, Batch scripts – Web & Mobile;
    • Linux, Microsoft Windows - Active Directory, Exchange, VM-Ware – System Admin;
    • Java, Groovy, Selenium, Apium, Geb - QA Automation and much more.

    Join US, and you’ll discover a place where work becomes fun! We are in Cotroceni Business Center – close to Politechnica University and AFI.