Technology Leadership – Independently he/she should be able to design, implement deliver complex Data Warehousing/Data Lake, Cloud Data Management and Data Integration project assignments.
Technical Design and Development – Expertise in any of the following skills.
Any of the ETL tools (Informatica, IICS, Matillion, Data Stage), and hosting technologies like the AWS stack (Redshift, EC2) is mandatory.
Any of the BI tools among Tablau, Qlik & Power BI and MSTR.
Informatica MDM, Customer Data Management.
Expert knowledge of SQL with the capability to performance tune complex SQL queries in tradition and distributed RDDMS systems is must. Experience across Python, PySpark and Unix/Linux Shell Scripting.
Project Management is must to have. Should be able create simple to complex project plans in Microsoft Project Plan and think in advance about potential risks and mitigation plans as per project plan.
Task Management – Should be able to onboard team on the project plan and delegate tasks to accomplish milestones as per plan. Should be comfortable in discussing and prioritizing work items with team members in an onshore-offshore model.
Handle Client Relationship – Manage client communication and client expectations independently or with support of reporting manager. Should be able to deliver results back to the Client as per plan.
Education Bachelor Equivalent - OtherPG Diploma in ManagementWork ExperienceWe are hiring for following roles across Data management tech stacks -
ETL-Snowflake/AWS /IICS-5- 8 years of experience in ETL tools -IICS, Redshift, Snowflake. Strong experience in AWS/Snowflake technologies- Redshift / Synapse/ Snowflake .Experienced in running an end-to-end ETL project and interacting with users globally. Has good knowledge of DW architectural principles and ETL mapping, transformation, workflow designing, batch script development.
Python/ PySpark - Expert in Python and should be able to efficiently use Python data-science and math packages such as NumPy, Pandas, and Scikit-learn/ Python web framework.Deep experience in developing data processing tasks using pySpark such as reading data from external sources, merge data, perform data enrichment and load in to target data destinations.Prior experience with Redshift / Synapse / Snowflake.
AWS Infra Architect - 10-15 years of experience as an AWS Cloud Infrastructure administrator role, AWS Cloud Architect, or Solution Architect.2-3 years of experience as AWS Cloud Architect.Hands-on experience in debugging AWS services like EC2, EMR, S3, Redshift, Lamba etc. Hands-on experience in container orchestration tools like ECS / EKS.Hands-on experience in creating infrastructure using IaC like Cloudformation/Terraform.
Data Modeler - 8+ years of experience in commercial Data modelling, data entity defining for developing business insights for life sciences organisation.Prior experience in client management and have worked across a variety of projects from data engineering to data operations, to help improve and run client’s entire system of business processes and operations, implementing cutting edge automation technologies .
Azure ADF - 5+ years of relevant experience in delivering customer-focused information management solution(s) across Data Lakes, Enterprise Data Warehouses and Enterprise Data Integration projects primarily in MS Azure cloud using Data Factory and Databricks.
Snowflake Architect - 10+ years overall EDW (ETL, BI projects) /Cloud Architecture experience, software development experience using object-oriented languages .Expertise in Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, Zero copy clone, time travel, and understand how to use these features.
Business Analyst -Patient Specialty Services-8-10 years of extensive experience in working on Patient level datasets. Have a fair understanding of Patient data processing within the HIPAA environment, such as Patient data aggregation, tokenization, etc.
MDM - Informatica/ Reltio- 5-8 years of experience & should have hands-on experience working on MDM Projects.Hands-on experience in industry data quality tools like Informatica IDQ, and IBM Data Quality.