ETL Resume Samples

4.5 (112 votes) for ETL Resume Samples

The Guide To Resume Tailoring

Guide the recruiter to the conclusion that you are the best candidate for the etl job. It’s actually very simple. Tailor your resume by picking relevant responsibilities from the examples below and then add your accomplishments. This way, you can position yourself in the best way to get hired.

Craft your perfect resume by picking job responsibilities written by professional recruiters

Pick from the thousands of curated job responsibilities used by the leading companies

Tailor your resume & cover letter with wording that best fits for each job you apply

Resume Builder

Create a Resume in Minutes with Professional Resume Templates

Resume Builder
CHOOSE THE BEST TEMPLATE - Choose from 15 Leading Templates. No need to think about design details.
USE PRE-WRITTEN BULLET POINTS - Select from thousands of pre-written bullet points.
SAVE YOUR DOCUMENTS IN PDF FILES - Instantly download in PDF format or share a custom link.

Resume Builder

Create a Resume in Minutes with Professional Resume Templates

Create a Resume in Minutes
EB
E Brown
Ed
Brown
221 Ortiz Square
New York
NY
+1 (555) 126 6600
221 Ortiz Square
New York
NY
Phone
p +1 (555) 126 6600
Experience Experience
Houston, TX
ETL Analyst
Houston, TX
Jacobson Group
Houston, TX
ETL Analyst
  • Works with team to develop policies and security frameworks to ensure precise and accurate delivery of information
  • Provides expertise using multiple ETL products namely COGNOS DATA MANAGER, INFORMATICA, DATA STAGE, etc. and any other ETL and Modeling software
  • Providing test case input and assisting with production validations
  • Developing process flows and documentation
  • Convert solutions into functional specifications and translate to both development staff and end users
  • Be very passionate about quality and have a strong sense of ownership on the work accomplished
  • Development and documentation of standard file formats
San Francisco, CA
ETL Consultant
San Francisco, CA
Brown-Gaylord
San Francisco, CA
ETL Consultant
  • Performs work on-time, within scope, and with high customer satisfaction
  • Manage dependencies and risks with respect to work assignments
  • Perform work on time, within scope, and with high customer satisfaction
  • Provide status of work tasks
  • Provides status of work tasks
  • Manages and escalates dependencies and risks with respect to work assignment
  • Design, develop, and test processes for extracting data from legacy systems, production databases, Teradata, Teradata Aster, Hadoop, and Open Source platforms
present
Phoenix, AZ
ETL Tech Lead
Phoenix, AZ
Labadie-Spencer
present
Phoenix, AZ
ETL Tech Lead
present
  • Manage day to day activities, setting work priorities, personal development plans, providing training and development opportunities of all direct reports
  • The person will be responsible for leading & supporting the team in technical build & implementation activities for Alerts & Notifications and work across releases for applications for different business functions across BUK
  • Manage/ escalate risks and issues through to resolution. Implement solutions to prevent repetition of known issues/ risks and share knowledge of lessons learned
  • Work closely with the Lead Designer on product designs and make contributions ton architectural issues where possible
  • Assist Project Manager in raising change records
  • Work with SME, Data stewards for data discovery and identify anomalies in existing platform as an improvement area in new environment
  • Closely work with Project/Release managers & support them in all activities during the entire life cycle of the project
Education Education
Bachelor’s Degree in Computer Science
Bachelor’s Degree in Computer Science
Baylor University
Bachelor’s Degree in Computer Science
Skills Skills
  • PL/SQL, SQL, Oracle, Strong Understanding of ETL, Principles of Data Modelling, basic Unix, DataStage or Informatica helpful
  • Provide follow-ups and resolution to the issues raised on design and code reviews
  • Responsible for organizing code review and obtaining sign-up on the code he/she delivered
  • Contribute to logical/physical data models, class diagrams, activity diagrams, sequence diagrams and UI prototypes
  • Perform peer reviews on code and design as requested
  • Perform additional design tasks as assigned by team or tech lead
  • Responsible for Component/Application Design for flawless functionality and optimal performance
Create a Resume in Minutes

15 ETL resume templates

1

ETL Performance Engineer Resume Examples & Samples

  • SQL performance tuning including over time ability to apply particular TD techniques/capabilities
  • Ability to analyze data consumption patterns & then work with consumers to define adjusted as well as new views
  • Assist data modelers in identifying new facts and dimensions to be used in datamarts
  • Work with the onsite and global team in the SDLC model to deliver high quality technical solutions that meet the needs of our clients
  • Establish/communicate a quality solution that will enable the group to implement changes into the target EDW in a timely and efficient manner
  • Build / improve client relationships through proactive communication and face-to-face meetings
  • 5+ years of professional experience as a Performance Engineer in an Enterprise Data Warehousing environment; hands on experience with Informatica is preferred
  • Experience writing Unix Shell Scripts, preferred
  • Experience with designing physical and logical models preferred
  • Proven ability writing complex SQL statements
  • Experience with Teradata is preferred
  • College degree in Computer Science or related field or equivalent experience
2

Senior ETL / Business Intelligence Developer Resume Examples & Samples

  • Business Objects – Universe Designer & Web Intelligence
  • QlikView
  • BO Data Services
  • Oracle & PL/SQL
  • Enthusiastic, clear, and concise communicator
  • Translate technical speak in business terms
3

Icdw ETL Common Components Lead Resume Examples & Samples

  • Prioritizing and manage development and implementation of enhancements/changes
  • Conduct ETL design and architecture reviews with Application Development Teams
  • Collaborate with developers, architects, quality assurance and production support
  • Develop and maintain ICDW DI standards and best practices
  • Maintain book of work for ICDW Common Components
  • Oversee common components release work and work prioritization
  • Manage onsite & offshore consulting resources
  • Coach staff in technical matters and delivering on other job-related responsibilities; conduct performance reviews, appraisals and personal development planning with each team member; and promote effective teamwork and resolve interpersonal issues
  • 5 years of Data warehouse experience
  • 7 years of experience with Informatica Power Center required, Power exchange experience would be a plus
  • 5 years of unix shell scripting experience
  • 5 years of any RDBMS experience, teradata experience will be a plus
  • 3 years of experience in a ETL Lead Role
  • Experience in establishing ETL standards, best practices and strategy
  • Proven experience in all phases of the Software Development Life Cycle (SDLC)
  • Proven experience leading development teams to meet the goals of the project; mentoring less experienced team members
  • Proven ability overseeing Release Management including the final production acceptance review and signoff
  • Bachelor's/Master's Degree in Computer Science or related field experience
4

Senior.VP / ETL BP&A Senior Analyst Resume Examples & Samples

  • Bachelor's degree CIMP certification preferred
  • Experience managing cliet focused teams in a highly visible, high stress environment
  • 10 years relevant experience
  • Experience with ETL tools (Ab Initio preferred)
  • Knowledge of data quality concepts and the theories of data quality
  • Experience developing and executing ETL rules
  • Experience moving large amounts of data within large corporations
  • Familiar with analytic concepts, practices, and procedures
  • Ability to define, create, and improve procedures to ensure consistency and adherence to all necessary policies
5

Etl Development Manager / Lead Resume Examples & Samples

  • 12+ years in a technical specialist/architect role with experience on implementing large and complex large projects
  • Financial Services experience is a requirement, and data warehousing experience is required
  • The candidate should have very strong technical experience in the areas of data analysis, database design, ETL, data mining experience
  • Strong Ab Initio/Informatica/SWIFT expertise is required
  • The candidate should have strong Oracle and UNIX experience
  • Non-technical knowledge, experience, and skills (leadership, management, oral and/or written communication, etc
  • Due to the high visibility of the position, the candidate must possess superior communication skills as they will be interacting with people with diverse skills and seniority. The sometimes ambiguous environment means that the candidate should also be experienced with multi-tasking, balancing tasks with priorities accordingly
  • The person has to be results-orientated, willing and able to take ownership of engagements. The candidate should have strong analytical skills. Prior vendor management engagements experience is preferred
  • Educational requirements
6

ETL Technical Lead-aml Domain Resume Examples & Samples

  • 8 years in a technical specialist/architect role with experience on implementing large & complex large projects
  • Financial services experience is a requirement and data warehousing experience is required
  • Exposure to AML business domain knowledge is preferred
  • The candidate should have a very strong technical experience in the areas of data analysis, database design, ETL, data mining
  • Strong Informatica expertise is required
  • Non-technical knowledge, experience, and skills (leadership, management, oral and/or written communication, etc.)
  • The sometimes ambiguous environment means that the candidate should also be experienced with multitasking, balancing tasks with priorities accordingly
  • Experience working on several projects at the same time is required
  • The person has to be results-orientated, willing and able to take ownership of engagements
  • Language requirements (including proficiency levels for speaking, reading, and writing): English – excellent
7

ETL Development Lead Resume Examples & Samples

  • Participate CPB ETL CoE activities and work with regional development teams to define and enforce the global standards and best practises
  • Work with on-shore team support on-going ETL development tasks
  • Work with the global and region application teams support the strategic initiatives
  • Has rich experience in working in multiple complex projects as ETL developer lead
  • 7+ years industry experience
  • Hands-on experience: 6+ years with Ab Initio (mandatory) and other ETL tools (optional)
  • Very good SQL and relational databases experience such as DB2, Oracle
  • Solid development skill and software life cycle experience for enterprise application
  • Strong expertise in data analytic, technical design, debugging and problem solving
  • Strong customer service and team orientation skills
  • Strong written/verbal communication skills
  • Good Unix and Shell scripts skill are necessities
  • On-shore development experience is a plus
  • Candidate should be willing to work late in the evening India time on need basis in order to interact with US onshore team and to meet urgent requests by clients
8

Software Development Manager ETL Resume Examples & Samples

  • Position is supervisory but requires strong technical acumen
  • Proven leadership on strategic programs
  • Extensive experience with data warehousing and meta-data driven development
  • Extensive experience with RDBMSs, specifically Oracle
  • Extensive experience with ETL design and implementation (preferably using Ab Initio or Informatica)
  • Experience with Service Oriented Architecture (SOA), TIBCO and web services
  • Able to manage multiple projects simultaneously with competing priorities
  • Experience with budgeting, planning, fiscal controls and application lifecycle management
  • A track record of successfully delivering to plan and on budget
  • Strong problem solving and trouble shooting skills with the ability to react quickly to changing requirements and evolving situations
  • Ability to analyze requirements and guide the team toward accurate effort estimates
  • Ability to produce work breakdown structures and project plans
  • Experience with Level III production support and the maintenance of a large suite of applications
  • Must work well in a collaborative, team environment as well as independently
9

ETL Development Manager Resume Examples & Samples

  • Expert in technical are 4 of the following areas: Technology Delivery, Data base and data concepts and ETL tools and technologies
  • Expert in managing high pressure technical deliveries within strict timelines
  • Must have a strong track record of managing large complex business change and technical change programmes of strategic significance including via third party suppliers
  • Strong Project mobilisation / initiation / planning experience in addition to management of established programmes
  • Must be able to demonstrate first class stakeholder management, highky skilled in communication both written and spoken, strong presentation skills and strong and influential personal credibility
  • Expert in managing significant business change/transformation challenges
  • Exceptional leadership skills with evidence of managing large teams across a range of disciplines and locations
10

Cib-dcpp-etl & DB Expert Resume Examples & Samples

  • Design and develop database schemas and objects
  • Develop complex Stored Procedures and materialized views to optimize report performance
  • Monitor health and capacity of the database and perform resiliency activities like partitioning and purging
  • Develop shell scripts in Unix to support data loads in the database
  • Design and support Informatica ETL mapping and workflows using Power Center designer, repository manager, workflow manager/monitor
  • 5 to 8 years of hands on Oracle/Sybase database experience in a large scale datawarehousing environment (preferably in financial domain)
  • 2 to 3 years of ETL experience in Informatica desired
  • Excellent knowledge of datawarehousing concepts (Star schema/Snowflake schema/SCD), SQL performance tuning and best practices
  • Nice to have prior experience working with columnar databases like Sybase IQ
11

ETL Technical Lead Resume Examples & Samples

  • Responsible for the technical implementation of a project
  • To be an acknowledged expert in their technical field with proven experience of the techniques and tools being used across the development lifecycle
  • To work across multiple phases of software development within a project as a team member or dealing with the most technically challenging assignments. This includes
  • Working directly with business areas to clarify detailed technical requirements
  • Designing, coding and unit testing the most complex software components for new or enhanced IT systems to a high level of quality, producing appropriate documentation
  • Providing technical support to business analyst/project managers and coaching to less experienced staff across a geographically dispersed teams
  • Maintaining an expert level awareness of relevant software design techniques, development tools and processes, providing leadership in the use of these across the organisation area
  • Database code (SQL and PLSQL) performance tuning skills
  • Unix commands and shell scripting knowledge
  • Can describe the overall function of several components in the technical platform
  • Can identify the specific functions and responsibilities and key customers and relationships of own IT department/function
  • Can describe rationale for major IT initiatives and identify major IT issues
  • Contributes to the development and implementation of standards and procedures
  • Has developed and executed a full spectrum of tests on multiple applications and environments
  • Experienced with testing complex, multi-platform, distributed applications
12

Im-etl, BO Developer Resume Examples & Samples

  • Analyze requirements and develop ETL/BO reports with minimal supervision
  • Generate and maintain system documentation
  • Participate in requirement meetings with business and technology stakeholders
  • Analyze requirements and develop Business Objects reports with minimal supervision
  • Work on informatica end to end
13

ETL Development Manager Resume Examples & Samples

  • Lead and communicate mid to large scale Data Integration projects directives/progress with key stakeholders, independently
  • Interpret written business requirements, functional requirements and technical specification documents to design and develop technical solutions that meet business needs
  • Provide status and progress updates to Technical Leads and Project Managers
  • Contribute to design review meetings with other members of Application Development
  • Perform complex defect verification, debugging, testing and support
  • Create and maintain technical documentation using defined technical documentation templates that meet SDLC standards
  • Financial Services industry experience desired, but not necessary
14

ETL Analyst Resume Examples & Samples

  • Bachelor’s Degree in Computer Science, Information Systems or related field / equivalent experience
  • 5+ years of experience in developing and/or supporting technical solutions for Informatica, Ab Initio ETL Applications or equivalent Data Warehouse ETL applications
  • Must have at least 3 years of experience with BI reporting tools
  • Worked in environments using SDLC methodologies and standards - Agile preferred
  • Must have strong analytic and problem solving skills
  • Exposure/Experience in Unix/Linux environment
  • Prior development experience is a Plus
15

IT Solutions Developer / ETL Resume Examples & Samples

  • Develop reporting applications using SQL Server2005 in customized ETL framework
  • Participate in peer reviews of business requirements
  • Design, develop and unit test ETL/Database/Report technical components
  • Document and maintain design diagrams/specifications
  • Responsible for task estimation using established estimating models, best practices and past experience
  • Interact with team leads to ensure designs are thorough, consistent and meet long term design objectives
  • Troubleshoot functional and performance issues in development and test environments
  • Communicate risks and issues to the team lead in a timely manner
  • Comply with mandated policies and procedures and contribute to procedural improvements
  • Ensure adherence to architectural best practices including maximizing reuse within and beyond areas of direct responsibility
  • Ensure 100% compliance to TD's delivery methodology and audit / control requirements
  • Represent the development team at project stakeholder meetings and obtain buy-in from management for all key project plans / commitments
16

Nform Data / ETL Manager Resume Examples & Samples

  • Knowledge or exposure to industry ETL tools (Datastage/Informatica) data movement concepts required
  • Background/exposure to Finance/Accounting preferred
  • Strong skills in Excel for data validation
  • MS Office skills for creating documents and presentations
  • Develops periodic goals, organizes the work, sets short-term priorities, monitors all activities, and ensures timely and accurate completion of the work
  • Maintains risk management and compliance programs and activities for their assigned group
  • Provides input and support to budget management process
  • Identifies business needs and develops conceptual applications design
  • Ensures completion of management status reporting for projects
  • Advises systems staff on the impact of systems enhancements to existing designs
  • Provides project planning including docket prioritization and budget considerations
  • Markets systems products and services to other partners or clients
  • Communicates with various business areas and outside vendors, consultants, and clients regarding automation needs
  • Ensures compliance with all audit requirements including change control procedures and data security
17

Senior Tech Lead-avp-etl for Global Finance Applications Resume Examples & Samples

  • As an Applications Senior technical Lead, responsible for leading distributed ETL development teams for the Global Finance applications
  • Lead and participate in application design, development and support of various Corporate Risk Treasury work streams to achieve business requirements & objectives, in a collaborative environment
  • Client interface and Source interface for both business and Technology teams globally for Product Data across Wholesale and Retail bank products
  • Responsible for Implementing all business required Change request and new sourcing within the Common Data Acquisition Framework
  • Lead for team of Common data Acquisition developers
  • Responsible for technical specs & design, code reviews, testing, & production implementations
  • Function as a liaison to the offshore development teams and technical represented to the business teams
  • Must be able to multi-task and work on multiple projects at the same time
  • Must have 6-8 years of experience of in-depth Data analysis and requirement documentation within the financial industry. -
  • At least 8+ year of experience in senior development and lead responsibilities using Ab Initio ETL
  • At least 4+ years of experience using Operations Console and Ab Initio BRE
  • At least 3+ years of experience developing on the Application Configuration Environment
  • At least 5-6 year of hands on SQL construction using Databases such as Oracle, Netezza and Teradata
  • At least 4+ years of experience using Operations Console
  • Solid understanding and experience of data regarding financial product and balances
  • Solid technical troubleshooting and problem management skills
  • Strong verbal and written communication skills, particularly ability to write technical specifications
  • Proficiency in Microsoft Office and project management tools
  • Degree in BS or better in MIS or CIS technology areas preferred
18

Development Lead-etl Resume Examples & Samples

  • Provide leadership expert specializing in practices and development tools
  • Participate in the definition and implementation of norms and standards development and fosters their development when required
  • Promote good practice development and also acts as a coach within the development teams
  • Ensure technology watch on processes and development tools
  • Make analysis for the selection of new technologies, tools and development methods and propose standardization for business
  • Coordinate the implementation of new techniques, methods and development tools in the enterprise
  • Help with the designer of solution as a technology expert to develop a detailed design that meets the system requirements
  • Validate the technical feasibility of the solution and raise the risk areas
  • To have an overview of developments and to explain the design to a group of developers
  • Ensure that development is consistent with the design
  • Participates in the evaluation of estimates, valid and promptly report deviations during the implementation
  • Acts as a technical coordination regarding the preparation of development environments and ensure their integrity during the project
  • Responsible for the implementation of norms and standards in the project and is the guardian of best practices
  • It plays a leadership role with developers. It determines the optimal sequence of activities taking into account technical constraints and schedule
  • Ensure the quality of deliverables development (code review, unit testing, installation instructions, regardless of performance, etc.)
  • Identifies common (technical) services, develops and promotes reuse
  • Responsible for integration activities and preparing deliveries (packaging, deployment, ...)
  • Participates and supports various testing phases (preparation of test data, setup environments ...)
19

CIB Investor Services Senior ETL Resume Examples & Samples

  • ) 3-5 yrs industry experience in financial markets
  • ) Must be able to work directly with business users and analysts to understand and document requirements
  • ) Must be proficient with programming standards and best practices
  • ) Must be able to function in a self supervisory manner
  • ) 5+ years experience SQL Server development (Proficiency in Stored Procedures, Triggers, Batch processing and Performance tuning is a must)
  • ) 5+ years experience as Informatica PowerCenter developer (Latest Version 9.1)
  • ) 5+ years experience Unix Programming. Shell scripting, Perl
  • ) 1-2 years experience Control-m programming
  • ) Experience writing technical documentation for production support
  • ) Very good communications skills
20

ETL Senior Analyst Resume Examples & Samples

  • Interface with various teams within the IT organization and with business partners
  • Perform regular on-call rotations for support of ETL processes
  • Fulfill role of technical lead for complex projects between disparate IT systems
  • Mentor, coach, and provide feedback to develop associates
  • Ensure all changes are properly documented, planned, tested, and approved prior to being moved into production
  • 5+years of experience in developing ETL solutions
  • Experience developing solutions for both Data Warehouse and Enterprise Applications
  • Experience troubleshooting technical issues, and optimizing and debugging OracleSQL/PLSQL
21

Edw Etl Development Lead Resume Examples & Samples

  • 7 - 10years of experience at Enterprise-level ETL development and ETL architecture using Informatica, Teradata, and understading the COBOL file structures
  • Strong Informatica technical knowledge in the areas on Informatica Designer Components -Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor
  • Good knowledge of analytical and logical conceptual level programming skills
  • Good knowledge of Erwin model generation tools (logical and physical); Teradata and the Teradata Financial Services Logical Data Model
22

Ihc Etl Development Manager Resume Examples & Samples

  • Develops, maintains and utilizes business intelligence and reporting tools necessary for measuring the Group's productivity and, in turn, supporting the CBG Sales & Marketing Manager
  • Develops and manages databases from the download of raw data from the host systems to departmental systems. Analyzes the utilization of downloaded data and reports to determine the feasibility of complete automation of reporting
  • Develops, with Information Technology and within the groups operating divisions, Both long-range and short-range plans and provides detail for the acquisition and installation of software and equipment
  • Provides Group level KPI analytics and reporting to management. Including the development and monitoring of pipeline reporting, referral tracking, product goals, client portfolio reports, etc
  • Manages department systems and business intelligence staff including selection, work allocation, development and performance management
  • Directs the continuing review of present systems and work processes, examining techniques in use and determining appropriate changes to effect improvement, reduce costs and enhance efficiency
  • Interfaces with users, vendors, and Information Technology to ensure compliance with their requirements for applications being developed
  • Supports and implements department level initiatives and vendor relationships
  • Supports management by working within the department to improve communication, system availability and customer service
  • Oversees the development and facilitation of training classes on new or updated procedures as necessary
  • Bachelor’s Degree in Information Systems required
  • Master’s/Advanced Degree in Information Systems preferred
  • 10 or more years directly related technical experience
  • 10 or more years supervisory/management experience
  • Management skills in particular managing technical staff
  • Strong knowledge of business systems and database management
  • Strong knowledge of SQL database
  • Strong knowledge of Microsoft Office, including EXCEL, ACCESS, Project, Visio, Word, and Outlook
  • Strong knowledge of OLAP or MOLAP cubes and Business Intelligence Reporting
  • Strong knowledge of Visual Basic.net
  • Familiar with Banking Systems
  • Strong understanding and application of principles, standards, industry practices, techniques and concepts
23

ETL Technology Business Consultant Resume Examples & Samples

  • Design and develop relational database environments, database models, and ETL processes across a variety of platforms using SSIS and custom/hand coded ETL processes (i.e. Python and .NET)
  • Consult with business partners in a way they understand to solve complex business problems
  • MS SQL Server query authoring and database optimization
  • Establish architectural principles, design patterns, best practices, and mentor team members on their appropriate application
  • Potential for advanced data analytics work
  • Strong experience and knowledge of designing and developing relational database environments, database models, and ETL processes within MS SQL Server with an understanding of design for scalability, performance, and reliability
  • Write complex queries, joins, and updates using T-SQL programming
  • Advanced query performance tuning (query plans, hints, indexing strategies, etc.)
  • Experience with Oracle PL/SQL and DB2
  • Familiarity with Unix/Linux environments and shell scripting
  • Experience with one or more scripting languages (Python, Perl or Ruby)
  • Excellent communications and interpersonal skills; ability to work with business partners as well as other members of the technical staff
  • Demonstrated ability to mentor others to maintain architectural vision and quality
  • Working knowledge of C# and Visual Studio
  • BS degree in computer science, engineering, or other major requiring engineering core course
  • Knowledge of documentation of database and software architecture using UML (Visio, SPARX EA Architect)
24

Senior Etl Technical Systems Analyst Resume Examples & Samples

  • Develops detailed plans and accurate estimates for completion of build, system testing and implementation phases of infrastructure projects
  • Provides 4th level of support on a weekly rotation base. Lead L4 trouble-shootings and infrastructure incident reviews. Create a plan/solution to prevent future support incidents for reoccurring
  • Following best practices of change management and source version controlling
  • 10 % Mentoring and Communications
  • Preferred Capital Markets knowledge and experience
  • Expert with Data Warehousing and ETL tools, IBM Infosphere DataStage, Informatica, etc
  • Expert with Linux administration, software installation, NAS, SAN, SFTP
  • Proficient with multiple commercial RDBMS: SQL Server, Sybase, Oracle, DB2, MySQL, Teradata, Vertica,etc
  • Programming languages: Java, C/C++, HTML, Unix Shell
  • IT Standards, Methodologies, Audit Requirements, SDLC
25

Etl Software Developer Resume Examples & Samples

  • PL/SQL scripting
  • C/C++ language
  • HP-UX / Linux (RedHat 5.x) environment
  • Good communication and documentation skills in English
26

Application Developer Etl Resume Examples & Samples

  • Manage technical project team consists of full time & consultants for successful development and delivery of the project
  • Handle multiple projects in parallel
  • Work closely with Business Analysts and help them in FRD completion
  • Participate and deliver Solution design, working closely with the architecture team
  • Performance improvement & SQL tuning of Informatica mappings, SQL & PL/SQL scripts
  • Technical reviews, Data validation & end to end testing
  • Participate in new team member hiring
  • Create necessary documentation as per SDLC standards and Agile development methodologies
  • Participate in definition, implementation and measuring of development and delivery performance metrics
  • Participate in support activities after project go-live
  • Computer Science or Engineering or equivalent
  • SAP BODS, Informatica certifications a plus
27

Lead Data Engineer Etl Resume Examples & Samples

  • Design data integration solutions that deliver business value in line with the company's objectives
  • Provide the thought leadership within IT to advise the business, mentor staff, and leverage industry best practices in data integration
  • Provides scoping, estimating, planning, design, development, and support services to a project
  • Collaborate with the IT product management team to influence product direction
  • Track progress and intervene as needed to eliminate barriers and ensure delivery
  • Review the technical work of other team members
  • Ensure adherence to IT standards and methods
  • Responsible for communicating status, problems, issues and underlying process problems to technical and non-technical audiences
  • Participate in establishing IT standards and processes
  • Participate in recruiting employees and contractors
  • Provide training, guidance, assistance, and knowledge transfer among team members
  • 2 - 3 years of Technical lead background
  • 8 or more years of hands-on experience Testing in a Oracle/ Teradata Data Warehouse environment required
  • 8 or more years experience in analyzing, testing, documentation and maintaining complex software programs
  • 8 or more years experience in designing the Test Strategy, writing Test Cases and Test execution activities for Data Warehouse Environment
28

Second Level Operations Etl & dwh Engineer Resume Examples & Samples

  • 2nd/3rd level restoration, maintenance, configuration management of ETL&DWH solution deliveries
  • Code debugging (mainly complex PL/SQL code)
  • Preventive maintenance, platforms and application troubleshooting
  • ETL & DWH design strategy scheduling basing on customer needs and platforms dependences
  • Fault Management, Problem Management, Incident Management & Configuration management, including on call service outside business hours
  • Oracle Database 10/11g Administration Knowledge
  • DataStage (Ascential, Infosphere) Basic or Administration Knowledge
  • Unix Shell Programming
  • Web languages programming
  • Previous experience as Developer and/or Tester and/or Deployment
  • Oracle WebLogic Server 11g: Advanced Administration
  • BOXI
  • Knowledge of Managed Service Telecom Operations Practice
