ETL Developer - Brno, CZ – Inzerce – Fórum – Programujte.com

Pixmania.com was founded in 2000 and is one of the pioneers of e-commerce in France and Europe and a major player in the sale of mass-market consumer electronic goods over the Internet. Pixmania.com counts 30 million unique visitors per month and over 10 million customers.

E-merchant is the e-commerce platform and services offer of the Pixmania Group and represents 10 years of experience and expertise of successful e-commerce across Europe with a complete suite of integrated software and services.

Now we are looking for motivated individuals to join our team in Czech Republic on the position of ETL Developer on different seniority levels.

Principal responsibilities:

- develop software for data flow modeling and analysis – using Talend tool
- close cooperation with BI team
- opportunity to participate in other projects using wide range of technologies, mainly Java, Oracle, PHP
- software troubleshooting and maintenance
- write technical documentation

The successful candidate should have:
- IT university degree or equivalent experience
- communicative English
- experience with developing ETL software using Data flow modeling software like Talend, Pentaho, etc…
- knowledge of databases like MySQL, Oracle
- knowledge of version control systems like SVN, Git,…
- advantage: PL/SQL

We offer:
- professional growth within attractive international environment
- competitive remuneration
- development trainings
- flexible working hours
- 5 weeks of vacation
- language courses (English, French, Czech)
- contribution to pension scheme and leisure time activities
- rest area and multicultural working environment
- company events

Starting date: as soon as possible

APPLICATIONS
If you are interested in our offer, please send your application with a current CV in English to the following address. All data will be treated with strict confidence.

PIXMANIA s.r.o.
Alena Krejcirova
Triniti Office Center, Trnita 5, Brno
tel: 511 187 503, email: jobs@pixvalley.com

Note: I am moving to Brno on long term residency. Please consider my cv for this opening.

Below is my CV pasted.

SWATI PAREEK

SLS Sunflower, Kadubeesanahalli, Marathahalli, Bangalore, India

Email: pareek_swati@yahoo.com; Mobile No: +91-9686432467

A. Summary of Professional Experience

Has 9+ years of professional experience working in IT companies and research organization in the area of Oracle 9i/10g/11g, PL/SQL, DB2, SQL Server, Oracle Forms and reports, ETL Processes(Informatica), SQL Loader, Unix shell scripting. Database modeling, design and development experience along with the maintenance, performance tuning and analysis of commercial database. Data Analysis for the business requirements and reporting. Experience working on databases designed on distributed model. Intensive client interaction to understand the requirements. Leading and mentoring within the team. Expertise in data analysis, problem analysis and providing robust solution. Automating manual processes and job scheduling. Has software development experience in C, C++, VC++ through full software development life cycle (SDLC) of automating the design and modeling of scientific instruments. Experience of working on wide domains including financial, automotive, telecommunications, medical, research, electronics, insurance etc.

Skills:

Databases: Oracle 9i/10g/11g, PL/SQL, Oracle Forms and Reports, IBM DB2, Sql Server, MYSQL,

Database Tools/Technologies: IBM Cognos, Informatica, Toad, SQL Developer, Oracle Designer, Backup, Performance Tuning, SQL Loader

Scripting Languages: Unix Shell Script, HTML, Java Script, PHP

Programming Languages: Work experience in  C, VC++, Knowledge of Java, C++. VB

OS Platform: Windows, Unix, Linux

Networking: Knowledge of basic networking concepts and technologies

Certifications

Oracle 10g Database Administration I (IZ0-042) – Jan 2009.
IBM Certification in DB2 UDB V8.1 Family Fundamentals.
IBM Test 286 Application Development Web Sphere Studio V5.0.
Diploma in Business Programming from Versatile Systematics, Jaipur

Publications

Swati Pareek et al., “Automation in Pierce Gun Design”, Sixth International Vacuum Electronics Conference (IVEC-2005), Noordwijk, The Netherlands, Apr, 20-22 2005.

B. Education

M.Tech (Computer Science), Banasthali Vidyapith, 2005.
MIT (Masters in IT), Manipal Academy of Higher Education, 2003.
Post Graduate Diploma in IT, Manipal Academy of Higher Education, 2001.
B.Sc, University of Rajasthan,2001

C. Details of Professional History

i). Aug 2009 – Till Date with IBM India Pvt. Ltd, Sr. Systems Engineer, Pune, India

Projects History:

              a.)    April 2014 – Till Date – Medtronics, USA

Working as Oracle PL/SQL Developer , DBA and support engineer for the client Medtronics
Data analysis and reporting as per the business requirements
Handling different components for enrollment, password management, jobs scheduling and monitoring, Pl/SQL development.
Extensively client interaction, working with Senior managers of Medtronics , Problem resolution.
Propose design for problem resolution and functionality enhancement, estimation,

                            development.

Working on RFC, Deployment and Change Management
Working experience on 700+ databases, distributed computing and remote procedure calls
Database administration user creation, role assignment,
Job Monitoring
Unix shell scripting and sql scripting for the new functionality and code enhancement.
Modification in existing procedures/functions/packages for fixing problem
Development of new code for added functionality, testing and deployment
Providing global support on enrollment application and connectivity through medtronics reporting

b.) Nov 2012 – April 2014 – Idea Cellular , India

Working as Oracle Lead for new product development; Dealers and Sales System for Idea Cellular for the management of distributors and retailers across the country.

                             Calculation of Compensation for the retailers and distributors.

