Data Warehouse Resume
5.00/5 (Submit Your Rating)
PROFESSIONAL SUMMARY
- Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
- Demonstrated expertise utilizing ETL tools, including Informatica(PowerCenter, IDQ, and PWX), SSIS, and DataStage and ETL package design, and RDBM systems like SQL Servers, Oracle, and DB2.Strong experience in RDBMS Concepts, Dimensional Data Modeling ( Confidential, Snow -
- Confidential, FACT and Dimension tables), Logical and Physical Data Modeling and worked extensively with slowly changing Dimensions.
- Knowledge and experience in JAVA, XML, DTD, XML Schema, XSL (XSLT, X-Path).
- Excellent technical and analytical skills with clear understanding of design goals of reporting tools such as SSRS and Crystal reports and dimension modeling for Confidential .
- In-depth knowledge of data mapping, warehousing tools, unit testing, process documentation and data mapping.
- Worked on big data analytics using Apache Spark, Scala and Hive.
TECHNICAL EXPERIENCE
Software and Tools: Informatica (PowerCenter), IDQ, DataStage, DVO, Erwin, PWX, SSIS,SSRS, Crystal Reports, SAP ECC, SAS, Epic Clarity, Apache Spark, Scala, Hive.
Platforms: AIX, UNIX, Sun Microsystems, Sun Solaris, HP-UX, Compaq, z/OS, Intel, Windows NT, Dell
Databases: Teradata, DB2, Oracle, Access, SQL Server
Programming: SQL, T-SQL, PL/SQL, VBA, AS400, XML, Korn, ASP, C/C++, Java, MQSeries, HTML