Sailesh Kumar Singh Email & Phone Number

DW-BI-SQL-ETL-Informatica-Teradata-Automation-NIFI-Agile-GCP-BQ with 9+ Years ExpETL BI-Technical Lead in retail industry. Summary of Qualifications: • 9+ years of experience in the IT industry specific with Data Warehousing and Data Marts. • Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing,implementation, and production support. • Worked in both Waterfall & DevOps Agile Developmentenvironment. • Demonstrated expertise utilizing RDBM systems like Teradata, Oracle and Informatica PowerCenter 9.x/10.x (Source Analyzer, Repository Manager, Server Manager, Mapping Designer, Mapplet Designer, Transformation Designer) as an ETL tools. • Experience in performance tuning of Informatica Sources, Targets, Mappings and Sessions. • Worked extensively on Teradata tool & utilities i.e., FastLoad,Mload, Tpump, TPT, FastExport. • Performed Data analysis, data profiling, data quality and data ingestion in various layers using Teradata database queries, Informatica PowerCenter and Unix shell scripts • Experience in BI Data Model, Design/Develop ETL, data marts, custom reports.Strong understanding of Data Modeling (Relational, Dimensional, Star Schema and Snowflake), Data Analysis, implementation of Data Warehousing in providing solutions in OLAP and OLTP application development using Windows and UNIX. • Collaborated within multiple stakeholders, management, vendors, and teams like DBA, support to analyze needs and issues, define strategies, and ensure timely delivery of quality-driven technology and process improvements. • Working on Google Cloud Platform & NiFi • Working on Google Big Query, while helping client on a movement from traditional DB to cloud journey. Advises client on discrete business problems, formulates options including assessing their relative merits and risks, and works with client personnel(s) to determine the best solution. Responsible to ensure Incidents are resolved/remediated within established SLAs.Responsible to support process improvements to continuously improve the stability and performance of the applications. Specialties: Teradata Business Intelligence Informatica PowerCenter Business Objects PL/SQL OracleGCPNiFi