ETL Developer Resume Pleasanton, CA - Hire IT People

SUMMARY

Highly motivated IT professional with more than 12 years of experience in Design, Development, Testing, Implementation, and Maintenance of applications using Informatica ETL
Proficient in working with Informatica 10x/9x/8x/7x, SSIS and Reporting tools like Cognos and Business Objects, and Crystal Reports in Windows and Linux environments
Created detailedETL Migration Processesfor Informatica, Database, Scheduling, O/S and H/W teams
Led a group of technical on - shore and off-shore developers and support team
Worked extensively on Informatica partitioning when dealing with large volumes of Meter Reads data and also partitioned the tables in Oracle for optimal performance
Managed software design and technical architecture of a large complex system, using project management and planning skills to minimize development time and maximize client acceptance
Drove continuous process improvement by leading the development, implementation, and maintenance of standardized tools, templates, and processes across the enterprise
Created logical and physical solution documents, solution alternative analysis and participated in implementation plans for project roadmap purposes
Experience with Dimensional Layer Modeling (Facts, Dimensions, Business Measures and Grain of the Fact etc.) and in-depth knowledge of Complex Data Models of Relational, Star, and Snowflake schema
5 years of experience with SQL, Teradata, Oracle Exadata, Erwin
3 years of experience with Business Objects and Cognos
Developed and performed tests on all ETL codes for system data, analyzed all data and designed all data mapping techniques for data models
Deployment activities include interacting with various teams for ETL/DB/Script migration to the production environment

TECHNICAL SKILLS

ETL & OLAP: Informatica 7x/8x/9x/10x, Informatica Data Validation Option, SSIS, IBM Datastage

Reporting and Analytics: Business Objects, Cognos

Business Tools: WebSphere Business Modeler 6.2, Rational Requisite Pro, Clear Quest

RDBMS: Oracle 12c/11g/10g/9i/8i, Teradata, DB2

Testing Tool: HP Quality Center

Scheduler: Informatica Scheduler and Control-M

Operating System: Windows NT/XP/2000, UNIX, Linux

Version Control: Sharepoint

PROFESSIONAL EXPERIENCE

ETL Developer

Confidential, Pleasanton, CA

Responsibilities:

Worked with the project lead to define tasks and create teamwork plans with moderate supervision
Worked closely with internal customers, IT staff, vendors and consultants to plan and execute development projects
Supported other ETL developers; providing mentoring, technical assistance, troubleshooting and alternative development solutions
ProvidedestimationsforETL deliverablesand oversaw the progress of quality ETL deliverables
Provided inputs for risk analyses and development plans to take account of design decisions
Provided project management, estimations, and resource management activities
Documented the business requirements and framed the business logic for the ETL process
Responsible for team management, project planning and monitoring

Environment: Informatica 10.2, WinSCP 3.8, UNIX, Oracle 12C

Senior Quality Analyst Lead

Confidential, Pleasanton, CA

Responsibilities:

Involved in requirement gathering, analysis, and design, and performed end to end testing
Created test plans and test scripts based on the higher/lower level design documents
Worked extensively with Line of Business and User Acceptance testing resources to cover total functionality for system integration testing, including end to end and regression testing
Prepared requirement traceability matrix after completion of test plan and test scripts
Identified and documented defects/system issues using Quality Center and assisted with root cause analysis for timely resolution of defects
Involved in test resources alignment and project funding meetings
Managed and led all the tasks for offshore team members
Created test plan and script, defect management templates; created initial test plan and developed test cases and test scripts manually
Reviewed business requirements, IT design documents and prepared test plans which involved various test cases for all assigned module/projects; reviewed test requirements, created test plans and test strategy documents

Environment: HP Quality Center, Informatica 10.1, WinSCP 3.8, UNIX, Oracle 12C

ETL Developer

Confidential, Pleasanton, CA

Responsibilities:

Provided logical solution design specifications for review and adoption
Created detailedETL standards documentsfor design, development, release management and production support
ProvidedestimationsforETL deliverablesand oversaw the progress of quality ETL deliverables
Designed anddevelopedMetadata frameworkfor the ETL, Business and Support teams for day to day needs
Automated, redesigned and tunedseveral ETL processes for optimal utilization of time and resources
Contributed to the review of physical design
Facilitated communication between business partners and IT

Environment: Informatica 10.1, Informatica 9.6, WinSCP 3.8, UNIX, Oracle 12C, Oracle 11g

We provide IT Staff Augmentation Services!

Etl Developer Resume

Pleasanton, CA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship