Data warehouse Lead Resume Pleasanton, CA - Hire IT People

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

We provide IT Staff Augmentation Services!

Data Warehouse Lead Resume

Pleasanton, CA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship