Sr. Data Analyst/ Senior ETL Developer Resume

PROFESSIONAL SUMMARY:

Over 9+ years of total IT experience with strong knowledge in ETL/Database/Reporting technologies.
Extensive hands - on experience in Informatica 8.x/9.1/9.6 and involved in major deployments.
Experience on Informatica Big data management (BDM) 10.1 version tools. Data ingestion into Hive/HDFS, Data Lineage and Data Profiling .
Experience in BI tools using Hyperion IR studio 11, OBIEE and Power BI.
Data Preparation concept using Informatica Intelligent Data Lake. (IDL)
Involved in Troubleshooting database problems, Performance tuning - session and mapping tuning, partitioning and SQL Tuning.
Experience in developing ETL processes using major RDBMS like Oracle11g (Exadata), Mongo DB.
Experience on Data Quality framework including Data profiling, creating Data dictionaries and Source to target documents.
Expertise in scheduling jobs using Redwood scheduler.
Exposure in data migration, data development and maintenance projects.
Certified on IDQ 8.6 . Ongoing certification for Informatica 9 Specialist.
Good knowledge in SQL Scripts, UNIX Shell Scripting .
Thorough understanding of Software Development Life Cycle (SDLC) including requirements analysis, system analysis, design, development, testing, documentation, training, implementation and post-implementation process.
Good communication, analytical and immediate problem-solving skills.
Expert in Agile and Scrum methodologies.
Project Management in execution of major projects including Project scheduling, co-ordination, status/defect tracking, task/team management and Risk management.
Involved in Costing and Budgeting/ effort estimation for projects

TECHNICAL SKILLS:

Operating Systems: Windows, Linux OS.

Languages: SQL, UNIX Shell Scripts, Java Scripts, PERL

ETL Tools: Informatica7.x/8.x/9.x, Informatica10.1 Big data Management (BDM) edition, Data Quality/ Data Explorer/Power exchange.

Database: Oracle11g, Exadata, Tera data, NO SQL (Mongo DB)

Reporting Tools: Hyperion IR 11, OBIEE, Power BI.

Utilities: Putty, WinSCP, Rational Clearcase, ClearQuest, Redwood Scheduler.

WORK EXPERIENCE:

Confidential

Sr. Data Analyst/ Senior ETL Developer

Responsibilities:

Application development and maintenance support activities.
Responsible for the monthly release activities, performance tuning of the jobs and making VDW system available to the users and continuous improvement activities.
Data Quality team in creation of Data Dictionaries, Data Profiling, and providing status reports.
Data migration from Oracle to Exadata of the Vehicle warehouse.
Actively involved in SDLC processes like - Confirm Technical Architecture, Design reviews, Code development and reviews and Implementation support.
Actively involved in Project Management activities like - Estimation, Scope, Risk Management, Change Controls, Resource management and Project Planning Activities like - End to End Scheduling, Tracking, Defect prioritization, Resource Planning, Implementation, Communication planning and Career planning of team members.

Confidential

ETL Developer

Responsibilities:

Analysis of ETL code and fixing defects.
Understanding of requirements and convert into Technical specifications.
Development of ETL jobs to convert data from SQL Server to Teradata.
Part of Production support team in monitoring the batch.
Worked closely with QA team in integration testing of projects.
Defect/Issue tracking.
Worked in Informatica 8.1 ETL tool for the development.

Confidential

ETL Developer

Responsibilities:

Development of ETL jobs from flat files to Oracle DB for different subject areas.
Adherence of ETL code standards and code review.
Implementation of the ETL codes to Production.
Warranty support to the jobs deployed in Production.
Creation of Test case/Test plan document for the project.
High and Low level design documents creation.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship