Associate- BIM

Position Summary

To be a driven business analyst who can work on complex Analytical problems and help the customer in better business decision making especially in the area of pharma/life sciences (domain).

Job Responsibilities

Engage with Client to participate in requirement gathering, Status update on work, UAT and be the key partner in the overall engagementParticipates in ETL Design using any python framework of new or changing mappings and workflows with the team and prepares technical specificationsCrafts ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenterWrite complex SQL queries with performance tuning and optimizationShould be able to handle task independently and lead the teamCoordinate with cross-functional teams to ensure project objectives are met.Collaborate with data architects and engineers to design and implement data models.

Education

BE/B.TechMaster of Computer Application

Work Experience

Advanced knowledge of PySpark ,python, pandas, numpy frameworks.Minimum 4 years of extensive experience in design, build and deployment of Spark/Pyspark - for data integration.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 destinationsCreate Spark jobs for data transformation and aggregationSpark query tuning and performance optimization - Good understanding of different file formats (ORC, Parquet, AVRO) to optimize queries/processing and compression techniques.Deep understanding of distributed systems (e.g. CAP theorem, partitioning, replication, consistency, and consensus)Experience in Modular Programming & Robust programming methodologiesETL knowledge and have done ETL development using any python frameworkWorked with Databricks/Snowflake in the past Preferable.

Behavioural Competencies

OwnershipTeamwork & LeadershipCultural FitMotivation to Learn and Grow

Technical Competencies

Problem SolvingLifescience KnowledgeCommunicationCapability Building / Thought Leadership