senior Informatica developer

GARIMA SINGH

Informatica Developer

Phone: 469-***-****

Email: ******.***********@*****.***

CAREER OBJECTIVE:

Young, Energetic and result oriented professional with 6+ years of experience, graduated from New York Institute of Technology in Master of Science in Computer Science. Looking forward to work in a stimulating and challenging environment that would facilitate the maximum utilization and application of my broad skills and expertise thereby making a positive difference to the organization.

EDUCATION:

Master of Science (M.S.) in Computer Science – 2019(NYIT – GPA 3.93)

Bachelor of Technology (B.Tech.) – Information Technology – 2013 (with First class)

Certificate of Java Language.

Workshop for Developing Web Application using ASP.Net.

Completed Training from Indian Institute of Information Technology on Embedded System

Certificate for completion of training for Computer Systems used in BPCL.

TECHNOLOGY AND TOOLS:

ETL

Informatica PowerCenter 9.0 & 9.6

Data Quality

Informatica Data Quality

Data Publication/

Subscription

Informatica Data Integration HUB

Database

Oracle 10g, 11g and SQL Server

Programming

Java (8 &9), JSP, Java Script, HTML 5, CSS 3, ASP.NET, C++

Other Tools

Visual Studio 2019 & 2017, Microsoft SQL Server Management Studio 2017, Eclipse, Netbeans, Apache Tomcat 9, Microsoft Visual Studio 2005, Virtual Box, Open Day Light Controller,

Sflow-rt, Putty, Wireshark, Prometheus, Grafana.

SUMMARY:

Highly efficient technology expert with unique skill set in development, implementation and maintenance of data warehouse.

Demonstrated more than 5 years of infallible achievements in delivering critical components.

Extensive experience in Developing ETL solution using INFORMATICA.

Expertise in implementing Data Validation process using Informatica Data Quality (IDQ)

Experience in developing publication and subscription using Informatica Data Integration Hub (DIH)

Experience in designing various technical and functional design document.

Expertise in development to ensure timely delivery of the assignment.

An excellent team player with effective communication skills and good relationship with clients and various other stakeholders.

Managed all aspects of planning, requirements gathering, design, testing and release of ETL components

Integrated data from several systems into a data warehouse.

Built efficient views using PL/SQL to improve performance of these reports.

Provided excellent support; oversaw development and implementation to ensure client needs were met.

Commanded mastering of the technical knowhow and designed the entire scheme of things to get data and transform it to suit the data requirements of the data model.

Created unit test scripts and execution of the same to ensure defect free delivery of the components.

Oversaw code deployment to higher environments and provided release scripts and documentation to aid the deployment. Coordinated the release process like code check-in, version control using SVN and mock migration

Automated the code by scheduling the jobs through scheduler Autosys. Unix scripts were developed to handle file processing and to invoke the ETL objects

WORK EXPERIENCE:

Welron Solutions (India) April 2016 – July 2017

Working as Informatica Developer for the project.

Requirement Gathering and Analysis. Designing technical specification and data flow diagram design document. Managed all aspects of planning, requirements gathering, design, testing and release of ETL components.

Worked with Data Architecture team and designed Data model for the project.

Worked with Java/UI developers and BAs for the smooth development of the project

Manages database team and work on task creation and assignment for the Database team.

Works with BAs as first line for each Release requirements.

Works on complex and critical pieces to make sure all Database tasks are done in time and good quality

Detailed review of all code scripts helps in resolving all defects and requirement gaps.

Developed workflows and mappings using INFORMATICA and DIH.

Developed data quality validation using IDQ

Developed various stored procedures and functions for implementing various logics.

Designed complex Calibration and Finalization Logic in Database code.

Code Review and analysis.

Continuously worked on DB code performance tuning, enhancing the DB development process and building the Database team.

Provided excellent support; oversaw development and implementation to ensure timely delivery of the project.

NEXTSTEP (India) Sep 2013 – March 2016

Working as Informatica Developer in the project.

Designing technical specification and Data flow diagram design document.

