Senior ETL Developer

Req ID: 153015

• Provide strategic thinking leadership pertaining to new ways of leveraging information to improve business processes.
• Design and document detailed ETL specifications based on business requirements.
• Design and develop using procedural and record based patterns. Analyze functional specifications and assist in designing potential technical solutions.
• Assist in documenting the requirements, resolving ambiguities and conflicts, and ensuring requirements are complete.
• Define, document, develop, enhance and maintain Software application modules in Informatica, ksh, Perl, SQL.
• Develop high performance application using tuning ETL methods related to Informatica and SQL.
• Develop test plans and tests all code following standards and best practices.
• Perform design validation, reconciliation and error handling for all code.
• Understand and execute release management and change management processes for changes to applications.
• Identifies, troubleshoots and resolves application issues and code defects.
• Production support activities involving the identification, troubleshooting and resolution of application issues and code defects
• Work with source system developers and business owners to define data extraction methodologies.
• Work with Data Modelers to develop data warehouse models, design specifications, metadata process and documentation.
• Understand SDLC concepts and complies with the process.
• Demonstrate success working in a team-based environment by following standardized processes.
• Participate and share expertise in peer reviews of documentation and code.
• Manage individual workload and deliver to the agreed upon project milestones
• Coach and mentor junior team members to facilitate their professional development.
• Demonstrate ability to work in team environment and help resolve issues
• Communicate status / risks to manager regarding delivering solution on time

• Bachelor's degree in Computer Science, Information Systems, Electrical Engineering or related field
• 5 plus years of experience in ETL development, Informatica Programming.
• 5 plus years development experience with database engines including Oracle.

• Strong Database (Modeling, SQL), Oracle, SQL and PL/SQL.
• Understanding of BI/ETL development in the IT industry with recent development, system administration, application tuning and debugging experience.

• Knowledge of database performance factors, monitoring tools and tuning procedures
• Familiarity with Data Integration/Warehousing methodology and techniques.
• Knowledge of the company's business practices, and familiarity with the industry's products and services is preferred.
• Understanding of SDLC and production environments.
• Strong verbal and written communication skills.
• Participate in 24/7 on-call support rotation.
• Business Application experience: Billing & Rating, Activation & Provisioning, Inventory Management, Sales & Marketing, Campaign Management, Dealer Compensation/Sales Commission, CRM/Customer Service
• Software Engineering: PL-SQL, SQL Plus, K Shell, C Shell, Perl

• Integration Technologies: Service Oriented Architecture (SOA), Informatica or other leading ETL tools
• Databases: Oracle, SQL, Data Warehousing, OLAP Systems
• O/S & Network: IBM AIX, Sun Solaris, HP/UX, LINUX