Working on RFC and responsible for deployment. Database analysis and KPI reports to client.
BI reporting using Cognos, developed automated jobs for report generation.
Highly integrated system that captures data from different applications running for Idea and consolidate them in DSM2 database. 
Extract data from BI system implemented on IBM DB2 and generate data sets and reports
Take technical decisions and propose solutions as per the requirement. Guiding other team members.
Development of the programs,procedures, sql loading for loading data from csv  files into database.
Extract data from other database sources and load in DSM2
Data load using ETL processes from different legacy systems to DSM2 using informatica and sql loader
Write test cases, Unit and Integration testing
Unix shell scripting for the automation of data loading processes.

c.) May 2012 – Nov 2012 – General Motors (SAAB Cars), Sweden

Worked as Oracle PL/SQL / Forms developer for MAS migration project for SAAB Cars. Upgrade the existing system and development of new components for the client’s requirement.
Development of Procedures and functions
Modification in existing programs
Modify and develop new forms for front end integration.

d.) Jan 2012 -  May 2012 - : RACV, Australia

                      -     Worked as PL/SQL Developer for the client RACV for the CID (Corporate Integrated      

      producing various reports.  Database) application which is the data warehouse used by RACV to consolidate information from its various transactional and functional systems,into a tool suitable for

-    Worked on complete SDLC cycle for the RFS assigned individually. Cost estimation,

      requirement analysis and client discussion, development, test case development, testing , deployment.

-    Worked on RFS for the change deployment of the new requirements mentioned by the   client for modifications in the existing SQL scripts/UNIX scripts or creation of new scripts.

e.) Mar 2010 – Aug 2010 –:Idea Cellular, India

Worked as PL/SQL Developer for the collections database to provide data to the customers of different circles as per their requirements and generation of automated reports for the users
Develop new scripts and modify existing scripts for generation of reports, to find the mismatch in data if any and notify the users for the same.
Database management and integration of data in three different database systems.
Unix scripting for file handling and execution of programs in integrated database systems.

f.) Jan 2010 – Mar 2010 -: Idea Cellular, India

Database design and development in SolidDB.
Fetch data from other databases in Oracle and DB2 and create a new database in SolidDB for UUP.
Keep data updated in UUP by accessing data through views in base system.

g.) Aug 2009 – Dec 2009 –: General Motors (SAAB Cars), Sweden

Worked as PL/SQL Developer for development of new system for SAAB cars warehouse that involves disintegration of the financial system of SAAB from the GM system and develop independent system for SAAB.
Development of new interface and forms, development of new procedures, modification in existing interfaces and programs.
Developed test cases and done regressive testing of the system.

ii). Apr 09 – July2009 with Zensar Technologies, Software Developer Pune, India 

1.  Working as a DB2 Developer in BND project for the client Strate, South Africa to maintain and manage the data of Johansburg Stock Exchange (JSE).

2.     Working on the role of Database Developer and Administrator for storing, maintaining and returning resultset of reconsiled data to the client for Bonds and Equity type of market.

iii)  July 07 – Jan 09 with CSV Media Clubhouse, Programmer, Ipswich, UK

1.     Working as a team member in the Management Information System project of the   organization.

2.     Automating the operations, modeling and design of the database in DB2 UDB, Oracle.

3.     Database Administration, User Creation and Authorization, Backup, Performance Tuning.

4.     Analyzing data to provide solutions developing code through PL/SQL.

 
iv.) Since Oct 06 – Dec 06 with NAV back office IT solutions Pvt Ltd., Jaipur, India as a Tr. Software Engineer (PL/SQL Programmer).

Worked as a Team member for two projects NAV Central and Monthlies Automation for US clients like Sequent, Orix etc, who deal with hedge funds accounting.
Worked as a PL/SQL Programmer for Navcentral Project.
Handle queries related PL/SQL Programming, Query Optimization, Performance Tuning, reporting.
Writing stored procedures, functions, triggers.
Creating and updating of Parser configuration files used for Parsing.
Prepare Comma separated version (CSV) files for reporting to the clients on daily basis.
Worked as a Database Programmer in SQL Server for Monthly Automation project for hedge fund accounting fund managers. Provide support to the fund managers by providing results through T-SQL and stored procedures. 

 
v.) Since Sep 05 – Sep 06 with International Institute of Informatics & Management, Jaipur, India.

Worked as software developer in a development team for database programming in DB2, Oracle and PL/SQL. Working with stored procedures, triggers, cursors.
Supervised the IBM project on Service Cadre Automation through INVITE, a project    development programme by IBM. Designing the database and database programming in DB2 for providing results for web enabled interface.
Handled some Java programming includes socket programming and file handling.
Worked as an Assistant Professor for DBMS, Database Design, Computer Organization, System Analysis & design.

vi.) Since July 04 – May 05 with the Central Electronics Engineering Research Institute (CEERI), Pilani, India, Council for Scientific and Industrial Research (CSIR) Lab

Worked as a trainee Developer for the project Modeling of Electron Beam Dynamics in Traveling Wave Tubes developing individual modules like:

1. AUTOPPM: Automated graphical software for the design and optimization for PPM focusing system of electron gun developed in Visual C++ with some modules developed in C language.

2. INSYGUN: Software for the automatic synthesis of design of electron gun developed in Visual C++.

D. Conferences/Seminars/Achievements

“Automation in Pierce Gun Design”, at Sixth International Vacuum Electronics Conference (IVEC 2005), held in Noordwijk, the Netherlands, Apr, 20 - 22 2005. (Presented the paper in the conference)
Give virtual sessions for IBM Learning on Oracle 11g PL/SQL New features for IBM India, and IBM Philippines, which was internationally recognized by DBMS team Philippines.
Blue Point Winner in IBM for innovative idea and implementation.
National Seminar on Application of Quantitative Methods for Managerial Decisions
Workshop on Enterprise Application Development with IBM Software