ETL Consultant Downey CA (Remote) Duration: 12 months Skills Required The Informatics Data Analyst will possess knowledge and experience in basic statistical concepts; identifying the trends, business opportunities, and relevant issues; commonly-used demographics and databases; definitions of fields and how data is entered and processed; data mining/intelligence; statistically-valid analysis and measurement methodologies; packaging data - infographics and other data display techniques, and report design options; data interpretation and validation; Ad Hoc analysis/performance evaluation principles; common demographic data bases; SQL coding and report services; data warehouse design; web-based application design; PC skills (e.g.
Microsoft Office, Word, Excel, PowerPoint, SAS, Access and Excel); working independently as well as a leadership role in creating process documentation and interfacing with other team members to obtain this information; detailed-oriented; excellent interpersonal, oral and written communication skills; ability to handle multiple tasks; and problem solving and troubleshooting skills.
Skills Preferred 1.
Understand the architecture, data warehousing concepts, and components like SQL Pools, Apache Spark pools, and Data Flow.
2.
Strong knowledge of SQL for data extraction, transformation, and loading (ETL) tasks, including complex querying, stored procedures, views, and indexing.
3.
Proficiency in designing and implementing efficient data models for data warehousing, including dimensional modeling techniques such as star and snowflake schemas.
4.
Familiarity with programming languages like Python or Scala for data processing, analytics, and automation tasks in Azure Synapse Analytics.
5.
Understanding of various data integration methods, including data ingestion from different sources, data replication, and data synchronization techniques.
6.
Ability to optimize query performance and data processing in Azure Synapse Analytics through techniques like partitioning, indexing, and query optimization.
Experience Required This classification must have a minimum of two (2) years of experience in processing, management, and retrieval of information.
Experience Preferred 1.
Having 2 to 4 years experience 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.
2.
Having 2 to 4 years experience in designing and developing data warehouses using other platforms like Microsoft SQL Server, Oracle, or Teradata can be valuable in understanding data warehousing concepts and best practices 3.
Having 2 to 4 years experience in big data technologies such as Apache Hadoop, Apache Spark, or Apache Kafka can be beneficial, as they integrate with Azure Synapse Analytics and enable large-scale data processing and analytics.
4.
Having 2 to 4 years of experience in data visualization tools like Power BI or Tableau to create insightful visualizations and reports based on data stored in Synapse Data Warehouse.
5.
Having 2 to 4 years experience in 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.
Education Preferred A Bachelor's or Master's degree in Computer Science, Information Technology, or a related field is typically required.
Regards Sunil Damagalla West Advanced Technologies, Inc E: sunil.dwati.com D: 279-666-5837