Menu

Jatin KANDPAL

Paris

En résumé

7+ years of involvement in ETL, BI and DWH solution development in an Agile and Waterfall methodologies. Enthusiastic Certified Scrum Master (PSM 1) with dynamic experience in delivering high-quality software within time and budget.
Possess International experience at Onsite (Germany)

ACHIEVEMENT & INNOVATION:
• Innovation over Alexa on Project Status
• Received Cognizant Gem award for outstanding performance
• Received ‘Feather in Cap’ performance award for Parallel Processing under soft dollar innovation which reduced the job time from 2 weeks to 1 day

Mes compétences :
Agile Scrum
PL/SQL
SQL
Informatica
Informatica PowerCenter
Microsoft Excel
ETL
Business Intelligence
Analytical Skills
Design
Project Planning
sprint backlog management
automation testing
International Experience
Parallel Processing
dynamic experience
solution development
Data Modelling
Data Warehousing
Confluence
JIRA
Microsoft Team Foundation Server
Scrum Methodology > Sprint Planning
Tableau
shell scripting
SQL Server Integration Services
Test Cases
Test Planning
Control-M
Agile Methodology
Apache Subversion
DB2
Git
Microsoft SQL Server
Oracle
Oracle PL/SQL
Python Programming
Scrum Methodology
Test-Driven Development
Waterfall Methodology

Entreprises

  • Cognizant Technology Solutions - ETL-BI Developer & SCRUM MASTER

    Paris 2016 - 2018 * Responsible for Analysis, Design, Data modelling and Implementation of applications for Telekom sector covering data extraction, transformation and visualization using Informatica and PowerBI
    * Trained in data warehousing, data modelling concepts, and SCDs
    * Led a team of 20. Conducted review of code and functional and technical documents
    * Developed complex Informatica mappings and workflows
    * Written PL-SQL procedure, packages for ETL, SQL queries within the Informatica mappings and wrapper UNIX shell scripts
    * Done performance Tuning at the Mapping level as well as Database level to increase data throughput by applying indexes, partitions
    * Extensively used workflow and mapping parameter & variable
    * Built effective reports using Tableau in close collaboration with stakeholders which helped the client in Decision-making
    * Involved in project planning, estimations and recruiting new talents
    * Facilitated Sprint planning, daily scrum, Sprint review retrospective
    * Collaborated with Product Owner and development team in Product Backlog and sprint backlog management and removing impediments
    * Extensively used JIRA, TFS, Confluence for planning, action-board

  • Infosys - Informatica Developer

    Roissy en France 2011 - 2016 * Analysed the business requirement and created the business rules using Informatica, SSIS in Agile mode to provide insight on bank metrics like coverage ratio between deposit & loan amount
    * Worked across different transformation like Look-up, Router, Joiner, Update strategy, Normalizer, Filter, Sorter
    * Involved in preparation of LLD, HLD, operation manual, test cases, test plans, prepared effort estimation
    * Optimized the Informatica mappings which reduced the job times to load data in data marts, data warehouse
    * Performed manual, regression, bi-lateral, automation testing
    * Scheduled jobs using Control-M

Formations

  • Sikkim Manipal University OPS (Pune)

    Pune 2012 - 2014 Masters Degree

  • Panjab University (Chandigarh)

    Chandigarh 2008 - 2011 Bachelors Degree

Réseau

Annuaire des membres :