Associate - Business Information Management

Technology Leadership

• Independently he/she should be able to design, implement, and deliver complex Data Warehousing/Data Lake, Cloud Data Management, and Data Integration project assignments.

Technical Design and Development Expertise

• 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 Tableau, 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 RDBMS systems is a must.
• Experience across Python, PySpark, and Unix/Linux Shell Scripting.

Project Management

• Is a must to have.
• Should be able to 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 the 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.

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 - Other
• PG Diploma in Management

Work Experience

We are hiring for the 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 into 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, Lambda 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 modeling, data entity defining for developing business insights for life sciences organization.
• Prior experience in client management and have worked across a variety of projects from data engineering to data operations, to help improve and run clients' 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.