| 20,000+ Fresh Resumes Monthly | |
|
|
| | Click here or scroll down to respond to this candidateCandidate's Name
PHONE NUMBER AVAILABLE EMAIL AVAILABLE LINKEDIN LINK AVAILABLEData engineerSUMMARYA Data Engineer with 8+ years ofprofessional experience in processinglarge scale of data by developing andoptimizing Business Intelligence andData Warehouse functionality withadvanced SQL hands on expertise.Skilled in implementing technologiessuch as Python, Java, ETL and databasehigh availability, disaster recovery andcloud maintenance configuration. Data modelling Database design & modeling Python Development (migrationand data cleansing) ETL development and pipeline Data migration Performance tuningSKILLSLanguage:PythonSQL (PL/SQL, T-SQL) ...JavaDatabases:SnowflakeSQL ServerPostgreSQLMySQLOracleAzure:Azure FunctionAWS:AWS EMRAWS GlueAmazon S3Amazon RedshiftETL:ADFSSISTalendOLAP Cube SSASLinuxJira, ScrumPowerBI & SSRSBig Data:Hadoop, Map Reduce ..Spark, KafkaHBase and HiveTOOLSBitbucket Azure DevOps VSCodeSnowSQL SSMS Toad, Oracle SQLDeveloper SSIS Jupyter NotebookData profiler DSP SSRS SSASPgAdmin Visual Studio GITPROFESSIONAL EXPERIENCETrellance (Tampa, Florida)Data Engineer Mar. 2022 Oct.2023 Implemented ADF pipeline which deals with various types of databases such as Oracle, SQL server, DB2. Involved new design of architecture which make our main product more reliable, performative. Designed and developed migration pipeline based on Azure Data Factory. Developed extensive functional Snowflake Procedures processes as part of ADF pipeline. Converted old C# Ingestion process into Snowflake procedural steps ADF pipeline. Developed various types of validation Snowflake procedures in different languages such as SQL, Java script and Python. Worked Azure DevOps pipeline which automatically creates prod or non-prod Snowflake environment. Tracked and resolved real time clients major incidents with product owners for our system reliability.Rio Tinto (Ulaanbaatar, Mongolia)IT and Data delivery centre in Mongolia for global mining company (Headquarters in London) Data Engineer (Productivity Metric Developer) Jan. 2019 May. 2021 Included a team for agile development through Jira (SDLC). Implemented a serverless architecture using API Gateway, Lambda and Dynamo DB and deployed AWS Lambda code from Amazon S3 buckets. Migrated entire company workload to AWS cloud leveraging EC2 and S3 for efficient scaling, increasing efficiency by 30%. Data ingestion from unstructured data to relational database using Python. Worked on Advanced SQL query, and Designed data modeling. Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform, and load data from different sources like Azure SQL, Blob storage, Azure SQL Data warehouse, write-back tool and backwards. Provided data cleansing and quality using Python. Built any in-house development on Python.Information Technology Center in General Department of Taxation (Ulaanbaatar, Mongolia)Database Developer Aug. 2016 - Jan 2019 Created extensive PL/SQL and T-SQL queries (OLAP & OLTP) for monthly billing process. Configured indexing, partitioning and replication for database high availability. Optimized DB and SQL Query for effective system usage and DB performance. Developed Java jar for database maintenance and migration. Deployed necessary procedures, functions, and triggers on Database /Oracle and MSSQL/ Designed physical database schema and modelled data. Taken RMAN actions for Oracle and MSSQL database backup and export, import tasks. Monitoring database backup, export, and import with disaster recovery plan with database replication.Java Backend Developer Jul. 2014 Aug. 2016 Used RESTful web services to expose certain functionalities of the application. Used Spring Dependency Injection feature for Bean wiring. EDUCATIONMaster of Science in Computer ScienceMaharishi International University, Fairfield, Iowa (May.2021 June 2023) Master of Engineering in Space Technology Applications Beihang University, Beijing, China (Sep.2012 Jul.2014) Bachelor of Science in Software EngineeringNational University of Mongolia, Ulaanbaatar, Mongolia (Sep.2007 Jun.2011) |