Job description:
role: lead data engineerlocation: remoteduration: long term 8 to 10 years of experience working in data engineering, business intelligence or related field delivering large scale data platforms and services. ideal candidate will have the following skills: a successful history of manipulating, processing and extracting value from large, disconnected datasets. expertise in data modeling, data access and data storage techniques. the candidate should have foundational knowledge of dimensional modeling to build a data warehouse strong experience building transformational logic using sql on relational sql and nosql databases. skills using dbt framework for data transformation is plus robust programming skills and strong experience with python to ingest, transform and load the data experience building and optimizing big data data pipelines, architectures and data sets using tools like airflow. experience with aws cloud services: ec2, emr, rds, redshift

Resume:
<<summarypractical database engineer possessing in-depth knowledge of data manipulation techniques and computer programming paired with expertise in integrating and implementing new software packages and new products into system. offering 12-year background managing various aspects of development, design and delivery of database solutions. tech-savvy and independent professional bringing outstanding communication and organizational abilities. hardworking and reliable data engineer with strong ability in building data pipelines. highly organized, proactive and punctual with team-oriented mentality. skills requirements gatheringanalysis and modelingdata warehousingsql reportingbusiness intelligencedata managementmicrosoft sqldatabase analysissql tuningcritical thinking experience senior data engineer, 12/2017-currentsplunk– ,adept in troubleshooting and identifying current issues and providing effective solutions.managed performance monitoring and tuning while identifying and repairing issues within database realm.worked as part of project teams to coordinate database development and determine project scopes and limitations.trained non-technical users and answered technical support questions.collected, outlined and refined requirements, led design processes and oversaw project progress.created conceptual, logical and physical data models for use in different business areas.wrote and coded logical and physical database descriptions, specifying identifiers of database to management systems.applied conceptual, logical and physical & dimensional/relational model designs to etl tasks.managed end-to-end operations of etl data pipelines, maintaining uptime of 95%.assisted in user acceptance testing for accounting/marketing users, verifying etl jobs complied with assigned parameters, achieving desired results.worked successfully with diverse group of coworkers to accomplish goals and address issues related to our products and services.worked closely with team members to deliver project requirements, develop solutions and meet deadlines.senior database consultant, 02/2013- 12/2017amazon.com, inc.– ,created informatica mappings/etl’s usinginformatica power centerto load the data from oracle, mysql databases to sql server 2016 databases hosted on aws cloud.performed the data manipulations using variousinformaticatransformations like expression, lookup, update strategy, router and sql transformation.designedinformaticaworkflows with many sessions with event with task, event raise task and email task. scheduled the created workflows/jobs usinginformatica scheduler.created multiplet-sqlobjects mainly stored procedures and functions for new and existing software application requirements.created multiple linked servers for ease of the users to execute commands on remote servers.developed new code and fine-tuned existing stored procedures to improve performance while utilizing the sql server profiler and database engine tuning wizard.created ssis packages to migrate data from legacy systems such as oracle, vertica, sql server, flat files to centralized it destination. created ssis packages utilizing different ssis transformations likescript component, merge join, look upand implemented error handling and logging.performed unit testing and qa testing at various levels of the etl’s and actively involved in team code reviews.developed report models using report builder and distributed reports in multiple formats using sql server reporting services (ssrs) in business intelligence development studio (bids) and sql server data tools(ssdt). createdparameterized, cascaded, drill-down, cross-tab and drill-through reportsusing ssrs 2008 r2/2012.created ad hoc queries in t-sql, stored procedures and views to store the data of third parties, and use them in ssrs reports to generate reports on the fly. worked with multivalued parameters for parameterized reports in ssrs.developed vba scripts for periodic financial (daily, weekly) reports generated directly from excel utilizing power pivot options in excel.managed report delivery based ontime driven and data driven subscriptionsandreport securityfor providing ssrs reportserver level, folder level and item levelpermissions to various users across the organization based on role based access control(rbac).worked on resolving any performance issues with ssis packages and ssrs reports and fine tune them for better performance.worked on cleaning up users on sql server and audit the access level. revoke inappropriate access, setting up ad groups and grant access based on the created groups.worked on databaseperformanceandmaintenancedutiessuch astuning,backup,restoration.provide on-call support for production job failures. resolve and close the time critical incidents in an appropriate way. perform root cause analysis, create problem report and work on any subsequent code changes to stop them from re-occurring.database consultant, 08/2011- 02/2013amazon.com, inc.– ,involved in gathering business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.usingt-sqlcreated complexstored procedures, functions, cursors, tables, and viewsand used other sql joins and statements for applications in sql server 2005/2008.developed standalonessispackages to extract data from different sources likesql server, flat files, excel, oracle, and sybasetransform and load the data onto required databases.usingssistransformations filtered bad data from different sources usingderived column, lookup, fuzzy lookup and conditional split.involved in creation of technical specs, design documents, implementation documents, and unit testing/test case /test plan documents and maintained issue logs.using script component inssiswrotec#.netcode to generate dynamic file names and create a text files. debugged and verified the values getting stored invariablesin run-time usingc#code.created dynamicssispackages through variables and script task components (c # and vb.net) and scheduled the packages using sql server agent to process and load the data.scheduled the package based on the enterprise calendar through sql server agent. created several one-time and recurring jobs for package scheduling.created xml file for package configurations and implemented parent-child package configuration inssispackages. implemented error and event handling: precedence constraints, break points, data grid and logging inssispackages.usingssrsdeveloped multiple types of reports including sub reports, parameterized and drill down reports using global variables, expressions and functions based on the requirements provided.deployedssrs.rdl reports on to the report server and created time driven subscriptions on the deployed reports.created cubes with multiple fact measures groups, and multiple dimension hierarchies based on the reporting needs usingssas.modified existing dimensions and created new dimensions as per new business requirements.created gui interfaces using c#.net and .net framework to simplify the database access to end business users. enhanced existing gui interfaces based on new requirements and improved efficiency.resolved and closed production incident tickets generated because of failure of daily jobs. education and trainingmaster of science:electrical engineering,expected in 01/2011-california state university - sacramento-sacramento,cagpa:status-.