Senior Technical Lead

Senior Data Engineer

Senior Data Engineer at Actively Seeking New Career OpportunitiesAchievements:• Obtained trainings on Airflow and Dbt Labs• Obtained Google Cloud Certification in Introduction to Generative AI• Obtained Google Cloud Certification in Generative AI for Developers• Obtained AWS Certification in Solutions Architect AssociateNote: Took gap to pursuit a different work visa in USA. Moving back to India from USA.

Client: Leading US Automobile Manufacturer, Auburn Hills, MI, USADepartment: Product Development AnalyticsRole: Data Insight Specialist (On-Site, Michigan, USA)Responsibilities• Analyzing the business needs, define the data processes & documenting them.• Supporting deep dive into various existing analytics and assisting in identification of the right data sources.• Analyzing the data from various sources and understanding the relationship among them.• Interacting… Show more Client: Leading US Automobile Manufacturer, Auburn Hills, MI, USADepartment: Product Development AnalyticsRole: Data Insight Specialist (On-Site, Michigan, USA)Responsibilities• Analyzing the business needs, define the data processes & documenting them.• Supporting deep dive into various existing analytics and assisting in identification of the right data sources.• Analyzing the data from various sources and understanding the relationship among them.• Interacting with various development teams to create and maintain data process & the data analytics.• Supporting data loading, cleaning, processing & transforming.• Acquiring data from primary and secondary sources and maintain data systems.• Filtering, cleaning & transforming data.• Identifying, analyzing and interpreting trends or patterns in complex data sets.• Analyzing data and creating reports.• Coordinating with the Business Users on the finalization of the Actual KPIs.• Coordinating and directing offshore team to build solutions.• Implementing and following a Scrum Agile development methodology within the cross functional team.• Acting as a liaison between the business user group and the technical team.• Developing web reports to deliver relevant and meaningful data to customers.• Creating design guidelines and ensuring adherence and design consistency across multiple reports.• Collecting and using analytics feedback for reports to improve usability and user experience.• Integrating with software to create customized reports, graphs, charts, and tables based on available data• Building and maintaining applications.• Ensuring that the application under development confines to the business requirement.• Locating and defining new process improvement opportunities. Show less

Client: Leading US Automobile Manufacturer, Auburn Hills, MI, USADepartment: Powertrain Engineering / PropulsionRole: Senior Data Engineer (On-Site, Michigan, USA)Responsibilities• Understanding business requirement and evaluating the changes and system dependencies.• Construction of high level and low-level designs and documenting them.• Creation, maintenance, and optimization of data pipelines that extract, transform, and load (ETL) data from various… Show more Client: Leading US Automobile Manufacturer, Auburn Hills, MI, USADepartment: Powertrain Engineering / PropulsionRole: Senior Data Engineer (On-Site, Michigan, USA)Responsibilities• Understanding business requirement and evaluating the changes and system dependencies.• Construction of high level and low-level designs and documenting them.• Creation, maintenance, and optimization of data pipelines that extract, transform, and load (ETL) data from various sources.• Design the architecture of databases and data systems, considering factors like scalability, performance, and reliability. • Design and implement data models to organize and structure data effectively, ensuring that data is stored in a way that supports efficient querying and analysis.• Integrate data from different sources, which may include databases, APIs, logs, and external data feeds. • Implement processes and systems to monitor and maintain data quality, including data validation, cleansing, and error handling. • Optimize data pipelines and systems for performance and efficiency, tuning database configurations, query optimization, and implementing caching mechanisms.• Implement security measures to protect data against unauthorized access, ensuring compliance with relevant regulations such as HIPAA, or industry-specific standards.• Monitor data pipelines and systems for issues such as bottlenecks, failures, or data inconsistencies. Troubleshoot and resolve these issues promptly to minimize downtime and data loss.• Document data processes, systems, and architectures, making it easier for team members to understand and collaborate. Collaborate with data scientists, analysts, and other stakeholders.• Stay updated with emerging technologies, tools, and best practices in data engineering. • Innovating to design and to solve business problem associated with business changes. • Creating and supporting data reports and dashboards to assist the client with business analytics. Show less

Client: Leading US Automobile ManufacturerDepartment: After Sales (Parts & Services)Role: Data Engineer / Web Developer (Off-Shore, Mumbai, India)Responsibilities• Understanding business requirement and evaluating the changes and system dependencies.• Construction of high level and low-level designs and documenting them.• Creation, maintenance, and optimization of data pipelines that extract, transform, and load (ETL) data from various sources.• Integrate data… Show more Client: Leading US Automobile ManufacturerDepartment: After Sales (Parts & Services)Role: Data Engineer / Web Developer (Off-Shore, Mumbai, India)Responsibilities• Understanding business requirement and evaluating the changes and system dependencies.• Construction of high level and low-level designs and documenting them.• Creation, maintenance, and optimization of data pipelines that extract, transform, and load (ETL) data from various sources.• Integrate data from different sources, which may include databases, APIs, logs, and external data feeds. Ensure that data is consolidated and standardized for analysis purposes.• Implement processes and systems to monitor and maintain data quality, including data validation, cleansing, and error handling. • Optimize data pipelines and systems for performance and efficiency, tuning database configurations, query optimization, and implementing caching mechanisms.• Monitor data pipelines and systems for issues such as bottlenecks, failures, or data inconsistencies. Troubleshoot and resolve these issues promptly to minimize downtime and data loss.• Document data processes, systems, and architectures, making it easier for team members to understand and collaborate.• Development of interfaces using different architectures and technologies to provide best in class solutions.• Conducting testing of scripts and software application to test availability and performance of applications.• Reviewing the developed code against set standard while optimizing the design to ensure application performance. • Providing application support to the customers when they run into issues by investigating & resolving the issues.• Updating the User Manual document with changes being made to the application. • Innovating to design and to solve business problem associated with business changes. • Creating and supporting data reports and dashboards to assist the client with business analytics. Show less