Developed workflows and mappings using INFORMATICA and DIH.

Developed data quality validation using IDQ.

Developed various stored procedures and functions for implementing various logics.

Code Review and analysis.

Managed all aspects of planning, requirements gathering, design, testing and release of ETL components.

Provided excellent support; oversaw development and implementation to ensure client needs were met.

Created unit test scripts and execution of the same to ensure defect free delivery of the components.

Oversaw code deployment to higher environments and provided release scripts and documentation to aid the deployment. Coordinated the release process like code check-in, version control using SVN and mock migration.

Automated the code by scheduling the jobs through scheduler Autosys. Unix scripts were developed to handle file processing and to invoke the ETL objects.

SOFTPRO (India) June 2012 – Aug 2013

Requirement Gathering and Analysis.

Designing Technical specification and Data flow diagram design document.

Developed workflows and mappings using INFORMATICA and DIH.

Developed data quality validation using IDQ

Writing various stored procedures and functions for implementing various logics.

Code Review and analysis.

Worked on Project proposal for various requirements

ACADEMIC TECHNICAL PROJECTS:

An SDN based Network Analysis & IDS Development Framework Jan 2018 – Apr 2018 New York Institute of Technology, USA

Developed OpenFlow Mesh Network topology using Mininet and Openday-Light Controller that act as a webservice.

Analyzed the traffic from one host to another in network to detect attack using SFlow-rt

Monitored the performance of the build Mesh Topology using Prometheus and Grafana monitoring tool.

Used Putty to connect to SSH-X11 forwarding.

Crate Jun 2018 – July 2018

New York Institute of Technology, USA

Create 3D Crate box using C++ and Visual Studio 2017

Developed C++ code to change texture and lighting of the crate.

Also created logic to implement 3D rotation of the Crate object.

Developed reusable geometry class to alter sides of the Crate.

Developed logic to change the Crate box with skull as per the project requirement.

Web Server Sep 2018 – Oct 2018

New York Institute of Technology, USA

Developed code in Java 9 to connect to the HTTP Server from the client application.

Developed code to display the client request made to the HTTP Server.

Wrote code to return requested webpage as per the client request received.

Developed exception handling to capture runtime exceptions.

Dynamic Web Server Oct 2018 – Nov 2018

New York Institute of Technology, USA

Developed code in Java 9 to connect to HTTP server

Developed Time handler code in Java and hosted as service to return current time to the user.

Developed Echo Header handler service in Java to handle dynamic user requests and return output accordingly.

Developed File Home Handler service in Java to provide file search functionality to users.

Servlet Nov 2018 – Dec 2018

New York Institute of Technology, USA

Developed Java Servlets to extend capabilities of the server to respond to various requests.

Developed various programs to validate if server is up and running

Developed Servlet filters to pass request back down to filter chain.

Created Servlet filter to return IP address of client machine and current time stamp.

Keystroke Biometric March 2019 – May 2019

New York Institute of Technology, USA

Developed code in Java to calculate the report for given data

Developed report of false accept and false reject rate using given data.

Developed calculator template using key hold and key interval, genuine score using Manhattan distance using given data.

Library System March 2019 – May 2019

New York Institute of Technology, USA

Create a Library system using Asp.net, Visual Studio 2019 and Microsoft SQL Server Management Studio 2017.

Developed Asp.net code to connect all the pages each other.

Also, connect front end to back end.

Developed back end using Microsoft SQL Server Management Studio 2017.

Developed reusable views and stored procedures to get the perfect display for my Library System.

Extra-Curricular Activities:

Attend a Cyber Security Seminar done at -NYIT

NYIT Edward Galliano Scholarship

Volunteer for Marathon Race for National Cancer Awareness Day (2008)

Winner in Dance Competition at School Level.

Winner in 100m & 200m Race at College Level.

Active Participant in All College Cultural Events.

Participated in Technical Fest NIRMANA.

Class Representative, Captain of Basketball team, Cultural Coordinator, Peer Mentor

Senator of the Dance Club in NYIT, 2019

Contact this candidate