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