06/04/2025 updated
HA
100 % available
IICS CDI & CAI Consultant with 14+ years of experience in Data Warehousing
Greater Noida, India Bachelor of Technology (B. Tech) in Information Technology
Data AnalysisApplication Integration ArchitectureAutomationUnit TestingBusiness IntelligenceBig DataCloudera ImpalaDatabasesData ValidationData IntegrationData IntegrityExtract Transform Load (ETL)Data MartData ModelingData VisualizationData WarehousingIBM DB2Apache HadoopApache HivePython (Programming Language)Unix ShellMainframe ComputingOracle Business Intelligence Enterprise EditionOnline Transaction ProcessingOracle ApplicationsPerformance TuningQuality ManagementCloud ServicesProcess AutomationShell ScriptSQL DatabasesSqoopTableau (Software)WorkflowsData ProcessingInformatica PowercenterSnowflakeQlikviewPrestoReporting ToolsAmazon Redshift
Data Warehouse & ETL Development
Expertise in Data Modelling for Data Warehouse/Data Mart development and ETL development (OLTP). Competent in Data warehouse concepts and ETL designing with 14+ years of experience.
Informatica Tools & Cloud Services
Extensive experience with Informatica Intelligent Cloud Services (IICS), Informatica PowerCenter, and implementation across data integration and application integration requirements.
Database Technologies & SQL
Proficient with multiple database platforms including Snowflake, Amazon Redshift, DB2 Mainframe, Oracle, and Presto SQL engine. Strong SQL skills for data manipulation and validation.
Shell Scripting & Automation
Experience in Unix shell scripting and Python scripting for batch process automation and ETL workflows.
Business Intelligence & Reporting
Knowledge of BI reporting tools like Tableau, OBIEE/Qlikview for data visualization and analytics.
Big Data Technologies
Experience with Hadoop ecosystem tools including Sqoop, Hive, Impala, and Pig for large-scale data processing.
Performance Tuning
Expertise in performance tuning at Informatica mapping level and session level to optimize ETL processes.
Data Validation & Quality Assurance
Experience in creating unit test plans and test cases, data validation between source and target systems to ensure data integrity.
Expertise in Data Modelling for Data Warehouse/Data Mart development and ETL development (OLTP). Competent in Data warehouse concepts and ETL designing with 14+ years of experience.
Informatica Tools & Cloud Services
Extensive experience with Informatica Intelligent Cloud Services (IICS), Informatica PowerCenter, and implementation across data integration and application integration requirements.
Database Technologies & SQL
Proficient with multiple database platforms including Snowflake, Amazon Redshift, DB2 Mainframe, Oracle, and Presto SQL engine. Strong SQL skills for data manipulation and validation.
Shell Scripting & Automation
Experience in Unix shell scripting and Python scripting for batch process automation and ETL workflows.
Business Intelligence & Reporting
Knowledge of BI reporting tools like Tableau, OBIEE/Qlikview for data visualization and analytics.
Big Data Technologies
Experience with Hadoop ecosystem tools including Sqoop, Hive, Impala, and Pig for large-scale data processing.
Performance Tuning
Expertise in performance tuning at Informatica mapping level and session level to optimize ETL processes.
Data Validation & Quality Assurance
Experience in creating unit test plans and test cases, data validation between source and target systems to ensure data integrity.
Languages
EnglishFluent
Project history
Worked on multiple data integration projects including eBay Integration, Benify Integration, PGSDW Cloud Migration, PPM Analytics, Cognos Conversion, Front End Initiative, eWAT/PACE Reporting, YSA, PSP Next Phase, TBA Data, and PSP Plan Sponsor Portal projects. Responsibilities included ETL design and development, data warehouse architecture, performance tuning, and team coordination.