Post Job Free

Resume

Sign in

Data Developer

Location:
Woodbury, GA
Posted:
February 20, 2019

Contact this candidate

Resume:

Professional Profile: Multilingual Charismatic Specialist with intensive hands-on HR Functions Management & Personnel

Work Experience

Source InfoTech Inc (June 2015 – Present)

Role: ETL Developer (Informatica)

Responsibilities:

•Analyzed the business requirements and functional specifications.

•Extracted data from oracle database and spreadsheets and staged into a single place and applied business logic to load them in the central oracle database.

•Used informatica PowerCenter 10.1 for extraction, transformation and load (ETL) of data in the data warehouse.

•Developed complex mapping in Informatica to load the data from various sources.

•Implemented performance tuning logic on target, source, mappings, sessions to provide maximum efficiency and performance.

•Parameterized the mappings and increased the re-usability.

•Used Informatica Workflow manager to create sessions, workflow and batches to run with the logic embedded in the mappings

•Extensively used Toad Utilies for executing SQL (RBDMS) scripts and worked on SQL for enhancing the performance of the conversion mapping.

•Extensively used Informatica debugger to figure out the problem in mapping. Also, involved in troubleshooting existing ETL bugs.

•Created a list of the inconsistencies in the data load on the client’s side as to review and correct the issue on their side.

•Created the ETL exception reports and validation reports after the data is loaded into the warehouse database.

•Wrote documentation to describe program development, logic, coding, testing, changes, and corrections.

•Created Test cases for the mappings developed and then created integration Testing Documents.

•Followed Informatica recommendations, methodologies, and best practices.

Environment: Informatica Power Developer 10.1, Informatica Analyst Tool, Power Connect, Teradata, Oracale Data Integrator, Flat file, TOAD, Windows XP Professional,T-SQL.

University of Central Missouri (UCM)

Role: Graduate Assistant (January 2014 to June 2015)

University of Central Missouri is a leading public university in Missouri. The objective is to integrate different source systems into homogeneous environment to build Enterprise Data Warehouse for operational and strategic reporting. The goal of the project is to achieve is to better decision making with appropriate data view.

Responsibility:

•Interacted and coordinated with System architects, Business executives, analysts, Data population engineers and developers.

•Analyzed the Functional requirements and Technical requirements, preparing technical

•Involved in Business Requirements gathering and Analysis.

•Developed SSIS packages using looping, data formatting, check points, error handing, email notification etc.

•Developed SQL Quires to fetch complex data from different tables in remote databases using joins, database link and formatted the results into reports and kept logs.

•Created SSRS report according to user requirements and technical standards.

•Analyzed the source data coming from Oracle and working with business users and developers to develop the Model.

•Participated in all phases including Requirement Analysis, Design, Coding, Testing and Documentation.

•Extensively used SQL to validate the data loaded.

•Designed complex SQL queries to view the data from front-end.

•Created Reports as per the User requirements using extensive functionalities in Business Objects, which allows the users to analyze the data.

Education

Master of Science in Industrial Management (Lean Six Sigma Certified)

University of Central Missouri (UCM), Warrensburg, MO

GPA: 3.6/4:0

Bachelor of Science in Electronics and Communication Engineering

American International University Bangladesh (AIUB)

GPA:3.1/4:0

AHMED CHOWDHURY(Green Card Holder)

Telephone: +1-405-***-****

Email Address: ac8jzu@r.postjobfree.com



Contact this candidate