29

Development Lead Etl Resume Examples & Samples

  • Assists in the definition and execution of data acquisition processes, database/application design blueprints, and SDLC project plans
  • Leads the analysis, design, coding, testing, documentation, implementation and maintenance of ETL solutions
  • Creates/enhances development guidelines/standards, and enforces adherence to design and development standards
  • Provides ETL expertise to the business processes supported by the ETL application
  • Performs SDLC program/project planning, execution and control
  • Experience in the Design, Development, Testing and Deployment phases of the SDLC process
  • Informatica PowerCenter experience
  • Good analytical and communication skills
  • Project-based solution delivery experience
30

Etl Development Lead Data Management & Analytics Resume Examples & Samples

  • Ability to formally and informally mentor/teach other members of not only their team but both business consumers & IT application team personnel proper SQL (and where required, TD specific) techniques
  • Ability to define, design, execute or supervise the execution of appropriate performance tests
  • Ability to provide detailed revisions to existing training materials, more importantly, ability to be a lead participant in performance tuning "boot camps" that will be conducted on a go forward basis
  • Ability to over time provide guidance to development teams re: specific application of detailed architecture guidance to view builds
  • Ability to understand data models including upcoming specific revisions impact (if any) on existing structures and indices
  • Ability to work with IT and/or business personnel on adjustments required to their processes (bundles of queries) including potentially to the application or tool which triggers the process(es). Application here is meant in the literal sense of the word
  • Establish/communicate goals and objectives for the various projects
  • 5+ years of professional experience as an ETL developer in an Enterprise Data Warehousing environment; hands on experience with Informatica; Ab Initio highly preferred
  • Proven experience with issue resolution processes for application production problems
31

Ihc Etl Development Manager Resume Examples & Samples

  • Manages employees directly, through subordinates and occasionally other managers. Establishes performance goals, allocates resources, assesses annual performance and recommends individual merit and promotional increases
  • Prepares project plans including scheduling, costs, resources and other operational concerns
  • Analyzes management needs regarding information retrieval, data control and use of computing and data processing resources and processes. Maintains knowledge of emerging technologies and recommends/evaluates technologies
  • Directs and/or assists in the continuing review of present systems and methods, and the formulation of new and revised systems, examining techniques in use and determine appropriate changes to effect improvements, reduce costs and enhance efficiency
  • Plans, coordinates and schedules investigations, feasibility studies and surveys, including the economic evaluations of proposed and existing systems
  • Ensures proper coordination between assigned staff and all interfacing staff and groups
  • May conduct vendor negotiations and develop contract proposals
  • Provides technical expertise in the examination and definition of objectives of existing or proposed systems and in the design of improved systems utilizing information technology
  • Assist in the development of cost and time estimates for capital budgeting plan
  • Assist in the development of operational budget plan for the area
  • Bachelor's degree in information systems or related field
  • Seven to ten years directly related experience
  • Extensive working level systems knowledge
  • Experience managing staff and managers
  • Technical skills in systems management, technologies, integration of distributed systems for centralized control and optimization
  • Must have understanding of mainframe, mid-range and micro-technologies, platforms and networks (LAN, WAN, VANs.)
  • Knowledge of ACD and V systems
  • Budgeting skills
  • Compile statistics, prepare forecasts and recommendations
  • Cost analysis projections
  • Demonstrated management
  • Develop business proposals
  • Develop installation policies and procedures
  • Effective negotiating
  • Planning, organizing and controlling
  • Team building
32

Business Intelligence / ETL Manager Resume Examples & Samples

  • Key participant in creating and implementing a data management/governance framework for JPMIS
  • Develop and plan required data sourcing and transformation projects in response to business needs
  • Effectively partner with the Data Insights team to drive usage and improvement of the IntelliStor data asset that drives analytics within JPMIS and for our strategic partners
  • Schedule, organize and manage new information & data management activities for JPMIS
  • Create and enforce guidelines to ensure consistency, quality and completeness of all JPMIS data assets
  • Apply quality assurance best practices to all work products
  • Manage a team of technologists
  • 10+ years of overall experience with an emphasis on Business Intelligence, Data Modeling, ETL, and Analytics
  • Financial Services background or experience required – specifically as it relates to products within the wholesale banking space (e.g., derivatives, equities, investment/wealth management)
  • Technical skills as demonstrated by analytical experience
  • Deep experience across the full range of database and business intelligence tools; publishing and presenting information in an engaging way
  • A proven track record of strategic thought leadership
  • Demonstrated experience building, leading and managing high performing teams
  • Technical expertise regarding data management frameworks, ETL solutions, data models and database design/development
  • Extensive experience with SQL, ETL frameworks and data visualization tools
  • Experience in data mining techniques and procedures and knowing when their use is appropriate
  • Knowledge of Big Data technologies (e.g., Hadoop, GreenPlum) is preferred
  • Knowledge of Java (Core, Servlets, JDBC) and Python development is preferred
33

ETL Development Lead-data Management & Analytics Resume Examples & Samples

  • Proactively engage with the project stake-holders and understand requirements
  • Leading data modeling discussions
  • Assisting in setting technical direction for data within the organization
  • Guiding technical decisions to support long term strategy around core consumer data model
  • Establish standards around flexibility of the data model to ensure deviations are within established guard rails
  • Five or more years of experience in data modeling and design, coupled with strong knowledge of the software development lifecycle
  • Five or more years of enterprise level data design and development
  • Three or more years of management experience
  • Hands on experience with modeling tool such as (but not limited to) ERWIN
  • Hands on experience with massively parallel processing database technology
  • Five or more years of professional experience as an ETL developer in an Enterprise Data Warehousing environment; hands on experience with Informatica; Ab Initio highly preferred
  • Demonstrated experience in all phases of the Software Development Life Cycle (SDLC)
  • Proven ability writing SQL statements
  • Demonstrated experience working with a project team to develop a strategy, technical solution, and ultimately to implement high quality technical solutions
  • Experience with Teradata preferred
  • College degree in Computer Science or related field
34

Analyst, ETL Solutions Resume Examples & Samples

  • Design and develop new source system integrations from a variety of formats including files, database extracts and APIs
  • Design and develop solutions that deliver data in the correct structure inside the data solution including transformations from source systems into a core model as well as moving data from unstructured to relational systems for analytic processing
  • Design and develop solutions for regularly exporting data to divisions for marketing and reporting as well as external vendors
  • Investigate problems and resolve as required, including working with various internal teams and vendors. Proactively monitor the data flows with a focus on continued performance improvements
35

ETL Solution Engineer Resume Examples & Samples

  • Provide L3 Support to operational applications running out of both New York and Zürich
  • Act as developer for multiple .Net BI projects
  • The development services will range from regional specific deliverables to collaborative delivery of global projects and will require strong problem-solving skills
  • Engage with the business to capture and refine requirements
  • Development initiatives will cover all phases of the SDLC+ lifecycle, including design, development, implementation and support of software solutions
  • Work closely with a global technology team and contribute throughout the agile development cycle
  • To be part of a global, client-focused team that supports a wide range of business initiatives and processes for Products IT in the PB WM domain
  • Ability to multi-task and quickly adapt in a dynamic environment is critical
  • BS / BA in Computer Science, Engineering, MIS or Mathematics
  • Minimum 5+ years of IT experience
  • Good work experience in Microsoft reporting services, Integration services, analysis services and MS .Net
  • Efficient Analytic, Problem Solving, & Decision Making Skills
  • Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, User Defined Functions and Cursors
  • Solid skills in MS Office suite, Excel, Word, Power Point, SQL using sql server and / or Oracle
  • Working knowledge in dash boarding tools such Tableau and Qlick View a plus
  • Working knowledge of Enterprise Architecture a plus
  • General knowledge of financial industry – equities, fixed income, options
  • Knowledge of Private Banking domain - Risk Analysis, wealth management strategies and advisory process a plus
  • English mandatory, German advantageous
  • Excellent troubleshooting skills
  • Ability to communicate project status and performance to project stakeholders and management
36

AVP ETL Development Resume Examples & Samples

  • Create project estimates
  • Create documentation to describe system design
  • Provide status updates to management team
  • Work with multiple teams to ensure accurate integration with multiple systems
  • 12+ years of extensive data integration experience
  • Extensive knowledge of Informatica PowerCenter 9.X which includes development, designing and providing solutions to the existing problem
  • Well versed in MSSQL and Oracle Databases
  • Knowledge of other Informatica tools including DVO, IDQ, and TDM
  • Excellent team player with ability to manage solution design from inception to delivery
  • Out of box thinker in terms of ETL development
  • Informatica Sales Force integration knowledge is optional
37

ETL Application Development Manager Resume Examples & Samples

  • The person will be leading a business delivery vertical – of mid-large size teams supporting mission critical Mortgage Banking ETL applications
  • Engage/Drive the planning, architecture, design, and development of solutions that satisfy business requirements for large complex systems
  • Interact with senior leadership in the organization to develop strategy for teams at global sites
  • Day-to-day resource management and Project Execution
  • Will have functional reporting to Executive Director/Head in US and local reporting to India Site Manager
  • A minimum of 12 years of overall applications development experience required with 6+ years of experience with leading the design and development of ETL systems
  • Experience in developing business cases and present complex ideas quickly and effectively
  • Deep technical expertise in areas including ETL tools, Open systems, development tools
38

Risk-etl Development Lead Resume Examples & Samples

  • Informatica certified developer a plus
  • Able to work with Infrastructure Teams/DBA for Performance Tuning related efforts
  • Strong expertise in writing shell scripts
  • Professional verbal and written communication skills
39

ETL & Data Warehousing Specialist Resume Examples & Samples

  • Development and support of ETL solutions
  • Incorporating new or pre-existing company data into the warehouse on a regular basis
  • Interaction and engagement with management and stakeholders across the entire business unit
  • Work closely with the Business Intelligence and ETL teams to develop and expand the ETL competency within IT
  • An IT qualification or relevant experience
  • Strong knowledge of Data Warehousing technologies & methods
  • Proven track record of managing & successfully delivering projects
  • Experience developing in Oracle & Microsoft data warehouse software tools (e.g. Oracle Data Integrator, Microsoft SSIS, PL/SQL etc.)
  • Experience with the full development lifecycle
40

ETL / Teradata Developer Resume Examples & Samples

  • Provide reporting capabilities for new product offerings
  • Provide product analytics that give insight into effectiveness of our product offerings
  • Provide capabilities to predict customer behavior, and empower business to strategize on future product offerings
41

Manager Mis\etl Resume Examples & Samples

  • Run Extraction Transformation Load (ETL) processes of intermediate level of complexity to meet the high availability, data integrity and reliability requirements of the production environment
  • Monitor, assess and evaluate ETL results
  • Through various dimensions of analysis, work closely with our technology partners and Country teams’ to develop actionable recommendations to enhance data quality & productivity
  • Strong knowledge of server operational and application platforms: Windows 2003/2007, database and programming platforms and technologies: MS SQL Server 2008/2012, DTS, SSIS, TSQL, SAS, SAS Macro, VBA, VBScript
  • Understanding of financial and management accounting principles
  • Effective team-builder and a good team-player and highly dedicated to the highest standards at customer service
  • Excellent analytical, problem solving and troubleshooting skills
  • Creative and flexible in finding solutions to support business needs in a rapidly changing, demanding and complex environment
  • Excellent interpersonal and communication skills and be able to work independently as well as within the team
  • Ability to deliver results under tight deadlines with multiple priorities is essential
42

ETL Administrator Resume Examples & Samples

  • Problem analysis, evaluation, recreation, and resolution of client reported problems
  • The use of relevant problem management systems to search for known problems and to create new entries/update existing entries
  • Perform daily health checks, liaise directly with client staff, complete technical analysis and resolve production incidents and problems
  • Minor enhancements to the ETL tool
  • Hands on participation in problem resolution, with responsibility for supporting significant ETL processes
  • Ability to support SQL Server, DataStage and Java required
  • Support triage of problems across the client, IBM and subK elements of the solution
  • Aptitude and willingness to learn new analytics solutions (via Watson Content Analytics) an advantage
  • At least 5 years experience in software development background
  • At least 5 years experience in Datastage, SQL Server, Java
  • At least 5 years experience in support/operations roles
43

Lead ETL & Smartstream Developer Resume Examples & Samples

  • Demonstrate a good grasp of modern day design patternscode development techniques and software industry best practice
  • Should be able to demonstrate an active and ongoing interest in improved development practices and techniques
  • Business Analyst skills, and extensive Java / C# knowledge. Knowledge of existing Nomura solutions will also be desirable
44

Core Banking Senior ETL BA Resume Examples & Samples

  • Utilises good understanding of business analysis procedures and concepts and basic knowledge of other technical areas to Independently analyse business client needs
  • Participate in the ETL batch services development using the AbInitio framework to support TTS Core Banking business processing requirements in the EMEA region
  • Work proactively & independently, with all stakeholders, to address business requirements and articulate issues/challenges with enough lead time to address risks
  • This role is required to perform peer code reviews, test case reviews and deployment reviews
45

Production Services Lead-etl Application Resume Examples & Samples

  • Graduate in Computer Science
  • 6+ years of IT experience
  • 3+ years experience in ETL application development or data warehouse production support
  • 4+ years of experience in Teradata Utilities, TPT, Viewpoint and Developer tools available for the Teradata System. This includes MultiLoad, FastLoad, FastExport, TPT, BTEQ, TPump, SQL Assistant
  • Support Teradata software upgrade installations and new feature testing and adoption
  • Experience with SQL coding, performance tuning, understanding of ETL best practices and benchmarking on new technologies or features
  • Experience in Mainframe (JCL, COBOL) – creation, review, analysis of scripts
  • Experience understanding and experience in Teradata Architecture
  • Experience supporting best practices, platform migrations, new functionality implementations, platform usage standards and guidelines, assessing performance metrics, and formulating automated controls to optimize platform stability
  • Ability to monitor and effectively manage job production problems and identify drive process and system improvements to enhance efficiency
  • Ability to review and adjust timelines to software/hardware upgrades from a technical perspective, identify and provide the solution for the top consuming operations and take ownership and resolve day to day issues and escalations
  • Identify and provide the solution for the top consuming operations
  • Business knowledge/understanding, as well as technical knowledge
  • Must understand and meet the standards required by the Production Application owners and Business Partners
  • Exposure to banking and the financial industry
  • Teradata Certified Developer for Release 12 or newer
  • Flexibility in shift timings - may have to work in 2nd shift for time zone coverage
46

ETL / Data Integration Developer Resume Examples & Samples

  • Assist the Solution Architectsin the creation/modification and roll-out of development guidelines, tools and processes for Development in Digital Experience and across Global IT
  • Work under the guidance of Solution Architect to split overall solution design into manageable technical work packages which can then become the basis for development by an external partner/development pool or resources
  • When necessary, develop technical specifications for development work to be outsourced to an external partner
  • Act as the technical person responsible for selected work packages of the project by steering the development activities of external partners/Software Engineers – through best practices, desired integration standards, etc
  • Perform integrations and coding review to establish conformance to standards and desired quality levels
  • Project Management:Support the Solution Architects to ensure project demand can be balanced with resource availability, enabling development services to be provided in a timely, high quality and cost-efficient manner in order to meet agreed project timelines
  • Finance Planning:Tracking and monitoring of actual technical work package development costs and related external effort under the guidance of Solution Architect
  • Communication:Use appropriate and effective methods of communication with the Development stakeholder community throughout the development life cycle; coordination with other horizontal organizations to deliver a seamless overall software delivery experience to the different CoEs; generally under the guidance of the Solution Architect
  • Strong hands-on data integration development background
  • Willingness and passion for data, data integration and develop technical artifacts
  • Ability to multi-task in a flexible environment & patience to work under pressure
  • Fluent English (verbal and written)
  • Specific skills (vary by different technologies)
47

ETL / Bigdata Developer Resume Examples & Samples

  • Understand the structures, usage and sources of data
  • Proficient in SQL and experience with Stored procedures (Sybase/SQL Server a big plus but any DBMS ok)
  • Experience working with offshore teams (giving directions, doing code reviews, etc)
48

Senior ETL / DW Developer Resume Examples & Samples

  • Ability to lead walk though of design documents and provide technical leadership over programming team
  • Effective communications with all levels of internal and external customers and staff, including issue resolution, negotiation of project related priorities, and completion dates
  • Coordinate with deployment and support resources to ensure the solution gets implemented smoothly into QA and Production environments
  • Teradata knowledge
  • Experience with complex shell scripting using UNIX
  • SSIS and SSRS Knowledge
  • CA7 or equivalent job scheduling tool experience
49

ETL / Data Integration Developer Resume Examples & Samples

  • Project Management: Support the Solution Architects to ensure project demand can be balanced with resource availability, enabling development services to be provided in a timely, high quality and cost-efficient manner in order to meet agreed project timelines
  • Finance Planning: Tracking and monitoring of actual technical work package development costs and related external effort under the guidance of Solution Architect
  • Communication: Use appropriate and effective methods of communication with the Development stakeholder community throughout the development life cycle; coordination with other horizontal organizations to deliver a seamless overall software delivery experience to the different CoEs; generally under the guidance of the Solution Architect
50

ETL Specialist Resume Examples & Samples

  • Should have strong knowledge on Data warehousing concepts
  • Should be Expertised in implementing complete ETL Process
  • Strong knowledge on Dimensional Modeling
  • Experience in writing Stored procedure and SQL scripts
  • Experience in working with IBM Datastage ETL Technology
  • Experience in working with IBM DB2 database
  • Experience in working with Linux
  • Should be able to communicate with stakeholders on need basis
  • Datawarehouse / Dimensional Modelling
  • IBM DB2 database
  • ETL Flows Automation
51

Etl Software Developer Resume Examples & Samples

  • Under the direction of Business Systems Analyst and Software Engineer, translate Business Requirements and Technical Designs into ETL mapping specifications
  • Work with Business Solution Analyst, Architect, and Engineer to ensure designs are correctly interpreted into maps
  • Develop, document, test, modify, implement, and maintain ETL mappings and workflows
  • Troubleshoot, optimize and tune ETL and data quality mappings
  • Create and execute unit test plans based on requirements
  • Under direction of Software Engineer, evaluate existing ETL mappings and processes to identify opportunities for automation and efficiency gains
  • Manage ETL mapping work efforts on multiple complex projects and recognize relationships/synergies between them
  • Work with various IT and business teams to analyze ETL mapping requirements in the data warehouse, data marts or operational systems
  • Maintain existing code and fix bugs when needed
  • Occasionally provide off-hour production support
  • Utilize metadata management tool capabilities to ensure metadata is available to and usable by business and technical teams
  • Utilize data quality tool capabilities to facilitate the implementation of business-defined data quality rules
  • Assist with documentation of tasks and processes for business and technical teams’ use of data quality, metadata, and ETL tools
  • 1-3 years of relevant experience
  • Hands-on development experience using ETL tools and building ETL processes (Informatica platform preferred)
  • Knowledge of IT testing practices
  • Understanding of relational database management system (Oracle, SQL Server, etc.)
  • Ability to translate client/business needs and software designs into coding specs
  • Strong analytical, problem solving, and thought leadership skills
  • Strong communication skills with the ability to influence effectively
  • Highly motivated self-starter with the ability to be an independent thinker, strong attention to detail, and high level of personal accountability
  • Proficiency in Microsoft Word, Excel, PowerPoint, Access, Visio and Outlook
  • A passion for continuous learning and staying informed of the latest trends and technologies
  • Development experience in a data warehouse/Business Intelligence
  • Experience working on large volume data integration projects across disparate data sources and targets
  • Working knowledge of Microsoft SSAS, SSIS, Power Pivot, Power View, and Power BI
  • Experience developing databases using SQL Server
  • Understanding of metadata management and data quality principles
  • Experience with data quality management tools and metadata management tools (Informatica platform preferred)
  • Bachelor’s degree in Computer Science, Information Systems, or related field of study
52

ETL Sybase Applications Developer, Associate Resume Examples & Samples

  • Develop ETL and DB solutions for our Finance applications fulfilling stringent performance requirements
  • Participate in the technical requirement specification process to ensure that definitions of new functionality are clearly defined and understood
  • Collaborate with technology development team and designers to develop scalable and robust technology solutions to ensure business requirements are met
  • Ensure code development is consistent with company development standards and aligned with industry guidelines and best practices
  • Participate in the testing and validation of new software to ensure software changes meet functional requirements
  • Provide post-production application support as required. Responsibilities include, problem identification, troubleshooting, data analysis, and emergency bug fixes
53

ETL Parametrisation Analyst Resume Examples & Samples

  • Analysis, design and redesign of ETL solutions to gain productivity efficiencies,
  • Gathering business requirements from the Ops teams,
  • Analysis and design of systems connections,
  • Initiation and execution of technical improvements,
  • Day to day support to the operational areas with regards to technical problems
54

Senior ETL Tech Lead Resume Examples & Samples

  • 7+ years of relevant work experience
  • 5+ years overall experience in Data Warehousing extracting, transforming and loading
  • Demonstrated recent DataStage expertise
  • Demonstrated working knowledge in Data Warehouse loading, tuning and maintenance
  • Demonstrated ability to write advanced SQL database queries
  • B.S. / M.S. degree in Computer Science, Engineering or a related discipline or equivalent work experience
  • Proficient in UNIX and Java
  • Experience with job scheduler Control-M
  • Strong conceptual modeling skills and experience in both top down and bottom up data analysis
  • Ability to work under pressure and take ownership of issues. Sense of urgency to solve problems and propose solutions
55

Senior Applications Developer ETL Resume Examples & Samples

  • Certifications with Informatica and ETL related tools
  • Experience in implementing best practices, performance tuning, and optimization techniques
  • Ability to conduct code review with EAS Architecture team to ensure standards and best practices are followed
  • Strong project lead skills with ability to accurately estimate development and testing efforts, identify tasks on the critical path, and asses risk in the overall project
  • Strong knowledge in Microsoft Office, MS Project, and Visio
56

ETL Data Specialist Resume Examples & Samples

  • At least 3 years of experience designing and developing extract, transform and load (ETL) processes utilizing for example DataStage, Informatica, BigInsights or other vendors
  • At least 3 years of experience moving/migrating/managing data from operational & external environments to the business intelligence environment based on business rules and requirements
  • At least 3 years of experience working with data warehouses, data marts, operational data stores, data feeds and associated query mining/reporting for business analytics
  • At least 3 years of experience using data modeling/data workflow diagrams (conceptual, logical and physical)
  • At least 3 years of experience working with PL/SQL, SQL and Object Oriented concepts and design
  • At least 8 years of experience designing and developing extract, transform and load (ETL) processes utilizing for example DataStage, Informatica, BigInsights or other vendors
  • At least 8 years of experience moving/migrating/managing data from operational & external environments to the business intelligence environment based on business rules and requirements
  • At least 8 years of experience working with data warehouses, data marts, operational data stores, data feeds and associated query mining/reporting for business analytics
  • At least 8 years of experience using data modeling/data workflow diagrams (conceptual, logical and physical)
  • At least 8 years of experience working with PL/SQL, SQL and Object Oriented concepts and design
57

ETL Software Developer Intern Resume Examples & Samples

  • Develops, tests and implements planned enhancements to existing production systems and new systems to support emerging business needs
  • Follows directions from more senior developers to accomplish project objectives
  • Work closely with data modelers, business data analysts, and BI developers to understand requirements, develop ETL processes, validate results, and deliver to production
  • Assist and verify design of solution and production of all design phase deliverables
  • Major: Computer Engineering and Computer Science, or a related field
  • Working Knowledge of Informatica Power-Center and ETL concepts
  • Strong relational and dimensional data modeling skills required
  • Strong data management and data analysis using SQL required
  • Relational Database Experience Oracle and Teradata (BTEQ Scripts) preferred
  • Well versed in MS Office products (Word, Excel, Visio, PowerPoint, Outlook)
58

ETL / Data Developer Resume Examples & Samples

  • · Candidate should possess a strong understanding of database concepts including data warehouse, operational data stores, and data marts
  • · Candidate must have In-depth knowledge and hands-on experience Unix/Linux programming (shell and Perl)
  • · Candidate must have in-depth knowledge of ETL concepts and should have hands-on experience in implementing data integrations in Flat files and RDBMS systems specifically Sybase and MS SQL using custom development, a scripting language, or an ETL tool such as Informatica and Composite. Any hands-on experience in Teradata, DB2 and/or Oracle will be plus
  • · Candidate must have strong SQL skills and should have experience creating detailed technical mapping specifications, which include sources, targets, transformation rules, reference models, and developing data extracts into Excel or common database
  • · In-depth knowledge of data warehouse, operational data store, data marts, reference master data repositories
  • · In-depth knowledge of database concepts
  • · Data profiling experience, Prepare Functional specifications document(s), Data quality analysis
  • · In-depth knowledge and hands-on experience with ETL Informatica development, Performance tuning
  • · Data analysis and database design, database tables, views, functions creation experience
  • · In-depth knowledge and hands-on experience of RDBMS systems, specifically Sybase, Teradata, DB2
  • · Strong SQL skills and database programming skills including creating views, stored procedures and triggers, and implementing referential integrity, designing and coding for performance
  • · Strong Communication skills, co-ordination skills
  • · Experience in the Financial Industry, Retail Mortgages
  • · Experience in Oracle Database design, development
  • · One or more Informatica Data Quality/Analyst, Business Objects, Qlikview development
  • · Experience writing/supporting user reporting using Business Objects or similar tool
  • · The position is in a data architecture group focused on delivering both tactical and strategic database solutions to support mortgage analysis for retail banking
  • · The individual will work closely with other team members, application developers, and IT owners of the data sources
  • · Individual will be responsible for the development of ETL Design, Development, Testing, Migration, Deployment, Support, Database components, and providing custom data extracts via reports, data extracts, and profiling tools such as Informatica data quality, and for coding stored procedures
  • To be successful, the role will require the individual to understand the banking technology landscape, and to have the ability to gather data requirements and prepare the data mapping, ETL processes, logical design the database and/or the database changes required to load, reconcile and report on the data
59

