Zyme Solutions Pvt Ltd Bangalore : Data warehousing Expert

[muthukalee]

Role : Data warehousing Expert

Location : Bangalore

Responsibilities :

* Architect, design and develop data warehouse solutions that support identified Business requirements.
This will specifically include :
o Design and develop data warehouse star schema and multidimensional cubes, based on business requirements, to support high-end, mission critical online analysis.
o Design, build and implement ETL programs to load, cleanse and transform source data into the data warehouse and marts.
o Build the supporting metadata repository.
o Develop DSS queries and reports, batch jobs and operational maintenance jobs.
o Develop data mining scenarios in support of business requirements.
* Provide scalable solutions to manage large volume imports and implement operational procedures as necessary.
* Design robust data warehouse management functions covering resource management, security, backup and recovery, performance monitoring and tuning, data and cube management and capacity planning, and high availability.

Required skills :

* Experience working in an agile development process.
* Strong experience in data modeling and data architecture principles including :
o Partitioning,
o Knowledge of aggregation design considerations,
o Index strategies
o Cube design consideration and
o Loading/uploading considerations
* 3 or more years of experience developing Dimensional Models for Data Mart/ Data Warehouse applications.
* Experience in RDBMS technologies (MySQL, Oracle).
* Experience in using tools such as Erwin, workbench.
* Excellent ETL staging environment design and performance tuning skills.
* Excellent SQL complex query, procedure and function writing skills
* Experience in ETL tools (Informatica/Kettle) for designing complex transforms to load data from different data sources into data warehouse/marts.
* Knowledge of scripting language (Perl, Unix Shell).
* Understanding/experience in working within an iterative development environment.
* Strong experience with performance optimization and tuning with reporting applications a MUST.
* Good written and verbal communications skills and good facilitation skills

Required experience :

* Minimum 3-5 years of experience in relevant areas of responsibilities

Other :

* Experience in the areas of channel management and supply-chain preferred

Education :

* Regular Full Time Degree in Engineering, MCA or equivalent from a recognized university/institute

To Apply :
Please send your resume to careers@zymesolutions.com with only "Data warehousing Expert" in the title of the email. Please send your resume as an attachment in one of the following formats : Plain ASCII, PDF, MS Word or HTML only.

Contact us :
Zyme Solutions Private Limited
# 38/C/23, Venkatamma Complex,
South End Road, Basavanagudi
Bengaluru, Karnataka 560004
080 66991200
http://www.zymesolutions.com

[Guest]

LAKSHMI VENKATESWARAN
Email : Venkateswaran.Lakshmi AT gmail.com
Career Profile
Senior Software Engineer, iGATE Global Solution Ltd, Bangalore, INDIA
June 2009-June 2011.
Engineer Trainee, Honeywell Technology Solutions Lab, Madurai, INDIA
Dec 2008-May 2009.
Experience Summary

Strong understanding in Data warehousing-Business Intelligence concepts.

21 months extensive experience in Analysis and development of data Extraction,
Transformation, and Loading (ETL) using Informatica.

Good knowledge of modeling and database design, life-cycle development
methodology.

Strong analytical, problem identification and solving skills.

Good database analytical and SQL, PL-SQL writing skills.

Solid understanding of Relational and Dimensional modeling.

Worked on scheduling tool (CRONACLE) and performed efficient logical execution
of data.

6 months of development and support experience in Java Technology
Technical Skill Set

ETL : Informatica 8.6

Database Environments : Oracle 10g

Operating Environments : UNIX, Windows

Domain Knowledge : Finance-Factoring

Tools : SQL developer, TOAD, Cronacle
Educational Details
2004–2008 Vivesvaraya Technological University, Bangalore, INDIA
Bachelor of Engineering in Information Science Aggregate : 75%
2002-2004 Department of Pre-University Education, Bangalore, INDIA
XII Pre University Course Aggregate : 81%
2001-2002 Board of Secondary Education, Bangalore, INDIA
X -Secondary School Leaving Certificate Aggregate : 91%
Project Details
Project # 1- Risk and Finance Data warehouse
Client : GE Commercial finance, United Kingdom
Organization : iGATE Global Solution Ltd
Duration : June 2009 – July 2010
Team Size : 8
Project Type : Development/Testing/RTS
Tools : Informatica Power Center 8.6, BO XI R2, Oracle Client 10g, Toad, UNIX
Project Description
- This application is implemented to capture and maintain the daily transactions
between the Client, Debtors and Factors in the Factoring business.
- Daily transactions include keeping track of new Clients/Debtors and updating the
invoice details of existing Clients/Debtors.
- Perform reconciliations of data on a daily basis.
- Providing snapshot/summary data for reporting to users through Business Objects.
Contribution
- Responsible for creating Informatica mappings by applying necessary
transformations as per the logic required.
- Responsible for creating PL_SQL scripts for testing.
- Developed UNIX scripts for e-mail notifications.
- Monitored loads and resolved data mismatches.
- Automated the complete reconciliation process.
Project #2 : Tax Stream Interface Application
Client : GE Health Care, United States of America
Organization : iGATE Global Solution Ltd
Duration : August 2010- December 2010
Team Size : 4
Project Type : Development
Tools : Informatica Power Center 8.6, Teradata, Oracle Client 9i, Toad, UNIX,
Cronacle
Project Description
- This application is an interface which retrieves data from the General Ledger and
provides Trial balance for tax calculation and identifying unmapped accounts for
a particular period.
- The Trial balance data is further retrieved for tax calculation and finally uploaded
into the Tax Stream Application.
Contribution
- Involved in the gathering the requirements from the clients.
- Designed the logical flow of the process to be implemented, integrating multiple
technologies like Informatica, Teradata and Oracle using Cronacle.
- Created mappings to provide the trial balance data.
- Responsible for creating procedures for tax calculation.
- Responsible for scheduling and performing testing of this application for correct
loading of files.
Project # 3 : Global Business Services Interface Application
Client : GE Health Care, United States of America
Organization : iGATE Global Solution Ltd
Duration: January 2011- June 2011
Team Size: 4
Project Type: Development
Tools: Informatica Power Center 8.6, Teradata, Oracle Client 9i, Toad, UNIX,
Cronacle
Project Description
- This application is an interface which retrieves data from the General Ledger and
categorizes the accounts as Active, Inactive Reactive and Upload.
- Provides the trial balance (Year to date balances) for the all of the active, reactive
and upload accounts for a particular month.
- Finally the balance data in captured in a flat file and uploaded in the Global
Business Services Application for user reporting purposes.
Contribution
- Involved in complete life cycle of design of this interface.
- Interacted with clients in understanding the changing requirements.
- Responsible for creating the complete flow of the process of categorization of
accounts using Informatica, Teradata and Cronacle.
- Responsible for performing testing in the application for correct loading of files.