Responsibilities
4-7 Years of Experience in developing solutions on SQL Server using TSQL, SSIS.
Should have Good Knowledge and implementation on database modelling techniques.
Should have hand on experience on ETL technologies like SSIS
Should have Good work experience on Creation of Sub Queries, Joins, Stored Procedures, Views, Functions, Cursors and Triggers etc.
Good to have Cube development techniques using SSAS. (Optional)
Good to have worked on Partitions, Processing mechanism of cube, modelling concepts of cube. (Optional)
Should have Good work experience on working on recursive Datasets.
Should have good knowledge on Database optimization, Query optimization & Resolving performance issues of the queries.
Should be Good in Analytical thinking and should be able work independently on the assigned task
Should have Good Knowledge on database Deployment process
Should have worked on agile project implementations
Good to have - Able to implement row level security on data and have an understanding of application security layer models in Power BI.
Good to have - Building Reporting solutions with architecture understanding.
Profile required
Good knowledge and experience in designing and implementing technical architecture based on SQL/SSIS/SSAS technologies
Good communication and Good interpersonal skills
Comfortable to work as a team and share information with the teammates
Must have Good Knowledge on SQL Server with T-SQL and SSIS
Good knowledge on SQL Server Analysis service (SSAS) - Optional
Good to have knowledge and experience in power BI / Data Warehouse. Optonal
Able to develop SSIS package Independently using data flow and control flows
Independently design components, develop code and test case scenarios by applying relevant software craftsmanship principles and meet the acceptance criteria.
Complete the assigned learning path. Take part in team ceremonies be it agile practices or chapter meetings.
Deliver on all aspects of Software Development Lifecyle (SDLC) in-line with Agile and IT craftsmanship principles.
Deliver high-quality clean code and design that can be re-used.
Actively, work with other development teams to define and implement API's and rules for data access.
Ensure customers, stakeholders and partners are rightly communicated on time.
Assess production improvement areas such as recurrent issues.
Perform daily checks and maintain required standards and production processes.
Provide suggestions for automating the repetitive and regular production activities.
Perform bug-free release validations and produce metrices, tests and defect reports.
Assist in developing guidelines and ensuring that team practices them.
Ability to perform level 2/level 3 production support
Why join us
We are committed to creating a diverse environment and are proud to be an equal opportunity employer. All qualified applicants receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status”.
Business insight
At Société Générale, we are convinced that people are drivers of change, and that the world of tomorrow will be shaped by all their initiatives, from the smallest to the most ambitious.
Whether you’re joining us for a period of months, years or your entire career, together we can have a positive impact on the future. Creating, daring, innovating and taking action are part of our DNA.
If you too want to be directly involved, grow in a stimulating and caring environment, feel useful on a daily basis and develop or strengthen your expertise, you will feel right at home with us!
Still hesitating?
You should know that our employees can dedicate several days per year to solidarity actions during their working hours, including sponsoring people struggling with their orientation or professional integration, participating in the financial education of young apprentices and sharing their skills with charities. There are many ways to get involved.
We are an equal opportunities employer and we are proud to make diversity a strength for our company. Societe Generale is committed to recognizing and promoting all talents, regardless of their beliefs, age, disability, parental status, ethnic origin, nationality, gender identity, sexual orientation, membership of a political, religious, trade union or minority organisation, or any other characteristic that could be subject to discrimination.