ETL Developers Resume Examples & Samples

  • Hands on experience building compelling data visualizations (as well as lead and advice management on how the visualizations work.)
  • Develop testing specifications based on data integration requirements and mapping specifications
  • SQL skills / data analysis skills
  • Expertise in Microsoft BI Stack (SSIS/RS/AS)
  • Data visualisation experience with tools such as Tableau or Qlikview
  • Knowledge and experience of all phases of software development (including requirements analysis, design, coding, testing, defect management
  • Previous experience contributing to business intelligence, data warehousing or advanced analytics project
  • Sharp analytical skills and ability to think laterally in approaching complex business problems
  • Strong consulting background with an aptitude to contribute to all areas of the business
  • Strong communication skills both written and verbal
60

ETL Data Specialist Resume Examples & Samples

  • 3 year designing and developing extract, transform and load (ETL) processes utilizing for example DataStage, Informatica, BigInsights or other vendors -
  • 3 years moving/migrating/managing data from operational & external environments to the business intelligence environment based on business rules and requirements -
  • 3 years working with data warehouses, data marts, operational data stores, data feeds and associated query mining/reporting for business analytics -
  • 3 years data modeling/data workflow diagrams (conceptual, logical and physical) -
  • 3 years working with PL/SQL, SQL and Object Oriented concepts and design
  • 8 year designing and developing extract, transform and load (ETL) processes utilizing for example DataStage, Informatica, BigInsights or other vendors
  • 8 years moving/migrating/managing data from operational & external environments to the business intelligence environment based on business rules and requirements
  • 8 years working with data warehouses, data marts, operational data stores, data feeds and associated query mining/reporting for business analytics
  • 8 years data modeling/data workflow diagrams (conceptual, logical and physical)
  • 8 years working with PL/SQL, SQL and Object Oriented concepts and design
61

CIB ETL, DB, Unix Application Developer Resume Examples & Samples

  • Primary Skills- Highly Proficient in the following
  • Strong Informatica Power Center Knowledge, both in terms of Technical Architecture and Client Tools (5+ years experience)
  • Good in Data Warehouse Fundamentals
  • Strong in working with different Databases and Strong SQL & PL/SQL Knowledge (preferably MS SQL Server) (5+ years experience)
  • Strong UNIX & Shell Scripting Knowledge
  • Knowledge of FTP/SFTP
  • Knowledge of Perl would be preferable
  • Developing, coding, writing specifications
  • Good Experience in writing and managing test cases and test plans for different phases of SDLC
  • Systems Analysis & Design - Extensive experience as analyst/designer. Ability to read and comprehend business and functional requirements, and develop high level and detailed design documents. Thorough understanding and experience with development lifecycle (SDLC) and experience of production support
  • A self confident and authoritative manner without being over bearing
62

Application Developer ETL / DB Resume Examples & Samples

  • Conducts analysis, scope and time estimation to develop and deliver data integration solutions
  • Develop mapping specifications, Source to target mappings and ETL development. Perform
  • Adhere to standards and strategic objectives, and meets committed timeframes and schedules
  • 5 years as an applications developer, with significant time as data integrator/developer
  • Hands on experience in writing Complex SQL queries, PL/SQL code, stored procedures, functions and Packages
  • Proactive, team player and should be working well with members of the project
63

ETL / Big Data Developer Resume Examples & Samples

  • Proficient in JAVA or C++
  • Experience with Unix and Unix Shell scripting a plus
  • Experience with Big Data Technologies a plus
64

Senior ETL Data Analyst Resume Examples & Samples

  • Facilitates high level and detailed requirements analysis and translates business requirements into data needs for BI & data solutions
  • Work with the architects and development teams to implement data & process flows to capture business needs and system deliverables
  • Analyze and document the proposed solution’s impact on existing systems, and propose design or process changes to meet business requirements
  • Lead and co-ordinate test planning on data and BI solutions
  • Create and maintain data and process flow diagrams to be used as project artifacts or reference for future changes to ensure consistent repeatable processes are implemented
  • Lead business meetings through walkthrough of data analysis conclusions, results and end-state process flows to validate or educate stakeholders on recommended solutions. Negotiate and gain buy-in on results
  • Perform and document data profiling, using industry standard tools, which will be used to assist in data and reporting solutions. Participate in creating project documentation, including design documents, requirement documents, data dictionaries and data mapping documents
  • Bachelor’s degree in related field (Finance, MIS, Business Administration, Computer Science) or two year degree with equivalent experience
  • 7+ years of experience supporting data architects/technical teams in a large and complex data environments with experience using PL/SQL and query development tools like Toad, SQL Developer, Oracle or SQL based RDBMS
  • Experience working with data in a variety of formats including mainframe and distributed environments
  • Strong background translating user & business requirements in to complex technical solutions
  • Experience in interviewing business users, collecting and interpreting requirements, explaining solution details to business audience and run meetings
  • Working experience with agile or other rapid application development methods
  • Demonstrated ability to balance data theory with practical solutions
65

ETL Parametrisation Analyst Resume Examples & Samples

  • Analysis, design and redesign of the Xceptor (ETL) solutions to gain productivity efficiencies
  • Gathering business requirements from various Fund Accounting teams,
  • Analysis and design of the systems connections in FA area,
  • Initiating and executing of the technical improvements,
  • Day to day support to the operational areas with regards to the technical problems and tools used by the processes
66

ETL Data Engineer Resume Examples & Samples

  • Develop, test and automate applications using Unix Shell Scripts, and Perl
  • Work independently in the development, testing, implementation and maintenance of systems of moderate-to-large size and complexity
  • Experience in Enterprise Data Warehouse on AWS
  • Strong understanding of AWS components like EC2, S3 and EMR is required
  • Minimum 5+ years of experience working with Data Warehouse development
  • Experience with Non Columnar and Columnar Databases with strong SQL scripting
  • Strong knowledge of any ETL tool as Pentaho, Informatica, Ab Initio
  • Understanding of Data warehousing methodology (ELT – ETL)
  • Experience in developing ETL applications using Python or Pig
  • Knowledge of code management using Git / SVN or other standard tool
  • The ability to work effectively across time zones with other global team members
67

Lead ETL / DW Developer Resume Examples & Samples

  • Comply with ETL standards and guidelines related to the design, construction, testing, and deployment activities within the Delivery Management environments
  • Ability to act as a lead developer responsible for the planning, completion and coordination of work activity for projects involving more than one developer
  • Execute hands on Informatica Mapping and Development
  • Take an active role in joint solution design and be an advocate for long term quality in the process. Work closely with Data analysts, end users, developers and QA team to ensure technical compatibility
  • Evaluate and understand a variety of modeling and/or diagramming techniques, with the ability to create process flow diagrams and the ability read data flow and entity relationship models
68

ETL Business Intelligence Analyst Resume Examples & Samples

  • Derive business requirements based on customer requests; Validate technical system specifications to meet business requirements
  • Design and implement data schemas and ETL jobs that populate and maintain departmental reporting database and exchange data with external partners and regulators
  • Present data in a variety of formats (charts, graphs, tables) for leadership and other stakeholders
  • Work closely with BI Report Developers who will create end-user visualizations and end-user reports
  • Perform fact-based analysis; explain technical issues in words that non-technical stakeholders will understand
  • Champion privacy and security for all systems, data, and information
  • Develop design and maintain internal documentation of work products
  • Self-directed team player - able to initiate projects independently; prioritizes and organizes own work to meet deadlines; assist and collaborate with other team members to continuously expand our capabilities
  • Bachelor’s degree in Computer Science, Business, Finance, Health Administration or related field
  • Have a passion to understand and be part of the business, not just mastering the technology
  • Develop complex MS SQL Server queries for data extraction and reporting
  • Perform data conversions (ETL) from multiple data sources, develop necessary SQL for loading / updating and maintaining data tables
  • 3+ years experience with SQL tools , especially SQL management studio, T-SQL, SSIS
  • Experience with complex data schemas; multi-million row tables; complex queries
  • Working knowledge of relational databases and database structures
  • Successful time / project management, problem solving, organizational, and analytical skills
  • Demonstrated process improvement, workflow, benchmarking and / or evaluation of business processes
  • Proficient in: MS Excel, MS Word, MS PowerPoint, MS Outlook, MS Visio
69

Data Ingest & ETL Specialist, Senior Resume Examples & Samples

  • 6+ years of experience in a systems engineering role in the context of data management or data ingestion
  • Experience with using analytical expertise in identifying and quantifying problems, providing effective resolutions, handling multiple duties, and completing assigned tasks accurately and on a timely basis
  • Experience with Apache Camel, ActiveMQ, FTK, WinHex, forensic tools, EnCase, Windows Detour, Pentaho, Linux, Windows and Apple OS, WinZip and RAR, Aspera, Big Data XFER, or Logicube Omniclone Xi
  • Ability to apply a sound troubleshooting methodology to isolate and resolve the root cause of reported issues
  • Experience with building, configuring, and maintaining hardware components in a laboratory environment
  • Knowledge of infrastructure design supporting data science and data analytics environments
70

Data Ingest & ETL Specialist, Mid Resume Examples & Samples

  • 3+ years of experience in a systems engineering role in the context of data management or data ingestion
  • Experience with ingesting data into applications and resolving data errors
  • Experience with using forensic tools to analyze data
  • Experience with managing user accounts, reviewing system log files, and performing security updates on Windows and Linux systems
  • Ability to work with all seniority levels of staff within the client base
  • BA or BS degree in CS, IT, or a related field
71

Senior ETL Data Integration Developer Resume Examples & Samples

  • Codes, tests, debugs, implements, and documents moderately complex programs
  • Designs and configures environments and creates builds. Ensures configurations, environments and builds meet standards and technical specifications; performs technical analysis and component delivery
  • Assists support and/or project personnel in resolving moderately complex program problems
  • Provides technical advice on complex programming
  • Develops test plans to verify logic of new or modified programs
  • May lead and direct the work of others
  • Bachelor’s degree from an accredited college or university or equivalent years of experience required
  • Minimum six (6) years of software development and configuration experience required
  • Extensive experience creating and deploying builds for complex software systems, including ETL and databases required
  • Experience setting up software development and test environments including migrating large amounts of data required
  • Experience creating complex SQL queries and scripts required
  • Experience in the use of configuration management tools required
  • Experience leading teams preferred
  • Serena CM and/or Remedy configuration tool experience preferred
  • ETL and/or OBIEE application development experience preferred
72

ETL Manager Resume Examples & Samples

  • Analyze and understand the ETL work flows developed
  • Validation of data transformations and perform End-to-End data validation for ETL & BI systems
  • Should be strong in SQL and write complex SQL queries for validating business rules using Oracle/Teradata/SQL Server/DB2 scripts
  • Understanding of the data model
  • Develop Test strategy, test plan/design , execute test cases and defect management for the ETL & BI systems
  • Good problem solving & debugging
  • Client-facing, Presenting the deliverables with project stake holders
  • Minimum 6 years of experience in Data warehousing environment/projects
  • Minimum 4 years of experience in ETL & BI testing
  • Strong knowledge on ETL and BI processes
  • Strong in ETL data validation developed using Informatica /Abinitio /Datastage/SSIS ETL environments
  • Exposure to Big Data testing and Automating the ETL & BI data validation
  • Excellent written and verbal communication skills are must
73

Database Developer, ETL Resume Examples & Samples

  • Understand current-state data schema and data model and define future-state data schema
  • Define data normalization and schema integration as required by the project
  • Capture & document the logical and conceptual data model for the project
  • Determine the appropriate data flow model among primary and ancillary data stores
  • Define & document meta-data, data lineage and data dictionaries across the data stores
  • Design and document data flow diagrams, schema and data mapping/cross-walks across the data stores
  • Define data quality and data validation specifications & standards and data cleansing/data scrubbing techniques to ensure consistency amongst data sets
  • Define data transformation, ETL and ELT requirements for Source, Target Databases for Extraction, Transformation and Loading (ETL)
  • Perform data analysis and normalization to resolve requirement conflicts and gaps between various data stores and business entities create entity relationship and multidimensional data models, reports and diagrams
  • Define principles of Data ware housing using Fact Tables, Dimension Tables, star schema modeling and snowflake schema modeling, slowly changing dimensions, foreign key concepts, referential integrity
  • Define conceptual, physical and logical data models (3NF) using various Data modeling tools like Erwin, MS Visio, Power Designer
  • Translates business requirements into DDL scripts for ETL development to acquire the appropriate source data for the warehouse
  • Define technical metadata and conduct data model reviews with project team members
  • Experience in interacting with business analysts and developers to analyze the user requirements, functional specifications and system specifications
  • Perform data profiling and data analysis on the source systems; complete data mappings from source to destination
  • Perform Data Base Optimization/query optimization to address performance bottle necks
  • Collaborates with members of the product, revenue, research, and central support communities to collect and research specific member issues related to product properties in production
  • Interacts with members of the business/IT community to understand future business requirements and strategies and document reporting requirements
  • Interface with system architects, designers, and developers to ensure a thorough understanding of functions, technical, and performance requirements
  • Review/analyze test case results to ensure functionality meets documented specifications
  • Assist in the execution/analysis of integration, user acceptance, and performance testing
  • Maintain prescribed processes and accepted templates/methods of documentation for all allocated projects
  • Excellent technical, organizational and planning skills, excellent communication, and problem solving skills
  • Participate in the identification and documentation of “as is” and “to be” products within the project lifecycle
  • Hands on experience with schema design and definition in a data warehouse environment
  • Hands on experience with ETL routines for Source, Target Databases for Extraction, Transformation and Loading
  • Knowledge of Business Intelligence and Reporting platforms preferred by not required
  • Proficiency in Database SQL query development and data analysis
  • Building and maintaining ETL workflows
  • Building and maintaining complex SQL queries for data analysis and data extract
  • Building and maintaining complex scripts and automation components
  • Ability to work with onshore and offshore development teams
  • Very good listening and interpretation skills
  • Ability to lead tasks and contribute to multiple projects concurrently
  • Ability to collaborate with members of the client community as well as IT staff
  • Critical thinking with excellent judgment and initiative
  • Self-motivator with great attention to detail and follow through
  • Proficiency with Excel, Word, PowerPoint, and Visio
  • Proven analytical skills
  • Ability to work independently and in a team setting
  • Ability to excel in a fast paced environment
  • Minimum 8 years of years IT work experience focused on Data Warehouse and/or Business Intelligence applications
  • Understanding of Data Warehouse concepts (Kimball methodology for developing dimensional data models)
  • Experience with a BI platform such a Business Objects and Microstrategy (preferred)
  • 5 + years of demonstrated ability to develop/enhance/maintain complex databases
  • Experience with Microsoft SQL Server 2008 (or higher versions)
  • Experience with SSIS required
  • Experience with T-SQL to develop Stored Procedures, Functions and Triggers
  • Experience with debugging reports/ SQL code
  • Experience with change management, software application testing and troubleshooting coordination, routine maintenance, and data management
  • Bachelor’s Degree in a business or technical/engineering discipline
74

ETL Oracle Developer Resume Examples & Samples

  • Oracle SQL and PL/SQL Perl Excellent verbal and written communication Â
  • Python Informatica Sybase IQ or other columnar database dev-admn
  • Monitoring tools: HP BSM, Extrahop, Splunk, CA Wily Project management
75

ETL Data Stage Resource Resume Examples & Samples

  • Over five year experience in Datastage and mainframe skills Strong working knowledge in Teradata and data warehousing
  • Mainframe skills including MVS, JCL, CA7, TSO/SPF, COBOL . Strong data design, data modeling and facilitation skills . Strong written/oral communication and interpersonal skills
  • Strong drive for results and ability to multi-task and work independently
  • Ability to work with cross-functional teams and all levels of management
  • Experience in creating and executing detailed test plans
  • Over five years of experience in Datastage, Mainframes, designing and developing ETL applications in Teradata data warehousing environment
  • Ford Experience a plus
76

Clarity ETL Resume Examples & Samples

  • Build SQL server/Oracle database objects, program functions and stored procedure to perform algorithm, and configure/optimize client database for project implementation
  • Work with client DBA and Clarity Admin to configure ETL and DataLink
  • Work with BusinessObjects tools to perform custom analytics and visualize data in actionable ways
  • Liaise with client team, clinical team and vendor team to troubleshoot technical issues
  • Lead Clinovations report writing and workflow optimization for key product offerings
  • Innovate and explore additional data cuts and tools to meet client needs
  • Participate in project team meetings
  • Up to 30% travel required
  • Certification in Clarity ETL Admin and Clarity Data Model (any clinical application) required
  • Strong report writing experience in tools such as Epic Reporting Workbench, Crystal Reports, Tableau, and others
  • Experience with programing in SQL Server and Oracle environments
  • Education and experience equivalent to a University degree and 3+ years of project support experience in the same or related industry
  • Exceptional communication with both staff and clients with the ability to meet or exceed deadlines
  • Excellent presentation and negotiation skills with the ability to demonstrate these skills in both face-to-face and electronic formats including but not limited to telephone and email systems with special attention to detail and accuracy
  • Familiarity with using a centralized project documentation process or project web site
  • Ability to effectively communicate with senior management and major project stakeholders
  • Ability to solve problems by applying technology while remaining self-motivated, organized and resourceful
77

Senior ETL Application Software Engineer Resume Examples & Samples

  • 3+ years of related experience in ETL application / software development
  • Requires demonstrated understanding of business process as it relates to experience in the field. Healthcare experience strongly preferred
  • SQL (required), Informatica (Power Exchange and/or Power Center) or similar ETL tools (required), Teradata or other relational database systems (RDBMS) (required), Unix (preferred)
78

Senior ETL Applications Software Engineer Resume Examples & Samples

  • Conduct root cause analysis and advanced performance tuning for complex business processes and functionality
  • Healthcare experience strongly preferred but not required
  • Demonstrated understanding of business process as it relates to RDBMS, ETL, SQL, Informatica
  • Informatica (Power Exchange and/or Power Center) or similar ETL tools
  • Teradata or other relational database systems (RDBMS)
79

ETL Analyst Resume Examples & Samples

  • A minimum of 4 years supporting specific data application or conversion efforts or 4+ years creating reports for operational or conversion support
  • 2-3 years with investment system support as a BA or AA
  • Prior experience with implementation or support of brokerage systems or mutual fund file processing highly desirable
80

ETL Operations Analyst Resume Examples & Samples

  • 4-year degree in an IT or technical field or equivalent experience
  • 2-4 years supporting computer-based applications
  • Experience in remote software installation (e.g. experience with Citrix, Windows security, FTP, Firewall and network troubleshooting) a plus
  • Must have experience creating basic SQL statements and be familiar with relational database design concepts
  • Experience in Big Data technologies in Hadoop ecosystem (e.g. Hive, HDFS, MapReduce, Oozie, HBase, Sqoop)
  • Ability to work independently with minimal supervision and collaboratively within a team
  • Work effectively with customers and internal staff in fast-paced environment and time-sensitive situations
  • Ability to work in a team environment across multiple functional groups
  • Ability to explain technical concepts to non-technical users
  • Detail oriented with strong analytical, root cause analysis skills
  • Eagerness to expand technical skill set
  • Technical writing experience a plus
  • Knowledge of healthcare industry a plus
81

ETL / Data Engineer Resume Examples & Samples

  • Expertise in Informatica Powercenter or a similar ETL tool, LINUX/UNIX, Perl, Oracle and PL/SQL development
  • Problem Determination/Resolution: Supporting and troubleshooting batch processing and interactive user reports to ensure the high availability of Digital Insight's Admin Platform
  • Effectively interact on bridges and production support calls to ensure all global team members are constantly informed. This will require out-of-hours support
82

ETL & Integration Specialist Resume Examples & Samples

  • Strong presentation, verbal and written communications skills
  • Around 3-4 years of experience with Informatica PowerCenter and Oracle SQL, PL/SQL
  • Around 1-2 years of experience with Informatica MDM (formerly Siperian ver 9.5.x or later)
  • Minimum 1 year of experience with data quality and profiling
83

ETL Solution Consulting Cnslt / Spec Resume Examples & Samples

  • Oversees the designs, develops and tests complex Extract, Transformation, and Load (ETL) routines using Informatica software
  • Mentor team of Informatica developers in best practices for design & development
  • Creates and manages Implementation Plans
  • Post-go-live support and optimization of the Informatica jobs
  • Minimum ten (10) years of related experience
  • Seven (7) + years of related experience in developing and maintaining Extraction, Transformation and Loading scripts using Informatica tool and Oracle
  • Bachelor's degree in related field OR additional four (4) years of directly related equivalent experience
  • Experience in summarizing and presenting complex topics to non-technical audiences
  • Effective personal communication and client-facing skills with technical and management staff
  • Complete understanding and application of principles, concepts, practices, and standards in Informatica
  • Familiarity with software development life-cycle and ability to work in agile and waterfall methodologies
84

Senior ETL Software Developer Resume Examples & Samples

  • Develop an effective, robust Data Integration capabilities using Informatica Big Data solution and Hadoop Big Data Techniques in a Data Warehouse settings
  • Conduct ETL / DW optimization, troubleshooting and debugging
  • Work closely with the Architects, Business Analysts and developers in a team setting to ensure that requirements are taken into confidence while designing effective Data Integration solutions
  • Design and develop test plans for ETL unit testing and integration testing
  • Develop mappings to load data from multiple data sources to target
  • Deliver timely and effective technical assistance and troubleshooting when issues arise
  • Design and develop sustainable and performance efficient ETL work flows to support those requirements
  • Create technical design documents that capture source to target mapping, define transformation algorithms, and document data quality rules
  • Bachelor of Science degree with over 14 years of experience in the information technology area
  • 8+ years of full time experience in Informatica Server administration in the areas of installation, back up repository, configure setting/performance tuning, and metadata management
  • 5+ years of hands on experience in architecting the end-to-end data ingestion workflow
  • 8+ year knowledge of Informatica tools such as data integration, data profiling and Data quality and hands on experience developing ETL processes using Informatica Power Center ETL Designer
  • Read, write, and maintain SQL statements. Solid hands on experience in troubleshooting and perform tuning of Informatica ETL solutions
  • Strong interpersonal and communication skills to communicate with team members and management
  • Manage day-to-day operational issues related to deployed Informatica ETLs
  • Solid understanding of Informatica best practices for the data movement, data consolidation, metadata management, data quality and other data management activities
  • Solid understanding of Informatica advanced security protocols Workflow Manager, Workflow Monitor, and Repository Manager
  • 3-5 years of hands-on experience in supporting administration and configuration of Informatica Server in Linux OS
  • 3-5 experience in deployment/migration of developed workflows in various environments including development to test to production
  • Hands on knowledge with Informatica Developer tools and Informatica Big Data management (BDM) tool will be given a priority
  • Knowledge of CMS related data particularly claims, Beneficiaries and Providers
  • Experience of managing ETL in an environment involving 30TB+ data
  • Informatica Certified professional certification is a plus
  • Knowledge of Hadoop particularly Hive and HBase data store
  • Basic knowledge of DB2
85

ETL Manager Resume Examples & Samples

  • As Project Manager oversee the full project management life cycle and software development life cycle for the implementation of highly complex, large-scale, IT and business initiatives
  • Implementing established policies, system monitors and controls to ensure the successful management and reporting of all corporate initiatives in the program
  • Providing both verbal and written communications regarding project status, risks and issues
  • Consulting within the IT organization to develop appropriate support for IT-centric projects from various technology and service departments
  • Strong presentation and management meeting skills to all levels of the business
  • Manage customer expectations
  • Should have excellent people centric team management skills and conduct performance reviews
  • The ETL Manager will oversee data acquisition project delivery across all BI capabilities. This role is required to ensure all capability projects follow agreed upon global data acquisition design standards, adhere to all policies and procedures, and deliver cost effective and highly performing BI Data Acquisition solutions
  • Should have minimum 10 years of experience in IT with project management experience involving Data warehouse / ETL and related capabilities
  • Should have managed team with at least 10 members responsible for designing, developing and supporting Data Integration using ETL tools
  • Should be a proficient in estimation techniques followed for Data warehouse assignments
  • Should possess deep knowledge in Data warehousing and ETL Techniques
  • Conversant with at least any of the 2 leading ETL Tools – Informatica, SSIS, Data Stage, ODI, Talend
  • Should have experience to ETL Architecture design, development and implementation
  • Should have experience in providing estimates for proposal and previous experience in participation of client workshops
  • Should have managed at least 2 end to end ETL engagements for clients in any domain
  • Should have knowledge in Automation tools and techniques, shell scripting
  • Extensive client relationship management skills for proposals, delivery and issue resolution
  • Should be able to manage a portfolio of small to medium projects; will be responsible to meet project objectives and stay within scope, monitor and track progress to plan, and managing team work assignments
  • Adhere to agreed upon scope, timelines, and budgets; ensures successful outcomes through proficient time management and resolution of issues
  • Should have excellent people centric team management skills
  • Should be aware of CMMI processes and procedures, Six Sigma
  • Experience in Onsite-Offshore model is preferred
  • Experience in various project development methodology – Agile, Waterfall
86

ETL / Database Development Lead Resume Examples & Samples

  • Graduate Degree or equivalent experience
  • 5+ years of Data Warehouse experience
  • 5+ years of application development experience
  • 2+ years of team lead experience related to Data Warehouse Applications
  • ETL (DM Express or Informatica)Tool experience
  • Experience working in an Agile Scrum environment
  • Data architecture and modeling
87

ETL Consultant Resume Examples & Samples

  • Experience working with Oracle Data Integrator software
  • Experience with one or more of the various ETL tools (Oracle, Cognos, SAP, IBM, etc)
  • Should also have some "big shop” experience
  • Should be familiar with Data Warehouses and multiple databases
  • Some experience with Report Writing/Generation using Crystal Reports would be a plus
88

ETL Ab Initio Data Analyst Resume Examples & Samples

  • Development transformation logic to support the data consumption requirements
  • Assess the quality of data during development and test phases of the projects, and own the resolution of the data quality issues by working with development teams
  • Work with consumption technology/business teams to provide standards based solution
  • Develop or enhance standards for logical and physical model development
  • Develop mappings of sources to target databases, including documentation of transformation rules
  • Communicate regularly with architects and modelers working in parallel tracks to maintain consistency of models and other deliverables
  • Oversee the development of scripts to correct bad data or to implement data model changes as required
  • 8 to 12 years of extensive experience building large Data Warehouses (30+ TB) and back-office systems
  • Past experience in implementing Financial GL and sub-ledger systems
  • Past experience with banking products such as deposits, loans, securities, derivatives, etc
  • A strong demonstrated work history with 5 experience with ETL / Ab Initio
  • 5 years of strong RDBMS experience: Netezza, Teradata, and/or Oracle preferred
89

ETL Specialist Resume Examples & Samples

  • Developing and fixing defects in existing software to meet the client's requirements
  • Providing technical expertise in performing unit and integration tests
  • Supporting software releases
  • Preparing documentation
  • Communicating with stakeholders and work closely with other departments around the globe
90

ETL Database Administrator Resume Examples & Samples

  • Bachelor’s degree in MIS or Computer Science preferred
  • Strong working knowledge of SSIS and job creation combined with experience in physical and logical database design
  • Knowledge of banking or finance industry preferred
91

ETL Data Specialist Resume Examples & Samples

  • Designing and developing extract, transform and load (ETL) processes utilizing for example DataStage, Informatica, BigInsights or other vendors - 3 Years
  • Moving/migrating/managing data from operational & external environments to the business intelligence environment based on business rules and requirements - 3 Years
  • Working with data warehouses, data marts, operational data stores, data feeds and associated query mining/reporting for business analytics - 3 Years
  • Data modeling/data workflow diagrams (conceptual, logical and physical) - 3 Years
  • Working with PL/SQL, SQL and Object Oriented concepts and design - 3 Years
  • At least 8 years experience working with data warehouses, data marts, operational data stores, data feeds and associated query mining/reporting for business analytics
  • At least 8 years experience with data modeling/data workflow diagrams (conceptual, logical and physical)
  • At least 8 years experience working with PL/SQL, SQL and Object Oriented concepts and design
92

Experienced ETL / Transmissions Developer Resume Examples & Samples

  • Point-of-contact for internal business and external vendor partners on issues or enhancement requests
  • Develop and provide technical solutions for issues or enhancement requests in support of business operations
  • Liaise with other technology specialists and software engineers/developers to assist with quality assurance, code logic, data processing, system design, and disaster recovery/resiliency
  • Work in close partnership with existing Data Management and Integration to ensure overall cohesion of provided solutions
  • Ensure that any new integration into company systems meets functional requirements, system compliance, and interface specifications
  • Design, develop, and install enhancements and upgrades to systems and application software
  • Work with business requirements analysts to identify and understand source data systems
  • Map source system data to data warehouse models
  • Develop and test extraction, transformation, and load (ETL) processes
  • Understanding of source and target data structures, ETL processes, and products
  • Strong problem-solving and metadata skills
  • Completes mapping and transformation programs
  • Schedules extraction and load processes
  • Documentation and maintenance of ETL metadata in metadata repository
  • Database loadable files
  • Development/enhancement of underlying scripts used in ETL processes
  • Version control for ETL jobs
93

Toc-etl Performance Engineer Resume Examples & Samples

  • 8+ years of proven, strong experience with performance testing and performance engineering
  • Experience with performance diagnostic tools such as AppDynamics
  • Good communication and technical documentation skills
  • Experience in analysis and understanding of application eco-system and performance test results, and identify problem areas and monitoring needs
  • Capable of performance testing from end to end independently and being a team player at the same time
  • Unix/Linux commands,Shell scripting and Windows Power Shell scripting is a plus
94

ETL Dev Lead Resume Examples & Samples

  • Strong practical experience and a background in architecture, development, implementation, documentation and support of tools that leverage - Pentaho, Java, SOLR
  • Solid understanding in usages and reading code in- SSIS & MS SQL
  • Experience in migration of code
  • Have the ability to deep dive the code and understand business logic
  • Have worked with geographically distributed teams to effectively leverage the benefits offered by staff working in different timezone
  • Have managed and supported a Live deployment of Identity Management Solution
95

ETL Analyst Resume Examples & Samples

  • Bachelor's degree is required. Major in computer science, systems analysis or a related study preferred. Equivalent experience will not be a substitute for a four year degree
  • Seven to 10 years of solid experience in two or more of following disciplines including BizTalk send and receive operations as well as orchestration, Biztalk web interfacing and/or Windows Communication Foundation (WCF), and application development within a BizTalk environment (C#, .NET, WCF, XML). Informatica experience in Powercenter, development experience, maintenance, mapping enhancements, work-flows, and process. ETL solution and data conversion architect strategy work
  • Understanding of network architecture
  • Understanding of SOA and object-oriented analysis and design
96

ETL Development Lead Resume Examples & Samples

  • Manage the onshore and offshore development resources that are comprised of ETL workflows (Informatica), database development (Sybase/DB2), web based UI (JAVA), and batch stream processing (UNIX/Autosys)
  • Point of contact for data analysis on source systems, data expert of data mappings and transformation rules, SME capable of understanding the architecture and data flow in/out of CEDAR
  • Maintain and enforce data model design principles, architecture and coding standards, best practices adhering to the current SDLC framework of LCR policies and procedures
  • Lead the technical efforts for vetting new software tools, packages, custom software, proof of concept systems ensuring current technical needs as well as future assessment for scalability, efficiency, and optimal performance capacity
  • You will be working closely with the Business Analyst and Data Modeler to review business requirements, understand business processes, data entities, data producers, consumers, and the data dependencies between various departments. In turn, you will lead the development efforts and day-to-day meetings with offshore resources adhering to project plan deadlines and deliverables
  • Bachelor’s degree in Computer Science, Software Engineering, Information Technology, or related field required
  • At least 10 years of experience as a developer with 5 years prior experience of managing onshore and offshore teams
  • Experience in ETL Informatica, Data Quality tools, and Data Debugging tools. Unix and Autosys knowledge is preferred. Any JAVA experience is a plus
  • At least 10 years of PL/SQL experience with the ability to write complex queries to perform data analysis. A preference is given to DB2 v10+ databases
  • At least 5 years of experience working on Business Intelligence\Business Analytics\Data Warehouse solutions
  • Experience with IBM Cognos BI v8+ and IBM Open Pages is a plus
  • Strong data analysis and data profiling skills, as well as knowledge of principles, techniques, and best practices of Enterprise Data Warehouse Frameworks and Database design
  • Strong collaboration and communication skills. Must be a team leader and able to shift gears based on business demand and competing priorities. Must be well organized and able to tailor communication based on the audience and level (clients versus technical staff)
  • Must be able to lead and work with staff in multiple time zones with emphasis on team building, mentoring and coaching junior staff
97

Level Operations ETL & DWH Engineer Resume Examples & Samples

  • Technical degree
  • PL/SQL Solid code troubleshooting/debugging experience
  • Medium/high Unix, Linux O.S. experience
  • Technology skills in Data warehousing and Business Intelligence practice
  • Strong knowledge in Evolving Strategies for Extraction, Transformation Conditioning and Loading of data from various Heterogeneous data Sources
  • Experience of Configuration Management, Defect management and Release management
  • Experience in creating and updating High Level Design Documents and Details Design Documents in course of software development cycle
  • Ability to multi-task and work under pressure
  • Fluency in English language
  • Italian language knowledge is a plus
  • BSS (Business Support Systems) understanding/experience
  • Oracle Database 10/11g Administration Knowledge
  • DataStage (Ascential, Infosphere) Basic or Administration Knowledge
  • Unix Shell Programming
  • Web languages programming
  • Oracle BIEE
  • Networking knowledge/Experience (protocols)
  • Experience as Developer and/or Tester and/or Deployment
  • LI-RS2
98

ETL IDQ Developer Resume Examples & Samples

  • Good communication, consulting skills and a self starter, this is a senior position with constant interaction with business and leadership team
  • Hands-on experience with latest version of Informatica Data Quality and Power center
  • Experience loading metadata from Excel files, flat files, RDBMS
  • Good understanding of the star schema and multi-dimensional data model
  • Minimum 4 years of experience with developing data quality rules leveraging Informatica data quality suite
  • DQ Check for null, range of values, list of values, phone, account and SSN to be in standard formats
  • Understands Informatica Address doctor implementation and configuration
  • Interact with business users, understand functional requirement and convert the functional needs into technical specification documents
  • Oracle, Linux & Informatica Data Quality, PowerCenter
99

ETL Database Developer Resume Examples & Samples

  • ANSI SQL (T-SQL, PL/SQL,etc). Experience with Netezza or other MPP database platforms is preferred
  • Query Optimization strategies. Extensive experience in construction, testing, and performance tuning of SQL and data integration processes
  • Excellent hands-on experience in Unix/Linux shell scripting and complex SQL queries
100

ETL Admin Resume Examples & Samples

  • 8 + years experience on Informatica Administration on 8.x/9/x environment
  • Experieince in implementation/upgrade of Informatica upgrades from 8.x to 9.x. Enforce security and compliance for data transfer working with EIS and server engineering team. Collaborate internally with BIDM and external sources to build an integrated data solution\delivery
  • Able to understand\write shell scripts and sql (Oracle) for regular maintenance jobs to improve performance and uptime of Informatica platform. Maintenance of the Informatica ETL platform infrastructure (upgrades, patches, health monitoring). Worked on Change Management Tools to track all the incidents and changes and to plan the production changes as per the change management policies
  • Provide on call support for Informatica Infrastructure coordinating/applying patches
  • Participate in BIDM IT upcoming releases, risks, mitigation plan and create implementation plan
  • Team player and mentor junior support engineers
101

Etl Software Developer, Principal Resume Examples & Samples

  • Data mapping, extraction, transformation, analytic support
  • Perform ETL development as well as design framework for ETLing
  • Leads and drives team members to develop all projects to exceed industry best practices
  • Performs as a project lead with the responsibility for the instruction, assignment, direction, and monitoring of the performance of assigned software developers working on a specific project
  • Leads and participates in code and design reviews
  • Designs and ensures unit and integration testing is completed to ensure quality
  • Reviews and understands customer requirements and specifications
  • Develops code necessary to complete the assigned project(s) in the specified time frame according to departmental standards and guidelines
  • Identifies and reports problems in new and existing software. Recreates reported software problems to facilitate solutions. This includes validating the fix for the software problem
  • Writes, modifies, and debugs software for client applications
  • Develops the critical components of the solution, including but not limited to, security, rules infrastructure, custom adapter implementation, and application interfaces
  • Architects and codes multi-environment system solutions utilizing various programming languages
  • Profiles, analyzes and optimizes the software he/she is responsible for implementing
  • Employs best practices for design, development, unit testing and test plan development
  • Actively participates in the documentation of software requirements, functional design, flowcharts, and diagrams
  • Seeks to improve personal job related knowledge and departmental process by studying state-of-the-art development tools, programming techniques, and computing equipment; participating in educational opportunities, and reading professional publications
  • Five Years’ ETL experience
  • The clearance level required is dependent on the type of clearance supported by our client. (TS/SCI with favorable polygraph)
  • Demonstrated experience with Java, and or C# and Perl
  • Demonstrated Experience with Oracle Databases (SQL, PL/SQL)
  • Ability to not only develop but also design framework for ETLing
  • Familiarity with Hadoop, Hbase, and Marklogic
  • Linux command line administration experience
  • Pentaho experience
  • ActiveMQ experience
  • Camel experience
102

Business Intelligence Solutions ETL Specialist Resume Examples & Samples

  • Seven (7) years of experience* in Business Intelligence solutions development
  • Experience with business intelligence tools such as Microsoft SQL Server and OLAP cube
  • Experience with database design, dimensional modeling, data warehouse, business intelligence/analytic tools
  • Demonstrated experience in using relational data architecture and reporting tools to design and develop reports to meet specifications
  • Proficient in SQL – Query development and performance improvements
  • Experience in performing data analysis and profiling
  • Knowledge of ETL and Data integration
  • Note: A Bachelor's degree or higher in Computer Science or closely allied field, to include nine (9) semester hours or fifteen (15) quarter hours in computer science courses from an accredited college or university whose accreditation is recognized by the U.S. Department of Education or the Council for Higher Education Accreditation (CHEA) or foreign equivalent may substitute for the required experience on a year-for-year basis for up to four (4) years of experience in a Business Intelligence solutions
  • A Bachelor's degree or higher in Computer Science or closely allied field, to include nine (9) semester hours or fifteen (15) quarter hours in computer science courses from an accredited college or university whose accreditation is recognized by the U.S. Department of Education or the Council for Higher Education Accreditation (CHEA) or foreign equivalent
  • Experience with innovative BI technologies such as Power View and SharePoint Dashboard
  • Exposure to data modeling, predictive analytics, and forecasting techniques
  • Professional Level-2 certification as defined by the Department of Defense 8570.01-M Information Assurance Workforce Improvement Program such as Security+, GSEC, SCNP or SSCP
  • Experience in resolving data quality assurance issues in connection with information delivery and development tasks
  • Microsoft Certified Solutions Expert: Business Intelligence Solutions Expert (BISE) Certification
103

ETL Developper Resume Examples & Samples

  • Maintains existing databases and analyze, design, and create of new databases
  • Establishes standards, documentation and best practices for SQL
  • Guides and coaches developers in SQL scripting
  • Performs support, development and administrative activities, including periodic pager duty to support department 7 days a week, 24 hours and 365 days a year applications
  • Five years MS SQL Server database experience required
  • Three years C# and/or asp.NET experience preferred
  • 3 years of Informatica experience (PowerCenter, data quality, and master data management)
  • Teradata or Epic experience
  • ETL Administration
104

ETL Specialist Resume Examples & Samples

  • At least 2 years experience in IT sector
  • At least 1 year experience in an ETL tool (DataStage/ Informatica/ AbInitio)
  • Knowledge of Data Integration
  • Knowledge of Data Modeling
  • At least 1 year experience in writing technical specifications
  • 3 years experience in working with DataStage/ Informatica/ AbInitio
105

ETL Consultant Resume Examples & Samples

  • Experience in design and development within information management, data warehousing, data integration or business intelligence environments using Datastage or Informatica - ETL Tools and SQL
  • Experience in Cloud - preferred
  • Experience in Azure or AWS - preferred
  • Strong background in programming
  • Familiarity with latest trends in analytics and data warehousing concepts
  • A desire to be part of a professional services environment
  • Ability to work independently and take initiative on tasks that need to be done
106

ETL Software Engineer Resume Examples & Samples

  • Collects and analyzes BI end-user requirements and evaluates the feasibility of these requirements from a technical perspective
  • Participants in the design, implementation, executation and debugs manual test cases using a variety of testing techniques
  • Create test cases based on requirements
  • Data analysis skills and the ability to track a data element from source to transformation to target
  • Implements data models optimizing the data-mining performance function
  • Implements Extract Transform Load (ETL) solutions using BI best practices and methodologies; identifies root causes of issues with data quality and other related issues
  • Supports the development of new software or enhances existing software and integrates into new or modified systems and/or operational environments
  • Assist a reporting team optimizing the ETL process to ensure that business requirements are met
  • Documents all phases of work including gathering requirements, database diagrams, source to target mappings and other program technical specifications using current specified design standards for new or revised solutions
  • Provide on-call production support on a rotating basis
  • Undergraduate degree in computer science or at least 2 years’ of work experience in relevant field
  • Proficient with writing T-SQL statements, scripts, stored procedures, triggers, views and SSIS packages implementing business intelligence and data warehousing solutions in a SQL Server 2012 environment
  • Strong analytical and problems solving skills debugging and correcting code in high-pressure situations correcting defects or improving performance
  • Familiarity with Oracle, SQL Server, Cognos & Tableau (or similar) environments is a must
  • Solid foundation in and application of data warehousing and reporting platform concepts with ability to recommend solutions and drive best practices
  • Experience with SQL Server 2012 (including SSIS), a plus
107

Business Objects ETL Resume Examples & Samples

  • Lead high level and low level design, architecture, development, unit testing through the Business Intelligence Development Lifecycle (BIDLC)
  • Leads the Data Services development effort, manage the effort and mentor junior developers
  • Perform data analysis, modeling and design in support of DW systems including Star Schemas and ETL program development using comprehensive knowledge of complex Business Intelligence(BI) and Data Warehouse(DW) concepts
  • Design, develop and manage recurring data load process by extracting the data from multiple sources such as flat files, Oracle and other DB platforms
  • Review business requirements and data mapping specification and develop supporting routines
  • Established and document the ETL standards across the enterprise data warehouse
  • Tune and optimize performance of existing ETL processes and ensure new ETL processes met performance criteria
  • 15 year of relevant IT experience
  • Specialized experience in
108

ETL Performance Engineer Resume Examples & Samples

  • 12+ years of proven, strong experience with performance testing and performance engineering
  • Experience of doing performance testing of batch jobs or ETL process
  • Experience with Control M or Autosys jobs, ETL tools – Informatica or Ab Initio
  • Strong in writing SQL queries and Stored Procedures
  • Experience and expertise in Database Tuning – Oracle or SQL Server
  • Experience in gathering performance testing requirements, determining what needs to be tested and why, and creating test plan to implement
  • Capable of executing adaptive tests based upon intermediate findings to help trouble shoot and isolate application performance issues
109

ETL Test Analyst Resume Examples & Samples

  • Participate in requirement analysis, static testing and define test strategy or the project in hand
  • Participate in test estimations for project and allocation of tasks, delivery of testing artefacts like test cases, test results
  • Delivers the test data setups / requirements for the project
  • Drive test execution of the project with required validation of data models, transformations etc… and reports defects and status reports
  • Participates in test automation activities
  • Understands agile work methodologies and practises
  • Need to work with technical designers and development leads during test execution and validations
  • Need to provide supervise activities of SI resources working on the projects
  • Need to be proactive in taking resolving testing problems related to test data, defect priorities etc…
110

ETL Test Manager Resume Examples & Samples

  • Minimum 4 years of experience in Data warehousing environment/projects
  • Strong in SQL preparation in Oracle/SQL Server/DB2/Teradata RDBMS
  • Strong in ETL data validation using Informatica /Abinitio/Datastage/SSIS ETL environments
  • Strong in BI report validation using Cognos /Business Objects/Microstrategy /SSRS BI environments
  • Exposure to End-to-End data validation for ETL & BI systems
  • Exposure to DB tools : Toad/PL SQL developer/Rapid SQL/SQL Plus
  • Nice to have: Exposure to Automating DW systems/Big Data environment/Hadoop Environment/Test Data Management
111

ETL Practice Architect Resume Examples & Samples

  • 2-3 years of Architecture experience using Datastage, Predictive Analytics and/or Tableau
  • 8+ years of Data Warehousing experience
  • 1+ years Data Quality project work
  • Data architecture and modeling experience implementing proper data structures for an ETL solution using either Datastage, Predictive Analytics and/or Tableau
  • Knowledge and experience in the development & deployment of master data solutions and data warehouse data architecture for large data volumes and complex reporting solutions
  • Candidate must understand business processes, be a detailed-oriented person and quickly grasp new concepts. Additionally the candidate will have strong presentation, interpersonal, software development and work management skills
112

Fair-etl Developers Resume Examples & Samples

  • Analyze and develop complex ETL programs and perform testing, debugging, documentation to create highly reliable data integrations
  • Document architecture, technical solutions and complex ETL technical design following internal standards
  • Perform hands-on development and coding, unit, integration and functional testing, deployment support in line with best practices and established standards
  • Create ETL technical implementation work breakdown structure (WBS) plans to design and implement solutions; develop work effort estimates, and work schedules
  • A Minimum five (5) years’ experience in an application developer role, overseeing the relational and multidimensional design, development and support of large complex business and administrative systems using established ETL tools - Pentaho, Informatica etc
  • Solid understanding of data modeling and schemas
  • In-depth knowledge of and experience with ETL tools for development and applications with Oracle, SQL, PL/SQL
  • Proficiency in understanding relational and dimensional data models combined with a broad understanding of data technologies, including ETL, OLAP, OLTP and general modeling practices
  • Basic expertise of architecture and data warehouse best practices
  • Pentaho
113

Business Systems Analyst Business Intelligence & ETL Resume Examples & Samples

  • The ideal candidate for this position is a professional with superb communication skills who has a solid grasp of current web and Business Intelligence technologies
  • The candidate should have a good sense of industry trends and can effectively analyze complex business requirements and translate them into detailed functional specifications, test plans, and system/process/user documentations
  • The candidate should have a solid technical foundation enabling her or him to communicate effectively with development teams, while possessing the ability to successfully partner with key stakeholders and engage senior management to drive for results
  • The role will develop and advise on processes and programs that are key to our customers, our business partners, and internal operation
  • This will also include thought leadership around BI reporting and recommendations of processes or programs that increase results and drive organizational capability across a multitude of business dimension
  • Review data and metrics provided by the requirement team and or end users, assess the feasibility and provide reporting solutions that matches the requirements
  • Trouble shoots errors raised by end users regarding to the data problems
  • Engage and work in collaboration with other application owner area to help them finding their data problem as soon as the data issues arise
  • Provide solutions and answers on various inquires and questions raised by end users such as missed reporting schedules, web access problems and other concerns regarding to the reports or extracts that we provide
  • Provide the programming documentation based on the solutions delivered. The documentation should be focusing around the technical detail of the reporting system
  • Building relationships with business stakeholders, understanding their requirements, and establishing dialogue on how to support those requirements
  • Partnering with analysts and tool developers to understand existing reporting landscape, available data sources, and system dependencies and work flows
  • Analyzing data and metrics needs across business stakeholders; ensuring that all key performance indicators are identified and measured, supported by continued stability and reliability of Reporting tools
  • Documenting requirements clearly, concisely, comprehensively to appeal to development teams and to business stakeholders who must review and approve
114

ETL Specialist Resume Examples & Samples

  • Design and implementation of large and medium scale data warehouses, management information systems and operational data stores, taking into account user needs, business value and technological constraints
  • Relational and multi-dimensional data modelling
  • Design and implementation of ETL processes
  • Design and implementation of processes, methods and tools supporting data quality analysis and management
  • Analysis, verification and assessment of process and tools used by organizations for information management, providing recommendations for changes and improvements in the process, organization and technology areas
  • Experience in one or more of ETL integration platforms (IBM DataStage is a plus)
  • 1-3 years of experience in data integration
  • Practical SQL and database knowledge
  • Understanding of ETL and Data Warehousing techniques and patterns
  • Basic experience in using Unix/Linux operating systems and shell/bash scripting
  • Excellent communication (written and oral) skills in English
115

Test Lead-etl Test Analyst Resume Examples & Samples

  • Strong technical testing experience
  • Required to ensure effective test coverage, test design, test execution, and defect management
  • Strong knowledge of Business Intelligence, SQL, DataHub, and reports testing
  • Knowledge of Guidewire Claims Center would be an asset
  • Must have VERY strong, clear communications skills
116

ETL Practice Architect Resume Examples & Samples

  • 1) Microsoft, Tableau and/or Qlikview
  • 2) DataWarehouse
  • 3) Speaking/presentation skills
  • 2-3 years of Architecture experience
  • Data architecture and modeling experience implementing proper data structures for an ETL solution using tools such as INFORMATICA and Datastage is required
