Involved in performance improvement process and quality review process and supporting existing down streams and their production load issues. Here are a few tweaks that could improve the score of this resume: 2023, Bold Limited. Worked agile in a team of 4 members and contributed to the backend development of application using microservices architecture. Analysing the current data flow of the 8 Key Marketing Dashboards. Experience in analyzing data using HiveQL, Participate in design meetings for creation of the Data Model and provide guidance on best data architecture practices. Worked in determining various strategies related to data security. Built and maintained data warehousing solutions using Redshift, enabling faster data access and improved reporting capabilities. Constructing the enhancements in Ab Initio, UNIX and Informix. Manage cloud and on-premises solutions for data transfer and storage, Develop Data Marts using Snowflake and Amazon AWS, Evaluate Snowflake Design strategies with S3 (AWS), Conduct internal meetings with various teams to review business requirements. Worked on performance tuning by using explain and collect statistic commands. Reporting errors in error tables to client, rectifying known errors and re-running scripts. Pappas and Snowflake evangelist Kent Grazianoa former data architect himselfteamed up to review the resume and offer comments on how both the candidate and the hiring company might improve their chances. GClaireClaired knClairewledge with the Agile and Waterfall methClairedClairelClairegy in the SClaireftware DevelClairepment Life Cycle. Have excellent quality of adapting to latest technology with analytical, logical and innovative knowledge to provide excellent software solutions. Experience in pythClairen prClairegramming in data transfClairermatiClairen type activities. Created roles and access level privileges and taken care of Snowflake Admin Activity end to end. Extensive experience with shell scripting in the UINX EnvirClairenment. Data extraction from existing database to desired format to be loaded into MongoDB database. Extensively used Integrated Knowledge Module and Loading knowledge module in ODI Interfaces for extracting the data from different source. Experience in extracting the data from azure data factory. Q1. Developed and tuned all the Affiliations received from data sources using Oracle and Informatica and tested with high volume of data. Extensively worked on data migration from on prem to the cloud using Snowflake and AWS S3. Develop & sustain innovative, resilient and developer focused AWS eco-system( platform and tooling). Explore sample code, download tools, and connect with peers. Good knowledge on Snowflake Multi - Cluster architecture and components. Designed and implemented efficient data pipelines (ETLs) in order to integrate data from a variety of sources into Data Warehouse. Design dimensional model, data lake architecture, data vault 2.0 on Snowflake and used Snowflake logical data warehouse for compute. Development of new reports as per the Cisco business requirements which involves changes in the design of ETL and new DB object along with the reports. Fixed the SQL/PLSQL loads whenever scheduled jobs are failed. Consulting on Snowflake Data Platform Solution Architecture, Design, Development and deployment focused to bring the data driven culture across the enterprises. Created tasks to run SQL queries and Stored procedures. Q: Explain Snowflake Cloud Data Warehouse. StrClaireng experience in ExtractiClairen, TransfClairermatiClairen and LClaireading (ETL) data frClairem variClaireus sClaireurces intClaire Data warehClaireuses and Data Marts using InfClairermatica PClairewer Center (RepClairesitClairery Manager, Designer, WClairerkflClairew Manager, WClairerkflClairew MClairenitClairer, Metadata Manager), PClairewer Exchange, PClairewer CClairennect as ETL tClaireClairel Clairen Claireracle, DB2 and SQL Server Databases. View all Glan Management Consultancy jobs- Delhi jobs- SQL Developer jobs in Delhi Salary Search: SQL Server Developer with SSIS salaries in Delhi Actively participated in all phases of the testing life cycle including document reviews and project status meetings. Full-time. Evaluate SnClairewflake Design cClairensideratiClairens fClairer any change in the applicatiClairen, Build the LClairegical and Physical data mClairedel fClairer snClairewflake as per the changes required, Define rClaireles, privileges required tClaire access different database Clairebjects, Define virtual warehClaireuse sizing fClairer SnClairewflake fClairer different type Clairef wClairerklClaireads, Design and cClairede required Database structures and cClairempClairenents, WClairerked Clairen Claireracle Databases, Redshift and SnClairewflakes, WClairerked with clClaireud architect tClaire set up the envirClairenment, LClairead data intClaire snClairewflake tables frClairem the internal stage using SnClairewSQL. Experience in data architecture technologies across cloud platforms e.g. Look for similarities between your employers values and your experience. Created Oracle BI Answers requests, Interactive Dashboard Pages and Prompts. Good working Knowledge of SAP BEX. Involved in End-to-End migration of 80+ Object with 2TB Size from Oracle server to Snowflake, Data moved from Oracle Server to AWS snowflake internal stage with copy options, created roles and access level privileges and taken care of Snowflake Admin Activity end to end. Many factors go into creating a strong resume. Experience in using Snowflake Clone and Time Travel. Eligible Senior ETL Developer Resume displays skills and qualifications such as a broad technical knowledge, analytical mind, good communication and job core skills like good coding language grip, familiarity with coding languages and data warehouse architecture techniques. process. Ability to develop ETL pipelines in and out of data warehouse using combination of Python and Snowflake's SnowSQL 2. As such, it is not owned by us, and it is the user who retains ownership over such content. Worked with Kimball's Data Modeling concepts including data modeling, data marts, dimensional modeling, star and snowflake schema, fact aggregation and dimension tables . Tuning the slow running stored procedures using effective indexes and logic. Created Snowpipe for continuous data load, Used COPY to bulk load the data. Privacy policy Realtime experience with lClaireading data intClaire AWS clClaireud, S2 bucket thrClaireugh infClairermatiClairen. Here are a few tweaks that could improve the score of this resume: By clicking Build your own now, you agree to ourTerms of UseandPrivacy Policy. Unless specifically stated otherwise, such references are not intended to imply any affiliation or association with LiveCareer. 2023, Bold Limited. Involved in converting Hive/SQL quries into Spark transformation using Spark RDDs. Created Different types of Dimensional hierarchies. Preparing data dictionary for the project, developing SSIS packages to load data in the risk database. Involved in the enhancement of the existing logic in the procedures. More. Experience on performance Tuning by implementing aggregate tables, materialized views, table partitions, indexes and managing cache. Performed data quality issue analysis using Snow SQL by building analytical warehouses on Snowflake, Experience with AWS cloud services: EC2, S3, EMR, RDS, Athena, and Glue, Cloned Production data for code modifications and testing, Perform troubleshooting analysis and resolution of critical issues. Data Integration Tool: NiFi, SSIS. Snowflake/NiFi Developer Responsibilities: Involved in Migrating Objects from Teradata to Snowflake. Snowflake Data Engineer Resume 5.00 /5 (Submit Your Rating) Hire Now SUMMARY 12+ years of Professional IT experience with Data warehousing and Business Intelligence background in Designing, Developing, Analysis, Implementation and post implementation support of DWBI applications. Experience in Microsoft Azure cloud components like Azure data factory (ADF), Azure blobs and azure data lakes and azure data bricks. Develop transformation logics using Snowpipe for continuous data loads. Programming Languages: Pl/SQL, Python(pandas),SnowSQL Experience developing ETL, ELT, and Data Warehousing solutions. Designed and developed a scalable data pipeline using Apache Kafka, resulting in a 40% increase in data processing speed. Worked on Cloudera and Hortonworks distribution. Used Toad to verify the counts and results of the graphs and Tuning of Ab Initio graphs for better performance. Cloud Technologies: Lyftron, AWS, Snowflake, RedshiftProfessional Experience, Software Platform & Tools: Talend, MDM, AWS, Snowflake, Bigdata, MS SQL Server 2016, SSIS, C#, Python, Sr. ETL Talend MDM, Snowflake Architect/Developer, Software Platform & Tools: Talend 6.x, MDM,AWS, Snowflake, Bigdata, Jasper, JRXML, Sybase 15.7, Sybase IQ 15.5, Sr. Talend, MDM,Snowflake Architect/Developer, Software Platform & Tools: Talend, MS Visio, MongoDB 3.2.1, ETL, Python, PyMongo, Python Bottle Framework, Java Script, Software Platform & Tools: Sybase, Unix Shell scripting, ESP scheduler, Perl, SSIS, Microsoft SQL server 2014, Software Platform & Tools: ETL, MFT, SQL Server 2012, MS Visio, Erwin, Software Platform & Tools: SQL Server 2007, SSRS, Perl, UNIX, ETL (Informatica), Dot Net(C#), Windows Services, Microsoft Visio, Talk to a Recruitment Specialist Call: (800) 693-8939, © 2023 Hire IT People, Inc. Postman Tutorial for the Snowflake SQL API , Get Started with Snowpark using Python Worksheets , Data Engineering with Apache Airflow, Snowflake & dbt , Get Started with Data Engineering and ML using Python , Get Started with Snowpark for Python and Feast , Build a credit card approval prediction ML workflow . Participates in the development improvement and maintenance of snowflake database applications. Prepared the Test scenarios and Test cases documents and executed the test cases in ClearQuest. Developed Mappings, Sessions, and Workflows to extract, validate, and transform data according to the business rules using Informatica. Prepared ETL standards, naming conventions and wrote ETL flow documentation for Stage, ODS, and Mart. Stored procedures and database objects (Tables, views, triggers etc) development in Sybase 15.0 related to regulatory changes. Experience in Splunk repClairerting system. Very good experience in UNIX shells scripting. Participated in gathering the business requirements, analysis of source systems, design. Developed Talend Bigdata jobs to load heavy volume of data into S3 data lake and then into Redshift data warehouse. Designing application driven architecture to establish the data models to be used in MongoDB database. In-depth knowledge ofData Sharingin Snowflake, Row level, column level security. Creating Conceptual, Logical and physical data model in Visio 2013. Created data sharing between two snowflake accounts (ProdDev). Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions, Created Parameterized Queries, generated Tabular reports, sub-reports, Cross Tabs, Drill down reports using Expressions, Functions, Charts, Maps, Sorting the data, Defining Data sources and Subtotals for the reports. Progressive experience in the field of Big Data Technologies, Software Programming and Developing, which also includes Design, Integration, Maintenance. Need examples? Download your resume, Easy Edit, Print it out and Get it a ready interview! The reverse-chronological resume format is just that all your relevant jobs in reverse-chronological order. In-depth knowledge on Snow SQL queries and working with Teradata SQL, Oracle, PL/SQL. Used the Different Levels of Aggregate Dimensional tables and Aggregate Fact tables. Used Rational Manager and Rational Clear Quest for writing test cases and for logging the defects. Sr. Snowflake Developer Resume 2.00 /5 (Submit Your Rating) Charlotte, NC Hire Now SUMMARY: Total 9+ hands on experience with building product ionized data ingestion and processing pipelines using Java, Spark, Scala etc and also experience in designing and implementing production grade data warehousing solutions on large scale data technologies For example, instead of saying Client communication, go for Communicated with X number of clients weekly. Customized all the dashboards, reports to look and feel as per the business requirements using different analytical views. Best Wishes From MindMajix Team!! 92 Snowflake Developer Resume $100,000 jobs available on Indeed.com. Ensuring the correctness and integrity of data via control file and other validation methods. Enabled analytics teams and users into the Snowflake environment. Cloud Technologies: Snowflake,, SnowSQL, SnowpipeAWS. Created internal and external stage and transformed data during load. Spark, Hive: LLAP, Beeline, Hdfs,MapReduce,Pig,Sqoop,HBase,Oozie,Flume, Hadoop Distributions: Cloudera,Hortonworks. Working with System Integrator consultants at a deep technical level to successfully position and deploy Snowflake in customer environments. Excellent experience Transforming the data in Snowflake into different models using DBT. Strong working exposure and detailed level expertise on methodology of project execution. 4,473 followers. Data validations have been done through information_schema. Unless specifically stated otherwise, such references are not intended to imply any affiliation or association with LiveCareer. Good exposure in cloud storage accounts like AWS S3 bucket, creating separate folders or each environment in S3 and then placing data files for external teams. Click here to download the full version of the annotated resume. Remote in San Francisco, CA. MongoDB installation and configuring three nodes Replica set including one arbiter. If youre in the middle or are generally looking to make your resume feel more modern and personal, go for the combination or hybrid resume format. Expertise with MDM, Dimensional Modelling, Data Architecture, Data Lake & Data Governance. Developing ETL pipelines in and out of data warehouse using Snowflake, SnowSQL Writing SQL queries against Snowflake, Loaded real time streaming data using Snow pipe to Snowflake, Implemented the functions and procedures in snowflake, Extensively worked on Scale out, Scale up and scale down scenarios of Snowflake. Customize this resume with ease using our seamless online resume builder. Involved in creating new stored procedures and optimizing existing queries and stored procedures. Cloud Technologies: Snowflake, AWS. BI: OBIEE, OTBI, OBIA, BI Publisher, TABLEAU, Power BI, Smart View, SSRS, Hyperion (FRS), Cognos, Database: Oracle, SQL Server, DB2, Tera Data and NoSQL, Hyperion Essbase, Operating Systems: Windows 2000, XP, NT, UNIX, MS DOS, Cloud: Microsoft Azure, SQL Azure, AWS, EC2, Red shift, S3, RDS, EMR, Scripting: Java script, VB Script, Python, Shell Scripting, Tools: & Utilities: Microsoft visual Studio, VSS, TFS, SVN, ACCUREV, Eclipse, Toad, Modeling: Kimball, Inmon, Data Vault (Hub & Spoke), Hybrid, Environment: Snowflake, SQL server, Azure Cloud, Azure data factory, Azure blobs,DBT, SQL OBIEE 12C, ODI -12CPower BI, Window 2007 Server, Unix, Oracle (SQL/PLSQL), Environment: Snowflake, AWS, ODI -12C, SQL server, Oracle 12g (SQL/PLSQL).