I joined an MNC before 8 months as a fresher. I was trained on informatica , cognos toools and PL/SQL. During training I gained good grip on informatica nd PL/SQL. Also prior to joining this company I was having 10 months of java development experience at a startup company.
My trouble is that after training I'm given a ETL testing project. I've been working in this project since last 4 months. I tried best to adjust my mind but it's getting really difficult for me continue doing this work. I continuously feel like this is not my cup of tea. I discussed same with my manager and he told that I might be shifted to dev. after may be a year or two. But I'm afraid that if I'll wait for 1 year I might completely lose my developer mind as I've already started feeling my brain getting washed away. I continuously feel that my technical skills are getting wasted.
I'm confused whether what to do in such situation.
Is it possible to switch to development after working as tester for 1-2 year?
Hows the career growth in data-warehousing field?
I'm even thinking about switching to some small company as Java developer. Would it be a right decision to leave this company in such short span?
You say you have been "trained on informatica , cognos tools and PL/SQL". Are you using these tools in your testing work? If so, then you have some hands-on experience which should be marketable eventually, as ETL, Cognos and Informatica are all popular skills in the data warehousing sector. But your lack of work experience is still a problem, as you say you've only actually been working on the project for 4 months. Also, leaving a job after just 8 months is not going to look good to a potential employer.
If I were you, I'd look for opportunities to apply and improve your ETL and BI skills in your current job to increase your hands-on experience with these things. Explore the code that other people are writing, ask to sit in on code reviews if possible, look at how they are modelling data and data-flows, and how the data is transformed and presented in BI tools etc. Ask the developers to explain what they've done - or how they fixed a bug - so you can learn more about how the system works, which will help you as a tester and give you a deeper understanding of what you might have to do as a DWH developer.
Also, make sure you explore the theory around data warehousing - star schemas, data-modelling etc (try the "Data Warehouse Toolkit" and "Data Warehouse Lifecycle Toolkit" books by Ralph Kimball for a good introduction) - so that you understand how and why to use these tools in real systems. Get a year of real hands-on experience under your belt, then you have something meaningful to sell, either to your current employer or to another company.
Data warehousing is currently a very marketable skillset, and there seem to be plenty of jobs for people with experience in ETL and business intelligence. But you'll need to put your own time/effort into making sure you have the right skills and experience to get one of those jobs.
No more Blub for me, thank you, Vicar.
Joined: Feb 01, 2014
Thanks a lot for the reply.
Dev. team of the same project sits on other location. And since I've talked about my inclination towards dev. work, he's trying his best to keep me away from technical work. That was the reason I was considering though of jumping to some other company doing java dev. work as I already know JAVA by my past experience. Still confused ... :P