Associate Technical Architect

Job highlights

• . Must Haves . o . Strong experience with SQL Development / NZSQL including Stored Procedures . o . Must have strong experience with advanced SQL development and SQL optimization
• . o . Must have used external table,NZLOAD for file loading and unloading . o . .

Must Haves

o Strong experience with SQL Development/NZSQL including Stored Procedures

o Must have strong experience with advanced SQL development and SQL optimization .

o Must have used external table, NZLOAD for file loading and unloading

o Experience on Materialized views, CBTs

o Worked in AWS Redshift development or Netezza for at least 2-3 years

o Strong on Unix/Linux Shell Scripting

o Ability to interpret data models (3NF or Kimbal) and code SQL accordingly

o Must have used DevOps - Jenkins, Bitbucket/Git/Sourcetree, Automated Test Scripts using Unix etc.

o Must have strong analytic and problem-solving skills.

o Must have implemented end to end BI DWH application.

Good to Have

o Good to have an understanding of Control M , IBM CDC, EC2 etc.

o Good to have an understanding of AWS S3 , AWS DMS services.

o Good to have an understanding of reporting tools like Tableau or Cognos

o Insurance Domain Knowledge would be an added advantage.

o Good to have experience in Agile ways of working