Carla S.
AlpharettaGA

Data Architect | Data Engineer | SQL Developer | ETL Developer

Experienced Data Architect and Developer with extensive experience in data modeling, ETL, and building Data Pipelines. Skilled in Databases, Data Warehousing, Business Intelligence, Amazon Web Services (AWS), and Python. Past projects include: - Migrated data from on prem SQL Server to AWS Redshift - Created data models for data marts, data warehouses, and application databases - Created a custom orchestration engine in AWS for scheduling ETL process flows and defining job dependencies - Created a metadata driven file processing utility in AWS that would validate the arrival of all required files before executing the ETL load into the database - Created metadata driven parsing of Excel Files - Designed and developed the Disaster Recovery plan in AWS for the data pipelines and the data warehouse - Created a data pipeline for near real time processing of tens of thousands of XML files per day and loaded data into the data warehouse - Designed and developed the CICD process in AWS for deploying SQL Scripts and CloudFormation stacks - Perform code reviews for optimizing SQL query efficiency and ensuring best practice and standards are followed - Architect data pipeline specifications for the development team - Created ETL process for loading facts and dimensions in the data warehouse - Created metadata driven SSIS Package generation utilizing BIMLScript, allowing for updating hundreds of SSIS packages at once.
Skills

Skills

  • SQL Programming
  • AWS CloudFormation
  • Amazon DynamoDB
  • AWS Glue
  • Database Architecture