Description :
Title: Senior ETL Developer
Skills: ETL, Informatica, Oracle SQL
Location: Alpharetta , GA
Length: 6+ Months
Job description: Our Client is looking for a Senior ETL Developer.
Responsibilities:
* Provide technical team leadership on data integration project
*Aid in the design of technical and functional requirements.
*Create source to target data mapping documents.
*Help design ETL load strategies
*Responsible for the development of system test plans, test case creation, monitoring progress of specific testing activities against plan, and successfully completing testing activities within the requisite project timeframes
*Coordinate with Business Analysis team to insure data model designs support application requirements.
*Monitor, manage and report on development progress and status
*Designs and documents Life cycle development methodology.
*Develops programs based upon Design Documents
*Adjusts programs to accommodate errors and change requests
*Strong performance tuning experience using Informatica ETL & Oracle SQLs ** Solid understanding of Informatica v7 & v8
*Help design error handling strategies, load back-out strategies
*Develops, implements, integrates and maintains applications.
Job Description
*Under general supervision, formulates and defines system scope and objectives through research and fact-finding to develop or modify moderately complex information systems.
*Prepares detailed specifications from which programs will be written.
*Designs, codes, tests, debugs, documents and maintains those programs.
*Designs and constructs databases to ensure integrity, performance, accessibility, and recoverability of data.
*Establishes database definitions and tables; designs, codes, tests, and implements custom database scripts and formal procedures.
*May perform physical or logical data modeling.
*May also develop in the following areas: Enterprise Resource Planning (ERP), Moble Solution Services (MSS), Product Development, and Customer Care.
1-Completes all technical development tasks pertaining to applications per approved projects and allocated budgets;
2-Interfaces extensively with functional users to confirm the applicability of design alternatives, identifies and recommends cost effective options, and address user concerns;
3-Interfaces as necessary with all critical integration points to insure that applications are integrating successfully and efficiently with all requested applications;
4-Conducts necessary internal quality assurance, system testing, and load testing to insure that the application is of high quality when released to users for the User Acceptance Testing phase of the project (manage all necessary migration of software code to/from the respective environments - development, quality assurance, training);
5-Works closely with end users and corporate sponsors during the User Acceptance Testing phase of the project to insure that any and all necessary changes to the application can be accommodated to meet user requirements while also honoring timeline and budget restrictions;
6-Provides detailed deployment documentation to the support group to insure preparedness to deploy new releases into the production environment within the SLA windows
7-Designs, implements, and maintains databases with respect to access methods, access time, validation checks, and statistical methods;
8-Maps workflow and creates design specifications based on functional requirements;
9-Translates logical information model to efficient physical database designs;
10-Configures, analyzes, designs, develops, and maintains program code and applications to support business processes and functions; works on large, complex installations;
11-At the lower levels, responsibilities focus primarily on simple systems analysis and development activities. At the senior level positions, responsibilities focus primarily on design and development of innovative business solution systems.
12-At higher levels, designs and consults on data design, database architecture, metadata and repository creation; develops data warehousing blueprints, evaluates hardware and software platforms, and integrates systems. Evaluates reusability of current data for additional analysis; reviews object and data models and the metadata repository to structure the data for better management and quicker access. Serves as an expert to application developers to provide expertise on database capabilities and constraints.
Typical Training / Experience:
BS/BA in related discipline
ETL Development
Informatica v7
Informatica v8
Oracle SQL
5-8 years of experience in related field.
Certification is required in some areas OR MS/MA
Dept/Org Scope & Impact - Seasoned professional contributor with responsibility for an advanced area of work in the professional field; May be responsible for entire projects or functions having modest scope/impact or portions of projects having considerable scope/impact to department, area, and, at times, business unit results
Problem Complexity - Performs advanced areas of work for the professional field; Identifies key barriers/core problems and applies problem-solving skills in order to deal creatively with complex situations. Troubleshoots and resolves complex problems
Autonomy - Independently performs assignments with instruction limited to results expected. Determines and develops approach to solutions; Receives technical guidance only on unusual or complex problems or issues
Knowledge - Possesses and applies comprehensive knowledge of particular field of specialization to the completion of complex assignments. Advanced knowledge of organization's technologies and practices
Primary contribution is in applying knowledge (product, industry, professional, technical) rather than managing people. Greater than 50% of time is doing individual contributor work
Influence/People Leadership - May oversee the completion of projects or assignments, including planning, assigning, monitoring, and reviewing progress and accuracy of work, evaluating results, etc.; Contributes to employees' professional development, but does not have hiring or firing authority