Menu

Application Architect

at Genesis Corp dba Genesis10 in Chicago, Illinois, United States

Job Description

Genesis10 is currently seeking an Application Architect with our client in the financial industry located in Chicago, IL, Plano, TX, Richmond, VA, Phoenix, AZ and Kennesaw, GA. This is a 12 + month contract position.

Responsibilities:
Allow program to meet delivery targets
Provide Actionable Informational Dashboards to our TI and Business Partners
Responsible for developing / maintain TSQL code
Responsible for creating the table structures and will process data that is required to meet a critical reporting need within the technology group
Requirements:
Experience in MS SQL database developer
7+ years of experience as MS SQL / TSQL Developer with stored procedures, views, triggers, cursors, tables, and index creation
Experience with Autosys, BIDS/SSIS, TFS, Bit Bucket, C# and familiarity with object-oriented database design and development
Experience in database and query optimization will be important
Familiarity with IT Infrastructure management domain
Good communication and documentation skills
Solid understanding of data architecture, efficient database design, writing complex queries and query tuning and troubleshooting
Understand requirements provided by Business Analysts and writing ETL programs to source data from upstream database systems as well as data sourced with various file formats such xml, csv etc.
7+ years' fulltime experience in MS SQL development
MSSQL Server 2012 or higher
SSIS (SQL Server Integration Services)
Bit Bucket
Data Analysis
Writing complex queries and query tuning and troubleshooting
Ability to write complex stored procedures, functions as well as support/enhance existing
Ability to create/modify database schema, tables, indexes, etc.
Knowledge of Indexes, cursors, triggers
Experience working with partitioned tables and other database design patterns
SQL Database backup, restore experience with working knowledge of log shipping, log mirroring
SQL code optimization, tuning with ability to work with large datasets
Extensive knowledge of Data transformation and validation
ETL Processing (Autosys Preferred)
DevOps/Database Release Automation
C# scripting, Tableau, SSRS (SQL Server Reporting Services)
Infrastructure or Product life cycle management domain knowledge
Pay Range: $63.68 - $71.68

Only candidates available and ready to work directly as Genesis10 employees will be considered for this position.

If you have the described qualifications and are interested in this exciting opportunity, please apply!

About Genesis10:
Ranked a Top Staffing Firm in the U.S. by Staffing Industry Analysts for six consecutive years, Genesis10 puts thousands of consultants and employees to work across the United States every year in contract, contract-for-hire, and permanent placement roles. With more than 300 active clients, Genesis10 provides access to many of the Fortune 100 firms and a variety of mid-market organizations across the full spectrum of industry verticals.

For contract roles, Genesis10 offers the benefits listed below. If this is a perm-placement opportunity, our recruiter can talk you through the unique benefits offered for that particular client. Benefits of Working with Genesis10:
* Access to hundreds of clients, most who have been working with Genesis10 for 5-20+ years.
* The opportunity to have a career-home in Genesis10; many of our consultants have been working exclusively with Genesis10 for years.
* Access to an experienced, caring recruiting team (more than 7 years of experience, on average.)
* Behavioral Health Platform
* Medical, Dental, Vision
* Health Savings Account
* Voluntary Hospital Indemnity (Critical Illness & Accident)
* Voluntary Term Life Insurance
* 401K
* Sick Pay (for applicable states/municipalities)
* Commuter Benefits (Dallas, NYC, SF)
* Remote opportunities available
For multiple years running, Genesis10 has been recognized as a Top Staffing Firm in the U.S., as a Best Company for Work-Life Balance, as a Best Company for Career Growth, for Diversity, and for Leadership, amongst others. To learn more and to view all our available career opportunities, please visit us at our website.

Genesis10 is an Equal Opportunity Employer. Candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

Genesis10 is an Equal Opportunity Employer/Minorities/Female/Disabled/Veteran

Copy Link

Job Posting: 11986825

Posted On: Jun 18, 2024

Updated On: Jul 11, 2024

Please Wait ...