ETL Lead Resume

SUMMARY:

3 years of experience in Data ware housing.
I have prominently worked at ETL side with basic exposure to Reporting side.
I have worked in Development, Automation and Maintenance - Support related projects.
While Working in Maintenance
Support projects, activities were performed considering Change request processes.

TECHNICAL SKILLS:

Primary Skills: Informatica Power Center 9.1/9.6/10.1 , Oracle SQL, Unix and Shell Scripting, Subversion, GIT Stash

Secondary Skills: Spotfire 7.0/ 7.8, Ab Initio

Databases: Oracle, Teradata

PROFESSIONAL EXPERIENCE:

Confidential

ETL Lead

Responsibilities:

Help build new solutions for data reports. Worked on 3 Major SOWs to build new solutions for business.
Resolve the incidents and requests locked by users within SLAs.
Work on process, logic or job changes requested in existing system.
Maintain the applications check list and review yearly to decommission/ add the applications based on revised contract.
Coordinate with Customers to understand the requests/ changes/ problems and deliver the solution. Coordinate with offshore and nearshore teams to distribute work.
Suggest and build the solutions which will save Manual interventions, time and money.

Operating Systems: Windows, Unix, Linux, Informatica 9.6

Programming Languages: ProC, Shell scripts, PL/SQL.

Confidential

ETL Lead

Responsibilities:

Resolve the incidents and requests locked by users within SLAs.
Work on process, logic or job changes requested in existing system.
Help subscribers to build new subscriptions as per the requirement from mater data pool. Guide and follow the HtR COE approval process to create new subscription and update existing one.
Manage the authenticated access to each subscription.
Monthly audit to check for unauthorized hits on database, subscriptions and tables. Identify Dormant users and take the necessary actions.

Operating Systems: Windows and Unix.

Programming Languages: Informatica Power center 9.6, PL/SQL, Unix Shell Script.

Confidential

ETL Lead

Responsibilities:

Knowledge Transfer from Customer IT solutions.
Applications onboarding process. Create Service and Application CIs. Help prepare the contract and yearly expenses for maintenance.
Build the infrastructure - Work to build the infrastructure. This project requires informatica Clod, Oracle and Spotfire. Set up the Dev, Test and prod environments for each area. Migrate and test the code from Sandbox to all the 3 environments.
Identify the data refresh timelines, POCs, SMEs. Build offshore team.
Resolve the incidents and requests locked by users within SLAs.
Work on process, logic or job changes requested in existing system.
Sync up with Customers, offshore team and other upstream and downstream teams.

Operating Systems: Windows, Linux.

Programming Languages: Informatica 9.6, Informatica Cloud, Spotfire, Teradata, PL/SQL, Shell Script.

Confidential

ETL Lead

Responsibilities:

Resolve the incidents and requests locked by users within SLAs.
Work on process, logic or job changes requested in existing system.
Coordinate with Business/ users and offshore - nearshore team.
Assist users and resolved the requests.
Investigate in case of any data inconsistencies in reports and involve the concerned data processing team for more investigation.

Programming Tools: Confidential 7.8