Overview
Skills
Job Details
Role: Database Applications Developer
Alpharetta, GA Onsite
F2F Interview
Required Skills and Experience:
- Data Modelling & Data Warehousing: Strong understanding of data warehousing concepts, building facts and dimensions, and translating business requirements into a data warehouse.
- SQL: Highly skilled in SQL, including stored procedures, views, and debugging.
- SSIS: Good knowledge of SSIS (SQL Server Integration Services), including storing, deploying, and scheduling packages.
- Snowflake: Ability to query and understand Snowflake.
- Python Scripting: Experience in Python and calling APIs using Python is a plus.
- ETL: Knowledge of ETL is good to have, but heavy ETL knowledge is not required.
- Kafka/Hadoop/Pulsar: Experience is not a big priority.
- Google Cloud Platform: Experience is good to have but not a must.
Interview Process:
- Round 1: Telephonic interview (conducted by Priya).
- Round 2: In-person interview with three or more employees.
- Interview questions will focus on the five key skills mentioned above.
We are looking for a Data platform Engineer to join our growing team of Data platform management. The candidate will be responsible for expanding and optimizing our data and data pipeline architecture, as well as optimizing data flow and collection for cross functional teams. The ideal candidate is an experienced data pipeline builder and data wrangler who enjoys optimizing data systems and building them from the ground up. Possess a high level of energy and passion about data and processes, a self-starter being able to hit the ground running and comfortable supporting the data needs of multiple teams, systems and products.
Responsibilities:
- Data acquisition and ingestion - Identify data sources and build pipelines using various ETL tools such as but not limited to, SSIS, and Alteryx. Data sources including but not limited to SQL Server, Teradata, Hadoop\Hive, PostgreSQL, Oracle and flat files, Google Cloud Platform, Datamodeling , Snowflake.
- Identifying ways to improve data reliability, efficiency and quality by various data solution techniques.
- Experience in Snowflake.
- Strong experience in defining the data architecture framework, standards and principles, including modeling, metadata, security and reference data.
- Create and optimize data models to support various business applications.
- Reviewing modifications of existing data systems for cross-compatibility.
- Automate and support workflows to ensure timely delivery.