Data Lead Resume

SUMMARY:

Data Integration expert with 20 years of industry and consulting experience leading high - value enterprise data transformation initiatives in both Commercial and Federal space.
ETL design and development of Enterprise Data Warehouses (Data Marts), Business Intelligence, and Big Data Lakes (on-prem and on Cloud).
Skilled in managing client relations, team leadership, and functioning as a trusted advisor
Extensive experience in all stages of System Development Life Cycle (SDLC).
Experienced in Agile development.
ETL Development, ETL design and architecture
Design and development of data pipelines - ingestion, curation, and transformation - from various kinds of data formats including flat files, relational, XML files, and cloud data warehouses such as Redshift
Design and development of ETL workflows, mappings - using Informatica
Expertise in SQL and PL/SQL (stored procedures & functions)
Data Architecture of Enterprise Data Warehouses (Data Marts) and Data Lakes
Data Modeling of OLAP systems including dimensional data modeling (star schemas, snowflakes).
BI Reporting using Tableau, OBIEE
Data Governance (including metadata management, data lineage, data quality, access and privacy)
Expertise in both on-prem and cloud Data Warehouses (including Amazon AWS Redshift, and Google BigQuery)

TECHNICAL SKILLS:

Data Integration (ETL) - Informatica Power Center, Oracle Data Integrator (ODI)
Enterprise Data Warehouse - Oracle, Db2, Netezza, SQL Server, Amazon AWS Redshift, Google BigQuery
Business Intelligence - Tableau, Qlik, OBIEE, Cognos, Power BI
Languages - SQL, PL/SQL, Python, Java, Unix Shell scripts
Hadoop (Hbase, MapReduce, Hive, Hbase, Spark, Storm, Flink, Kafka, Sqoop)

PROFESSIONAL EXPERIENCE:

Data Lead

Confidential

Responsibilities:

Perform as the ETL lead and data architect of Enterprise Data Warehouses, Data Lakes, and Business Intelligence programs
Design of data integration (ETL) architecture and data pipelines
Development of ETL workflows, worklets, and mappings using Informatica PowerCenter
Creation of source-to-target mappings (including transformations)
In corporate best practices of ETL design and development in order to create scalable and flexible ETL pipelines. In corporate exception handling, messaging & alerts, change data capture etc.
Data Modeling and architecture of Enterprise Data Lakes, Data Warehouses and Business Intelligence systems.
Design of EDW and Data Marts data models utilizing dimensional data modeling (Star and snowflake schemas).
Sample engagements:
ETL design and development of Enterprise Data Warehouse for one of the largest Insurance companies utilizing Informatica, SQL and Oracle PL/SQL program units
ETL design and development of the Enterprise Data Lake on cloud for a top US national bank utilizing AWS Redshift, and Informatica.
Design and development of the ETL of multiple data marts using Informatica. Designed exception handling, restart ability, and data reconciliation.
Develop the logical and physical dimensional data models for the cloud EDW of a regional bank on Google BigQuery.
Data Integration (ETL) design and development of the Enterprise Data Warehouse and BI program for the largest US mortgage insurer focusing on Loan Accounting analytics.

ETL Lead

Confidential

Responsibilities:

ETL Lead of a portfolio of projects in Data Warehousing, Data Lakes, Big Data, Business Intelligence, and Analytics.
Implement industry best ETL practices to ensure scalable and high performing ETL workflows that meet the SLA.
Design ETL workflows and mappings using Informatica, Oracle PL/SQL, and SQL
Responsible for leading the development of Data Lake Architecture, EDW Architecture, Data Integration/ETL architecture, Data Marts design, and Data Models (dimensional data models - Star Schemas, snowflake).
Responsible for leading the design and development of ETL solutions for several organizations

Data Architect, Analytics & Business Intelligence,

Confidential

Responsibilities:

ETL design and development of a portfolio of BI and Data Warehousing engagements with public sector and commercial clients
Design and develop ETL workflows using Informatica, SQL PL/SQL program units (stored procedures and functions)

ETL Lead, Business Intelligence & Data Warehousing,

Confidential

Responsibilities:

Design and development of ETL for Business Intelligence (BI) and Enterprise Data Warehouse (EDW) project for the Department of Confidential.
ETL Architect for Other BI & Data Warehousing projects: VHA, USPTO, TSA, DOI.
Managed client relationships, communicated project progress to project sponsors, and facilitated communication between project
Overall responsibility of the data architecture of the data warehouse. Led the development of a Data Warehouse Bus Architecture consisting of integrated data marts using dimensional data models (star schemas).
Design and develop ETL workflows and mappings using Informatica.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship