We provide IT Staff Augmentation Services!

Data Warehouse Lead Resume

Pleasanton, CA

SUMMARY

  • Over 14 years of IT experience with expertise in managing, designing and implementing Data Warehouses & Data marts using various ETL & OLAP tools, Databases and operating systems
  • Successfully managed Enterprise scale DW/BI projects for major financial and health care clients
  • Provided baseline architecture for data warehouse and data integration projects
  • Implemented ETL design, real - time data processing design, data reconciliation strategy
  • Analyzed source systems, business requirements and documented business rules on need basis
  • In-depth knowledge in Dimensional Data modeling, Star Schema modeling, Snow-Flake modeling, Fact and Dimension tables, Physical and logical data modeling
  • Experience in Performance Tuning of ETL, DB and UNIX code
  • In-depth knowledge of Informatica server administration work, Installations and upgrades.
  • Worked for over four years with Informatica Professional Services team
  • Extensive knowledge of Web services, HTTP, IDQ and XML
  • In-depth knowledge of various databases development and UNIX, PYTHON scripting
  • Excellent team player, quick learner with strong technical background, ability to work and deliver under tight deadlines.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center, Informatica Cloud, Pentaho, Power Exchange, IDQ, MDM, Data Stage, Intermediate experience to Oracle Warehouse Builder

Reporting Tools: Business objects, Hyperion Brio, Hyperion Analyzer, Data Analyzer, Metadata Manager, Tableau, Power BI, Exposure to Cognos

Data Modeling Tools: Languages

SQL, PL/SQL, C, C++, HIVE, UNIX, Perl, Python, exposure to JavaDatabase/Applications: Oracle, SQL Server, Hyperion Essbase, DB2, Hadoop

Oracle Utilities: SQL Loader, TOAD, SQL Navigator

Database Skills: Stored Procedures and Packages

Web Technologies: XML, Webservices

Operating Systems: Solaris, HP-UX, Red Hat Linux, MS DOS, Windows NT/2000/XP

PROFESSIONAL EXPERIENCE

Confidential, Pleasanton, CA

Data warehouse Lead

Responsibilities:

  • Designed and developed PDW Informatica and UNIX server upgrade project
  • Designed data visualization using Python to present current impact and growth
  • Developed Python based REST APIs to track claims and perform sales analysis using SQLAlchemy and SQL
  • Built the optimal extraction, transformation and loading of data from a wide variety of data sources and applications using SQL, Informatica power center, Informatica cloud (IICS)
  • Managed and coordinated QA and production releases
  • Used IDQ to complete initial data profiling and removing duplicate data
  • Assembled large, complex data sets that meet functional/non-functional business requirements
  • Built ETL pipeline using SnapLogic calling python scripts to enable large JSON source file extract into data lakes
  • Built tableau reports based on financial and subscriber data for business teams
  • Worked with data and analytics experts to strive for greater functionality in our data systems
  • Built the infrastructure required for optimal extraction, transformation and loading of data from a wide variety of data sources using SQL, Pentaho, Informatica power center, Informatica cloud (IICS)

Environment: Informatica Power Center 10.x, Informatica cloud services, Informatica Data Quality, Oracle 12x, PLSQL, Hadoop, Python, Postgres, Linux, Python, Airflow, JIRA, Slack, GitHub, Tableau, Power BI, SnapLogic

Confidential

Data Warehouse Lead

Responsibilities:

  • Designed LARS ETL processes using Informatica powercenter, IDQ, PL SQL, UNIX
  • Managed LARS ETL team (analyzed requirement, assigned tasks, follow-ups)
  • Managed and coordinated QA and production releases
  • Gathered and analyzed new business requirement coordinating with Business team
  • Generated HIVE query to create and load external tables into Hadoop (POC)
  • Conducted POC on new products and options for facilitating ETL code

Environment: Informatica Power Center 9.x, IDQ, Data Stage 9.x, Hadoop, HIVE v0.11, Oracle Warehouse Builder, Oracle 11x, UNIX, AUTOSYS, Quality Center

Confidential

Data Warehouse Lead

Responsibilities:

  • Developed and implemented ETL process using Informatica powercenter, IDQ, Power Exchange
  • Performed production support
  • Data modelled new requirements for ongoing ETL processes
  • Designed, developed and implemented CDW ETL process
  • Reviewed and approved technical design documents for ETL ahead of implementation
  • Documented ETL and production support transition process
  • Managed and coordinated QA and production releases
  • Managed ETL team members and reviewed and approved their code
  • Developed stored procedures for stand alone ETL tasks
  • Developed UNIX shell scripts and Tivoli Job schedules

Environment: Informatica Power Center 8.6.1, Oracle 10G, PLSQL, UNIX, Tivoli, HP Quality Center, Share point

Hire Now