Senior Data Analyst with SQL programming experience. 12+ Needed Irvine, CA Hybrid at Irvine, California, USA |
Email: [email protected] |
Hello Professionals, Role : Senior Data Analyst with SQL programming experience. 12+ Needed Location : Irvine, CA Hybrid onsite Need local candidates only Client : Direct Client Duration: Long Term Contract NO OPT CPT H1BT Manager Notes: Must In-depth SQL programming exp. hands-on coding skill in recent 3-4 years . coding task in Interview . Must have AWS exp . On prem to AWS Migration . Candidate with data lake and redshift is preferred Data Analyst experience. Cognos, Tableau, PowerBI-- Any 2 will work Good Data warehouse and design exp Snowflake Schemas exp required Good Comm Skills JOB DESCRIPTION: Key Responsibilities: Work with Business Analyst to design dimensional model and source to target (ETL) specifications documentation Analyze and understand source data and business processes that may affect the model Analysis of Source system data, including data profiling Creates DDLs for creating/modifying database objects Documents Source to Target ETL Specifications Creates Technical specifications that show data flow process Define and implement data integration strategies, best practices, and standards to ensure data quality, consistency, and integrity. Design and development of ODS Unit test of all ETL development Peer review of ETL development Design and optimize views Experience Required: In depth experience with SQL programming and relational database management systems such as Oracle, Microsoft SQL Server, or DB2 Experience with business intelligence technologies and tools, such as IBM Cognos, Business Objects, Oracle Business Intelligence (OBIEE), and Tableau Expertise in data profiling/analysis Data modelling experience Direct experience working with business and technical users on extracting data quality requirements Excellent problem-solving skills, critical thinking skills and attention to detail Demonstrated ability to work with others from diverse backgrounds. Demonstrated effective communication and interpersonal skills. Demonstrated service orientation skills Demonstrated ability to communicate technical information to technical and non-technical personnel at various levels in the organization Strong organizational skills and Ability to manage multiple priorities and meet project deadlines Thorough knowledge of data management systems, practices, and standards Self-motivated and works independently and as part of a team Ability to work in UCI Science library office (Local candidate) Monday through Friday during working hours Preferred experience: Experience in a higher education environment, especially working with student, employee and financial data Knowledge of and experience with standard data warehousing techniques, data modeling, star and snowflake schema design and implementation, and design patterns Experience in IICS Direct experience implementing data lakes, data virtualization, and/or big data solutions Experience working on agile development projects Knowledge of FERPA, HIPAA and SB1386 Security laws and other legislation governing security of IT activity. Knowledge of Tibco Thanks & Regards, Kumar US IT Sales /Technical Recruiter Email : [email protected] Linkedin: linkedin.com/in/kumar-stonegate/ Stonegate Technologies LLC 4400 Route 9 South Suite 1000, Freehold, NJ, 07728 www.stonegate-tech.com -- Keywords: information technology California New Jersey |
[email protected] View all |
Fri Mar 22 21:14:00 UTC 2024 |