We provide IT Staff Augmentation Services!

Etl Architect Resume

2.00/5 (Submit Your Rating)

PROFESSIONAL SUMMARY:

  • Extensive career Experience in Data Warehousing, Decision support Systems and has Wide Experience in implementing Data Warehousing solutions to large corporate clients and has professional experience of about 15 years working with various industries such as Retails, Manufacturing, Pharmaceuticals, Mortgage & Finance, and Telecom.
  • Strong experience in Implementing Full Life cycle
  • Data Warehousing Projects and Extensive experience in development of Decision Support Systems (DSS).
  • Skilled in defining and implementing the various components of a data warehouse such as Operational source systems, Data staging, Data presentation and Data access tools.
  • 8 Years of Strong experience in Data Model design and development.
  • Expert in Designing Dimensional Modeling (Star Schemas, Snow flake schema) and Operational Data store (ODS) Data Warehouse design.
  • 6 Experience in designing models with ER Studio.
  • 4 Experience in ETL architect.
  • About five years of experience working with Oracle Data Integrator ( ODI ) topology manager, designer, Operator and trouble shooting of packages.
  • Over 6 years of experience with ETL tools such as Oracle Warehouse Builder, Informatica (Power Mart/Power Center).
  • 6 years of experience in performance tuning of complex sql queries.
  • Over 6 years of Hands - on experience in designing, tuning, and leveraging large data warehouses.
  • Over 4 years of experience with Business Objects, TABLEAU, OBIEE.
  • . Over two years of experience with Amazon Redshift, S3, Data Pipeline.
  • Experience in implementing Oracle, SQL Server and Teradata database applications.
  • Proficiency in data warehousing techniques for data cleansing, Slowly Changing Dimension phenomenon, surrogate key assignment and change data capture.
  • Involved in identification of facts and dimensions and hierarchies for OLAP models.
  • Over 3 years of experience in AIX environment.Kornshellscripting to write post and pre-session shell scripts and scripts which are responsible for sending some reports and files as email attachments and ftp'ing xml files to remote servers using vi editor.

TECHNICAL SKILLS:

ETL Tools: Oracle Data Integrator (ODI), Oracle Warehouse Builder 10g/9i/8i (OWB), Informatica 7.1.3/6.x/5.x

RDBMS: Oracle 11g/10g/9i/8i/8/7.x, SQL Server 2000/2005, Teradata v2r6/v2r5/v2r4, IBM DB2, DB2 UDB v7.2/8.1, Amazon Redshift.

AWS: Redshift, S3, DATA PIPELINE, EC2

Azure: Data lake, data factory, data bricks, data analytics

Data Modeling Tools: ERwin 7

OLAP Tools: TABLEAU, OBIEE11g, Business Objects XI/6.x/5.1MicroStrategy, Cognos.

Programming Languages: SQL, PL/SQL, C, C++, VB, UNIX shell scripting

Oracle Tools: PL/SQL, SQL*LOADER, Oracle Sql Developer, ERWIN, TOAD

Operating Systems: UNIX, Windows NT, Window 9X, MS-DOS

PROFESSIONAL EXPERIENCE:

Confidential

ETL architect

Responsibilities:

  • Strong experience in Implementing Full Life cycle
  • Data Warehousing Projects and Extensive experience in development of Decision Support Systems (DSS).
  • Skilled in defining and implementing the various components of a data warehouse such as Operational source systems, Data staging, Data presentation and Data access tools.
  • 8 Years of Strong experience in Data Model design and development.
  • Expert in Designing Dimensional Modeling (Star Schemas, Snow flake schema) and Operational Data store (ODS) Data Warehouse design.
  • 6 Experience in designing models with ER Studio.
  • 4 Experience in ETL architect.
  • About five years of experience working with Oracle Data Integrator ( ODI ) topology manager, designer, Operator and trouble shooting of packages.
  • Over 6 years of experience with ETL tools such as Oracle Warehouse Builder, Informatica (Power Mart/Power Center).
  • 6 years of experience in performance tuning of complex sql queries.
  • Over 6 years of Hands - on experience in designing, tuning, and leveraging large data warehouses.
  • Over 4 years of experience with Business Objects, TABLEAU, OBIEE.
  • . Over two years of experience with Amazon Redshift, S3, Data Pipeline.
  • Experience in implementing Oracle, SQL Server and Teradata database applications.
  • Proficiency in data warehousing techniques for data cleansing, Slowly Changing Dimension phenomenon, surrogate key assignment and change data capture.
  • Involved in identification of facts and dimensions and hierarchies for OLAP models.

We'd love your feedback!