| Remote opportunity for Data Warehouse Developer with Azure at Downey, California, USA |
| Email: [email protected] |
|
From: Raghu, West Advanced Technologies, Inc [email protected] Reply to: [email protected] Hi, My name is Raghu and I am a Staffing Specialist at West Advanced. I am reaching out to you on an exciting job opportunity with one of our clients. Please go through the Job description and let me know if you are comfortable with the requirement. please share you updated resume and let me know the best time to reach you to discuss Job Title: Data Warehouse Developer with Azure Location: Remote, Downey, CA, 90242 Duration: 12 Months LA County PROB Required Skills: The Senior Programmer will possess knowledge and experience in applications software development principles and methods sufficient to participate in the design, development, testing and implementation of new or modified applications software; operating systems installation and configuration procedures; organizations operational environment; software design principles, methods and approaches; principles, methods and procedures for designing, developing, optimizing and integrating new and/or reusable systems components; pertinent government regulations; infrastructure requirements, such as bandwidth and server sizing; database management principles and methodologies, including data structures, data modeling, data warehousing and transaction processing; functionality and operability of the current operating environment; systems engineering concepts and factors such as structured design, supportability, survivability, reliability, scalability and maintainability; optimization concepts and methods; establish and maintain cooperative working relationships with those contacted in the course of the work; and speak and write effectively and prepare effective reports. This classification must have a minimum of seven (7) years of experience in electronic data processing systems study, design, and programming. At least four (4) years of that experience must have been in a lead capacity. This classification requires the possession of a bachelors degree in an IT-related or Engineering field. Additional qualifying experience may be substituted for the required education on a year-for-year basis. Preferred Skills: 1. 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. 2. 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. 3. Ability to design and implement data warehouse data models, including star schema, snowflake schema, and dimension hierarchies for optimized data retrieval and analysis. 4. Understanding of data integration techniques and data quality processes to ensure data accuracy, consistency, and reliability in the data warehouse. 5. Knowledge of data warehouse architecture principles, such as data staging areas, data marts, data lakes, and the overall data flow. 6. Familiarity with data warehouse development methodologies and the ability to apply best practices in building scalable and maintainable data warehouses. 7. Proficiency in scripting languages like Python, Perl, or scripting for automating ETL processes and data manipulation. 8. Understanding of data security principles and compliance regulations to protect sensitive information in the data warehouse. 9. Skills in optimizing data warehouse performance, including query optimization, index creation, and partitioning. 1) 3 years of experience in the past 4 years in working with Oracle database architecture, data modeling, normalization, and performance optimization. 2) 3 years of experience in the past 4 years in working with mainframe databases like IBM DB2 and IMS (Information Management System), including data modeling, database design, and SQL querying. 3) 3 years of experience in the past 4 years in working with Microsoft Azure Cloud platform, including familiarity with other Azure services like Azure Data Lake Storage, Azure Databricks, Azure Data Factory, and Azure DevOps. 4) 3 years of experience in the past 4 years in working with designing and developing data warehouses using other platforms like Microsoft SQL Server, Oracle, or Teradata 5) 3 years of experience in the past 4 years in working with years of experience in big data technologies such as Apache Hadoop, Apache Spark, or Apache Kafka 6) 3 years of experience in the past 4 years in working with data visualization tools like Power BI or Cognos to create insightful visualizations and reports based on data stored in Synapse Data Warehouse. 7) 3 years of experience in the past 4 years in working with data cleansing, data profiling, and data validation techniques to ensure high data integrity in the data warehouse. A Bachelor's or master's degree in computer science. Details Required for Submission Full Legal Name: Phone Number: Email ID: Current Location: Visa Status: Willing to relocate: Best time reach: Availability for the Interview: Thanks & Regards, Raghu Nunna Accounts Manager West Advanced Technologies, Inc [email protected] Serving government agencies for 22 Years www.wati.com Keywords: access management business intelligence information technology golang California Idaho Louisiana Remote opportunity for Data Warehouse Developer with Azure [email protected] |
| [email protected] View All |
| 03:28 AM 04-Apr-24 |