117

Lead ETL Wherescape Architect Resume Examples & Samples

  • Responsible for design, development, implementation, and maintenance of the enterprise data hub and downstream processes
  • Provide assistance in troubleshooting job failures, missed SLA’s, and other critical production support issues
  • Prepare and present technical design concepts to internal audiences of various levels
  • Provides technical work guidance and mentoring
  • 5 years’ hands-on experience with Wherescape Red
  • Strong leadership skills to gain credibility with various levels of management and stakeholders
  • Understanding of SDLC best practices
  • Sufficient business acumen to understand finance and banking business concepts and processes
  • Working knowledge of Informatica, UNIX, and PostgreSQL
  • Autosys experience is a plus
118

Senior ETL Specialist Resume Examples & Samples

  • Development and delivery of end-to-end DW & BI solutions
  • Translate detailed requirements into functional specifications
  • Define Extract, Transform & Load (ETL) processes and frameworks
  • Provide work estimates in support of assigned work
  • Ensure that development work assigned to you, or that you are accountable for, follows applicable standards and that code is clear, efficient, structured and easily maintainable
  • Develop, debug and unit test components (existing and new) of the application
  • Provides technical oversight to development team working on BI Reporting tools (Business Objects, MS SSIS/SSRS)
  • Provide guidance to project team on collecting metadata and maintaining the data dictionary
  • Serves in a leadership role for technical project decisions
  • Provides support for the implementation and deployment of new data solutions
  • Develops, tests, documents and implements high-performing, scalable solutions including schema design, storage engines, indexing strategies, SQL tuning, ETL processes, stored procedures and software applications
  • Mentors and guides other data developers in best practices for Data Warehouse and Data Application development
  • Troubleshooting and performance optimization of BI solutions
  • Deliver DW & BI solutions according to Systems Development Life Cycle (SDLC) methodology
  • Contribute to definition and implementation of standards and best practises for DW & BI
  • Create documentation for business definitions of data as well as data models
  • Proactively monitors, tunes and maintains data solutions for performance, capacity management and business continuity perspectives
  • Contribute to definition and implementation of Business Intelligence strategy and roadmap
  • Provides consultation for the evaluation of data and software systems
  • Promote DW & BI services across the organization
  • Develops and manages effective working relationships with other departments, groups or personnel with whom work must be coordinated
  • Possesses an understanding of information systems, data modeling, business intelligence, relational database design and knowledge of how to access multiple information sources for analytical purposes
  • Ability to take direction and follow through with assignments
  • Uses initiative, exercises good judgment and exhibits business savvy orientation
  • Very strong conceptual, analytical, judgment and communication abilities are critical
  • Experience in developing solutions for data warehouse loads and system integrations using
  • ETL Tools: Informatica PowerCenter, Microsoft SSIS, SQL script, stored procedures (5+ years)
  • Strong Knowledge of SQL
  • Experience with production implementation change management processes
  • DW Methodology: Kimball, Inmon, dimensional and relational data modeling (5+ years)
  • Databases: Microsoft SQL Server, Oracle, DB2, flat files (7+ years)
  • Process: Project management and software development life cycle /SDLC (5+ years)
  • Documentation: Technical writing, Visio, PowerPoint, flowcharting (5+ years)
  • Communication: Presentation and interpersonal skills
  • Analytical: Conceptual, requirements interpretation, solution creation and problem-solving abilities
  • Collaboration: Experience working in a team-oriented, collaborative environment
  • Education: Computer Science degree or certificate, or equivalent, supplemental training
  • Leadership: Proactively adapt to challenges, organizing work, mentoring
  • Environment: Experience working in large organization
119

Lead ETL Wherescape Architect, VP Resume Examples & Samples

  • Participate in analysis and design meetings, collaborating on efficient and cost-effective solutions with various team members
  • Works on major projects providing subject-matter expertise and technical direction to more junior technical staff
  • Perform code reviews of both contract and MUFG team members to ensure established standards and architectural designs are adhered to
  • Typically has 7-10 years of data warehouse programming/systems analysis experience
  • Advanced data modeling knowledge required (logical and physical)
  • Ability to clearly communicate complex technical concepts to internal audiences of various knowledge levels
120

EDI / ETL Manager Resume Examples & Samples

  • Will act as an ongoing technical support contact and will develop and maintain relationships with external vendors, third parties and other customers
  • Will provide research resolution for escalations from internal and external team members
  • Will have the skills to work independently and coordinate closely with other team members to provide support for client interfaces and project management related to implementing new/enhanced interfaces
  • 10+ years of experience in a related technical/business field
  • 4+ years of managerial experience over a technology related team
  • 3+ years of experience with EDI and ETL support utilizing data tools, FTP communications and ability to read and understand mapping specifications and standards
  • 2+ years of experience with EDI 834, 835, 837
  • Understanding of ASC X12 standards and HIPAA standard transaction code sets
  • Working knowledge in multiple products and tools such as: DataStage, Ab Initio, Sterling Integrator, Web Services, and Java
  • Knowledge of project management standards, methods and techniques (ITIL, ITSM, etc.)
  • Technical knowledge of software and hardware testing methodology, knowledge of support organizations, business and workflow process, and quality methods
  • Exposure and general understanding of Healthcare claims processing
121

Business Intelligence / ETL Developers Resume Examples & Samples

  • Implementing and/or maintaining Business Intelligence (BI) and data warehouse applications using of SQL, ETL, BI tools (Ex: SAP Business Objects Suite ) and database programming and reporting tools
  • Designing and building universes, creating canned and ad-hoc reports, and creating dashboards
  • Developing, implementing, and maintaining ETL (extract, transform, and load) solutions to bring new data into the data warehouse
  • BI administration tools
  • BI best practices and principles
  • Basic programming ability using SQL and PL/SQL
  • Experience conducting requirements gathering sessions
  • Experience developing report testing strategy
  • Bachelor’s degree in Computer Science, Information Systems, or related field
  • Certifications in either Business Objects and/or Oracle software/ ETL Developer
