Resume

Sign in

Developer Data

Location:
Lake Forest, Illinois, United States
Salary:
75000
Posted:
November 28, 2018

Contact this candidate

Resume:

Anjali Negi

Email: ac7thl@r.postjobfree.com

Cell: 224-***-****

Summary:

Over 3.6 years of overall IT experience as a ETL Developer with extensive project lifecycle Experience in Design, Development, Implementation and testing of various sized applications using ETL Tools.

3.6 years of Informatica experience in ETL, Data Mapping, Transformation and Loading from Source to Target Databases.

Designed and deployed well-tuned Informatica mappings.

Worked on SQL, creation of queries for execution.

Practical experience with various Informatica components such as Joiner, Lookup, Sorter, Filter, Aggregator etc.

Experience in Hyperion, Production Support and Troubleshooting for various ETL Jobs.

Practical experience with working on multiple environments like production, development, testing.

Experience in low level ETL testing, defining ETL specifications and data modeling.

.

TECHNICAL SKILLS

ETL Tools: Informatica (9.1), Oracle, Sybase.

Database Tools: Oracle SQL Developer 2010 version 3.1, Sybase.

Tools: SQL developer, Putty.

Programming Languages: SQL, Oracle SQL

Operating Systems: Windows 2007, UNIX

Education Details

Bachelor of Technology (B.tech, Computer Science)

Professional Experience:

Syntel Pvt. Ltd. May 2015 – Jun 2016

Sr. ETL/Informatica Developer

Client: West Band Insurance

Responsibilities:

Worked as a senior coordinator for the offshore/onshore developers to resolve queries and guide in respective processes.

Responsible for creating the technical design document.

Closely worked with business users to gather the requirements and also responsible for creating mapping documents.

Designed test cases and executed respective scenarios.

Generating status reports and sharing with clients.

Actively participated in ETL code review sessions to get approvals form DEV to QA.

Good experience on EME and migrate Informatica code to various environments.

Responsible for debugging QA, prod batch jobs if any abends on weekly or daily basis.

Experienced in represent as ETL contact person for all cross work stream projects for any files consume/creations.

Responsible for data requests and pulling the data out of PROD to downstream & source application.

Communicated directly with clients to gather information for the various development projects.

Understanding the requirement and implementing the transformations using the Data Mapping and Interface Design document.

Experience in ETL testing and validation.

Environment: Informatica (9.1), EME, Oracle, SQL 3.1, Unix, Windows 7.

Syntel Pvt. Ltd. June 2014 – Feb 2015

ETL/Informatica Developer

FDX to MISA: The Management Information System is a distributed system designed for historical Clearance archival and reporting. MIS Archive collects data from multiple FedEx Express clearance information systems and consolidates it for a single database. The information provided by MIS Archive is used by Global Trade Services (GTS) and clearance locations to ensure regulatory compliance and the highest levels of operational excellence. The project was mainly to migrate the MISA Sybase database to Teradata.

Client: Fedex

Responsibilities:

Implemented various ETL projects in Syntel.

Responsible for Design the technical design document and estimates the hours for ETL projects

Closely work with business users to gather the requirements and also responsible for creating mapping documents.

Actively Participated in problem solving and troubleshooting for the applications implemented with Informatica.

Performed analysis on quality and source of data to determine accuracy of information being reported.

Created different parameter files and changed Session parameters, mapping parameters, and variables at run time.

Involved in unit testing, Integration testing and User acceptance testing of the mappings.

Actively coordinated with testing team in the testing phase and helped the team to understand the dependency chain of the whole project.

Actively participated in ETL code review sessions to get approvals form DEV to QA.

Good experience on EME and migrate Abinitio objects to various environments.

Responsible for debugging QA, prod batch jobs if any abends on weekly basis.

Experienced in represent as Syntel ETL contact person for all cross work stream projects for any files consume/creations.

Responsible for data requests and pulling the data out of PROD to downstream & source application.

Communicated directly with clients to gather information for the various development projects.

Understanding the requirement and implementing the transformations using the Data Mapping and Interface Design document.

Environment: Informatica (9.1), EME, Sybase, UNIX, Windows 7.

Syntel Pvt. Ltd. Dec 2012 – May 2014

ETL/Informatica Developer

FDX MISA Assessment: Worked on MISA (Management Information System) /Archive which is a distributed system designed for historical Clearance archival and reporting. MIS Archive collects data from multiple FedEx Express clearance information systems and consolidates it for a single database. The information provided by MIS Archive is used by Global Trade Services (GTS) and clearance locations to ensure regulatory compliance and the highest levels of operational excellence.

Client: Fedex

Responsibilities:

Involved in Data transfer design and development for legacy data to a newly defined data model for the data warehouse.

Involved in meetings to gather requirements from the Business Users.

Responsible for creating business solutions for Archival database.

Created complex mappings in Power Center Designer using Expression, Filter, Sequence Generator, Update Strategy, Joiner and Stored procedure transformations.

Worked in debugging production failure using Log messages, Server Messages.

Responsible for project delivery and production support.

Providing technical support and troubleshooting issues for business users.

Environment: Informatica (9.1), EME, Sybase, UNIX, Windows 7.



Contact this candidate