Etl Developer / Data Modeler Resume
0/5 (Submit Your Rating)
Columbus, OH
SUMMARY:
- I have 10+ years’ work experience in Data Warehouse as ETL developer/Data Modeler, contributed to several successful DW projects involving multi - sources and large data sets by providing data model design and data flow (ETL) development/implementation in various system environments.
- With multiple core skills for data industry in terms of databases/ETL tools/data modeling tools/programming language/open source/big data, I have been successfully performing multiple duties in solution design, development, testing, documentation and support.
TECHNICAL SKILLS:
SKILLS: Teradata, Oracle, Unix, Shell Script, ETL, Data Model, Data Warehouse, SQL tuning, Big Data, Hadoop, Spark, Hive, Informatica, PL/SQL, Java, ODI, Vertica, Erwin, ER-studio, Business Intelligence, Control-M, Automic, Business Object, Eclipse, Toad
WORK EXPERIENCE:
Confidential, Columbus, OH
ETL developer / Data Modeler
Responsibilities:
- Providing data model/ data integration solution design, source to target mapping document, ETL code development, unit test/data verification, defect/bug troubleshooting and fix, performance tuning, production support for the new multi-sources large retailing (RMS) data warehouse.
Confidential
ETL developer / Data Modeler
Responsibilities:
- ETL developer: Informatica mapping/workflow development, Unix Shell scripts and PL/SQL development, unit test/data verification, defect/bug troubleshooting and fix, performance tuning, MTP support;
- Data Modeler: Design and build dimension model tables in ERwin, provide source to target mapping doc to ETL team, generate DDL for the database change deployment, defect/bug fix, performance tuning, support;
- Business Analyst: Transfer customer requirements to the technical requirements as needed by Data Modelers, data verification, and compose DDS (Data Definition), then test data after development done.
Confidential
BI Developer
Responsibilities:
- Datastage Job Maintenance, Informatica mapping/workflow development, unit test/data verification, defect/bug troubleshooting and fix, performance tuning, MTP support;
- Business Object Report Development/Support for the Customers in US and Europe