Associate Technical Architect

• Strong experience with SQL Development/NZSQL including Stored Procedures
• Must have strong experience with advanced SQL development and SQL optimization .
• Must have used external table, NZLOAD for file loading and unloading
• Experience on Materialized views, CBTs
• Worked in AWS Redshift development or Netezza for at least 2-3 years
• Strong on Unix/Linux Shell Scripting
• Ability to interpret data models (3NF or Kimbal) and code SQL accordingly
• Must have used DevOps - Jenkins, Bitbucket/Git/Sourcetree, Automated Test Scripts using Unix etc.
• Must have strong analytic and problem-solving skills.
• Must have implemented end to end BI DWH application.

Good to Have

• Good to have an understanding of Control M , IBM CDC, EC2 etc.
• Good to have an understanding of AWS S3 , AWS DMS services.
• Good to have an understanding of reporting tools like Tableau or Cognos
• Insurance Domain Knowledge would be an added advantage.
• Good to have experience in Agile ways of working