122

ETL Test Manager Resume Examples & Samples

  • Requirement analysis and understanding of DWBI technical specification documents
  • Perform data analytical testing for the BI systems
  • Strong in BI report validation developed using Cognos/Business Objects/Microstrategy/SSRS BI
  • Exposure to DB tools : Toad/PL SQL developer/SQL Plus
  • Excellent communication, documentation and presentation skills
123

ETL Developers Resume Examples & Samples

  • Create/manage batch processes
  • Gather mapping and reporting requirements and coordinate all data movement activities
  • Analyze, develop, install, test, upgrade, maintain and support complex data/process models, and processes in an ETL environment
  • Provide project estimates, plans, and schedules
  • Bachelor's degree in Computer Science or equivalent degree
  • Experience with UNIX scripting, SQL, DMExpress, FilePort also strongly preferred
  • Experience with QualityStage, Information Analyzer, and Change Data Delivery (CDD) will get top priority in considerations
  • Experience with IBM's MDM software is a definite plus
  • Knowledge of Extraction, Transformation, and Loading (ETL) disciplines
  • Knowledge of Greenplum database platforms
  • Knowledge of AIX UNIX systems and tools
  • Strong testing and debugging skills
  • Sound understanding of banking/financial industry processes is a plus
124

ETL Development Executive Resume Examples & Samples

  • Design, develop, test and implement ELT (Extraction, Load & Transform) processes to populate the global data warehouse in line with agreed standards and guidelines
  • Participate in design and code reviews, documentation of design, and implementation of methodologies to ensure high quality deployments
  • Create specifications, test plans & detailed design documentation to support handover to operational teams
  • Determine data mapping and transformation rules
  • Contribute to project plans
  • Support systems integration and user acceptance testing
  • Understand Unilever Release process and adhere to standards defined by the Towers
  • Contribute to enhance existing standards and innovate new used cases
  • Fully conversant in pushdown/ELT (extract, load & transform) concepts
  • Strong experience in BODS (Business objects data services) and / or SSIS
  • Design and development standards for ETL
  • Data blending tools Alteryx and Data integration tools Mulesoft
  • Knowledge of Teradata, SAP, SQL server and Hadoop is desirable
  • Ability to prioritise own work and the work of others, multi-task, and meet deadlines
  • Ability work flexible hours to work with team members in various time zones across the globe
  • Good analytical skills to innovate new solutions and automation
  • Ability to quickly understand requirements and provide solutions
  • Ability to learn new skills
125

Senior ETL Dev Tech Architect Resume Examples & Samples

  • Work with Functional Architect in Creation of estimates for new project efforts and project budget management
  • Overall ETL solution design and creation of design specifications to implement changes
  • Project planning for individual efforts
  • Creation of design specifications to implement changes
  • Development, testing, and deployment of project deliverables
  • Issue resolution & escalation, and project status reporting
  • On call support team for handling production issues
  • Impact analysis of potential technology changes to the ETL environments
  • 7+ years' of Informatica ETL development experience with exposure to version 9.1 or later
  • Should be at or near expert level with Informatica Power Center and possess a solid working knowledge of SQL and ETL load and extract processes within Informatica. Additional experience with Metadata Manager, Informatica Parallelism, Power Exchange, and Real Time Data Acquisition desired
  • Experience with Oracle database technologies within an ETL framework
  • Experience with Data Warehouse technologies within the domain of ETL/Data Integration, Business Intelligence, and relational and multi-dimensional Database systems
  • Experience in an UNIX environment and proven knowledge of scripting languages
  • 3+ years' experience working with the following
  • Experience producing data models and DDL for implementing SQL database structures in support of ETL processes
  • Data Warehousing data architecture methodologies including dimensional modeling and DW & Data Mart architecture
  • PowerExchange (PWX) in One or more of the following: JMS/MSMQ/TIBCO/Websphere MQ/WebMethods Broker
  • XML/Complex XML Processing and related technologies (XSD/Xpath)
  • Informatica B2B (Data Transformation Studio)
  • PowerCenter Unstructured Data Option (UDO)
126

ETL Development Consultant Resume Examples & Samples

  • Capture ETL Requirements
  • Design, develop, and test processes for extracting data from source applications
  • Design, develop, and test processes for loading initial and cyclical data into a data warehouse
  • Determine data growth trends and peak business periods
  • Coordinate ETL Development activities with other team members on-site, and off-shore
  • BA/BS degree in an Information Technology or Business-related field required
  • Strong problem-solving skills and innovation
  • 3+ years experience using a 3rd party ETL programming tool required (knowledge of SAP Data Services a plus)
  • 5+ years of experience working with BI Solution Delivery teams required
  • Knowledge and/or experience with SAP BI tools (Webi, Explorer, Dashboards, Lumira, etc.) a plus
  • Experience/Familiarity with Teradata DBMS, Teradata SQL and Teradata utilities (BTEQ, MLOAD, TPT) and Linux OS is preferred
  • Experience working with off-shore developers a plus
  • Ability to lead and work in groups – strong consultative and consensus building skills
  • Experience with a Job Control and Scheduling application a plus
127

ETL Consultant Resume Examples & Samples

  • Capture ETL requirements – note this includes all data integration techniques such as ELT, etc
  • Design, develop, and test processes for extracting data from legacy systems, production databases, Teradata, Teradata Aster, Hadoop, and Open Source platforms
  • Design, develop, and test processes for validating and conditioning data prior to loading it into a Teradata Warehouse, Teradata Aster, or Hadoop platform
  • Design, develop, and test processes for loading initial and cyclical data into a Teradata Warehouse, Teradata Aster, or Hadoop platform
  • Design the processes to meet service level agreements for data timeliness and frequency
  • Determine which data elements are historic and the retention period for historic data
  • In depth knowledge of the Teradata Database, Teradata Aster, and / or Hadoop platform
  • In depth knowledge of ETL tools and the SQL language
  • Ability to understand and properly use data integration techniques such as ETL and ELT
  • Profiling, validating, conditioning, transforming, and cleansing of data
  • Implement projects on premises, in the cloud, and between mixed environments
  • Knowledge of Architecture Principles, Advocated Positions, Design Patterns, and Implementation Alternatives
  • Understanding of the Teradata Reference Information Architecture
128

ETL Consultant Resume Examples & Samples

  • Understanding, documenting, and articulating the customer's current data warehouse, data mart, and big data architecture. This includes a complete inventory of the customer's data warehouses, data marts, and big data stores, as well as their respective business functions
  • Understand the client’s business goals, information needs, application requirements, IT plans, and architecture and articulate linkage to the proposed architecture and application designs
  • Design and manage winning POC applications based on customer requirements
  • Demonstrating and utilizing knowledge of business problems of customers in their industry
  • Identifying new application opportunities for Consulting Services engagements
  • Demonstrating the ability to relate business problems to the underlying data and the ability of technology to solve the business problems
  • Work with Teradata project managers to scope projects and develop statements of work, project plans, and risk analysis utilizing both Waterfall and Agile methodologies where appropriate
  • Provide technical thought leadership and actively participate in the application design, implementation, and roll-out efforts
  • Responsible for logically grouping development tasks into work packages and distributing them as appropriate to ETL development resources
  • Responsible for leading the development of the ETL environment, processes, programs, and scripts to acquire data from source systems and apply the data to the tables in the Teradata
  • B.S. / M.S. in Computer Sciences, Software Engineering, Computer Information Systems
  • Data Warehouse design and development experience of at least 5-10 years
  • Success at managing projects of appropriate scale (10 resources)
  • Excellent understanding of DW business and key processes
  • Industry expertise – Telecom, Retail, Manufacturing, Financial etc. would be an advantage
  • Technical knowledge and in depth experience with analytics, applications, enterprise architectures, solutions, and technologies
  • Proven capabilities in relational database and big data technology in the application development environment (Teradata, Teradata Aster, Hadoop, DB2, Oracle)
  • Hands-on experience of EDW development especially in ETL area
  • Operational knowledge of third party ETL tools (Informatica, DataStage, Abinitio, ODI and/or others)
  • Client interfacing, relationship building, and consulting skills required
  • Ability to work in a dynamic and collaborative team environment, demonstrating excellent interpersonal skills
  • Strategic Planning and Thinking
129

ETL Consultant Resume Examples & Samples

  • Design, develop, and test processes for extracting data from legacy systems or production databases
  • In depth knowledge of ETL tools / analytical skills for junior
  • Master Degree, preferably in an Information Technology (IT) related degree
  • You will be required to work on projects in the Benelux region, so willingness to travel is essential
  • Fluent in Dutch and English, both spoken and written
130

ETL Consultant Resume Examples & Samples

  • Capture ETL requirements
  • Design, develop, test, support processes for extracting and loading data from source systems to DWH and DM
  • Analyze and optimization current solutions, physical model optimization, query tuning
  • In depth knowledge of any enterprise relational database
  • In depth knowledge of ETL tools: Informatica PowerCenter or SAS DI
  • Knowledge of Metadata driven approach is an advantage
  • Knowledge of BigData is an advantage
  • Master degree in IT or related sphere
  • English intermediate, Russian native
131

Data Integration / ETL Consultant Resume Examples & Samples

  • Bachelor’s Degree preferably in Computer Science, Computer Engineering, Management Information Systems or equivalent work experience
  • At least4 years of experience in developing data integration extract transform and load jobs/application
  • At least 4 years of experience working with Relational Database Management Systems (e.g. Oracle, SQLServer, Sybase, Sybase IQ, DB2, Teradata, MySQL)
  • Strong experience and skills in structured query language (SQL)
  • Has working knowledge/experience on Teradata Physical Design and Implementation, Teradata Utilities and Performance Optimization
  • Have work experience on creating UNIX Shell Scripts and Stored Procedure and Macros
  • Must have a good understanding of Database Designs and Data Models
  • Knowledge of any DI/ETL Tools such as Teradata TPT, Informatica, DataStage, Oracle Data Integrator, Ab-Initio, BusinessObjects Data Integrator (SAP DI), Microsoft SSIS, SAS Data Integrator, Pervasive, Talend, Genio or similar is an advantage
  • Preferably with experience in Data Warehouse/Data Mart development
  • Experience in analyzing and understanding customer requirements
  • Experience in handling small teams is an advantage
  • Good communication skills ( English: Written and Verbal )
  • Team player, flexible, hardworking, self-motivated, initiative
  • Ability to work in a dynamic and collaborative team environment
132

ETL Development Engineer Resume Examples & Samples

  • Create and maintain ETL tools and scripts to facilitate the migration of files, applications, services, configurations and other data between platforms
  • Create and maintain tools and scripts to extract, transform and load billing and configuration data between platforms
  • Collaborate closely with DevOps team members to implement tools scripts and other automation solutions
  • Collaborate closely with support, customer experience, brand, and other business resources to meet business objectives
  • Follow incident, problem, crisis and change management processes
  • Document, track, and communicate solutions to problems
133

ETL Database Developer Resume Examples & Samples

  • 5+ years of database related experience
  • 3+ years of Data Warehouse experience
  • ETL (DM Express or Informatica) Tool experience
  • Bachelor Degree or higher
134

Financial Systems Systems Analyst ETL Resume Examples & Samples

  • Experience with ETL projects (data extract, transform and load) (good to have) * This one is key
  • Understanding Test Automation Strategy (good to have) *** This one is key
  • Finance business acumen with a focus on Enterprise tax processing (nice to have)
  • 2+ years’ experience in the following
135

ETL Specialist Resume Examples & Samples

  • Around 4-6 years of experience with Informatica PowerCenter and Oracle SQL, PL/SQL
  • Minimum 1 year experience with Big Data ETL technologies (e.g. AWS, Hadoop, Spark SQL)
  • Experience with Life Sciences Industry is preferred
  • Familiarity with industry standard data sources such as IMS NPA, NSP, LRX is a plus
136

ETL Software Developer Lead Resume Examples & Samples

  • Lead day to day running of technical aspects of a project
  • Working with the project team to ensure timely delivery
  • Assisting Information Architects on high level design
  • Respond to technical questions/issues related to the project
  • Ensure technical excellence and skills of development staff through training, valuation and continued development
  • Enforce standards, best practices and tool usage within the team
  • Ensure completion of code reviews
  • Lead tasking/estimating for stories and defects
  • Ab Initio or similar ETL Software Suites
  • Data Warehouse development
  • Database technology such as Teradata, SQL Server & Oracle
  • Hands-on experience designing, developing and optimizing complex solutions that move and/or manipulate large volumes of data
  • Hands-on experience and proficiency with SQL preferred
  • Hands-on experience and proficiency with Unix preferred
  • Hands-on experience and proficiency with Big Data environments preferred
  • Working knowledge and use of BI/DW development methodologies, standards and procedures
  • Experience working with onshore and offshore resources
137

ETL Data Engineer, Product Development Resume Examples & Samples

  • Develop ETL source and target mapping design/specifications based on the business requirements and ETL standards and architecture
  • Develop and execute SQL/stored procedures/ server scripts as needed to support ETL code
  • Design and execute Unit Test plans and document results
  • Provide assistance in determining ETL hardware/software requirements and assist with production migrations
  • Ensure performance metrics are defined, met and tracked and conduct QA reviews
  • Maintain and develop project standards, quality control and documentation
  • Keep supervisor apprised of current status of projects
  • Experience writing ETL/ELT procedures and transforming large datasets, preferably “from scratch” using a scripting language
  • Strong understanding of SQL and database concepts
  • Strong understanding of Python
  • Experience with the Linux shell; must understand crontab and how to automate jobs
  • Experience with Data Integration tools (especially Pentaho)
  • Ability to develop and manage project schedules/project work plans as well as lead design and development reviews
  • Strong and effective communication skills including the ability to interpret a variety of instructions provided in written, oral, diagram, or schedule form
  • Capability to moderate discussions between technical and non-technical end users including the aptitude to take non-technical requirements and convert them into technical requirements
138

Msbi Technical Lead Ssis Etl-onsite Resume Examples & Samples

  • Gathering and analyzing the business requirements from the business users
  • Analyzing and identifying the technical and business challenges for the projects and designing feasible approaches in ETL technology
  • Developing Functional and Technical Design Documents for the project implementation
  • Attending the Architecture and Design review sessions of the Data Model, Data marts and Data Warehouse
  • Modifying the existing Design specifications based on the Change Requests
  • Reporting the status updates on tasks to the client on timely basis
  • Working with cross functional teams for leveraging the data on Projects
  • Coordinating with offshore team to pass on the task from different meetings, allocating the tasks and tracking the status
  • Reviewing the code developed by the offshore team to ensure the quality of deliverables
  • Reviewing the unit test cases and test results created/captured by the offshore to ensure the quality of deliverables
  • Providing best practices to improve the performance and data cleansing techniques wherever necessary across the Data Warehousing
  • Automating the job process or batch process by creating scripts
139

ETL Senior Professional Resume Examples & Samples

  • Bachelor’s degree in information technology, computer science, information systems or other closely related field
  • Two (2) years of experience working in a data warehouse environment
  • Hands-on, technical experience working on data warehouse projects
  • Experience using Tableau Server and Tableau Desktop in order to create Tableau reports for a broad range of users
  • Experience providing IT support in a higher education and/or medical environment
  • Extensive knowledge of databases, database technology, and SQL
  • Comprehensive understanding of best practices of ETL
  • Comprehensive understanding of technical requirement definition and data mapping
  • Ability to effectively work on an interdisciplinary team
  • Ability to review work products for correctness, adherence to the design concept, user standards, and progress relative to schedules
  • Ability to serve as project manager for various ETL assignments
  • Intermediate knowledge of Microsoft Office applications, particularly Excel and Access
  • Practical knowledge of the Microsoft SQL Server data management system
  • Excellent written, oral communications, interpersonal skills. Must be well versed in communicating with both technical and non-technical staff
  • Demonstrated ability to follow system development life cycle best practices, including: requirements gathering, development standards, quality control, release management, testing, documentation
  • Strong knowledge and experience building custom ETL mappings
  • Strong knowledge and experience with Microsoft SQL Server and its Business Intelligence tool set
140

ETL Data Analyst Resume Examples & Samples

  • 1) 3+ Years as an ETL Analyst in an enterprise environment helping map and scrub incoming data from multiple data sources (SQL, Oracle, EDI, Web service, etc) to enterprise data destinations (in this case, the destination is an AS400 DB). - this project is focused on implementations and mapping data from multiple client sources to one source
  • 2) 3+ Years working with ANY ETL tool/wizard and having an understanding of how these tools create ETL packages. SSIS Development experience would be a HUGE PLUS, but not required. If there are two candidates and one can do SSIS from scratch, they will be the choice
  • 3) 3+ Years T-SQL- ability to write inner joins, outer joins, EXPLAIN THE DIFFERENCE BETWEEN THE TWO, select statements, updates, merges, create Aliases, use common functions FROM SCRATCH
141

ETL / Integration Analyst Resume Examples & Samples

  • Define business user requirements on moderate to complex projects with some analytic design and data modeling
  • Provide follow-up to ensure successful implementation of designs and enhancements
  • Develop and test extraction, transformation and load (ETL) processes
  • Work with team to identify and understand source data systems
  • Adapt ETL processes to accommodate changes in source systems and new business rules
  • Devise or modify procedures to solve problems related to applications issues, troubleshoot user support problems, and be actively involved with application performance planning
  • Perform assigned software development and maintenance tasks including development of function specifications, prototypes, programming and testing
  • Work with Technology Integration Specialists or business users to design and provide training
  • Take proactive steps to evaluate issues, determine alternatives, and implement the appropriate solution for the client group
  • Perform client training
  • Perform business system design and data modeling tasks
  • Stay up-to-date on changes and advances in technology that could affect the company
  • Administers BI tools and analytic servers
  • Troubleshoot BI tool problems and tunes for performance
  • Develop multidimensional semantic layer and BI query objects for end users
  • Helps business users select the appropriate BI tool(s)
  • Develop and manage BI training, documentation and help desk capabilities
  • 3 or more years of development experience in Java or similar development language required
  • Experience with extract, transform and load processes preferred
  • Experience building and supporting web services – JAX-WS preferred
  • Experience with Business Object Data Services, Web Intelligence, Crystal Reports and Business Objects preferred
  • Experience with MuleSoft Enterprise Service Bus preferred
  • Knowledge and experience with object oriented programming languages
  • An understanding of relational databases and dimensional database models (star schema)
  • Basic knowledge of server based computing environment, including computer hardware, operating systems, networking, and middleware and database management systems
  • Basic knowledge of information engineering concepts, including business area analysis, business system design, data modeling and application construction
  • Depending upon programming assignments, experience with but not limited to programming languages including Java and .NET
  • Ability to work independently with business partners in software requirements and system support while keeping team members well informed of efforts
  • Demonstrated ability to manage multiple priorities and work within challenging situations
142

ETL Data Analyst Resume Examples & Samples

  • Design, develop, test, QA and update data integration (ETL, replication, change data capture),Data design/modeling, data profiling, and data profiling processes
  • Update and maintain metadata repositories and dictionaries
  • Responsible for creating, validating, and/or updating source-to-target maps. Help perform source analysis and supports departmental process improvement initiatives
  • Assist with logical and physical model design, source-to-target mapping, use cases, and other development processes and artifacts. Identify data subject areas, entities, attributes, relationships, information types, and domains
  • With project team, design and communicate logical and/or physical models and designs
  • Responsible for supporting identification of physical implementation requirements, including normalization techniques and referential integrity or dimensional techniques
  • Assist with defining, maintaining, and enforcing data architecture, definitions, and standards
  • Participate in data policy, standards, and procedure development processes
  • Perform code reviews, data model reviews, and testing
  • Establish standards and best practices
  • Work with IT partners to perform periodic system and database operational tests, audits, and tuning. Responsible for promoting understanding of data quality concepts and methods. Identify, document, and recommend solutions for poor quality data
  • Extensive knowledge of SSIS of performing ETL tasks in SSIS including; acquiring, transforming, and loading of data
  • Demonstrate strong quantitative, analytical, and problem solving skills, with ability to adapt to new methods, techniques, and procedures
  • Extensive knowledge of Oracle ETL, replication, change data capture and other data integration techniques and technologies
  • Experience with Microsoft SQL Server 2008 Suite of tools (SQL SMS, SSIS, SSRS, SQL Server BI Studio, etc) helpful but not required
  • Extensive knowledge of database systems and administration, including security, development and testing support, modeling and logical design, database design, and qualify control
  • Nice to have skills
  • Experience with Informatica, DataStage as alternative ETL tools
  • No 3rd party submittals please
143

ETL Quality Analyst Resume Examples & Samples

  • Familiarity with Healthcare data
  • Strong fundamental knowledge of Data Warehouse (tables, primary and foreign keys, indexes, partitions, views, referential integrity, functions, triggers, stored procedures and packages)
  • Hands on test experience with Oracle SQL, ETL, Data Model, Data Warehouse and Business Intelligence based report
  • Experience in writing complex SQL Query in UNIX and Windows environment
  • Complete understanding of the QA, SQL & software development life cycles
  • Strong analytical problem solving skills, good verbal and communication skills
  • Hands on knowledge in defect management, test management & MS office tools
  • 5+ years of software testing and QA experience
  • 2+ years recent hands on experience with Data Warehouse testing/QA
  • Shell/perl/java scripts knowledge
  • Proven ability to adhere to established release management processes
144

Senior IT Application Developer ETL Resume Examples & Samples

  • Development, maintenance, and/or support of one or more applications in an assigned technology, major system, or functional area. Participation in and providing leadership for analysis leading to requirements/specifications, estimates, and system designs for applications
  • Performing and overseeing programming, quality assurance reviews, documentation, system deployment, training, and project setup/support
  • Performing project setups, analyses, designs, etc., for/with customers. Similar duties are often associated with the selection, acquisition, installation and configuration of applications licensed from third parties, and interaction with vendors is required
  • Interpreting and applying directions originating at a higher level
  • Assistance in supervision or mentoring of staff; allocating and monitoring work
  • Prepares development hours and cost estimates
  • Provides input to development project plans
  • Development of Data Models and processes
  • Logical Database: Logical Database design which includes: Clarifies functional specifications and avoids assumption, Confirms business requirements, Facilitates business process improvement, Focuses on requirements independent of technology, Decreases system development time and cost, Facilitates data re-use and sharing, Foster seamless communication between applications, Establishes a consistent naming scheme
  • Build specifications for extract, transform, and load processes, following standards for Informatica to facilitate the data mart/warehouse fact and dimension models
  • Responsible for time scheduling, properly building jobs with appropriate failure notifications, and properly maintaining adequately documented run books of the jobs
  • Review business requests for data design and data usage. Avoid redundant extracts by understanding gap analysis of available data and working to build interfaces for new data
  • Work with business to gather/analyze requirements to determine extent of reporting and/or interface needs
  • Ensure warehouse and database functions in accordance with Data Governance policies as set forth by KBR policies and standards
  • Collaborate with cross-functional teams to design solutions
  • Coordinate new data development which includes the creation of new structure to meet business requirements or streamline existing processes to reduce overhead on the existing warehouse
  • Work with the release management team to ensure that proper change management process is performed, as well as planning deployment timelines to avoid emergency migrations
  • Define and recommend BI standards, processes and technologies
  • Researching and recommending software technology direction
  • Bachelor’s degree in Computer Science / Computer Information Systems or related field or extensive applicable experience
  • A minimum of 5 years of experience working with enterprise data warehouse projects
  • Strong understanding of data analysis, data and process modeling and relational database concepts
  • Extensive data warehousing/business intelligence development and architecture experience
  • Extensive experience designing relational (conceptual, logical, physical) and dimensional data models for data warehouse/business intelligence
  • Extensive experience with system integrations
  • Extensive experience with Informatica PowerCenter
  • Experience with Embarcadero or Erwin data modeling tools
  • Experience with Automic (UC4) Scheduler
145

Application Developer Etl Resume Examples & Samples

  • Develops and tests for extraction, transformation, and load (ETL) processes
  • Able to handle Production issues, defect tracking process and estimation of work efforts on defects
  • Good verbal/written and inter-personal skills
  • Positive attitude, self-motivated and confident
146

Apps Sup Technical Specialist With ETL Resume Examples & Samples

  • Work with the application support team to resolve issues/tickets in a timely manner
  • Investigate system issues and work with technology partners and recommend solutions
  • Ability to delve deep into the code structure to understand complex algorithms and troubleshoot system/data problems
  • Provide technical oversight across systems and applications; leverage support skills across multiple teams and departments
  • Debug and test new software / applications and able to make general enhancements to the existing software / applications
  • Demonstrate drive and initiative; be goal-oriented, dedicated and self-sufficient
  • Partner with development and other technology teams to develop strategy regarding overall architecture and infrastructure, identifies and defines necessary system enhancements; analyzes existing system logic, identifies problems; and recommends and implements solutions
  • Be able to work well under pressure, adapt quickly to changing priorities and maintain focus on key tasks during busy periods
  • Responsible for system availability / stability within the production environment to agreed business levels
  • Communicate complex technical issues to business users in a language they understand
  • Assess and prioritize issues based on criticality
  • Able to provide effective client communications regularly and escalate when appropriate
  • Provide support for the applications on a rotational basis where needed. Able to cover off hours and weekends where required for tasks like system upgrades and new production rollouts
  • Plan for and execute annual Continuity of Business (COB) tests, which will involve liaising with DBA’s, System Administrators, Users and other technical support teams to ensure test plans are executed as per the plan
  • Ensure production support documentation is kept up to date
  • In-depth expertise and troubleshooting on specific platforms or applications
  • Implementation and release planning, coordination with L2 for execution
  • Analyze and co-ordinate resolutions with vendors
  • System and application performance analysis, co-ordination, and remediation
  • Identify automation for repetitive activities and proposal for performance improvement, if any
  • Interaction with 3rd Party Vendor support
  • Perform file configuration and settings changes regarding the difference app and web servers on which the application is hosted
  • Support continuance of business testing and planning
  • Participate in and execute emergency changes to bring an application back to production
  • 5+ years experience working in a support environment and dealing with business and technology users in a support role
  • 3+ years building SQL queries
  • 3+ years with Unix Shell Scripting
  • 3+ years Core Java
  • Strong Problem Solving skills
  • Databases / SQL
  • Hadoop, oozie, spark and Hive queries
  • Knowledge of Unix platform
  • Proficiency in dealing with complex technical issues in an application support role (not desktop) support
  • Webservice /API is a plus
  • Perl is a plus
  • Knowledge of Retail Risk business is a plus
  • DB Procedural Language is a plus
147

Senior ETL / Talend Developer Resume Examples & Samples

  • Understand and evaluate source system data
  • Develop ETL solutions
  • Participate in Model reviews with Data modeler and project team members
  • Optimize the SQL for better performance
  • 5 + years’ experience in ETL development – Talend/Abinitio preferred and DW architecture in a volume intensive data warehouse environment preferably in financial industry
  • Good Experience of application integration
  • Knowledge on Unix Shell / Perl scripting is added advantage
  • Solid database knowledge around partitioning, stored procedures, functions, performance tuning, optimization of SQL
  • Knowledge of Java (Core Java, Spring, Multithreading) is plus
