We provide IT Staff Augmentation Services!

Data Warehouse Lead Resume

Pleasanton, CA


  • 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.


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


Confidential, Pleasanton, CA

Data warehouse Lead


  • 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


Data Warehouse Lead


  • 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


Data Warehouse Lead


  • 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