Technology Lead Resume

PROFESSIONAL SUMMARY:

6 years 4 months experience as of 11th May 2018
Having ample experience in data warehousing and business intelligence.
Extensive work in ETL process consisting of data transformation/migration, data sourcing, mapping, conversion and loading, data testing and validation against source database
6+ years of experience in Data Integration (DI) using Informatica Power Center.
Able to work independently and contributed as Subject Matter Expert for the application during discussions with Client and external Teams.
Informatica Administration: Code Migration from dev to test and to production environments using labels and queries, Server monitoring using Admin Console.
Working experience with multiple databases like TERAD, Oracle, Netezza
Business Requirement gathering and analysis of the impacted objects.
Excellent team player and proven track record working in various team sizes performing cross - functional roles.
Working in AGILE METHODOLOGY.

TECHNICAL SKILLS:

Databases: NETEZZA , TERADATA , Microsoft SQL Server 2008

Tools: INFORMATICA 9.6.1, Power Exchange

Languages: SQL , PL/SQL

Web: XML

Operating System: Windows 2000, UNIX

PROFESSIONAL EXPERIENCE:

Confidential

Technology Lead

Responsibilities:

Development of INFORMATICA code and changes according to business requirement and logic.
Design the DB changes in the data warehouse for new business requirements and aligning with DBA’s
Design and Mapping document creation for new and existing changes as per business requirement.
Understanding Business requirement and providing the details to offshore team members according to the development plan.
Aligning tasks in Rally (AGILE METHODOLOGY) for offshore team members.
Migration of INFORMATICA code using deployment groups to higher environments.
Label and query creation for INFORMATICA code migration.
Creating change request according to the planned date and aligning to E2E teams for deployment activities.

Environment: INFORMATICA 9.6.1, UNIX, NETEZZA, Power Exchange, LARA (INFROMATICA deployment tool for higher environment)

Confidential

Analyst

Responsibilities:

Bringing of new data from source and modifying it according to the business requirement using INFORMATICA and then storing it in our data warehouse.
Gathering business requirement from the business.
Designing and Coding for the ETL flow.
Guiding the team persons and providing solutions.

Environment: INFORMATICA 9.6.1, UNIX, DB2

Confidential

Developer

Responsibilities:

Bringing of new data from the pointed source and modifying it according to the business requirement using INFORMATICA.
Providing Business Views for front end reporting.
Scheduling the ETL jobs using Dollar Universe.
Gathering business requirement from the business.
Creating the ETL’s according the architecture followed.

Environment: INFORMATICA 9.6.1, TERADATA

Confidential

Developer

Responsibilities:

ETL to load the data into the base tables on daily basis.
Scheduling the ETL jobs using Dollar Universe.
Queries used in the source qualifier of the ETL to extract the data from source.
Confidential -W-3NF architecture design for all the ETL’s

Environment: INFORMATICA 9.5.1, TERADATA

Confidential

Developer

Responsibilities:

Collected the entire business requirement and built the document of understanding.
Source was XML file with all the data and linking between Tier 1 and Confidential .
Analysed the primary and foreign key relations between the different parts of the XML and finalised the XML to be used in the ETL.
Created procedures and ETL to load the data from multiple XML files into the base tables on daily basis.
Scheduling the ETL jobs using Dollar Universe.

Environment: INFORMATICA 9.5, PL/SQL

Confidential

Developer

Responsibilities:

Created procedures and ETL to load the data into the base tables.
Provided procedures that were called by Xcelsius using the web services to bring the data.
In-built the security mechanism for the front end to give user security.
Scheduling the ETL jobs using Dollar Universe.

Environment: : INFORMATICA 9.1, SQL (Microsoft SQL Server 2008), Microsoft Excel

Confidential

Developer

Responsibilities:

Bringing of new data from the pointed source and modifying it according to the business requirement using INFORMATICA.
Scheduling the ETL jobs using Dollar Universe.
Creating the ETL’s according the architecture followed.
Monthly loads to be carried out and also the data extraction from source BO and loading it into our database using ETL (INFORMATICA).

Environment: INFORMATICA 8.6 and PL/SQL

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship