Informatica Developer Resume

SUMMARY

Experienced Developer accomplished in performing ETL processes with Informatica Power Center 10.1.
Proficient in Repository Configuration, creating Mappings, Sessions, Worklets, Workflows and processing tasks using SQL, XML, moving Data from multiple source systems to targets.
Experienced in all phases of the Data Warehouse project life cycles including Requirement Gathering, Design, Development, and Testing
Expertise in Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions. Experience using of Data Modelling and statistical Data Mining tools such as Minitab, SPSS, SAS, and SQL. Good knowledge of entity relationship and Data Models.

AREAS OF EXPERTISE

Informatica Power Center and ETL
SQL
Master Data Management
Data Profiling
Data Migration and Integration

TECHNICAL SKILLS

Interpersonal: Excellent oral, communication skills. Highly adaptable. Attention to details.

Programming: Oracle SQL, R, MatLab, SPSS

Software: Minitab, SAS, Fracpro, Meyers, ELA, ArcGIS, CMG, MS Office Suite, JobMaster

PROFESSIONAL EXPERIENCE

Confidential

Informatica Developer

Responsibilities:

Creating and implementing repositories to manage all of the essential master data elements in one central database to define how information will be stored, structured, manipulated, and moved.
Gathered business requirements for data warehouses and HUB, resulting in development of a common vocabulary enabling stronger knowledge of data assets.
Creating data mappings from source analyzer to transformation and target tables, in order to perform required manipulation to meet business logic
Performing aggregator, expression, router, and filter transformations in order to sort extracted data, perform simple batch calculations, and route manipulated data to desired target output
Loading data from source SQL servers to target environment in order to organize and store data according to data storage guidelines
Defining base objects, staging tables, queries, static and dynamic lookups in order to consolidate data from multiple sources
Developing SQL module for integrating existing data from third party platforms to the database to optimize data integrity
Normalizing data from heterogenous sources, creating stored procedure, thereby improving session run times and overall efficiency of ETL processes
Performing match, merge, trust, and validation rules to ensure the effectiveness of MDM process on data.
Profiling data, managing metadata information and multiple levels of data migration processes to track data lineage.
Creating, modifying, and communicating the project plan with other team members, analyzing source system for integrity issues and troubleshooting errors.

Confidential

Project Engineer

Responsibilities:

Given data, designed schedule for jobs using 3D fully coupled software. Projects cost an average $2.5M per week but saved client 30% due to integrated design and efficient fluid systems
Trained new engineers in use of fracture modeling software and performed peer - to-peer training to improve subject matter competency across the department
Assessed and interpreted data for all clients to meet client requirement and ensure data integrity.
Verified expected fluid performance, breaker tests, fluid characterization and accounted for all chemical inventory to confirm effectiveness of treatment design
Documented post job chemical and proppant inventories for ensuring proper tracking and accounting for chemical supplies and prepared analysis reports.
Developed analytical, statistical model to examine and mine master data to properly interpret and propose future designs
Integrated data from multiple sources, creating singular view of all data elements, sorting, classifying, and profiling data to ensure manipulation result integrity
Proposed appropriate future treatment design based on model in order to satisfy client requirements.
Identified topography and created grid using ArcGIS, providing interactive view of actual geographical locations

Confidential

Science Advisor

Responsibilities:

Delivering formal Presentations at national, regional, and other related scientific meetings, increasing awareness of subject matter issues.
Demonstrated excellent judgment, critical thinking and reasoning showing a solid grasp of contemporary literature and regulatory guidance thereby improving the school system.
Maintained an in-depth knowledge and understanding of various markets and products, writing manuscripts for publication, moving the school to a higher ribbon status.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship