About Me
• Professional with 8+ years of experience in Information Technology industry and 4+ years of experience working as a Data Engineer with hands-on in the areas of Database Development, ETL Development, Data modelling, and Big Data technologies.
• Experience with ETL workflow Management via Apache Airflow and in writing the python scripts to implement the workflow.
• Experience on performance tuning of SQL queries by analysing the code, recreating the user driver tables by right Primary Index, scheduled collection of statistics, secondary or various join indexes.
• Have knowledge and experience in fact dimensional modelling (Star schema, Snow flake schema), transactional modelling and SCD
• Have experience in using Relational Data Base Management (RDBMS) systems like Oracle, MS SQL Server, Teradata, DB2 design, MS Access, and database development using SQL, PL/SQL, writing, testing and implementation of triggers, stored procedures, functions, packages, Cursors using PL/SQL.
• Hands on Experience with AWS Snowflake cloud data warehouse and AWS S3 bucket for integrating data from different source systems which includes loading nested JSON formatted data into Snowflake table.
• Experience with Data pipelines, end to end ETL and ELT process for data ingestion and transformation in GCP.
• Experience in integration of Informatica Data Quality (IDQ) with Informatica PowerCenter.
• Experience in Data Mining solutions to various business problems and generating data visualizations using Tableau, Power BI, Alteryx.
• Experience in Data Integration and Data Warehousing using ETL tools like Informatica PowerCenter, AWS Glue, SQL Server Integration Services (SSIS), and Talend.
• Experience in Business Intelligence Solutions with Microsoft SQL Server and using MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
• Experience in utilizing Informatica PowerCenter, Informatica Data Quality (IDQ) as ETL tool for extracting, transforming, loading and cleansing data from various source data inputs to various targets, in batch and real time.
• Experience in working with Amazon Web Services (AWS) cloud and services like Snowflake, SQS, S3, and EC2.
• Experience in design, development, unit testing, integration, debugging and implementation and production support, client interaction and understanding business application, business data flow and data relations.
• Analysed data and provided insights with Python library function like Pandas.
• Worked on AWS Data Pipeline to configure data loads from S3 into Redshift.
• Worked on Data Migration from Teradata to AWS Snowflake Environment using Python and BI tools like Alteryx.
• Experience in moving data between GCP and Azure using Azure Data Factory.
• Developed Python scripts to parse the Flat Files, CSV, XML, JSON files and extract the data from various sources and load the data into data warehouse.
• Worked on JIRA for defect/issues logging & tracking and documented all my work using Confluence.
Hire Remote Developers For Your Project
iT-Outstaffing.com is a reliable Staffing Vendor that provides
Remote
Developers
for your project within 24h on request
Skills description
The “Python” name was borrowed from the TV show called Monthly Python and a language itself was developed in 1990. Python supports different programming modules and packages that promotes modularity and smart code reuse. Python interpreter and standard libraries are fully available for all the major platforms in compiled and original versions.
Python authors were guided by a philosophy of simplicity and immediacy, as an unwavering guarantee of quality. Python’s philosophical paradigm implies a harmony, beauty and an avoiding of excessive complexity. That's why Python is considering as one of the most easiest programming languages and as the very prospective one.
The so-called generation of Python is quite young and very progressive. This is why even highly qualified Python developers are still quite young, but ambitious professionals. Python freelancers have an experience in the complex implementation of dynamic interactive web sites and web applications. Python has no limits, so Full Stack Python developers professionalism is limitless too. AOG offers you to work directly with the Python developer and our managers will help you 24/7!
If HTML is a basis of frontend programming, then the SQL is a key to the deep database programming and managing of almost every existing DBMS. Using this language, you can manage different data, filter and analyze information even in very large volumes.
In general, SQL first appeared in 1974, but it is still widely used by programmers who work with different databases platforms such as MySQL, because of its versatility and uniqueness. Did you know that a well-known Microsoft Access application is also based on the SQL? Yes, SQL is much closer than it seems. It’s everywhere!
Typically, experienced SQL developers are working with multiple platforms and databases systems. It is an incredibly big advantage! You can hire a highly qualified SQL database developer and get an expert advice from him or simply involve him in your project as a BackEnd SQL Freelancer. During one week you can test your candidate and if he will not satisfy you, we will replace him for another one without any difficulties!