148

Application Development Specialist, ETL Resume Examples & Samples

  • Develop ETL solutions based on Functional Requirements submitted by Business Analysts
  • Develop Technical Specifications from submitted Functional Requirements
  • Debug issues discovered during testing or production failures
  • Document newly developed or modified ETL processes
  • Maintain ETL development standards developed by the team
  • 3 or more years experience developing ETL jobs in IBM InfoSphere DataStage / QualityStage version 9.1 or higher
  • Experience with importing various data sources (flat files or Database tables), editing and transforming the data to be loaded into a Database stage environment
  • Degree in computer science, management information systems, or a related field with five years of software development experience
  • 3 or more years of Healthcare experience
  • 2 or more years of experience using Netezza
  • Familiar with Data Governance practices and standards
  • Experience in supporting a production and development environment, including performance monitoring and tuning of production jobs
  • Extensive experience in data analysis and/or reporting along with strong knowledge of database and related technologies (SQL, RDMS, etc.)
149

Senior ETL Software Engineer Resume Examples & Samples

  • Very good knowledge of ETLs development
  • Very good knowledge of SQL
  • Proficiency with Java 7 and J2EE middleware platforms is a must have. We would prefer current Wildfly 8+ experience, but will consider Websphere, Weblogic, Oracle Java EE experience as a replacement if JPA, EJB, and WS technologies were used
  • Demonstrated Object-Oriented development skills are paramount to designing within our multi-tenant product environment. You will need to prove your design skills abstracting business logic into reusable interfaces and then architecting efficient technical object models to implement your designs
  • Direct experience implementing J2EE technologies in an SOA environment. We generate our Web Services "bottom-up" so you'll need to understand and speak to that method and how you have used it in the past or would use it
  • Business process understanding and a willingness to learn are very important. The services you design will be consumed by Ready's front-end developers, our clients, and vendors we partner with so you need to understand their needs and how their systems fit into the overall business architecture
  • Solid knowledge of client database access, schema design, SQL, and Stored Procedures. Experience with any decent relational database will suffice. What we care about is your knowledge of normalized database design and your ability to abstract business logic from data persistence
  • Working knowledge of Linux environments, source code control systems, and release management. We use Linux for everything (even development, but Windows is okay) so to be an effective Designer you really need to understand how your systems will be deployed, how they will scale, how they will perform under load, etc. If you build your own Linux systems and install/configure Wildfly by yourself, you'll be in good shape and ahead of most
  • Documentation thoroughness is very important to us. Do you strive to complete documentation that allows handoff to support teams upon project completion? Are your design documents devoid of logic holes and all-inclusive of client requirements? Are your designs laid-out the same way each project and evolve to include more detail over time? Do you pride yourself on understanding your company's technology architecture and maintaining good stewardship of it? These are examples of traits we care about and will want to know if you have these too
  • Must be able to learn new systems quickly, take initiative to be productive, and be self-motivated. This is a respected role within the organization; you will be expected to manage yourself in large part. We rely upon self-forming teams and self-managed leaders within IT; micromanagement is not our style
  • For education we prefer a degree in Computer Science or Computer Engineering, but one is not required. We are results-oriented so high aptitude, time-tested skills, and proven successful implementations are all that really matter ... so bring your "A Game" and we'll find a spot for you
  • Apache Spark
  • Enterprise Integration Patterns
  • Telecom experience
150

Data Engineer, ETL Resume Examples & Samples

  • Design and implement new ETL pipelines based on client business logic
  • Optimize and scale existing ETL pipelines
  • Develop tools to support ETL platform
  • Perform ad-hoc queries to support client teams
  • Strong communication skills relating technical work to non-technical people
  • Bachelor’s degree or higher in a relevant technical field, or comparable work experience
  • Competence in Python and SQL
  • Working knowledge of Unix systems, such as Fedora, CentOS, Redhat, etc
  • Understanding of data quality Best Practices
  • Disrupt the norm: Cherish the opportunity to find better ways to do things, regardless of how disruptive or initially painful it might be
  • Dissent then execute: Raise issues and fixes in the planning stage, but when it’s time to execute, execute diligently and without reservation
  • Test and learn: When developing new processes or features, link it to a hypothesis, and evaluate that hypothesis without bias
  • Nothing is impossible: Imagine what’s possible and then have the discipline to execute it. One without the other is not valuable
  • Defect is treasure: Every mistake is an opportunity for the organization to learn and make improvements
  • Share success: Given how hard it is to promote change in our industry, celebrate each success along the way
151

ETL Consultant Resume Examples & Samples

  • BS or above, major in Computer Science, Electronic Engineering, Mathematics or Financial related
  • 2+ years working experience of large-scale IT companies or IT departments in the financial services industry
  • In depth knowledge of RDBMS Theory and SQL
  • In depth knowledge of the Teradata Database
  • Familiar with banking business
  • Familiar with mainstream data modeling tools, such as ERWin
  • Knowledge of the banking operational systems is a plus
  • Works independently
152

Microsoft ETL Consultant Resume Examples & Samples

  • Strong understanding of ETL fundamentals / data warehousing principals
  • Data migration experience / integration experience
  • Data mapping / data modelling experience
  • Experience with ETL tools such as MS SSISor (Informatica, Datastage, SAS DI, Ab Initio )
153

Solution Engineer, Ab Initio / ETL Resume Examples & Samples

  • 3-5 years of experience with Ab Initio ETL Platform (plans, graphs, psets, meta-programming capabilities, etc.)
  • 3-5 years of hands-on experience in administration and configuration of Ab Initio ETL and Unix using Admin Console and Metadata Manager
  • Strong experience with UNIX or Perl Scripting
  • Experience with Ab Initio Metadata Hub development/administration
  • Strong expertise with any database programming
  • Must be able to work in Orlando, FL office. Must be willing to live in or near the Orlando, FL office
  • B.S. or higher in Computer Science or other technical field
  • 5+ years of full time experience with ETL tools and processes, preferably in a healthcare payer or provider industry sectors
  • ETL development experience using any of the standard COTS products
  • Experience working with any of the enterprise scheduling tools
154

Consulting Analytics ETL Consultant Resume Examples & Samples

  • Data ETL, modelling and analysis
  • Segmentation
  • Descriptive and predictive modelling
  • Business analytics & dashboard development
  • Custom software solutions (Javascript, Python etc.)
  • Supporting client engagement work in a variety of industries, areas and specialisms
  • Assisting in the scoping and delivery of analytical projects
  • Leading the design and delivery of innovative solutions using latest open source and proprietary technologies to meet client needs
155

ETL & License Coordinator Resume Examples & Samples

  • Development, validation, and support of the ELT/ETL procedures with ODI
  • Implementation of data integration and data loading tasks
  • Manage user licensing for the DW/BI tools, Cognos and Impromptu Acquire, organize and process daily, and weekly vendor files
  • Liaison with external partners when files are not received or formats change
  • Monitor data warehouse load process and error reporting
  • Documentation of technical and system specifications documents for ETL processes
  • Strong conceptual knowledge of Data Warehouse architectures, including star- and snowflake- schema
  • Ability to successfully engage in multiple initiatives simultaneously
  • Some experience in the Oracle ODI toolset and Oracle PL/SQL is a plus
  • Some knowledge of ELT/ETL concepts, design and coding is a plus
  • Self-driven and willingness to learn on the job
  • 1 years of relevant experience with Data Base Environments
  • 1 years developing with an ETL tool
  • Some experience with SQL queries, stored procedures views
  • Experience in publishing, digital media is a plus
  • Some experience working with Json file format and APIs is a plus
  • Bachelor degree in Computer Science, M.I.S., Business, Math/Stats or related field
156

ETL Administrator Resume Examples & Samples

  • Day to day administration activities like user creation, folder creation, configuring DB connections etc. Capacity planning and on-going monitoring to proactively increase capacity as needed
  • Should independently troubleshoot and resolve any platform issues
  • Manage backup and security of the ETL platform
  • Experience with installation and upgrade of Informatica Power Center (Power Exchange) & CDC on Linux platform
  • ETL objects change management and promote to production
  • Support Production platform 24x7 in large global environment
  • Infrastructure resource governance, monitoring and reporting
  • Manage Extraction maps, Capture Registration maps and Data maps for CDC
  • Troubleshooting and root cause analysis of any platform issue and its resolution
  • Document System Administration best practices
  • To be an advocate to Development team with standards and features of Informatica
  • Work with Development and Solution team to assist with implementation & roll outs
  • Working with vendor support efficiently to resolve issues
  • Tool Administration
  • Meta Data
  • Code Deployment
  • Security/Access Management
  • Design/Implement monitoring for services
  • Hot fix and new version upgrades
  • Debug Application/Infrastructure issues
157

Senior ETL / Database Developer Resume Examples & Samples

  • Responsible for the design, development, maintenance and support of multiple distributed applications
  • Coordinating with Onshore/Offshore development and support teams
  • Function as ETL/Sybase developer
  • Undertake performance turning and troubleshooting
  • Database programming
  • Writing technical specifications & design documents
  • Testing software designs and solutions (including debugging and troubleshooting)
  • Preparing environment migration documentation and tickets
  • Bachelor degree in Computer Science or related field
  • 5+ years of experience in the application development lifecycle with 3+ years developing ETL/Database objects
  • Good working experience with any one of RDBMS (Sybase, DB2, SQL Server, Oracle) and ETL(Informatica)
  • Strong SQL skills including the ability to rewrite complex queries
  • Must be familiar with worklets, mapplets, mapping, sessions, workflows and different kinds of ETL transformations
  • Expected to have good understanding of database design, development process, understanding of business requirements, good communication and co-ordination skills
  • Scripting knowledge with Unix/Perl
  • Must possess good written and verbal communication skills
  • Experience with finance industry
  • High degree of motivation to expand technical and business knowledge
158

ETL Ab Initio Applications Developer Resume Examples & Samples

  • Willingness to take ownership of tasks and the ability to work on their own initiative while being a strong team player
  • Understand the technical environment and look to continually promote increased knowledge in the team
  • Excellent verbal and written communication skills, able to communicate accurately, concisely and with tact and diplomacy when appropriate
  • Strong analytical & problem-solving skills - excellent attention to detail
  • Be conscientious, reliable and inquisitive with a keen desire to learn, not just gain the knowledge necessary for the job but also the underlying reasons and drivers
  • The ability to work under pressure within agreed timelines and to support multiple tasks in parallel
  • Demonstrable experience in the software industry very often in similar investment banking working on unified Risk Management environments
  • Front-office/risk management business knowledge as well as knowledge of financial instrument features and trade processing would be an advantage
  • Financial Engineering knowledge and familiarity with risk and regulatory systems and the data flows
  • Financial products knowledge such as OTC Derivatives, Securities, Repos, Securitization would be an advantage
  • Initial Investigation & Solution Identification
  • Analyze, Design, Develop, Code, Test, Debug, Document
  • Programming to satisfy business requirements for small, medium, large projects
  • Participate/Conduct code reviews and make sure that quality solutions are built to prescribed designs and best practices/standards have been followed
  • Responsible for on-time project/L3 Releases delivery with high-quality code
  • System test planning and system test execution
  • Support QA phase by assigning, tracking, and updating defects to development team
  • Support QA phase to schedule fixes and resolutions
  • Provide L3 Level support
  • Research, evaluate, identify alternative solutions and make recommendations to improve design and development processes
  • Identify ways and solutions to increase efficiency of production support
  • Works with other team members: DBA's, ETL developers, Technical Architects, QA & Business Analysts, Project Managers
  • Ab Initio 5+ years
  • Unix 4+ years
  • Oracle/SQL 4+ years
  • Software development experience in Data Warehouse environment 5+ years
  • Data Warehouse concepts 5+ years
  • Full life-cycle experience in BO projects, preferably in the finance industry
  • Full Software Development Life Cycle experience
  • Project release management
  • Ability to drive & deliver solutions independently
  • Prepared to challenge when business requirements seem conflicting
  • Experience with job scheduling tools like Control-M
  • Experience with Agile/JIRA methodologies
  • Proficient in Shell scripting
  • Proficient in advanced Ab Initio concepts/tools (EME, PDL, Conduct-it)
159

Business Intelligence ETL Specialist Resume Examples & Samples

  • Work with technical teams and end-users from the business to ensure that the BI function delivers the required outcome with proper master data governance and tooling
  • Perform quality assurance functions as they relate to reporting and data validation
  • Research data anomalies and engage business and operational stakeholders to develop solutions
  • Give advice and training around data governance and data quality
160

