principal data engineer resume example

• Designed and developed ETL packages to build highly complex workflows of data flow to process claims and submit to systems driven by regulatory and compliance purpose.
• Analyze business requirements and various data sources to design and develop SQL Server Integration Service (SSIS) packages.
• Development of ETL Packages for transformations, validations, and derivations. •
• Development of ETL Packages to generate client specific Reports in various file formats including fixed width format, delimited, flat and XML files.
• Development of ETL Packages to process one time and nightly updates to various tables used by downstream applications and processes.
• Increased performance and decreased runtimes of key ETL Processes by converting to PowerShell.
• Modified existing database design to improve system performance and reliability.
• Oversaw change management process to provide database code change guidance to team members.
• Worked extensively on the performance of daily jobs and thus recreated the entire loading process of loading data to achieve performance gain of 40% across different file formats.
• Created TSQL jobs to run at different schedules including Nightly, Monthly and Quarterly. Created and updated stored procedures, materialized views, triggers, and functions.
• Wrote unit and integration tests with the intent of reducing the issues identified during testing and improving the quality of the user stories.
• Collaborated with business and product teams to understand requirements and design detailed engineering solutions.
• Mentored and coached junior team members in using industry standard software engineering methodology and best practices.
• Followed best practices for code development and documented as part of developers COE.

• Analyzed user requirements, business processes, system procedures, and problems to automate processing or improve Existing computer systems, create functional/technical specifications by collaborating with end customers.
• Performed cross platform data extraction and migration (MSSQL, MySQL and Oracle)
• Wrote detailed description of user needs, program functions and steps required to develop or modify complex programs.
• Created detailed design documents and programming specifications.
• Plan and prepare technical reports.
• Extract, Evaluate and Migrate information gathered from multiple sources/applications.
• Collaborated with the Subject Matter Experts to discuss the business process, understand the system to extract the data from the system.
• Created technical specification documents, including data flows, data mappings and review with the team and other stakeholders on the project.
• Created configuration files for scheduling SSIS packages as SQL Agent jobs.
• Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SQL Server Reporting Services (SSRS).
• Created several test scripts documentations for user acceptance testing (UAT).
• Conduct code walkthroughs, and review peer code and managed documentation of standards, best practices, and ETL procedures.
• Analyze business requirements and various data sources to design and develop SQL Server Integration Service (SSIS) packages.
• Performing cleaning operations on the data to create pipe delimited text files.
• Configured SQL Mail agent for sending automated alerts/emails.
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.