MS SQL DEVELOPER Job Vacancy in CGI Inc Chennai, Tamil Nadu – Updated today
Are you looking for a New Job or Looking for better opportunities?
We got a New Job Opening for
Full Details :
Company Name : CGI Inc
Location : Chennai, Tamil Nadu
Position :
Job Description : Position Description:
Works independently under limited supervision and applies knowledge of subject matter in Applications Testing. Possess sufficient knowledge and skills to effectively deal with issues, challenges within field of specialization to test simple applications solutions. Second level professional with direct impact on results and outcome.
Your future duties and responsibilities:
3 – 5 years of experience in Development of high-quality database solutions, using PostgreSQL
Develop, implement and optimize stored procedures and functions using SQL & PL/pgSQL
Review and interpret ongoing business report requirements
Research required data
Analyze existing SQL queries for performance improvements
Develop procedures and scripts for data migration
Familiar with performance tuning such as indexes, partitions, clustering
Familiar with pg extensions – pg_trgm, pg_crypto
Familiar with different indexes – btree, gin, gist
Familiar with JSON data format & in-built Postgres JSON/JSONB functions
Ability to write a complex SQL, given a requirement
Ability to understand & troubleshoot machine-generated SQL code
Install/upgrade PostgreSQL
Familiar with cross-database IDEs – Dbeaver, DBVisualizer, TOAD etc
Familiar with PostgreSQL CLI psql
Familiar with database migrations using Flyway, Liquibase
Familiar with code version control in GitHub
Understanding of REST APIs will be an added advantage
Create SQL views, Common Table Expressions (CTEs) and stored procedures to combine/aggregate data needed for reporting purposes.
Use ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse
Familiarity with Software Engineering development cycle (SDLC)
Ability to communicate and work well in Agile/SAFE/Scrum team-based environment.
T-SQL, Performance tuning, SQL Server SSIS, Reporting Service Qualifications Skills
Reporting and business intelligence tools like Microsoft SQL Server Reporting Services (SSRS) and SAP Crystal Reports
NoSQL database systems, such as MongoDB and CouchDB
Big data technologies like Hadoop and Spark
Cloud services like Amazon AWS and Microsoft Azure The Software Development Life Cycle (SDLC), specifically Scrum and Agile methodology
Required qualifications to be successful in this role:
MS SQL good hands on writing queries , creating Stored procedures, functions, complex joins, creating triggers,
Query optimization, writing efficient queries, partitioning, Query executions plan etc.
Knowledge on managing SQL databases .
Skills:
SQL
SQL Server
SQL Server Management
What you can expect from us:
Build your career with us.
It is an extraordinary time to be in business. As digital transformation continues to accelerate, CGI is at the center of this change—supporting our clients’ digital journeys and offering our professionals exciting career opportunities.
At CGI, our success comes from the talent and commitment of our professionals. As one team, we share the challenges and rewards that come from growing our company, which reinforces our culture of ownership. All of our professionals benefit from the value we collectively create.
Be part of building one of the largest independent technology and business services firms in the world.
Learn more about CGI at www.cgi.com.
No unsolicited agency referrals please.
CGI is an equal opportunity employer.
This post is listed Under Technology
Disclaimer : Hugeshout works to publish latest job info only and is no where responsible for any errors. Users must Research on their own before joining any company