SmartRecruiting is looking on behalf of its client for an Informatica ETL Developer.
Location: Bucharest, on-site
Company mission: The company is a creator and manufacturer of innovative social expression products that assist consumers in enhancing their relationships to create Happiness, Laughter, and Love. Headquartered in Cleveland, Ohio, the company has offices worldwide in Canada, the UK – Europe, Australia, and Asia and generates annual revenue of approximately $1.9 billion. The Bucharest Office is one of the IT Centers that offers support for the Corporation Teams in the Data warehouse, System Engineering, QA Automation Engineering, and Web & Mobile Development arias. We are a young, ambitious, and dynamic team, growing together with the company through high training offered by our specialists in a variety of technologies across all platforms:
- DWH: Oracle, SQL, Informatica, Teradata, ETL, Unix/Shell Scripting, QlikView, Cloudera – Data Warehouse;
- Web & Apps Development: Python, Java, C#, JavaScript, HTML, CSS, Endeca, SAP, Node JS,
- Android, iOS, Angular, Web Dynpro, ABAP, SSIS, Batch scripts – Web & Mobile;
- Infrastructure: Linux, Microsoft Windows – Active Directory, Exchange, VM-Ware – System Admin;
- Software testing: Java, Groovy, Selenium, Apium, Geb – QA Automation and much more.
- SAP: Web-Dynpro ABAP, as IDOC, PI, Web-service, Proxy, OData, EDI/ALE/IDOCs, RFC, BAPI’s
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, and 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
• Occasional primary support rotation on EDW processes (after Training); minimize disruption to the business
Requirements:
• Bachelor’s degree or higher, preferably with a data warehouse or relational database specialization or similar experience
• 3 to 5+ years of experience in data modeling for Data Warehousing
• 3 to 5+ years of experience performing ETL/data integration tools like Informatica Cloud (IICS) or Informatica PowerCenter
• At least 5 years of 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, ability 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
Benefits:
- Meal vouchers: working days month * 20 Ron
- Easter: 500 Ron (for employees who have been in the company for at least 3 months)
- Christmas: 500 Ron (for employees who have been in the company for at least 3 months)
- Voucher summer vacation: 850 Ron or 1250 lei holiday vouchers (granted all employees with seniority in the company of at least 6 months)
- Children up to 18 years: 150 Ron/ child (June 1st gift vouchers) and 150 Ron / child (Christmas gift vouchers) (employees with at least 3 months experience in the company)
- Employee’s birthday voucher – 100 Ron
- Medical assurance: Medicover
- Transport – 80 Ron or 135 Ron