Industry Experience: 2 Year+
Desired Skills:
• Modelling Tools - Erwin, Power Designer, MS Visio • Scripting Languages - PL/SQL, T-SQL, R, Power Query, DAX, MDX • Business Objects (OLAP): Business Object, BO Supervisor, Designer, Reporter and Web Intelligence • MapReduce, Pig & Python • ETL Tools – BODS, Informatica SQL Analyzer – SQL, PL-SQL • Database Technologies - Oracle, DB2, Netezza, SQL Server, HDFS, HBase, Hive, Impala • Algorithms Development / Problem Solving and Data Flow Resolutions using Programming languages like Python database scripting languages.
Desired Experience:
• Experience in data Processing with also experience in designing and implementing Data Mart applications, mainly transformation processes using ETL tools. • Experience of working on medium to large size data warehousing development or data reporting and MI life cycle projects. • Experience of working on data migration projects, or been involved in supporting data side of the migration’s life cycles. • Some experience with ETL methodology for designing and developing extraction, transformation and load processes in dynamic, high-volume data environments. • Experience of modelling of Databases for data warehouse implementing Star Schema and Snow Flake Schema. • Experience in code specifications and OLAP Analysis and Design. • Experience of using Business Object and creation of Universes, creation of reports and Info views • Knowledge and experience of SSIS / SSRS / SSAS • Experience of solving technical problems related to data. • Experience with data profiling and data classification exercise • Experience in Data cleanse approach and tools, automation of the manual data cleanse logics. • Experience of analysing data sets to determine optimal way to aggregate and report on it.
Qualifications:
Bachelor Degree (preferred in Computer Science or Mathematics or Statistics) or A Levels with Mathematics with a Certificate or Diploma in Structures Programming Languages or Relational or Non-SQL Databases.
Duties:
• Work on data centric projects, like Data Migrations or Data Cleanse Projects. • To automate the data cleanse routines or to automate the data generation as required for projects during data migrations, or testing and performance testing scenarios. • To work with Architects & Solution Designers to understand the detail of the designed solutions and develop the data requirements using different programming languages and tools. • Working on data obfuscation and data de-duping as per project requirements. • To work closely with Data scientists and Data analysts for development of the data sets they need for their research and investigations. • Assist Data science team with development of solution logics and algorithms for given data problems. • Using programming scripting and tools, automating and reducing the manual effort of data entry process and working on data loads. • To liaise with Project Manager and PMO team and follow the task timelines and report progress and delays. • Highlight any risk and issues to development completion timelines to PMO team. • To work with co-team members and developers and support System Integration Testing. • Unit Testing the Code fixing the data-oriented defects identified during SIT and UAT and other testing phases. (important one)
