We provide IT Staff Augmentation Services!

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

We'd love your feedback!