For more details, please connect with Kajal Verma at [email protected] or call at 609-564-2786.
End Client: State of New York
Job Title: Database Architect
Duration: 30 Months
Location: Albany, NY 12257 Hybrid
Position Type: Full-Time Contract
Hours Per Week: 40 Hours Per Week
Interview Type: Webcasting
Ceipal ID: SNY_DATA596_KV
Job Code: HBITS-08-14596
Department: Department of Financial Services
Job Title: Database Architect
Duration: 30 Months
Location: Albany, NY 12257 Hybrid
Position Type: Full-Time Contract
Hours Per Week: 40 Hours Per Week
Interview Type: Webcasting
Ceipal ID: SNY_DATA596_KV
Job Code: HBITS-08-14596
Department: Department of Financial Services
Scope of Project
Database Architect is expected to design data infrastructure to extract and organize Department of Financial Services' enterprise data systems, bridges the gap between business needs and complex technology, ensures Department of Financial Services' data is secure, highly available, scalable, and compliant with New York State policies and regulations.
Responsibilities:
- Monitor DFS Snowflake credit usage, adjust resource monitors, and tune virtual warehouses
- Manage Snowflake users and roles, enforce security policies, audit Snowflake access
- Write and tune SQL queries, build Snowflake ELT pipelines, manage compute and cost, and configure security and governance
- Build and update Informatica mappings and configure workflows.
- Perform unit testing and validate data integrity
- Troubleshoot failures, tune performance
- Documentation ETL process, security policies, system architecture, user guides and etc.
Required Skills:
- 84 Months Experience in Snowflake data warehouse development and administration.
- 84 Months Experience in Snowflake performance tuning and improvement.
- 84 Months Experience in Informatica pipeline development and data transformation.
- 84 Months Experience in Informatica performance tuning and improvement.
- 84 Months Experience in RDBMS (Relational Database Management System) and SQL Query development.
- 48 Months Experience in solution architecture & modeling.
- 84 Months Experience in database and platform security & governance.
- 84+ months: Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.
V Group Inc. is a NJ-based IT Services and Products Company with its business strategically categorized in various Business Units including Public Sector, Enterprise Solutions, Professional Services, Ecommerce, Projects, and Products. Within Public Sector business unit, we cater IT Professional Services to Federal, State and Local. We have multiple awards/ contracts with 30+ states, including but not limited to NY, CA, FL, GA, MD, MI, NC, OH, OR, CO, CT, TN, PA, TX, VA, NM, VT, and WA.
If you are considering applying for a position with V Group, or in partnering with us on a position, please feel free to contact me for any questions you may have regarding our services and the advantages we can offer you as a consultant.
Please share my contact information with others working in Information Technology.
Website: https://www.vgroupinc.com/publicsector
LinkedIn: https://www.linkedin.com/company/v-group/
Facebook: https://www.facebook.com/VGroupIT
Twitter: https://www.twitter.com/vgroupinc
Sign in
To continue your applicationor continue with email
By continuing you agree to our Terms & Privacy Policy.
Similar jobs
Show more