• Developed and maintained data pipelines using Informatica to extract, transform, and load data from various sources into DWH and data lakes for 16+ Datamart’s.• Implemented data processing jobs using Apache Spark for large-scale data analytics.• Designing and conducting complex analysis for 50+ BI analytical, predictive dashboards and reports to monitor data quality using MicroStrategy.• Lead and manage a team of 6 senior engineers, providing guidance, coaching & mentoring.•… Show more • Developed and maintained data pipelines using Informatica to extract, transform, and load data from various sources into DWH and data lakes for 16+ Datamart’s.• Implemented data processing jobs using Apache Spark for large-scale data analytics.• Designing and conducting complex analysis for 50+ BI analytical, predictive dashboards and reports to monitor data quality using MicroStrategy.• Lead and manage a team of 6 senior engineers, providing guidance, coaching & mentoring.• Collaborate with stakeholders to understand their data requirements and translate them into technical solutions.• SPOC for production support - debugging, failure analysis, RCA and providing business & technical solutions to customers. Show less

• Conducted end-to-end development of Hadoop data pipelines, including data ingestion, transformation, and storage, ensuring seamless data flow and quality.• Designed and executed complex Spark jobs for data processing and ensuring optimal performance. Sqoop jobs transactions with incremental load to Hive External table.• Identify opportunities for automation & guided team in SQL & HiveQL 50+ validation scripts.• Design and conduct analysis for Benchmark & Predictive analytical… Show more • Conducted end-to-end development of Hadoop data pipelines, including data ingestion, transformation, and storage, ensuring seamless data flow and quality.• Designed and executed complex Spark jobs for data processing and ensuring optimal performance. Sqoop jobs transactions with incremental load to Hive External table.• Identify opportunities for automation & guided team in SQL & HiveQL 50+ validation scripts.• Design and conduct analysis for Benchmark & Predictive analytical dashboards – Cube, datasets, Visuals – KPI’s, Graphs, Charts, Maps etc.• Developed mobile strategies for 15 iPad analytical dashboards, ensuring optimal functionality and user experience Show less

• Demonstrated proficiency in all stages of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).• Extensively worked on Informatica Designer Tools (Source Analyze, Warehouse Designer, Mapping Designer, Mapplet Designer, and Transformation Developer) and Workflow Manager Tools (Task Developer, Worklet and Workflow Designer) & Workflow Monitor.• Gained expertise in MicroStrategy, including ad-hoc reporting, cross-data mart reporting,dashboards, and visual insights

.Net Developer