Jatin K.

Bi/Etl Developer

555 dollar
Freelancer
7 years
Saint-Germain-en-Laye, FRANCE

My experience

More

T-Systems, GermanyApril 2016 - December 2018

COGNIZANT TECH SOLS      ETL-BI Developer      SCRUM MASTER
* Responsible for Analysis, Design, data modelling and Implementation of application for Telekom sector covering data extraction, transformation and visualization using Informatica and Power BI
* Led a team along with conducting code and functional doc reviews
* Good knowledge and hands-on experience with Power BI and Tableau
* Build effective reports using Power BI, Tableau in close collaboration with stakeholders which helped client in Decision-making, improving the network connectivity and providing campaigns to users
* Good in writing SQL queries within the Informatica mappings
* 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
* Experienced in writing UNIX shell scripts, PL/SQL procedures
* 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
* Sound knowledge on SSIS and Python
More

Westpac, AustraliaJune 2011 - March 2016

INFOSYS LTD      ETL- Client: Westpac, Australia      Project: DLCR     
* Analysed the business requirement and created the business rules using Informatica 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
* Done tuning of mappings, sessions for reducing the job times to load data in data marts, data warehouse
* Performed manual, regression, bi-lateral, automation testing
* Experience in creating reports using Tableau
* Good hands-on experience in scheduling jobs using Control-M

My stack

Databases

MySQL, TOAD, DB2, Microsoft SQL Server, IBM DB2, Oracle

Analysis methods and tools

Agile Methodology, Agile, Scrum, Confluence, JIRA, Kanban

Others

Project Management, Design, SDLC, Waterfall, Team management, Business Analysis

Business Intelligence

SSIS, Power BI, Informatica, ETL, Data Warehouse, SQL Server Integration Services, CONTROL-M, Business Intelligence

Software testing

Test Driven Development (TDD), Test Cases, Test Planning

IT Infrastructure

Git, Unix, BMC Control-M

Languages

Oracle PL/SQL, SQL, Shell Scripting, PL/SQL

Technologies

TortoiseSVN

Computer Tools

MS Office

Other

solution development, French, dynamic experience, Data Warehousing, Analytical skills, Scrum Methodology, Scrum Methodology > Sprint Planning, Data Modelling, sprint backlog management, and Implementation, English, Indian > Punjabi, Project Planning, Python Programming, tableau, International Experience, Waterfall Methodology, Scrum Master, Microsoft Team Foundation Server, automation testing, Certified ScrumMaster, Apache Subversion, ETL-BI Developer, BI DEVELOPER, Parallel Processing, Doctoral Degree > Doctor of Laws, Indian > Hindi, Informatica Developer

Environment of Development

SVN, TFS

My education and trainings

Masters Degree, Computer Application - Sikkim Manipal University2012 - 2014

Bachelors Degree, Computer Applications - Panjab University2008 - 2011