IT Data / ETL Analyst Resume Examples & Samples

  • Gather and analyze data in support of business requests, proposed projects, and system requirements
  • Identify and analyze applicable source data (e.g. internal/external data feeds, systems, database, "sources of truth")
  • Identify, develop and document testing strategies and success factors
  • Analyze data gathered and design potential solutions for integration
  • Collaborate with business partners to ensure data standardization (e.g., enterprise standards)
  • Support, recommend and document testing strategies and success factors for testing
  • Contribute with reviews, analysis and creation of project estimates, timelines, dependencies and deliverables to ensure achievement of project goals
  • Support end user tool deployment, provisioning of data, and end users access setup and maintenance
  • Ensure compliance with enterprise Information Management standards and processes (e.g., data release governance, security, archiving, data quality, etc.) and provide feedback as appropriate
  • 1+ years of professional ETL experience and ETL tools
  • 1 + years of professional experience integrating data from large relational databases and data warehouses
  • 1+ years of professional experience writing advanced programming in SQL and Visual Studio (C#, ASP.NET)
  • Professional experience solving moderately complex problems and / or conducting moderately complex analysis
  • UnitedHealth Group or subsidiary work experience
  • Professional experience with SSIS
  • Understanding healthcare insurance industry (preferably clinical)
  • Some Quality Assurance and Testing experience
  • Knowledge of ACOs and population health management methods
  • Knowledge of STARS/HEDIS Quality Care Gaps
  • Knowledge of UHG claim data across (E&I, M&R and C&S)
  • Working knowledge of any of the following internal systems: ICUE, CareOne, V360, NDB, CDB, TOPS, COSMOS, CSP Facets, or Linx
161

ETL / Ssis Developer Resume Examples & Samples

  • Minimum 3 years of experience designing, developing, testing, and implementing ETL solutions using any enterprise ETL tools (SSIS)
  • 3+ years of experience working with high volume data bases and/or big data
  • Bachelor's degree in information systems or business management
162

ETL / DW Developer Technical Lead-dbpd Resume Examples & Samples

  • 5 years of experience working in a high volume Informatica Power Center, Metadata Manager environment and 10 years in ETL
  • 8 years’ experience with Oracle, SQL Server in Unix environment
  • 2 years ETL Team Lead experience
163

ETL Specialist Resume Examples & Samples

  • Develop SSIS projects to implement ETL including, transmission, encryption, and archiving of files received and generated
  • Design, develop, and maintain database tables, stored procedures, and supporting objects
  • Unit test to ensure the ETL code delivered is running and conforms to specifications and design guidelines
  • Document deployment procedures
  • Provide support to Business Analyst(s) in gathering and/or clarifying data and requirements from subject matter experts
  • Develop SQL queries and support ad hoc requests for data
  • 4+ years’ experience developing database ETL environments with business intelligence applications
  • 2+ years’ experience with Microsoft SSIS version 2005 or later
  • 2+ years’ experience writing stored T-SQL, procedures, functions, and SQL queries
  • Experience loading and extracting XML and or JSON data to/from databases
  • Experience developing reports using Microsoft SQL Server Reporting Services (SSRS) 2008 or later
  • Experience in Microsoft VB.net
  • Experience with Tableau development and or server administration
  • Experience implementing data warehouses
  • Excellent listening, interpersonal, written, and oral communication skills
  • Able to exercise independent judgment
  • Builds and maintains relationships with users to ensure adoption and buy-in of ETL solutions
164

ETL / Data Architect Resume Examples & Samples

  • Collaborate with business and technical leads to understand the key business and architectural requirements, and define the appropriate ETL solution and architecture to meet the customers technical and business needs
  • Architect, Design and Develop all ETL components including data acquisition, cleansing, standardization, validation, staging, database persistence, and job execution processes
  • Define technical specifications, conduct design and code reviews, and mentor ETL developers
  • Lead a team of ETL designers and developers, and perform hands on ETL development, deployment and implementation
  • Lead the overall structure of the ETL and Data Warehouse design including development of design standards and data persistence methodologies
  • 7+ years’ experience working on data integration and warehousing projects
  • 3+ years’ experience working in an ETL/data architect role with responsibility and ownership for Data Integration and Warehousing architectural design and implementation
  • 5+ years hands on experience developing ETL processes using IBM DataStage to feed an Operational Data Store and/or Data Warehouse
  • 3+ years working as an ETL development team lead, leading a team of 2 or more developers
  • Experience working as the development lead for a multi-shore development team
  • Hands-on experience with Unix/Linux and Perl scripting
  • Experience gathering and elaborating technical requirements, architecture, and designs
165

ETL Tech Lead Resume Examples & Samples

  • The person will be responsible for leading & supporting the team in technical build & implementation activities for Alerts & Notifications and work across releases for applications for different business functions across BUK
  • Manage day to day activities, setting work priorities, personal development plans, providing training and development opportunities of all direct reports
  • Work as an individual contributor to develop code and support the team on deliverables
  • Accountability for managing the task assignment and workload of SI partner teams. Needs to track their deliverables and monitor progress
  • Using direction provided by leadership and own understanding of project and PCB objectives, make decisions within the scope of a given project to ensure objectives are fully achieved and to realise opportunities / mitigate risks that may arise. Work to maximise the value of any given delivery
  • Participate in Post Release Reviews to ensure all lessons learnt on technical things are documented and incorporated in future releases/projects
  • Closely work with Project/Release managers & support them in all activities during the entire life cycle of the project
  • Identify key design/build issues and develop options and recommendations to resolve
  • All Barclays colleagues have to ensure that all activities and duties are carried out in full compliance with regulatory requirements, Enterprise Wide Risk Management Framework and internal Barclays Policies and Policy Standards
  • Hands on experience of analysis and development of AbInitio ETL (with Real time processing skills), Teradata and MI reporting solutions
  • Strong reporting and communication skills
  • Ability to build effective internal relationships
  • Ability to work with an existing body of code (maintenance, feature additions, debugging, etc.) and process Focused and make less dependent structures
  • Awareness of management information tools and systems
  • Governance and compliance policies, standards, and procedures required to fulfil role e.g. data security, records management,
  • IT and Business stakeholder management & governance, team building and team management experience
  • Ability to encourage and inspire team to help realise their potential, providing knowledge and guidance to all team members as required
  • Be hands-on with data analysis and deep-dive data mining; investigate databases on a regular basis with a certain degree of proficiency in SQL
  • SDLC: Environment management, QA process, Reviews and checklists, lineage, promotions, backup and recovery, data area management
  • High personal integrity, able to maintain confidentiality and proprietary company information
166

ETL / Integration Analyst Resume Examples & Samples

  • Define business user requirements on simple to moderately complex projects with some analytic design and data modeling
  • Under supervision devises or modifies procedures to solve problems related to applications issues, troubleshoot user support problems, and actively involved with application performance planning
  • Work with Technology Integration Specialists or Business Users to design and provide training
  • Under supervision perform business system design and data modeling tasks
  • Troubleshoots BI tool problems and tunes for performance
  • Develops multidimensional semantic layer and BI query objects for end users
  • Creates reports and report templates
  • Develops and manages BI training, documentation, and help desk capabilities
  • 3 or more years of relevant experience required
  • Knowledge and experience with object oriented programming languages preferred
  • Basic knowledge of information engineering concepts, including business area analysis, business system design, data modeling, and application construction
  • Experience with Business Intelligence and Data Warehousing
  • Experience with Extract, Transform and Load processes
  • Experience with Process Mapping
  • Experience with Object Oriented programming
  • Experience with relational database concepts
167

Senior ETL Specialist Resume Examples & Samples

  • Minimum 5 years of experience of ETL design, delivery and support with at least 2 full life cycle implementations
  • Experience with analytical reporting in SAP BW on HANA and SAP HANA solutions, design, delivery and support
  • Thorough understanding and ability to navigate and develop Shell scripting and CRON Job execution in a SUSE Linux environment
  • Demonstrated success delivering projects on time and on budget
  • Intermediate to advanced knowledge of BW/BI practices
  • Familiarity with Big Data Platform solution concept and migration of data into, within and out of Big Data Platform
  • Bachelor’s degree in an IT or related field, with 5+ years of experience with SAP BODS Data service solution delivery preferred; familiarity with BW/Business Objects preferred
  • Experience with performance tuning, real-time services, and BOBJ/BODS system administration, preferred
168

Manager, ETL & Encounter Resume Examples & Samples

  • 3 years of management or related experience in Information Systems, Technology or related environment, with lead/supervisory responsibilities directing staff through support and projects. Project management, system implementation, and system planning, all preferably in a healthcare-related environment
  • 5 years of experience working in healthcare setting
  • Documented experience collaborating with multiple stakeholders, including physicians, plans, vendors, payers (including governmental entities), and vendors
  • Strong analytical and logical problem solving skills
  • Strong interpersonal communication and relational skills, good organizational and project management skills; sound judgment; initiative; flexibility; detail-oriented
  • Good understanding of computer systems characteristics, features and integration capabilities
  • Solid grounding in core MemorialCare/Foundation enterprise systems/applications, including Epic, Health Catalyst, Cozeva, or related performance reporting application, MS SQL, Oracle, SAP, NextGen
  • Proven experience in systems, network, integration design and development
  • Working technical knowledge of current systems software, protocols, and standards
  • Proven project planning and leadership experience
169

IS ETL / Data Integration Developer Resume Examples & Samples

  • Required - 3 years SQL experience, data analysis and data profiling including three years of data extraction, transformation of data and loading data and one year of experience in data warehousing in an oracle environment
  • Must have computer skills and dexterity required for data entry and retrieval of information. Must be proficient with Windows-style applications and keyboard
  • Effective verbal and written communication skills and the ability to present information clearly and professionally to varying levels of individuals throughout the patient care process
170

ETL Data Analyst Resume Examples & Samples

  • To take ownership of a number of data objects through the ETL data migration process
  • Educated to degree standard or equivalent with a strong background in data analysis
  • Experience of large scale data migrations, preferably within an ERP environment. (not SQL server migrations)
  • Strong experience of SQL Server Management studio and specifically Transact SQL in writing stored procedures, user defined functions etc
  • Knowledge of SQL Server indexing and performance tuning
  • Any knowledge of SSIS\SSRS would be an advantage
  • Any knowledge of Microsoft AX data migration / import export framework (DMF)
  • Experience of working with various levels of business data owners, including the ability to communicate technical problems in business friendly language
  • Experience of running data mapping workshops
  • Experience of working on a European or Global data migration project
  • Has a clear eye for detail
  • Will not let a challenge drop until it has been resolved
  • Enjoys being part of a team and is fully engaged to contribute to the team to share knowledge
  • Potential for Global travel during the programme but the contractual office base will be London
  • Enjoys technology and sees this more as a hobby rather than just a job
171

ETL / Abinitio Developer Resume Examples & Samples

  • Analyze, Design, develop, code, test, debug and document as per the requirements of various projects
  • Open minded to take on different roles (other than the primary skill set) and work on other technologies as needed
  • Participate in functional and design reviews, identify efficiencies and provides alternatives
  • Participate in / Conduct code reviews and make sure that quality solutions are built to prescribed design and best practices/standards have been followed
  • Participate in Test Strategy definition and creation of test scenarios/cases for DEV (Unit Test) /SIT/UAT and execution of the same
  • Identify efficiencies and ways to improve design, development and testing processes through automation or other means
  • Troubleshoot systems production/performance issues under tight deadlines
  • Works with other team members, including DBA's, Other ETL developers, Technical Architects, QA, Business Analysts & Project Managers
  • 5+ years of experience in Data Management/ data warehouse
  • 5+ years of Application Development experience
  • A minimum of 4 years of data integration experience developing DI Applications using Abinitio. Experience with Talend is a huge plus
  • A minimum of 1-2 years’ experience using Control M is preferred
  • 1-2 years of Big data Hadoop experience
  • 3-4 years of hands on work experience in Oracle (SQL and Stored procedures)
  • 3 years’ experience with Unix background and shell scripting
  • Hortonworks and Cloudera knowledge is preferred
  • HIVE experience is a plus
  • Build data integration design and technical specifications, in alignment with DI technical architecture and framework, based on business functional and non-functional requirements
  • Demonstrates initiatives and self-starter
  • A pro-active approach to problem-solving, taking ownership of issues and following through to resolution
  • The ability to learn new technologies, software, and concepts quickly is essential
  • Can communicate clearly and excellently with a wide variety of people / functions
172

Senior ETL / Data Engineer Resume Examples & Samples

  • Design and development ETL mappings within data integration tools e.g. Informatica
  • Design structured, multi-source data mappings to deliver the dashboards and reports that make data actionable
  • Drive the collection of new data and the refinement of existing data sources to continually improve data quality and implement business logic using efficient transformations
  • Support data analysts and product managers by turning business requirements into functional specifications and then executing delivery
  • Lead the technical lifecycle of data presentation from data sourcing to transforming into user-facing metrics
  • Bachelors or Master’s Degree in Computer Science, Systems Analysis, or related field
  • 5+ years’ experience in dimensional data modeling, ETL development, and Data Warehousing
  • 4+ years’ experience with BI/DW/ETL projects using products like Informatica
  • Strong background in data relationships, modeling, transforming data for complex use cases and high volume data
  • Expert in SQL knowledge
  • Experience with Linux, UNIX, UNIX tools
  • Experience with Hadoop, Hive, Pig. Experience writing software to automate manual workflows
  • Knowledge of AWS product suite including S3, Redshift, Dynamo DB and RDS
  • Good instincts; you know what it means to be a subject matter expert and how to be a team player
  • Ability to work independently and problem solve with little to no direction. Impeccable customer service focus with a demonstrated desire to exceed expectations
  • Attention to detail; you prioritize multiple tasks simultaneously without sacrificing the ability to dive deep
173

ETL Senior Tech Lead Resume Examples & Samples

  • The person will be responsible for leading & supporting the team in technical build & implementation activities for all Ab Initio ETL and work across releases for applications for different business functions across BUK
  • The role will require work to be undertaken on multiple releases at a time, collaborating with Designers, PMs and developers as well as support and Infrastructure teams during and for the release of software components within the project scope, ensuring quality and timeliness of the delivery
  • Manage/ escalate risks and issues through to resolution. Implement solutions to prevent repetition of known issues/ risks and share knowledge of lessons learned
  • Work as an individual contributor when needed to design, develop and deliver solid Ab Initio ETL solutions
  • Work as a team lead to mentor and guide developers in AbInitio. Take accountability for reviewing code and assisting developers when they face technical challenges
  • Work closely with the Lead Designer on product designs and make contributions ton architectural issues where possible
  • Has an acknowledged area of expertise and understands how the team can deliver software more effectively
  • Using direction provided by leadership and own understanding of project and BUK objectives, make decisions within the scope of a given project to ensure objectives are fully achieved and to realise opportunities / mitigate risks that may arise. Work to maximise the value of any given delivery
  • Assist Project Manager in raising change records
  • Participate in Go / No-Go meetings and provide inputs from technical side
  • Provide knowledge sharing and mentoring to junior members of the team
  • End to end accountability for technical ETL delivery of assigned projects with high volume and quality outputs
  • Partner with the other IMCC functions for technical related topics, and imbibe them into the deliverables
  • Application of SQL and databases including data transformation
  • Exposure to Banking and Finance domains
  • Able to solve problems with data and to understand relevance to the wider objective
  • Hands on experience working on AbInitio ETL with Real Time processing details
  • Specific qualifications or certification in technology-based skill sets would be an advantage
  • Others: Unix, Teradata, Tivoli Scheduling, Change Management, Incident Management
  • Ability to work in high pressure, milestone driven project plan
  • Planning and estimating from requirements and change requests
  • Use the Barclays Training portal to accelerate and maintain skills level, particularly the development of professional change skill sets
174

ETL Ab Initio Data Analyst Resume Examples & Samples

  • Domain knowledge in Accounting, Finance, Risk Management and/or Regulatory Reporting in the Banking industry
  • Overall from 10+ years of data analyst experience
  • Past experience in IBM BDW implementations a strong plus
  • Passion to deliver results in a complex enterprise application / environment
175

Epic Clarity Etl Resume Examples & Samples

  • Advanced technically proficiency in Microsoft SQL Server
  • Advanced working knowledge of the analytical database operating system
  • Windows server administration experience or training
  • Ability to perform basic troubleshooting on your chosen platform (Microsoft SQL Server or Oracle), Windows Server, and IIS
176

SDE ETL & Ipaas Resume Examples & Samples

  • Partners with SPE or SDE – Data Sourcing & Profiling team to identify and understand mapping rules for various source data files
  • Map source system data to data warehouse models or master data attributes
  • Work with external partner resources to develop and test ETL processes and/or iPaaS solutions
  • Completed mapping and transformation programs for either ETL or data migrations
  • Processes and procedures for extracting and loading of data
  • Level 3 support of all processes and solutions within a domain
  • Deep knowledge of business process and related technology solutions within the specific area of sub-tower(ISC, Enabling Function, Growth)
  • Customizing of Data Stage or Cransoft tool and iPaas solutions to meet business requirements and mapping definitions
  • Deep experience in designing interface across SAP and Non-SAP (including 3rd Party data) using on premise and cloud environments for services like Managed File Transfer (MFT), Business Activity Monitoring (BAM), etc
  • Experience in implementing API Management, Electronic Data Interchange (EDI), and real-time business analytics and security solutions
  • Good understanding of Connectors and Cloud based platform integration process
  • Good understanding of SAP BW/BI
  • Strong focus in building cost effective innovations in solutions with emerging technology trends
  • Experience of agile approach and hands on technology trials
  • Experienced in converting business requirements into technical requirements
  • DIAL Methodology understanding
  • Ability to balance theory and reality
  • Informing
  • Manage high volume and high complexity projects across multiple delivery location in virtual environment
177

ETL Reports Developer Resume Examples & Samples

  • Minimum 5+ years of experience in developing BI/data analysis and visualization solutions with tools such as SSRS, JMP, Spotfire/Tableau etc
  • Experience with building custom reporting applications to solve business problems using technologies such as C#, ASP.NET, HTML, CSS etc
  • Experience in ETL development using known ETL tools like DataStage, Informatica, SnapLogic is a plus
  • Proficiency in writing and optimizing efficient ANSI standard SQL statements, creating views, stored procedures and user defined functions (UDF)
  • Prior good working knowledge on any one of RDBMS databases like SQL Server, Oracle and DB2
  • Proficiency in UNIX / Linux operating systems and bash shell scripts
  • Ability to understand relational database systems and its concepts
178

Senior Data Engineer / ETL / AWS Redshift Resume Examples & Samples

  • Minimum of 4years of experience in ETL development using known ETL tools like Snaplogic, DataStage, Informatica, etc
  • Minimum 2 years of experience writing Functions and Stored procedures in PostgreSQL
  • Prior good working knowledge on any one of RDBMS databases like PostgreSQL, SQL Server, Oracle and DB2
  • Exposure to MPP databases like AWS Redshift, Teradata, Netezza is a must. Specifically experience with AWS Redshift is highly desired
179

ETL / Ssis Developer Resume Examples & Samples

  • Lead or participate in new development requests, enhancements, and project initiatives aimed at providing data integration solutions per business requirements. Work closely with project teams to ensure that all Data Mart / Data Warehouse needs are met in accordance with the enterprise strategic direction
  • Design, maintain and support the interfaces that feed data warehouse systems. Provide ETL expertise and be the authority for the strategy, architecture, standards, dataflow processes, maintenance, support, and data quality procedures for the back-end components
  • Participate in the requirements analysis, definition, planning, development and implementation of ETL projects
  • Design, enhance and support the overall ETL / Data Staging processes and architecture
  • Develop and maintain testing standards and other data quality assurance procedures
  • Create, update and maintain data mart/warehouse documentation and standard procedures, including data flow diagrams that include source, transformation and target
  • Provide support for existing systems including performing maintenance and fixing production problems
  • Participate in the implementation of processes designed to reduce the number of production incidents and improve customer satisfaction
  • Bachelor's degree or equivalent work experience required; concentrations in Data Integration, Data Modeling and Data Warehousing
  • 7+ years of overall IT development experience with a minimum of 5 years direct experience in ETL design, development, testing, and application support in a multi-platform enterprise environment (Windows / Unix / Oracle.)
  • Minimum 5 years direct experience in Microsoft SSIS ETL development tools, including hands-on experience using the following version of SSIS: SQL Server 2014 Enterprise (12.0.x) / SQL Server Data Tools - Business Intelligence for Visual Studio 2013. Sagent Data Flow ETL experience a big plus
  • Solid working knowledge of relational databases, specifically Oracle 11g/10g/9i
  • Solid knowledge of SQL, Data Mapping, Database Structures, Processes and Scripts
  • Design and perform data integration work that is inherently complex and requires skills and knowledge of multiple data systems
  • Strong working knowledge of transactional and data warehouse systems, their interfaces and their impact on business
  • Knowledge of Stored Procedures and Unix Shell Scripting a plus
  • Java, SAP, PeopleSoft and Mainframe exposure a plus
  • Oracle PL/SQL experience is a plus
  • Exposure to Enterprise Application Integration concepts a plus (SOAP / REST WebServices, JMS/EMS, etc.)
180

ETL Software Engineer Resume Examples & Samples

  • Understand/apply reusable code design, leverage application architecture/framework capabilities and functionality, and design/develop solutions that are highly reliable, quality, scalable, and perform to meet business, functional and technical requirements and meet defined service levels
  • Deliver technical design and supporting documentation throughout the project lifecycle
  • Provide production support and triage issues in timely manner
  • Contribute on tech refresh projects
  • 5+ years of Software Development Experience in ETL and database technologies
  • 5+ years experience in Ab initio ETL tool and in EME
  • 5+ years experience in writing backend SQL queries, PL/SQL functions/procedures in Oracle database
  • 5+ years experience in writing Unix shell scripts
  • 5+ years experience in Job scheduling tool (Contorl M, Tivoli scheduler a big plus)
  • 5+ years experience in using source code control system (like SVN, EME)
  • 5+ years experience using Microsoft word/PowerPoint/Excel/Visio
  • Knowledge of SQL Server and Teradata database will be a big plus
  • TSYS Card processing platform knowledge
  • Experience with HTML, XML, Web Services / SOA
  • Ability to balance multiple time-critical tasks at the same time
181

SQL Unix DBA & Epic ETL Admin Resume Examples & Samples

  • Performs DBA activities associated with the design, deployment, use, control, monitoring, support and performance of Clarity database management systems to ensure their optimum use within the organization. Institutes administration policies, procedures, techniques and methodologies that enhance database support and provides optimum integrity, performance and availability
  • Ensure that proper backup strategies are in place and being followed, and verify restore media and documentation
  • Monitor database size and fragmentation levels, along with other maintenance tasks that are appropriate for optimizing performance
  • Monitor database server performance
  • Apply Microsoft SQL hotfixes and service packs when necessary
  • Routinely test any failover procedures for high availability
  • Verify and monitor the security of the database server
  • Verify that the Clarity ETL process is completed every day. Troubleshoot and resolve errors that occur during the ETL process
  • Install, configure, and maintain the Clarity database to ensure optimal performance and integrity
  • Work with Windows Administrator to ensure regular updates to the Clarity Console server are installed
  • Modify the ETL process in response to reporting needs, as necessary, performing tasks such as creating new tables or performing a Clarity Compass upgrade
  • Install, update, and troubleshoot the Clarity Console
  • Work with report writers to identify and resolve possible discrepancies between Cache and Clarity
  • Assists the A/D staff in client/server database design, development, load-testing and validation efforts. Recognizes and identifies areas where DBMS solutions will enhance application performance and user satisfaction. Suggests changes in programming techniques and methodologies to enhance database integrity, performance and availability. Translates application requirements into effective database structures, on-line queries, extracts and reports as needed. Coordinates special data archival needs. Works with applications staff to accommodate special application and database processing requirements
  • Assists in the administration of enterprise and/or departmental storage as needed. Incorporates storage management strategies into multi-platform, enterprise-wide solutions. Identifies areas where changes in strategy or day-to-day operation will enhance application availability and user satisfaction. Makes recommendations where appropriate
  • Is required to participate in a rotating on-call schedule supporting 24-hour, 7-day database operations
  • May assume duties of a higher level in preparation for increased responsibilities. Performs other related duties as assigned by the Director or the Manager
  • Incorporates Lahey Clinic Guiding Principles , Mission Statement and Goals into daily activities
  • Complies with all Lahey Clinic Policies
  • Complies with behavioral expectations of the department and Lahey Clinic
  • Maintains courteous and effective interactions with colleagues and patients
  • Participates in departmental and/or interdepartmental quality improvement activities
  • Participates in and successfully completes Mandatory Education
  • Performs all other duties as needed or directed to meet the needs of the department. Qualifications Education: High School Graduate
182

ETL Software Engineer Intern Resume Examples & Samples

  • The intern will analyze information and create presentations for internal and external use
  • Working with substantial independence, the intern will analyze and review financial, operational and business development-related data
  • Support a broad range of other assignments with responsibility for recommending and implementing change in methods and procedures in addition to advising management on appropriate next steps
  • Special projects as needed
  • Working towards Bachelors Degree
  • Strong qualitative and analytical skills and have ability to perform statistical calculations and evaluate results
  • Excellent communication and presentation skills, both oral and written
  • Strong planning and organization skills
  • Must be able to prioritize tasks and manage multiple projects in a fast paced environment with minimal supervision
  • Ability to work independently as well as in a team environment and communicate with all levels of management
183

ETL Specialist Resume Examples & Samples

  • 3+ years of Ab Initio experience (candidates with Informatica and/or DataStage only will not be considered)
  • 3+ years of ETL experience in implementation and design
  • Strong UNIX/LINUX scripting and debugging
  • Teradata and/or DB2
  • Control-M
  • Experience in logical data model development
  • 1-3 years of domain experience
  • Proficient designing technical solutions
  • Data mapping experience in implementation and design
  • COF Experience
  • Responsible for the design, development and administration of transactional and analytical data constructs/structures. Included within those responsibilities are the areas of data access and delivery technologies
  • Includes expertise in data mining, Extract Transform Load (ETL), design and documentation of data movement schemes, and mapping between applications
  • Provides clear concise communication to project team and managers. Leads solutions delivery single workstream.Search Jobs US
184

Senior Oracle Developer DWH / ETL Resume Examples & Samples

  • Design and development of core application modules
  • Participation in meetings with the customer
  • Maintaining project technical infrastructure (continuous integration, automated deployment)
  • Data modeling, logical and physical database design
  • Task decomposition and estimation
  • Peer review, mentoring
  • Bug fixing, test writing
  • Experience with Investment Banking
  • Experience with DWH
  • Experience with BI and ETL tools
  • Experience with Liquibase or similar tools
  • Experience in Java
185

Etl Team Lead Resume Examples & Samples

  • Master’s Degree or equivalent work experience in Computer Science, Information Systems, or other related field
  • Minimum of 8 years of DataStage experience in developing and deploying ETL solutions in complex processes
  • Has extensive experience with DataStage 7.x and in 9.x and in migrating code between versions
  • Experience and expertise Developing and maintaining efficient ETL Code, With Audit Balance and Control and Reject and Error handling processes
  • Experience developing ETL code to load data into relational databases and Dimensional databases and Conformed Dimension tables
  • Ability to lead a team of ETL Developers
  • Automotive Lending or Financial Services industry experience desire
  • Good communication skills are essential
  • Proven experience with SQL using SQL Developer
  • Strong analytical and good communications skills
  • Experience with IBM InfoSphere Information Server tool set
  • Ability to develop ETL guidelines, standards and methodology
  • Should be familiar with: Windows, Unix/Linux, PL/SQL, Shell Scripting
186

ETL Analyst Resume Examples & Samples

  • Works closely with data analyst’s and design teams in prioritizing data and information requirements using data from different data sources and maintaining the data warehouse or populating integration tables in other application systems
  • Collaborates with other IT teams in delivering robust, high quality and effective data transformation solutions using current ETL tools and any future acquired tools. The end resulting transformation data must be ensured to be accurate thru proper testing and validation processes
  • Determines how to provide the information required and translates requirements into ETL applications that employ appropriate tools. The developer will perform design, construction and unit testing of all backend components and works with data management staff to define an operational framework that will be used for development and implementation of application systems
  • Works with team to develop policies and security frameworks to ensure precise and accurate delivery of information
  • Provides expertise using multiple ETL products namely COGNOS DATA MANAGER, INFORMATICA, DATA STAGE, etc. and any other ETL and Modeling software
  • Conducts job responsibilities in accordance with the standards set out in the Company’s Code of Business Conduct and Ethics, its policies and procedures, the Corporate Compliance Agreement, applicable federal and state laws, and applicable professional standards
187

ETL Parametrisation Analyst Resume Examples & Samples

  • Analysis, design and redesign of ETL solutions to gain productivity efficiencies
  • Business process analysis to create most effective data flow models
  • Gathering business requirements from Custody and Fund Accounting ops teams,
  • Analysis and design of the systems connections,
188

ETL Analyst Resume Examples & Samples

  • Candidate will report to AT&T team lead but be assigned to be a member of a support team led by prime contractor in Vienna, VA
  • Handles and oversees day to day data cleansing and processing and analysis of data anomalies
  • Coordinates, maintain and executes data feeds from external sources (“alien feeds”). This includes, but is not limited to, the transfer and processing (ETL) of month-end data from HRC
  • Verifies and prepares updated data for model use within one business day of notification of availability
  • Must have expert level SQL and data analysis skills and understanding of relational database concepts to perform independent analysis of reported/suspected data issues
  • Shall have a Bachelor’s Degree from an accredited university in a related IT field such as computer science, computer programming, data base architecture, information systems, information technology, or software engineering; possess and maintain a SECRET security clearance
  • Have at least eight years of relevant experience (relevant experience includes data warehousing, database design and development, and database administration)
  • Have at least two years of experience implementing data stores on DoD servers subject to DoD security protocols
  • Have at least two years of experience performing database administration in the DB2 environment
  • Have at least two years of experience leading a database support team or project in database design, development, and maintenance
  • Excellent speaking and writing skills and must be capable of working in an integrated project team environment
  • Must have IAT II certification (minimum of Security+ and Microsoft OS Certification or Training). Must be US citizen and capable of obtaining SECRET clearance
189

Software Engineer, Data-etl Resume Examples & Samples

  • Define and implement ETL extract, Transform and Load for various data sources
  • Perform quality assurance of report content and reporting/analytic tool operations/functionality to eliminate errors, ensure accuracy
  • Strong scripting skills using Python or equivalent
  • Strong SQL skills both DML and DDL. Experience in coding and developing stored procedures
  • At least 3 years of experience in any relational database (PostgreSQL, SQL Server, Oracle etc.)
  • At least 3 years of experience in any ETL tool
  • Experience in Unix
  • Experience in Control-M is a plus
  • Excellent debugging and issues resolution skills related to all aspects of a database environment
  • Strong written and verbal communication; ability to explain technical concepts to non-technical audience
  • Embraces teamwork & possesses ability to effectively work cross functionally
  • Understands data warehousing concepts in order to translate the data via business intelligence into the proper tool
  • Experience with summarized data marts and architecture of data warehouses
  • Bachelor’s or Master’s Degree in related Information Technology or Information Science fields
190

ETL Analyst / Developer Resume Examples & Samples

  • Database SQL
  • Batch process experience
  • Experience using Unix/Linux operating system environment
  • Previous application data ETL (Extract Transform Load) experience
  • Experience working with relational databases such as Oracle database
  • Excellent communication, organizational, analytical and troubleshooting skills
  • Perl
  • Omnimark
  • Indexing experience
191

ETL Integration Analyst Resume Examples & Samples

  • Must have healthcare or clinical research background and knowledge
  • Extract Transform and Load (ETL) programming, and extensive experience using modern ETL tools and demonstrated ability to develop and validate complex database load and maintenance processes with Oracle Data Integrator, or a similar tools like Informatica Power Center, IBM Infosphere Data Stage
  • Extensive experience with SQL programming
  • Experience and understanding data modeling and data profiling tools
  • Experience working with Oracle databases or Oracle Health Analytics or Oracle Database Integrator
192

Software Engineer Etl-intern Resume Examples & Samples

  • Current undergrad in computer science (completed sophomore year studies)
  • Relevant coursework and interest in big data technologies, especially the Hadoop ecosystem and clustered columnar data stores, preparing the candidate to work on a 12 petabyte production Hadoop cluster
  • Proficient with Linux operating system, Java and Python languages
  • Must be able to work onsite in our New York City office at least 25+ hours each week for 10 weeks (June 12 - August 18)
193

Applications Developer ETL / SQL Resume Examples & Samples

  • Design, develop, implement and troubleshoot innovative and customer-centric data integration solutions for the OMC platform that need to result in scalable/maintainable applications
  • Provide detailed documentation on system design and implementation
  • Work with the Solution Architects, platform, data services and QA teams to release changes smoothly
194

Specialist Developer ETL / Pentaho Resume Examples & Samples

  • The Pentaho ETL developer will provide support in all aspects of data movement for a data warehouse environment,
  • Work closely with offshore team to deliver projects on time and in a high quality manner
  • Conduct system analysis and work estimate for new tasks
  • Preferred 3 to 7 years’ experience with ETL tools such as Pentaho, Informatica and Datastage
  • At least 2 years of experience with ETL tool Pentaho(Kettle)
  • Pentaho admin experience would be plus
  • Proficient in SQL and experience with Oracle PL/SQL will be plus
  • Ability to work efficiently with our offshore team
  • Strong communication and interpersonal skills, excellent team player
  • Superb ownership mindset, strong work ethics, a habit of excellence
  • 5 years of experience in software development required, experience in the securities or financial services industry is a plus
195

ETL Development Consultant Resume Examples & Samples

  • Capture ETL & Reporting and Analytic Requirements
  • Participate in the creation of semantic data models designed to meet reporting/analytic requirements
  • Design, develop and test BI solutions that make information available for our Business
  • Coordinate Development activities with other team members on-site, and off-shore
  • 5+ years of related Information Technology Management or Data Warehousing – experience with Teradata and/or Teradata Partner products a plus
  • 3+ years of experience using Informatica PowerCenter, (Cloud is a plus)
  • Experience as an ETL developer sourcing data from SFDC or Workday application environments a plus
  • Experience/Familiarity with Teradata RDBMS, Teradata SQL and Teradata utilities (BTEQ, MLOAD, TPT) desired
  • Experience with SAP BI tools (Business Objects Webi, Explorer, Dashboards, Lumira, etc.) or Microsoft Power BI a plus
  • Experience working with off-shore developers is a plus
  • Passion for working with data and providing analytic business solutions
  • Strong teaming skills
  • Strong MS Office skills required
  • Experience with the ERwin data modeling tool a plus
196

ETL Development Specialist Resume Examples & Samples

  • Responsible for designing, developing, automating, monitoring and maintaining ETL workflows
  • Develop and document technical requirements and solutions
  • Contribute code and fixes to existing data integration platform
  • Understands inter-application dependencies and evaluates their impact
  • Interact with cross-functional teams to ensure complete delivery of solutions
  • Troubleshoot issues making recommendations and delivering on those recommendations
  • Resposible for end-to-end testing of ETL processes ensuring reliability, accuracy and required performance levels
  • A minimum of a Bachelor's degree in the field of computer science/IT
  • A minimum of 3 years of experience working with data integration projects
  • Required Skills: C#, SQL
  • Proficiency with ETL tools (ie. Pentaho DI, DataStage, etc…) and techniques
  • Proficiency in scripting languages such as javascript, python or perl
  • Experience with Oracle or PostgreSQL is preferred but not mandatory
  • Candidates with experience in Telecoms OSS/BSS environments will be advantageous
197

ETL Data Specialist Resume Examples & Samples

  • Works with technical leads and architects to develop data integration and ETL solutions for the business in an agile, effective, and efficient manner
  • Leads, supports, and carry out ETL development
  • Carry out source to target data mappings
  • Delivers ETL development
  • Able to interpret data model which is part of the ETL and data integration framework
  • Carries out proof of concept and prototypes data integration solutions
  • Maintains a deep understanding and knowledge on Informatica products, and be the "go-to" person on the Informatica and ETL matters
  • Works with delivery teams to provide consultation, governance on data integration, and contributes to the delivery of projects
  • Supervise junior ETL developers and/or ETL contract resources
  • Transforms business needs and turns them into practical data integration services
  • Contribute to the development and publishing of ETL standards, principles, and policies
  • Work with other data specialists and architects in the development of enterprise data services
  • Provides leadership to ensure good data quality is intact and maintained when developing ETL solutions
  • Participates in the resolution of data quality and data integration issues
  • University degree in Information Technology, Computer Science, or equivalent education
  • Must have 7+ years of IT experience with at least 3 year in data integration and ETL development role
  • Must have extensive experience in data integration and ETL tools
  • Must have strong experience in Informatica products
  • Knowledge in common DBMS and reporting tools such as SQL, Teradata, MicroStrategy
  • Knowledge in data architecture, BI, and data quality are assets
  • Exposure in data modeling is an asset
  • Insurance business knowledge is an asset
  • Facilitation and workshop coordination experience
198

Data Engineer ETL / DW SDE Resume Examples & Samples

  • Design extract, load and transform (ELT) components and process flow using Python or Pig and Hive in single or multi node environment
  • Provide detailed analysis of problems and recommends solutions
  • Work with project managers and business analysts to recommend/develop system solutions to business problems, and translate business requirements into technical specifications and applications
  • Strong Experience in Enterprise Data Warehouse on AWS
  • Deep understanding of AWS components like EC2, S3 and EMR is required
  • Minimum 5+ years of experience working with UNIX environment, and experienced in shell and/or Perl programming
  • Strong understanding of Data warehousing methodology and ELT – ETL best practices
  • Previous experience with processing large amount of data is highly desired
  • Data model design using a columnar database such as Redshift is a plus
  • Experience with ETL /ELT data integration platforms as Pentaho, Talend, Informatica, Ab Initio is a plus
  • Experience in developing Data Warehouse applications using Python or Big data technologies (as Hadoop, Pig) is a plus
  • Familiar with DBMS table design, loading and tuning principles, and experience in SQL and stored procedures
199

Data Analyst With ETL Resume Examples & Samples

  • Bachelor’s Degree in Computer Science or applicable work/school experience
  • Talend experience, if not, then at least experience with Informatica or IBM Infosphere/Datastage, on a Linux environment, preferably with Postgres or Oracle/MySQL as the database
  • 5-8 years of experience participating in collaborative development environment
200

Ab Initio ETL Systems Analyst Resume Examples & Samples

  • Creates the high-level technical design for one or more complex projects and difficult maintenance efforts by analyzing and tracing designs to requirements (business and functional) and systems architecture
  • Responsible for creation of roadmaps, leading design reviews, and performing analysis for one or more applications
  • Identifies systems and technical constraints, potential technology risks, and document possible mitigation strategies for high complexity projects
  • Guide the design deliverables of Developers and other Systems Analysts
  • Consults with Business Analysts to write functional design for high complexity projects
  • Manages design reviews, application design impacts between concurrent releases, and technical walkthroughs
  • Understands the technical details, integration, and functions of multiple applications, hardware, and/or software within a team. Executes and enforces best practices. May be responsible to identify and design for non-functional requirements
  • Provides technical input and act as point-of-contact during architectural assessments for area applications
  • For high complexity projects, validate code to designs and requirements. Manages code walkthroughs, inspections, and review
  • Monitors the technical progress of the project
  • Assists with detailed project estimating and milestone planning. Reviews and validates accuracy of others’ estimates. Track the critical path across project teams and communicate the technical progress of the project
  • Recommends technology solutions to meet business requirements. Partner with Business Analysts and business clients to improve business requirements and business process flows
  • Internally communicates changes or issues with vended products
  • Evaluates Proof of Concepts (POCs) and validate that code delivers design intent
  • Plans, conducts, and reviews module and integration testing for high complexity projects. Analyze, validate, and consult on the content of functional test conditions for high complexity applications, projects, etc
  • Ensures technical issues are resolved
  • Evaluates root cause of issues and the resolutions
  • Manages the scope and change control process and provide direction for area of expertise. Manage and document issue resolution. Facilitate the change analysis for design, code, and other artifacts
  • Coordinates various technology organization groups around required operations, environment, and desktop documentation. Manages development of the documentation
  • Implements technical process improvements. Manages technical process and application process flows
  • Recommends technology solutions to meet business requirements. Maintains understanding of software industry and provide direction for future solutions
  • 10+ years of experience designing and building Ab Initio ETL solutions
  • 5+ years of experience with Unix, including Perl or other shell scripting languages
  • 5+ years of experience with Oracle SQL and PL/SQL
  • Experience working with globally distributed scrum teams
  • Experience with systems integration design and development
  • Experience with global delivery models
  • Requires strong time management skills
  • Ability to mentor junior teammates
  • Analytical, problem solving skills
  • Experience with Hadoop and/or Big Data a plus
  • Experience in the insurance industry a strong plus
  • Good decision making skills
  • Certified SAFe Agilist (SA) and/or other Agile/Scrum certifications a plus
201

ETL / Oracle Developer Resume Examples & Samples

  • Sound knowledge of the SDLC process
  • Strong data analysis and troubleshooting skills
  • 5+ years of strong database development experience
  • 5+ years of strong SQL and PL/SQL Knowledge
  • Developing Oracle stored procedures/packages
  • Creating tables/objects/indexes/triggers
  • Strong UNIX and Shell Scripting Knowledge
  • Informatica experience a plus but not mandatory
202

ETL Software Engineering Resume Examples & Samples

  • Strong knowledge of ETL tolls like Informatica, Data Stage, Pentaho etc
  • Must have excellent experience with Designing and developing ETL mappings and workflows for populating large scale data marts and/or data warehouses
  • UNIX shell scripting mandatory
  • Strong foundation in industry standard Data Warehousing design concepts
  • Good Hadoop and Spark experience for handling big data environment
203

ETL / Data Integration Consultant Resume Examples & Samples

  • Function as integrators between business needs and technology solutions, helping to create technology solutions to meet clients’ business needs
  • Understand the benefits of data warehousing, data architecture, data quality processes, data warehousing design and implementation, table structure, fact and dimension tables, logical and physical database design, data modeling, reporting process metadata, and ETL processes
  • 2+ years of hands on experience with Informatica PowerCenter and/or other tools such as Amazon Redshift, Ab Initio, SQL Server Integration Services (SSIS), SAP Data Services, SAS Data Management, Oracle Warehouse Builder and Oracle Data Integrator (ODI)
  • 1+ year experience leading workstreams or small teams
  • Willingness to travel 80 -100% of the time (Monday – Thursday/Friday)
204

ETL Software Engineer Resume Examples & Samples

  • 5+ years experience with IBM Datastage
  • 3+ years experience with a Oracle, preferably Teradata
  • 3+ years experience working in both Unix and Shell scripting
  • Experience with development, deployment, and support of large-scale OLTP and Data Warehousing applications in a mission-critical production environment
  • Strong technical experience in Design (Mapping specifications, HLD, LLD), Development (Coding, Unit testing) using Datastage
  • Exposure to other ETL tools such as Ab-Initio
  • Working knowledge of Hadoop is a plus
205

ETL Consultant Resume Examples & Samples

  • Integrate basic principles, theories, and concepts of their professional field with procedures and activities within the work area
  • Employ Consulting Services tools and methodologies with minimal direction
  • Understand professional behavior at a client site
  • Manage dependencies and risks with respect to work assignments
  • Perform work on time, within scope, and with high customer satisfaction
  • Provide status of work tasks
  • Understand the business Teradata is in and our market proposition
  • Accepts responsibility for planning and undertaking their professional development. Completes Teradata and external certification in field of expertise to enhance consulting performance
  • All Consultants are expected to build value in their practice through the contribution and reuse of consulting assets. At the conclusion of each assigned project, a consultant is expected to evaluate the project deliverables and to contribute those items that may be useful to other consultants that may be assigned similar projects. When a new project is assigned, the consultant will search the asset repository for assets that may improve or accelerate the project delivery
  • Bachelor Degree required
  • Internships or 0-1 years of related experience
  • Provides information openly and solicits input from others
  • Attends to the client communications and shares information from the client with others
  • Completes and submits all requested project communications on a timely basis
206

DNA HIL STA ETL Resume Examples & Samples

  • At least 8 years of experience in Project life cycle activities on DW/BI development and maintenance projects
  • At least 6 years of experience in technology consulting, enterprise and solutions architecture and architectural frameworks
  • At least 6 years of experience in Design and Architecture review
207

ETL Automation Engineer Resume Examples & Samples

  • Designing, Developing and Coding scripts for Automation testing
  • Developing and Maintenance of ETL graphs using Ab Initio tool for automating the data validations within different source data formats
  • Developing UNIX shell scripts for automating ETL jobs, execute bulk updates, automate file management, space management
  • Maintenance of ETL and Oracle/Sybase Distributed batches using Control M and UNIX
  • Supporting data management for teams across applications and executing ad-hoc batches
  • Managing and tracking work using management tools like JIRA & HP ALM
  • Work with multiple globally distributed teams to deliver solutions across regions
  • Understanding the business requirements and functional requirement to establish test plans and strategies
  • Understanding the Application, Database and ETL Designs to create best and feasible automation framework
  • Run batch job, perform data loads and manage data to be used by downstream applications
  • Manage enhancements and update of a large data mart
  • Design, develop automation scripts for functional and regression testing
  • Maintain and enhance existing automation scripts for the application
  • Maintain High-level understanding of application architecture from technology teams
  • Review requirements, user stories and technical designs for quality
  • End to End testing oversight and management of key issues with business and operations partners
  • Presentation of findings to stakeholders for review and approval and track them to closure
  • Experience working as a T shaped developer with strong test development skills
  • Hands on experience testing complex Web Applications integrated with backend Database DB2 utilizing Java, Spring, Hibernate, ETL tools Ab Initio
  • Experience with unit test and quality assurance test automation with such tools as Selenium and/or Cucumber, Ruby
  • Experience in Database testing with strong knowledge of database query tools and able to write and run complex queries in DB2 database for data validation
  • Have a good understanding of the Wealth management & financial industry concepts
  • Experience in Agile and Waterfall methodology and ability to work parallel
  • Experience in Business Analysis, Test Planning and Activity planning
  • Ability to effectively communicate plans to diverse groups of audience
  • Proactive and able to work in fast paced development environment
  • Excellent organizational skills, ability to multi-task and manage priorities
208

ETL Test Lead Resume Examples & Samples

  • Define approach to validating capabilities
  • Develop testing strategies and test plans, including functional testing, regression testing, negative testing, deployment testing , ETL job execution (Control-M)testing , and error handling testing
  • Work with business to understand the requirement
  • Work with operations team to coordinate the build of the testing environment for the initiative
  • Track Defects and report on testing progress and results
  • Demonstrate advance SQL, UNIX, Control-M and ETL skills
  • Demonstrated facility with the concepts of dimensionally modeled data warehouses & slowly changing dimensions, including the ability to write complex SQL queries against such a model
  • Deliverable
209

ETL Data Services Developer Resume Examples & Samples

  • Work closely with the Project Manager, Manager of Data Acquisition and the Finance team to ensure tasks are identified and appropriately estimated
  • Work closely with Data Architects, Sr. ETL Developers, Subject Matter Experts and Business Analysts in the Analytics team to ensure ETL jobs are designed appropriately to meet the requirements
  • Design and develop ETL processes and routines
  • Create and maintain ETL technical documentation
  • Design, develop and unit test ETL solutions based on business requirements and project deliverable timelines using the Analytics ETL framework, standards, and best practices
  • Work on any or all iterations for one or more subject areas within the data warehouse
  • Conduct and participate in code reviews
  • Develop and document technical design
  • Conduct performance analysis and optimization of Data Services jobs
  • Prepare, perform and document unit test and integration tests
  • Support BI Team during QA, UAT, and performance testing
  • Production support of ETL jobs
  • Bachelor's degree in data management, computer science, or related field preferred or equivalent combination of education and experience
  • 2 or more years of experience in SSIS development
  • Experience with SDLC processes
  • Experience working with all varieties of flat files
  • Ability to work well within a team and individually
  • Ability to respond quickly and adapt to change
  • Ability to be flexible and work under high pressure in a complex environment
  • Data Warehousing Standards, Strategies and Tools
  • Oracle 12c
  • SAP Information Steward
  • Financial Services Knowledge
  • Change Management Processes
210

ETL Tech Lead Resume Examples & Samples

  • Responsible for technical design, development & delivery of ETL technology (Ab Initio)
  • Coordinating delivery with the team and ensuring quality of delivery
  • Technical ownership of Code delivery and manage team / deliverables of 3rd party suppliers where applicable, for multiple technical projects
  • Effective liaison with Business project manager, Business analysts and other engineering teams
  • Technical Design, Develop and Implement Change Requests (CR)
  • Expertise in Ab Initio ETL technology
  • Expertise in Informatica ETL technology (preferred)
  • Expertise in Unix scripts, DB & TWS
  • Very Good communication and organizational skills
  • Very Good analytical skills
  • Experience in implementing DevOps (preferred)
  • Experience in using Jira and/or other agile development tools (preferred)
211

Analyst.it-etl Admin Resume Examples & Samples

  • Conduct ETL optimization, troubleshooting and debugging
  • Provide development support to ETL application development teams
  • Perform and assume other duties and responsibilities as required at direction of management
  • Record and maintain ETL software and operational procedures
  • Provide detailed analysis of problems and recommend solutions
  • Participate in continual improvements in order to decrease incidents and maintain quality
212

Database Developer ETL Resume Examples & Samples

  • Supports and designs department project assignments and small system implementation
  • Provides input to solution development efforts
  • Completes assignments as directed
  • Maintains schedules
  • Tracks information system resources for assigned projects
  • Reports on project time-lines and documents performance
  • Develops work products, documentation of operational and business objectives, best technology capabilities and task level resource requirements
  • Maintains project task plans, documentation and communications
  • Minimum of five (5) years experience in information technology dealing with applications development and support, or end user training, or equivalent experience in an operational or financial role utilizing the systems or data generated by the systems supported by this position
  • Knowledge of data warehouse and ETL(Extract, Translate and Load) development life cycle, including: requirement gathering, coding, and testing of projects
  • Skillsets used. Informatica Powercenter; SSIS(SQL Server Integration Services); SQL Server; Teradata
  • Experience with SQL Server ; SSIS packages, T-SQL stored procedures, views, triggers, SQL Scripts
  • Informatic highly preferred
  • Healthcare experience with EPIC
213

Information & ETL Analytics Technical Lead Resume Examples & Samples

  • BA/BS degree in computer science, information technology, engineering or related field
  • 8+ years of experience in architecting, designing, developing, supporting, and implementing BI solutions
  • Excellent understanding of developer and support processes including SDLC, project management, change management, and architecture process
  • Business intelligence/data warehousing technology skills with proven expertise in Microsoft BI stack (SQL Server, SSAS, SSRS, Power BI, and TFS)
  • In-depth knowledge of building complex multidimensional/tabular cubes and querying them using MDX/DAX (Microsoft SSAS)
  • Proven experience with SAP BW development and maintenance
  • Expert in multidimensional data modeling concepts and design
  • Experience in fine tuning the performance of SSAS cubes (tabular or multidimensional)
  • Expert in design, development, and support of SSRS reporting platform
  • Advanced experience with ETL/data integration methodologies and patterns (Microsoft SSIS)
  • Experience with Tableau reporting platform
  • Good knowledge of Oracle and SQL database technologies
  • Team player; ability to multi task
  • Strong communication skills and a strong self-starter attitude
  • Analytical thinker; strong problem solving ability
  • Ability to translate business requirements into technical specifications to design and deliver optimum solutions for business needs
  • Strong business analyst skills, able to work with many different stakeholders to elicit and document requirements
  • Strong estimation skills and strong track record of accurate estimations for BI solutions
  • Data gathering, research and analytical abilities so as to develop insightful conclusions and generate solutions to address user needs
  • Knowledge of ITIL is desired
  • IT Architecture Management experience
  • SAP - BW experience
  • Knowledge of Informatica and Dell Boomi ETL platform a plus
  • Proficiency in Google Analytics; Google Analytics Certification preferred
214

ETL Systems Analyst Resume Examples & Samples

  • Understand the Business requirements, project scope and translate it into technical specifications
  • Assess the impact to the current ETL pipelines based on the requirements
  • Document the technical specification/impact analysis using text and/or visual models
  • Create data flow diagrams, data mapping from Source to Stage and Stage to Target mapping documents indicating the transformations required and business rules to be applied
  • Create Test cases and Test scripts for system integration testing (SIT), User Acceptance Testing (UAT) and Unit Integration Testing
  • Validate ETL mappings and design and tune for better performance and reusability, with a view to optimize computing resources
  • Perform Data Analysis and Data validation by writing SQL queries
  • Be able to roll-up the sleeves, to interpret ETL code and troubleshoot ETL pipelines
  • Define data quality checks and profile data
  • Review code quality and make recommendations
  • Participate in the incidence management, problem management processes, root cause analysis, resolution and reporting
  • Write user stories and estimate the time required in tandem with the ETL engineers for ETL development work
215

Senior Analyst ETL Admin Resume Examples & Samples

  • Implement procedures to maintain, monitor, backup and recover operations for ETL environment
  • Report regularly on health and performance of ETL environment and jobs
  • Maintain ownership of release activities interacting with ETL projects
  • Establish projects, roles, users, privileges in different ETL environments (DEV, QA, PROD)
  • Perform administration of Informatica and DAC
  • Collaborate with Global team of ETL developers, support analysts and architects to implement ETL solutions
  • Perform independently with little direct supervision in administration of Informatica and DAC
  • Conduct troubleshooting for production issues related to Informatica and DAC administration
  • Create support ticket knowledge base and handle repetitive issues independently and work towards permeant fixes
  • Good understanding of OBIEE architecture is required
  • Must have experience in, configuring and maintaining Oracle Business Intelligence system and troubleshooting issues
  • Must have experience on Data Warehouse Administration Console (DAC) and OBIA
  • Desired to have experience in OBAW data model &performance tuning
  • Must have hands on experience on Informatica and Troubleshooting experience on Informatica 9 and above
  • Must have hands-on experience on SDLC
  • Must have working knowledge- on SQL/ PL-SQL
  • Must have knowledge of UNIX / LINUX, Shell scripting
  • Exhaustive experience of carrying out enhancements involving Informatica, DAC and OBIEE
  • Ability to solve problems independently, quickly, and completely, and to communicate clearly to management and peers
  • Ability to concisely organize and present written technical data
  • Good understanding of change management and ITIL will be an added advantage
  • Informatica certification is preferred
216

ETL Analyst Resume Examples & Samples

  • 834 format data mapping
  • Payroll deduction code mapping
  • Development and documentation of standard file formats
  • Developing process flows and documentation
  • Assist in developing a scalable data mapping and transmission strategy
  • File mapping using commercial ETL tools (ex. Pervasive, WebMethods, BizTalk, Sterling, etc.)
  • Providing test case input and assisting with production validations
  • Consulting with upstream and downstream customers on problem solving and best practices
  • Leading and participating on cross-functional project teams
  • Data trending and analysis
  • Some B2B client interaction
  • Interfacing with offshore teams
  • Creating dashboards for transmission and quality statistics
217

Epic Analytics Senior DBA / ETL Administrator Resume Examples & Samples

  • Minimum of five years working in an information technology role of which a minimum of three years experience as a database administrator including two years on a Microsoft SQL Server platform required
  • SQL stored procedure writing required
  • Prior experience within a data and/or analytics department at a large scale health system or health information technology company preferred
  • Experience with leading healthcare information systems (e.g. Epic, Cerner,McKesson, GE, Lawson, Kronos, StrataJazz) preferred
  • Bachelor's degree in Computer Science, CIS, MIS, Engineering or related field preferred
  • Epic certification in Clarity Administration and Caboodle Administration is preferred
  • Certification as a Microsoft Certified Solutions Associate for SQL Server preferred
  • Working knowledge of Microsoft SSIS preferred
  • Working knowledge of Microsoft SSAS cubes preferred, to include setup and
  • Data modeling experience and familiarly with those design tools, such as Erwin or Embarcadero preferred
  • Familiarity with Epic Clarity, Epic Caboodle, and Epic Slicer Dicer preferred, especially to
  • Working knowledge of Team Foundation Server preferred
218

ETL Development Manager Resume Examples & Samples

  • Demonstrates expertise in a variety of the field’s concepts, practices, and procedures related to ETL/Data design and development
  • Create and maintain relationships with senior level stakeholders, ensuring understanding of key business drivers and needs
  • Develop and recommend strategies and specifications for (technical) data solutions based on the analysis of the business goals, objectives, needs, and existing data systems infrastructure
  • Develop technical strategies and architectures for high-performance, scalable and complex enterprise-grade solutions
  • Manage delivery of high exposure, high impact deliverables
  • Lead a team of technical resources including developers, database administrators, system administrators and architects
  • 15+ years of development management experience
  • 10+ years’ experience working in a large data warehouse environment
  • 5+ years of Global Markets experience (Understanding of business operations and transactions)
  • 5+ years’ experience interfacing with C level employees
  • Ability to negotiate and influence
219

ETL / Ssis Data Integration Developer Resume Examples & Samples

  • Work with various customers, prospects and stakeholders, understands and translates business use cases and/or requirements into data models, data integration routines and analytics reports
  • Identifies data sources, develop and maintain data architectures, constructs data catalog and data decomposition diagrams, provide data flow diagrams and documents the process
  • Develop, manage and maintain data models, including physical and logical models of the data warehouse, data marts, development and staging areas and source systems as necessary to meet new and changing business requirements
  • Hands on ETL development in tools such as SSIS and/or Informatica
  • Strong sense of accountability, adaptability, flexibility and a sense of urgency
  • Ability to work effectively with associates at all levels within the organization
  • Demonstrated ability to establish priorities, organize and plan work to satisfy established timeframes
  • Passionate about continuously improving organizational practices. Ability to learn and apply new technologies quickly and self-directed
  • The job level for this position will depend on the candidate’s experience and skill set
220

Lead Developer, ETL Resume Examples & Samples

  • Work with various business stakeholders to identify their information needs
  • Work with Data Architecture team to understand the source and target data models
  • Work closely with cross-functional business and business intelligence teams to document ETL requirements and turn them into ETL jobs
  • Develop, adhere to, and be a proponent for Data Warehouse development standards, including ETL standards and best practices
  • Provide documentation for all developed ETL processes, including process flow and source and target mapping
  • Conduct ETL performance tuning and troubleshooting
  • Work with Business Intelligence Operations team to ensure control objectives are implemented for all data movement processes, implement change control for production data, establish and follow proper incident management procedures
  • Ensure compliance with all applicable data privacy regulations and policies as they relate to both firm and client/contact data
  • Bachelor's Degree or higher and/or equivalent combination of education and experience preferred
  • Minimum of 7 years of experience in ETL/ELT development in Business Intelligence/Data Integration projects
  • Minimum of 7 years of data analysis and data quality
  • 7+ years of experience working with Informatica, GoldenGate, etc
  • 7+ years of experience working with Relational Databases like Teradata, Vertica, Oracle, SQL Server, etc
  • 5+ years of experience working with Unix Shell Scripts
  • Experience in writing complex SQLs to analyze and troubleshoot the issues/problems
  • Knowledge of MS-Office Suite (Word, Excel, Powerpoint)
  • Must have legal right to work in the U.S
  • Excellent communication and motivation skills, and ability to interact appropriately with senior level colleagues and business users
  • Experience in integrating technologies with internal and external data sources
  • Goal oriented and creative personality with good interpersonal skills
  • Ability to manage multiple assignments simultaneously and follow up on unfinished business
  • Ability to pay attention to the details and be organized
  • Commitment to internal client and customer service principles
  • Excellent time management skills, with the ability to prioritize and multi-task in a fast-paced environment
  • Experience with data analysis, data architecture, data cleansing and data quality
  • Experience with data integration tools like Informatica, Data Stage
  • Experience with databases technologies like Oracle, Teradata and Vertica
221

Ab Initio ETL Systems Analyst Resume Examples & Samples

  • 4-5 years of experience designing and building Ab Initio ETL solutions
  • 3 years of experience with Unix, including Perl or other shell scripting languages
  • 3 years of experience with Oracle SQL and PL/SQL
222

Senior ETL / Oracle Developer Resume Examples & Samples

  • At least 3 years experience in a data warehousing or another "big data" environment
  • RDBMS experience (SQL Server / Oracle) in both UNIX and Windows server environments. Previous experience using visual ETL tools (PowerCenter) or crating DB procedural ETL processes
  • Good understanding of Agile practices, including test driven development and refactoring
  • Experience of the full project lifecycle
  • Experience of Unit Testing and Mocking
  • UNIX scripting would be an advantage
  • Can work collaboratively or independently to deliver within project timelines
  • Can adapt and reapply lessons learned from previous tasks
  • Being proactive and take ownership of tasks and is proud of their work
  • Motivated and enthusiastic team player who's willing to teach as well as learn
  • Committed to excelling in their job and enjoys delivering accurate and efficient work products
  • Someone that shows initiative and resourcefulness and can deliver on time
  • Bachelor/Master degree preferred
  • Good English (written and spoken)
223

ETL Consultant Resume Examples & Samples

  • Understand the sales business model and be able to turn requests from internal customers into reports / solutions that meet their needs
  • Participate in the design and architecture of the data model
  • Liaise with other members of the team to coordinate the development of new projects
  • Investigate new approaches to provide technical solutions to the problems faced by the business
  • Draft and maintain technical documentation, contribute to the creation of manuals and documentation for the users
  • Provide technical support to internal customers (sales directors and managers, business analysts, sales reps) on existing and new tools/systems. Resolve bugs and issues
  • Keep pace with the development of Oracle Products. Assess their relevance to group operations. Propose upgrades. Investigate alternative tools and solutions
224

ETL Software Engineer Resume Examples & Samples

  • Minimum 2+ years of Application Development work experience
  • Minimum of 2 years of work experience in Data Warehousing environment, experience in handling large volume of data
  • Minimum 2 years of experience with ETL Tool
  • Ab-Initio experience is a plus
  • Knowledge of big data technologies like Hadoop/HDFS/Hive/Hbase/Impala & ETL tool integration experience with Hadoop file system is a plus
225

ETL Consultant Resume Examples & Samples

  • Design, develop, and test processes for extracting data from legacy systems, production databases, Aster Data, and Hadoop platforms
  • Design, develop, and test processes for validating and conditioning data prior to loading it into a data warehouse, Aster Data, or Hadoop platform
  • Design, develop, and test processes for loading initial and cyclical data into a data warehouse, Aster Data, or Hadoop platform
  • In depth knowledge of the Teradata Database, Aster Data Database, and / or Hadoop platform
226

ETL Tech Lead Resume Examples & Samples

  • Understanding the overall purpose of the project and contribute in design, development, testing and maintenance of ETL components and integration with Hadoop systems
  • Managing delivery of the team and ensuring quality of delivery
  • Effective liaison with Data ware house, testing team and infrastructure
  • Design, Develop and Implement Change Requests (CR) from Business
  • Provision of out of office hours support to ensure smooth delivery of project as per timelines
  • Support live implementation, Provide warranty support, Service transition, BAU support
  • Work with SME, Data stewards for data discovery and identify anomalies in existing platform as an improvement area in new environment
227

ETL / Data Engineer Resume Examples & Samples

  • Problem determination and resolution
  • Supporting and troubleshooting batch processing and interactive user reports to ensure the high availability of Digital Insight's Data Platform and Reporting Services
  • Effectively interact on bridges and production support calls to ensure all global team members are constantly informed
  • Previous exposure to major databases, data warehouses, ETL technologies and database-specific procedural languages such as PL/SQL
  • Expertise in Informatica Powercenter 9.1 & 9.6, LINUX/UNIX shell, Perl, Oracle and PL/SQL development
  • Data Modelling & Data Governance experience within an Enterprise setting
  • Secure File Transfer
  • HQL
  • Yarn
  • SaaS deployment and maintenance
  • Big Data in the Cloud
228

Fp-b ETL Data Stage Developer Resume Examples & Samples

  • Consult with System Analysts, Technical Leads, and Project Managers to establish specifications and estimates on projects of various sizes and efforts
  • Write detailed descriptions of user needs, system design, program functions, and steps required to modify computer systems and ensure compliance
  • Design, Develop, code, test, and debug application programs based on requirements
  • Analyze and recommend changes to improve efficiency, lower costs, and enhance quality of business applications
  • Work with System Analysts, Technical Leads, and Business Users to develop and implement acceptance test plan to ensure product meets customer requirements and expectations
  • Review code quality and drive automation process routines
  • Other duties as assign
  • Bachelor’s degree in Computer Science or related area of study, or equivalent combination or education and/or relevant work experience
  • 5 plus year’s experience supporting key enterprise business applications and servers
  • Ability to handle both design and coding responsibilities along with working under the guidance of a Lead Systems Developer
  • Strong problem-solving and analysis skills
  • Capable and willing to receive work direction from direct and indirect leadership
  • Strong desire to learn
  • 3+ years ETL Development experience using various technologies including IBM Info Sphere Data Stage and Unix
  • 2+ years experience working with IBM’s DB2 DBMS, SQL, Oracle DBMS
  • 2+ years experience in writing Shell Scripts
  • Working Knowledge on Scheduling tools(Robot, Autosys, TWS)
  • Thorough understanding of database concepts, data models, and the overall data flow architecture in data warehouse environments
  • Working knowledge of IBM Info Analyzer, Info Sphere and Fast Track Tool
  • Data Analysis experience including Data Profiling
  • Strong problem-solving, analytical and business analysis skills
  • Familiarity with MS Office product suite including MS-Project
  • Knowledge of IBM ISeries
  • Background in pharmaceutical and/or healthcare industry a plus
229

ETL Development Specialist Resume Examples & Samples

  • Investigation - Investigates issues by reviewing/debugging code and providing fixes (analyzes and fixes bugs) and workarounds, reviews changes for operability to maintain existing software solutions. Highlights risks and helps mitigate risks from technical aspects
  • Analysis - Analyzes requirement documents/HLDs. Performs impact assessment (for example, for critical production issues) and contributes to Root Cause Analysis of issues and outlines corrective actions. Performs scoping work
  • Team Work and Collaboration - Collaborates and adds value through participation in peer code reviews, provides comments and suggestions, and works with cross-functional teams to achieve goals. Serves as the technical focal point with other teams to resolve issues related to interfacing functionalities
  • Technical Ownership - Assumes ownership and accountability of specific modules within an application and provides technical support and guidance during solution design for new requirements, problem resolution for critical / complex issues. Ensures that documentation related to specific modules / applications is correct and up to date. Performs peer code inspection and reviews developed solutions and provide relevant feedback
  • Innovation & Continuous Improvement - Brings continuous improvements/efficiencies to the software or business processes by utilizing software engineering tools and various innovative techniques, and reusing existing solutions. By means of automation, reduces design complexity, reduces time to response, and simplifies the client/end-user experience
  • Quality and SLAs - Contributes to meet various SLAs and KPIs as applicable for account and unit - for example, Responsiveness, Resolution, Software Quality SLAs. Ensures assigned tasks are completed on time and delivery timelines are met as per quality targets of the organization
  • Onboarding & Knowledge Sharing - Onboards new hires and trains them on processes, shares knowledge with team members, and takes an active role in technical mentoring within the team and elevating the knowledge of the team
  • Communications - Represents/leads discussions related to product/application/modules/team (for example, leads technical design reviews). Builds relationships with internal customers/stakeholders
230

ETL Consultant Resume Examples & Samples

  • Integrates established disciplinary knowledge, within personal specialty area, with basic understanding of related disciplines and industry practices
  • Employs Consulting Services tools and processes without direction; Designs and implements available products and solutions with minimal direction
  • Understands the business Teradata is in and our market proposition
  • Analyzes and understands the client’s business at a functional or technical level. Builds relationships with client IT
  • Understands and reinforces account plan initiatives within scope of assignment
  • Applies professional judgment based on the analysis of relevant input
  • Manages and escalates dependencies and risks with respect to work assignment
  • Identifies scope changes
  • Performs work on-time, within scope, and with high customer satisfaction
  • Provides status of work tasks
  • Recommends practice improvements based on lessons learned
  • Accepts responsibility for planning and undertaking personal professional development; Pursues Teradata and external certification in field of expertise
  • 1-2 years of related experience
  • Communicates project status and issues effectively
  • Communicates well at all levels, with Teradata and client personnel, internal and external to the project team
  • Shares information appropriately and protects confidentiality
  • Recognizes when a personal deadline may be missed and communicates this information early
  • Understands the interdependencies of project work