![](https://www.tpiglobalsolutions.com/wp-content/uploads/2022/06/Icon-1024x845.png)
Search Jobs
Browse the latest opportunities at TPI Global.
TPI Global (formerly Tech Providers, Inc.)
https://techproviders.com/wp-content/uploads/2022/06/Logo-Color.png
http://www.tpiglobalsolutions.com
http://www.tpiglobalsolutions.com
true
Azure Data Warehouse Developer
Downey, CA US
Posted: 04/03/2024
2024-04-03
2024-05-08
Job Number: 21947730
Job Description
Azure Data Warehouse Developer
Downey, CA (100% Remote )
12+ Months Contract
Skills Required:
Experience Required:
Education Required:
Downey, CA (100% Remote )
12+ Months Contract
Skills Required:
- Strong understanding of relational database concepts, SQL (Structured Query Language), and data modeling. Knowledge of various databases used in data warehousing, such as Oracle, SQL Server, PostgreSQL, or MySQL.
- Proficiency in ETL tools like Azure Data Factory, Azure Synapse, or Microsoft SSIS (SQL Server Integration Services) to extract data from various sources, transform it to fit the target schema, and load it into the data warehouse.
- Ability to design and implement data warehouse data models, including star schema, snowflake schema, and dimension hierarchies for optimized data retrieval and analysis.
- Understanding of data integration techniques and data quality processes to ensure data accuracy, consistency, and reliability in the data warehouse.
- Knowledge of data warehouse architecture principles, such as data staging areas, data marts, data lakes, and the overall data flow.
- Familiarity with data warehouse development methodologies and the ability to apply best practices in building scalable and maintainable data warehouses.
- Proficiency in scripting languages like Python, Perl, or Shell scripting for automating ETL processes and data manipulation.
- Understanding of data security principles and compliance regulations to protect sensitive information in the data warehouse.
- Skills in optimizing data warehouse performance, including query optimization, index creation, and partitioning.
Experience Required:
- 3 years of experience with Oracle database architecture, data Modeling, normalization, and performance optimization.
- 3 years of experience with mainframe databases like IBM DB2 and IMS (Information Management System), including data Modeling, database design, and SQL querying.
- 3 years of experience with Microsoft Azure Cloud platform, including familiarity with other Azure services like Azure Data Lake Storage, Azure Databricks, Azure Data Factory, and Azure DevOps.
- 3 years of experience with designing and developing data warehouses using other platforms like Microsoft SQL Server, Oracle, or Teradata
- 3 years of experience with years of experience in big data technologies such as Apache Hadoop, Apache Spark, or Apache Kafka
- 3 years of experience with data visualization tools like Power BI or Cognos to create insightful visualizations and reports based on data stored in Synapse Data Warehouse.
- 3 years of experience in working with data cleansing, data profiling, and data validation techniques to ensure high data integrity in the data warehouse.
Education Required:
- This classification requires the possession of a bachelor’s degree in an IT-related or Engineering field. Additional qualifying experience may be substituted for the required education on a year-for-year basis.
Meet Your Recruiter
Share This Job:
Related Jobs:
There are currently no related jobs. Please sign up for Job Alerts.
Loading...
Login to save this search and get notified of similar positions.
About Downey, CA
Ready to take the next step in your career? Explore our job opportunities in the vibrant area around Downey, California. Nestled in Los Angeles County, Downey offers a perfect blend of urban convenience and small-town charm. Known for its rich history, diverse community, and proximity to renowned landmarks like the Columbia Memorial Space Center and the Downey Theatre, this area provides an excellent backdrop for professional growth. From savoring authentic Mexican cuisine to enjoying performances at the Downey Symphony Orchestra, there's something for everyone here. Consider a career in this dynamic region, where opportunities abound and a unique culture awaits. Dive into our listings today and discover your next career move in Downey, California.
Are you sure you want to apply for this job?
Please take a moment to verify your personal information and resume are up-to-date before you apply.