Data Engineer Senior

SUMMARY

A seasoned data engineer with **+ years of experience in full life-cycle ETL/ELT development, specializing in Snowflake cloud data analytics, modern data warehousing, and data transformation. Expertise spans across industries such as Manufacturing, Financial Services, Healthcare, and Consumer Goods. Proven ability to manage and optimize critical production systems, ensuring high data quality, integrity, and operational continuity.

Skilled in OLAP data modeling, relational databases, and BI reporting tools (Qlik, OBIEE). Proficient with ETL tools including Talend and Informatica PowerCenter, and experienced with relational databases such as Oracle 11g and SQL Server. Adept at working both independently and collaboratively with cross-functional teams to design, implement, and support complex ETL processes, ensuring seamless data flows from source systems to analytics and reporting platforms.

PROFESSIONAL EXPERIENCE

SKF USA Inc. – Senior Data Engineer

2019 - Present

As a Senior Data Engineer, I focus on designing and developing scalable, reliable data solutions, particularly around data pipelines and cloud technologies. My role involves working with Snowflake, DBT, AWS S3, and SQL Server to create efficient data warehouse architectures and maintain operational continuity for critical data systems.

Partner with the visualization team to support Qlik development and OLTP data modeling.

Work closely with the technical and business teams to understand their requirements, perform detailed analysis, design the appropriate solutions and implement them within the agreed timelines.

Create and maintain documentation of data ingestion processes, transformation rules and ETL workflows.

Automated and orchestrated workflows using Windows batch scripts, SQL Server Agent jobs, and Power Automate to streamline email-based data ingestion from distributors.

Solely responsible for managing and delivering accurate COGS data from distributors, crucial for sales managers' incentive compensation.

Collaborated with business users to troubleshoot and resolve critical production issues in a timely manner.

Developed and maintained code using Visual Studio Code with version control and team collaboration via Git and GitHub repositories.

Vivimed Labs USA, Inc. – Executive Director

May 2016 – 2018

Led US operations for an India-based specialty chemicals and pharmaceuticals manufacturer. Oversaw the setup of a startup Biotech plant and managed business strategies for the US market. Played a key role in driving operational excellence and fostering growth in both B2B and B2C sectors.

United Health Care/Optum – Senior ETL Architect

2005 - 2016

Designed, developed, and implemented complex ETL processes for multiple data sources, including Siebel Contact Center and external flat files, to support the Siebel Analytics data warehouse. Led efforts to ensure data integrity, reporting accuracy, and alignment with business goals.

Developed ETL architecture and implemented Informatica Mappings and Workflows to load facts and dimension tables into the data warehouse.

Led the creation of financial services BI initiatives, supporting business reporting and analytics requirements.

Wrote and maintained technical design documentation and source-to-target mappings for data transformation processes.

Managed ETL deployment and performed administrative tasks such as security administration and backup/restore processes within Informatica.

Delivered end-user support and training for OBIEE reports, dashboards, and performance monitoring.

Led troubleshooting efforts for complex production issues, ensuring minimal disruption to business operations.

Wyeth Pharmaceuticals – Sr. Consultant

2004 - 2005

Validated integrated physician data systems for compliance with CFR 21 Part 11. Developed validation scripts and processes using Informatica Mappings and workflows, PL/SQL, and Unix Shell Scripts.

Created complex validation scripts to ensure regulatory compliance and data integrity across systems.

Developed stored procedures, functions, and packages for data extraction and transformation.

M&M Mars Inc. – Sr. Consultant/Team Lead

2002 - 2004

Led a global data integration project for Siebel eConsumer Goods, designing and developing interfaces for Accounts, Products, Pricelists, and Shipments. Involved in the migration from Siebel 6.0.4 to Siebel 7.5.2.

Designed Informatica PowerCenter mappings and EIM configuration files for importing data from multiple global regions.

Wrote Unix shell scripts to extract source data from MQ Series, streamlining data loading processes.

Led a migration project, ensuring the seamless transition of critical data between Siebel versions.

KEY SKILLS & TECHNOLOGIES

ETL Tools: Talend, Informatica PowerCenter

Cloud Platforms: Snowflake, AWS S3, DBT

Databases: Oracle 11g, SQL Server

BI & Reporting: Qlik, OBIEE

Programming & Scripting: PL/SQL, Unix Shell Scripts, Windows batch scripting

Data Modeling: OLAP, Relational Databases, Dimensional Modeling

Project Management: Cross-functional team leadership, Agile methodologies

EDUCATION

Master of Science – Computer and Information Sciences

Temple University, Philadelphia

Bachelor of Engineering – Electrical Engineering

Osmania University, India

Contact this candidate