sample resume for talend developer

Resume Builder

• Resume Experts
• Search Jobs
• Search for Talent
• Employer Branding
• Outplacement
• Resume Samples
• Software Architect

ETL Developer Resume Samples

The guide to resume tailoring.

Guide the recruiter to the conclusion that you are the best candidate for the etl developer 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.

Create a Resume in Minutes with Professional Resume Templates

• Works within IT team to follow the full lifecycle development process working with development and technical operations
• Support other ETL developers; providing mentoring, technical assistance, troubleshooting and alternative development solutions
• Manage, mentor and develop onshore development resources and provide project related directions to offshore team
• Assist Service Manager and Service Director in providing management status reports on daily, weekly and monthly basis
• Assist business and technology stakeholders in establishing data management framework with necessary data quality controls and governance
• Communicate effectively with the other external IT development teams and the local development manager
• Work with other team members in establishing and sharing design and development techniques of the ETL process
• Provide process improvement analysis using process modeling and simulation techniques to understand the impact of process changes
• Provide operational analytics to support better management of MIS
• Attend technology design meetings and recommend security and data improvements – and will be empowered to work on those prioritized changes
• Develop scripts to automate the execution of ETL using shell scripts under Unix environment
• Providing routine process/operational control reports and/or Controls Dashboard support
• Help develop test cases and plans to complete the unit testing and support System testing
• Assist in software and hardware setup
• Lead overall data management solutions and design, change the status quo and create world class information management solutions
• Provides updates to the management and the business to keep them informed of any system issues
• Provides input to development project plans
• Manage the successful delivery of development projects across the full application lifecycle
• Mentor junior developers on the best practices for developing ETL jobs utilizing Informatica
• Ensure all metrics data is collected for all critical processes during the Design and the Development Phases of the SDLC lifecycle
• Provide governance to the review processes and effectively communicate out project status
• Strong Oracle PL/SQL knowledge and ability to code complex queries against a marketing database
• Excellent writing skills, oral communication skills, strong process skills, and leadership ability
• Detail-oriented drive to investigate and dissect information with a strong focus on quality
• Commitment to quality highlighted by strong auditing capability
• Solid knowledge of the UNIX/Linux environment
• Demonstrated ability to translate functional/high level design in detailed technical design
• Strong technical aptitude and ability to logically analyze and creatively solve complex issues independently
• Strong interpersonal skills and ability to work effectively with all levels throughout the enterprise
• Basic knowledge of Business Objects reporting tools like Web Intelligence, Lumira etc
• Extensive experience in data analysis and/or reporting along with strong knowledge of database and related technologies (SQL, OLAP, etc.)

15 ETL Developer resume templates

Read our complete resume writing guides

How to tailor your resume, how to make a resume, how to mention achievements, work experience in resume, 50+ skills to put on a resume, how and why put hobbies, top 22 fonts for your resume, 50 best resume tips, 200+ action words to use, internship resume, killer resume summary, write a resume objective, what to put on a resume, how long should a resume be, the best resume format, how to list education, cv vs. resume: the difference, include contact information, resume format pdf vs word, how to write a student resume, etl developer lead-hrt resume examples & samples.

• Work closely with the business leads to understand and finalize the requirements
• Participate in the continuous improvement of the application, develop best practices
• 10 to 15 years of industry experience in information technology. Data-warehousing experience is a strong plus
• 5 to 7 years of Oracle experience with strong fundamentals in performance and tuning, efficient SQL writing, stored procedures/PLSQL coding etc
• 5 to 7 years of experience with Informatica or any other ETL tool is a must
• Working knowledge of Unix/Linux
• Ability to interact with all levels of management

ETL Developer Resume Examples & Samples

• Analyze requirements and develop ETL/BI reports with minimal supervision
• Design and develop BI programs with consideration to data quality, data integrity and performance
• Design and develop database objects with consideration to best practices and reporting needs
• Conduct unit testing and participate in integration and system testing as required
• Perform general system maintenance and support as necessary
• Minimum 5 years experience developing ETL solutions for data warehouse environments
• Minimum 3 years experience using Informatica PowerCenter 8.6 or higher
• Experience using Informatica to interface with Salesforce is highly desirable
• Experience in optimizing/tuning ETL objects, indexing and partitioning for better performance and efficiency
• Knowledge of industry best practices for ETL and the common approaches to data warehouse architectures
• Minimum 1 year experience in design and development of Business Intelligence solutions, using Business Objects or Cognos
• Strong experience of data warehouse solutions using implementations of star and snowflake schemas
• Strong database experience working with various RDBMS platforms; knowledge of Oracle 10g/11 and Sybase 12x
• Strong experience in writing ANSI SQL code, as well as the ability to design and implement functional, stress and regression tests to assure correct operation of application
• Knowledge of Unix and shell scripting skills are a plus
• Good understanding of the software project lifecycle
• College degree, or specialized training
• Asset Management and/or Financial Services experience desirable
• Understanding of software development methods, including Agile

Junior ETL Developer Resume Examples & Samples

• Application Development of related projects/enhancements/bug fixes for the accounting platform, including interfacing with Operations and other business users
• Troubleshooting business issues, solving problems to provide solutions to diverse teams and the product aligned support areas
• Work with other Back Office Technology teams to make appropriate changes that will enhance the stability of the overall environment
• Ownership and participation in the Incident and problem management processes, being accountable for resolution, root cause analysis and technology and business reporting and communication
• Relationship management internally with the back office, trade support, and at times front office teams
• Navigate the wider technology organization; build relationships to help manage the team’s agenda with our critical technology partners
• Interface with external vendors and their technical support and development organizations ensuring focus to resolution of issues and strategic enhancements
• Proactively identify improvements and address them through independent thinking within a consensus driven team
• 2+ years experience in financial services with a focus in Securities Processing
• Understanding of the agile development methodology

Senior Data & ETL Developer Resume Examples & Samples

• Work in a globally distributed team that will deliver Business driven projects and IT solutions for Data & ETL requirements for Insights and non-Insights spaces
• Understand the requirements, design and implement data sourcing solutions by doing data modeling and implementing ETL using technologies like TeraData, Informatica and TWS
• Provide support to the different Insights and non-Insights dev teams for their data needs
• Productionize the ETL changes by going through the review and approval processes by interfacing with different teams like engineering, operations and DBAs
• Stay up to date on the evolving data architecture of the Insights applications
• Provide support to the Business in adhoc query space
• Interface with the business team and business analysts, support QA & UAT Testing, deployment, and Level 3 support for Data & ETL
• A minimum of 10 years of experience in IT, 5 years in Retail Brokerage IT
• Excellent knowledge of and experience with data warehousing/data marts concepts and practices viz. TeraData and Informatica is a must
• Demonstrated expertise with the some of the following tools/languages/disciplines: data modeling, data profiling, relational database SQL (e.g. SQL Server, Sybase)
• Experience in BigData technologies like Hadoop, HBase, Hive, HDFS
• Knowledge of retail broker dealer business; back-office operations and trade processing; familiarity with a wide range of financial instruments; such as stocks, options, mutual funds, fixed income
• Prior experience in data quality and data stewardship functions is a plus
• Bachelors/Masters Degree in Engineering, preferably Computer Science/Engineering, from a top tier University
• Background in Financial Services required
• Excellent communication skills in English language are essential, both written and oral
• Good interpersonal skills with the ability to facilitate or contribute thought leadership are required
• Partner with the infrastructure and architecture team to enforce best practices for all aspects of systems development including requirements, design, build and testing/validation
• Manage the relationship with internal and external services vendors to ensure superior service delivery for all application core technologies
• 5 years of professional experience as an ETL developer in an Enterprise Data Warehousing environment; hands on experience with Informatica and Teradata
• Experience with issue resolution processes for application production problems
• College degree or specialized training / equivalent work experience

Ab-initio ETL Developer Resume Examples & Samples

• 3-5 years in Ab-Initio development roles with experience on large & complex projects
• Data warehousing experience is required
• Appreciation of IBM Business Data Warehouse models is a plus but not a prerequisite for this position
• The candidate should be proficient with Oracle PL/SQL, Autosys and shell scripting
• Non-technical knowledge, experience, and skills (leadership, management, oral and written communication)
• Development and implementation of technology solutions
• Adding clarity to business requirements; translate functional requirements into technical requirements; check the technical feasibility of all business and functional requirements
• Work with external and internal suppliers to flesh out and develop technical solution
• Take responsibility for ensuring that build and code adhere to architectural and quality standards and policies
• Experience in ETL development (experience in Informatica or Ab Initio would be an advantage)
• Basic knowledge of Linux
• Basic knowledge of databases and SQL (Teradata would be an advantage)
• Prior knowledge of AML (Anti-Money Laundering) is an added advantage
• Strong client facing skills with a proven track record of building relationships with business and technology stakeholders at all levels
• Strong data warehousing and OLTP system knowledge from database/ETL development perspective
• Strong Oracle database knowledge including database design, development (package, procedure, functions, indexes)
• Datastage 8.1 knowledge required
• Ability to develop technical design using Visio and interpret and relate the business requirements to technical components
• Experience with 1 or more mainstream ETL tools (Talend 5.x, DataStage, Informatica) (3-5 years)
• SQL Server 2005 or greater (3-5 years)
• Experience with multiple relational database environments (SQL Server, Oracle, DB2, Informaix, etc)
• Experience working with various file types (ASCII, XML, EBCDIC)
• Experience with data mapping analysis and design
• Experience building roadmaps
• Source code tools such as TFS and Subversion
• Experience with operational data stores and data governance routines (PCI, NPI, Data Quality controls, etc)
• Ability to work effectively with minimal supervision
• Ability to multi task and adapt to change
• Ability to communicate with Line of Business clients
• Ability to analyze requirements documents for impacts
• Experience with Waterfall and/or Agile project management processes
• Java 7, JQuery, WebSphere 8.5.x, Spring Batch, Autosys, Drools, J2EE
• Experience with Financial data or Collections and Recovery business a plus
• Experience with Big Data concepts and tools
• Experience with Hadoop eco-system a plus (HIVE, Impala, HDFS, Cloudera)
• Six sigma certification (green belt with lean or other)
• Quality Center, Maximo, NEWs or other change management and testing tools
• Direct Connect NDM, SFTP, SSH
• Read, analyze and provide feedback and changes on business requirement documents
• Design, build, testing and maintenance of data integration / ETL processes
• Assist with design and implementation of staging areas and data warehouse
• Design and implementation of data quality and data cleansing requirements / methodologies
• Manage scheduling, support, tools and maintenance of integration processes
• Interaction and collaboration with other team members and business users
• Work with software vendor on trouble tickets / debugging efforts
• Provide / ensure data needs / requirements for data warehouse projects
• Requirements gathering, technical documentation
• Mentor and train other project staff
• 3 years of experience working with an ETL toolset in an Enterprise Data Warehouse environment (Informatica preferred)
• Database scripting background helpful
• Strong database knowledge (TeraData, DB2, Microsoft SQL Server)
• Experience with Data Warehouse lifecycles and methodologies
• Prior experience / role on an EDM/EIM team
• Experience with OLAP Cubes / Cognos Business Intelligence tools a plus
• Experience working with key business data such as sales, inventory, financials
• Skilled at requirements definition, data and process modeling, and the use of modeling tools
• Managing the tasks and timelines to ensure project milestones are met
• Ensure that technical components adhere to existing standards
• Keeping abreast of leading edge of development and ETL practices
• Understanding and clarifying business requirements, mappings and transformation objects
• Building data quality checks into developed applications and processes
• An appropriate level of documented unit testing is performed prior to implementation
• Transformations and processes, and an impact analysis is carried out prior to any enhancements
• Problems / errors are thoroughly investigated and resolved in a timely manner by involving the appropriate people in T&O
• Processes and system enhancements are implemented to prevent reoccurrences of issues
• Bachelor’s degree in Computer Science Degree or related IT certification
• Demonstrates good communication and interpersonal skills
• Exhibits good problem solving and analytical skills
• Possesses good customer service skills
• Is able to quickly establish rapport with business partners
• Demonstrates high attention to problem description, detail, and impact
• 3-5 years of development experience
• 3-5 years ETL development experience
• Strong hands on experience with SQL scripting is a must have
• Experience with developing in a UNIX environment, strong UNIX scripting is a must have
• Experience with relational databases like DB2 and Oracle
• Experience with the ETL tools preferably IBM Data stage, Quality Stage, Informatica or similar skills is a must have
• Ability to work in a team environment including effective communication within development groups, product, and business
• Completion of customer / contract specific development
• Rapid customer issue resolution
• Collaborates with manager to develop efficient, goal oriented code
• Collaborates with manager to develop with a focus on scalability / quality
• Work with Account Management and customers to diagnose issues and develop solutions
• Manages time effectively
• Bachelors degree in Computer Science, Electrical Engineering, or equivalent
• Experience with data movement, transforms, and loads
• 2+ years of programming languages
• PHP, MySQL, HTML, JQuery / Javascript, and CSS experience
• Experience with MySQL advanced functions, procedures and triggers a plus
• Knowledge of relational database design concepts
• Has rich experience in working on multiple complex ETL and data integration projects
• 4+ years hands-on experience in Ab-Initio (preferred) and other ETL tools
• 4+ years hands-on experience in Java
• Very good Unix and Shell scripts skills
• Experience with Autosys will be a plus
• Very good SQL and relational database experience such as DB2, Oracle
• Any data modeling and dimensional design skills will be a plus
• Good expertise in technical analysis/debugging problems/troubleshooting issues
• Ability to work successfully under pressure in a dynamic, multitasking environment
• Bachelor’s degree in Computers, Information Technology or Engineering

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

• Adhere to standard Data Warehousing techniques in integrating the various source systems into the target ICDW infrastructure
• Oversee formal testing processes and procedures
• Work with Application Leads and Business Managers to define and monitor Service Level Agreement's and support commitments for existing products
• Establish/communicate a quality solution that will enable the group to implement changes into the target ICDW in a timely and efficient manner
• 7+ years of Application Development experience
• 5+ years of professional experience as an ETL developer in an Enterprise Data Warehousing environment; hands on experience with Informatica and Teradata is preferred
• 3+ years of experience writing Unix Shell Scripts
• Proven ability overseeing installations and Release Management including the final production acceptance review and signoff
• Be hands-on, implementing with and expanding your knowledge of proprietary internal toolsets as well as established technologies such as: XML, XSLT
• Support existing integrations directly with our clients, ensuring our core offering is delivered without exception: quality, accuracy, and extreme cost efficiency of data transformation and delivery
• Experience with XPath concepts and logic
• Exposure to Altova toolsets for XML

Am-etl Developer Resume Examples & Samples

• Communicate with as well as direct Offshore team members
• Participate in all Development Lifecycle processes
• Incorporate security requirements into design
• ETL Informatica developer with data warehouse/datamart experience in the financial industry
• Work with Business Intelligence tools a plus – especially Business Objects

Fees Database & ETL Developer Resume Examples & Samples

• Data analysis and database design
• In-depth knowledge, hands-on experience with ETL
• In-depth knowledge, hands-on experience with RDBMS systems; specifically SQL server, Sybase, Teradata, and/or Oracle
• Strong SQL skills and database programming skills; creating views, stored procedures and triggers, implementing referential integrity, designing and coding to optimize performance
• Strong Communication skills, both written and oral
• Experience in the Financial Industry, Retail Mortgages
• Experience in at least on of the following: Informatica, Business Objects, Teradata, SSIS, SQL Server or Oracle development
• Experience interacting with Business partners on requirements, built prototypes to conceptual model including screen flows. Has the ability to demonstrate the working concept and solicit feedback
• Ability to device solution and document them as part of design
• Continuously learns and adapts market technology trends and applies them as appropriate
• Strong problem solving and design skills

Etl Developer Risk Systems Resume Examples & Samples

• Serves as an lead application technical expert on specific aligned applications
• Works with projects teams and systems analysts to translate technical requirements into optimally coded solutions which adhere to GE standards for architecture, security, stability and incident support
• Demonstrates command of multiple programming languages and basic system analysis techniques
• Participate in off-hours application support as needed
• Bachelor's Degree (or minimum 4 years equivalent work experience) with minimum 2 years of IT experience
• Minimum 2 years of experience in Informatica and other ETL tools including advanced features
• Minimum 2 years of experience in Teradata and Oracle experience Eligibility Requirements
• Must be able to satisfy the requirements of Section 19 of the Federal Deposit Insurance Act
• GE will only employ those who are legally authorized to work in the United States for this opening. Any offer of employment is conditioned upon the successful completion of a background investigation and drug screen
• Minimum 2 years of software development experience involved in all phases of the software development lifecycle
• Broad knowledge of IT systems, infrastructure, processes and controls
• Knowledge of IT controllership methodologies and standards; demonstrated experience though project execution compliant with systems development life cycle methodology
• Experience in normalized and dimensional logical modeling
• Possesses excellent SQL skills
• Ability to concurrently manage multiple projects and incidents
• Data Validation Option (DVO) experience #DTR
• Technically proficient in Abinitio features and functionality (experience in cooperating version 2.15 and 3.x)
• Strong practical knowledge of EME
• Multitasking capability - working in multiple projects
• Experience in Version control system (PVCS, VSS, etc.) is preferred
• Experience in ETL and Abinitio migration and upgrade projects
• Experience in driving a full lifecycle development of ETL projects
• Banking/Financial Services domain knowledge is preferable
• OS - Windows, Unix
• Proficient in working on backend technologies like Oracle/PL/SQL and stored procedures/triggers, etc
• Proficient in Unix Shell scripting
• Good technical analysis and troubelshooting skills
• Experience in designing and architecting medium to complex systems, well-versed with design standards and framework

Etl Developer Ayala Avenue, Makati Resume Examples & Samples

• Flexible in dealing with conflicting and changing priorities, and multi-task
• Highly self motivated and capable of working with minimal input and supervision
• A problem solver with strong analytical skills
• A strong communicator, both written and verbal
• Strong on detail
• A fast learner willing to take on new challenges

DB / ETL Developer Resume Examples & Samples

• Ensure to complete and deliver all assigned tasks on time with quality
• Should be able to multitask working simultaneously on more than 1 task at any given time
• The ideal candidate will possess a good compliment of IT skills and technical experience in Oracle and ETL
• Relevant work experience needed is between 3-4 years
• Candidate should have hands-on experience in Oracle and ETL technologies
• Exposure to IBM JRules and ETL tool
• Talend is a big plus
• Must include excellent communication and problem solving skills
• Should possess strong analytical and troubleshooting skills
• Bachelor's degree or equivalent work experience in Computer Science, Information Systems, or other related field
• Strong experience in Ab-Initio ETL development Tool and understanding of data integration best practices in data warehouse environment
• Demonstrate a strong understanding of key business drivers and ensure technical solutions deliver business value in line with the company objectives
• Strong development analysis skills and be qualified to technically lead a team of developers
• Can perform independently and guide, assist or mentor others in analyzing, designing, coding, testing, debugging, documenting, and installing a large/complex or several smaller solutions
• Provide prioritization, planning, estimating, work assignments, quality assurance and mentoring at any stage of a project
• Responsible for communicating to management on status, problems, issues and underlying process problems
• Identify and develop the Technical detail design document
• Document and present solution alternatives to clients, which support business processes and business objectives
• Demonstrate anticipation and initiative in the planning for and management of problems
• Resolve or escalate problems, and manage risk for both development and production support
• Coordinate vendors and contractors for specific projects or systems
• Maintain deep knowledge and awareness of technical & industry best practices and trends, especially in technology & methodologies
• Ensure that good business relationships are maintained with multiple clients and other IT departments to ensure successful implementation and support of project efforts
• Participate in the evaluation of new software and hardware
• Provide input to manager with respect to training needs of team members
• 4+ years experience with Informatica
• Can perform independently and guide, assist or mentor others in analyzing, designing, coding, testing, debugging, documenting, and installing a large/complex or several s maller solutions
• 5 or more years of hands-on experience developing software with Informatica and some Ab Initio (GDE v1.15) ETL tool and at least 2 years of technical lead experience
• 5 or more years experience in analyzing, designing, coding, testing, implementation, documentation and maintaining complex software programs
• 2 or more years experience developing in a UNIX/Teradata environment required
• SQL programming and performance tuning experience is required
• Strong experience in Data Quality, Source Systems Analysis, Business Rules Validation, Source
• Target Mapping Design and High Volume Data Loads
• Experience with Data Warehouse development
• Understanding of data modeling desired
• Experience with Oracle desired
• Considerable business knowledge, preferably the retail industry
• Ability to exercise judgment within broadly defined practices and policies in selecting methods, techniques and evaluation criterion for obtaining results
• Demonstrated leadership in instructing, guiding and overseeing the work of team members
• Would require working with business users understanding requirement and training them on data retrieval from Teradata
• Enough practical experience to train others in decision making, risk assessment, job knowledge, analysis, and project management
• Ability to work independently and multi-task to meet critical deadlines in a rapidly changing environment
• Control-M experience is a plus along with PowerCenter ETL and Hadoop experience
• Deliver ETL and related components as specified in the design, functional and non-functional requirements within established time and quality standards
• Develop, test and document existing and new ETL related components; make recommendations for related functions that result in a more cost effective product delivery
• Troubleshoot and fix coding defects and support all testing cycles, including but not limited to: Development Integration Testing, System Testing, User Acceptance Testing, End-to-End Testing, and Performance Testing
• Provide application integration support
• Perform code version control activities
• Create and update all necessary documentation for the Project
• Deliver effective and efficient solutions by meeting key project milestones and ensure that the project deliverables are on time and adhere to the corporate quality and security standards
• Experience with IBM DataStage and QualityStage
• DataStage XML components
• Current hands-on Unix/Linux shell scripting experience
• General database knowledge and expertise in SQL
• Proven problem solving and debugging skills
• In depth understanding on XML concepts and XML processing
• ETL Developer is responsible for Software development by using Data stage advanced technologies
• ETL Developer is responsible for Shell Scripting and provide support on various software functions like SQL & DB
• Development experience in DataStage 7 or 8
• DB2/SQL or Oracle and good knowledge in DB2/SQL
• Shell scripting in AIX and/or UNIX
• At least 2 years experience in ETL Development
• 1 – 3 years of technical experience and an Associate of Arts/Science or equivalent degree (two year college program) in computer science or related area of study; without a degree, one additional year of relevant technical experience (2-4 years in total)
• Has sufficient technical knowledge to assist with the completion of specific deliverables
• Able to communicate concepts with team and to peers
• Able to produce basic documentation to required standards
• Demonstrates understanding of assigned discipline or technical area. Demonstrate fundamental technical knowledge

ETL Developer, Senior Resume Examples & Samples

• 3 plus years application systems development/maintenance or ETL support experience
• 1+ years’ SAS programming work experience
• 1+ years’ SQL Server Integration Services (SSIS)
• 3+ years experience with Relational databases like Oracle and SQL Server
• Experience with SQL Server Reporting Services (SSRS) a plus
• Experience in Developing Client Server Applications using Microsoft .NET Framework, C# a plus
• Ability to learn new technologies, solves complex technical problems and multitask initiatives
• Understanding the data and the needs of upstream and Downstream systems
• Understand the data architecture and ability to understand and work on data models
• Design and implement high quality ETL deliverables for the various reporting and Integration requirements
• Troubleshoot and come up with innovative and performance efficient solution to address the problem
• Strong knowledge and experience with Terradata Database and writing SQLs
• Prior work experience on any ETL tools is a must. Experience with "Abinitio" is an added advantage
• Should be able to understand Data Models and must be able to independently work on Design and development of ETL jobs
• Must have strong knowledge of performance tuning of SQLs and ETL packages
• Prior experience of working on agile development teams with a strong focus on quality

Etl Developer Ab Initio Resume Examples & Samples

• Responsible for all ETL processes of the global corporate actions platform
• Lead & work with the development team and other partner system teams
• Work proactively to address project requirements, and resolve issues/challenges within acceptable timeline
• Manage the releases across multiple instances in production & test environments
• Be an active member of level 3 support team and oversee the activities of L1 & L2 support teams
• Manage competing priorities of business, with minimum or no loss of efficiency on project deliverables
• Bachelor’s Degree in Computing or Engineering
• Minimum 5 years of IT experience required
• Hands-on experience of ETL Tool (Preferably Ab Initio)
• Strong knowledge of Scripting Technologies - UNIX shell script & Batch Script
• Understanding of database (MSSQL preferably) with ability to write queries and stored procedures
• Experience in Finance Industry
• Knowledge of SWIFT Standards
• A self-starter who can deliver well as part of a global team
• Maintain communication with internal stakeholder on progress and deadlines
• 2+ years of database development using either SQL Server or MySQL (but with significant experience using both)
• 2+ years of ETL development using SSIS and related tools
• Good data modeling and SQL coding skills
• Experience performing basic DBA activities such as scheduled maintenance, upgrades, backups, performance tuning and troubleshooting
• Excellent troubleshooting skills with demonstrable experience identifying bottlenecks in existing database/ETL processes
• Good problem solving and negotiating skills

Experienced ETL Developer Resume Examples & Samples

• Support production deployment
• Identify and address technical issues in due time
• Ability to translate architecture documents in functional specification documents
• Development experience in DataStage 7.5 / DataStage 8.X
• Oracle DB 10g, 11g

Abinitio Etl Developer Resume Examples & Samples

• Code, test, modify, debug, document, and implement Abinitio Graphs utilizing the GDEenvironment and EME
• Document detailed application specifications; Create and translate technical requirements into programmed application modules
• Participate in design reviews / code reviews and ensure that all solutions are aligned to pre-defined architectural specifications; identify/troubleshoot application code-related issues; and review and provide feedback to the final user documentation
• Assume ownership and accountability for the assigned deliverables thru all phases of the development lifecycle
• SQL and RDBMS' like Oracle or Sybase
• ETL technologies like Informatica
• Building and deploying an Investment Book of Record
• Creates ETL specifications that align with interface and data requirements
• Develops ETL code to transport large volumes of data into a central data warehouse
• Actively participates in discussions with Business Analysts, Developers and Testers to address requirements implementations
• Provides ETL expertise to the business processes supported by ETL applications
• Assists in the assessment of new technologies to enhance the development process
• 3+ years of software development experience involved in all phases of the software development lifecycle
• Oracle RDBMS experience (including stored procedure development in PL/SQL)
• Interface requirements definition experience
• Develop client integration solutions and support the deliverables to include eligible member, claims and biometric data
• Perform ETL Development for inbound File Feeds, file loads and various controls
• Fine-tune ETL processes for performance optimization
• Demonstrate self-reliance in researching technical solutions and product functionality
• Continuously improve upon existing approaches by seeking opportunity to creatively transform current business practices into fresh alternative solutions
• Identify solutions to critical integration issues and develop corrective solutions
• Communicate with team members to assess progress of deliverables
• Create and maintain data integration documentation
• 6+ years of ETL Development experience with strong ETL and SQL programming skills (required); MySQL experience (desired)
• 4 years Bachelor's degree in Engineering or equivalent
• Experience with ETL (required), Pentaho, Pervasive or similar tools (preferred)
• Proficient technical skills to include (SQL DDL and DML, ETL methodologies, TOAD, Perforce, MySQL, Database Schemas)
• Access disparate data sources (databases, hardware devices, VSAM and flat files) and apply internal and external business rules, policies and data quality measures
• Insure the data is safely and securely transferred to target destinations
• Maintain an in-depth knowledge of current and emerging technologies and standards and provide technical direction to management and users
• Provide technical direction to other team members including contractors and employees
• Performs other duties, as assigned
• 5+ years of experience with the IBM InfoSphere Information Server ETL tool in a data warehouse environment is a must. Experience with both Server and Enterprise editions preferred
• Knowledge of database loading methods
• Knowledge of data warehousing methodologies
• Knowledge of mainframe file structures, namely copybooks is a plus
• Knowledge of all phases of the system development life cycle
• Demonstrated ability to take ownership & responsibility for development and maintenance projects

Ab Initio Etl Developer Resume Examples & Samples

• Initial Investigation & solution identification
• Analyzes, Designs, develops, codes, tests, debugs and documents
• Support QA phase by tracking and assigning defects to development team; Work with QA leads to schedule fixes and builds and enable QA to be successful
• Implementation and Warranty support
• Identify ways to increase efficiency of production support - Find solutions that allow operations to better do their job
• Works with other team members, including DBA's, ETL developers, Technical Architects, QA , Business Analysts & Project Managers
• Excellent knowledge of the Full life cycle of a project
• Mentor younger member of the team
• Bachelor's degree in Engineering
• Master's degree in Finance OR Information Technology is a plus
• Minimum 5 years of hands on work experience in Ab Initio (Application development)
• At least 6 yeards software development experience required in Operational Data Store / Data Warehouse environment
• Knowledge of release management, version control practices and procedures
• Experience with scheduling jobs using a scheduling tool like Control-M
• Analyzes, Designs, develops, codes, tests, debugs and documents to satisfy business requirements
• Experience in managing deliveries on application releases
• Conduct / Participate in design reviews and provide alternatives
• Conduct / Participate in code reviews and make sure quality solutions are implemented to design specification and best practices/standards have been followed
• Responsible for on-time project / L3 Releases delivery with high-quality code
• Support QA phase by tracking and assigning defects to development team; work with QA leads to schedule fixes and builds and enable QA to be successful
• Identify ways to increase efficiency of production support - Find solutions that allow operations to better do their job without involving development resource time
• Ensure that solutions are not one-offs, but can be leverage across the organization
• Minimum 5-7 years of hands on work experience in Ab Initio (Application development)
• At least 9-10 years of software development experience required in Operational Data Store / Data Warehouse environment
• Ability to provide optimal solution/design to problem definition

Analyst Etl Developer Resume Examples & Samples

• Participate in the full lifecycle of ETL software development - analysis, design, build, documentation and testing
• Collaborate with project managers, analysts, technical leads, business partners and developers throughout the SDLC
• Develop technical designs and build Informatica workflows, mappings, shell scripts, stored procedures, clearly documenting the process
• Create and execute unit tests on all solutions, work with Data analysts and QA engineers to ensure product and integrations tests are complete
• Work with the release manager, data analysts, and prod ops team to ensure solutions are well tested, production ready and well documented
• Work with the both project and support teams to understand existing systems and to help troubleshoot, optimize, and tune ETL processes as needed
• Build strong relationships with the peers, analysts, technical and business leads through delivery, communication and development of domain knowledge
• 3-6 years hands on experience developing Informatica mappings and workflows
• 3-6 years’ experience with UNIX shell scripting
• 3-6 years in data modeling and development with demonstrated strength in SQL, and stored procedures. Sybase preferred
• 3+ years’ experience with Data warehousing techniques (Star Schema, snow flaking, denormalization, Normalization, Aggregations)
• 3+ years working in a fast-paced environment, including multiple projects at any one time
• Experience working with XML document structures and hierarchical data
• Experience with Messaging is preferred, in particular IBM MQ series
• Minimum BA/BS degree
• Demonstrated interest in financial services required, experience preferred
• Excellent analytical and problem-solving skills coupled with attention to detail and thoroughness
• Strong teamwork, communication skills and time management abilities required
• Experience working in a global team environment

ETL Developer AVP Resume Examples & Samples

• 7 years minimum experience with strong ETL (Informatica/ Talend/ DataStage ), DW (OLTP and OLAP) methodology concepts
• Must be able to write complex Oracle database stored procedures/packages
• Strong experience with SQL queries
• Experience creating scripts in Unix/Java
• Strong database development capabilities
• Experience with high performance & high volume data ware house systems in a high pressure environment
• Must have demonstrated design and delivery experience in the full life cycle of data
• Should have experience of sourcing data from multiple systems using ETL to implement data transformation rules and load into the data warehouse
• Ability to carry out adaptive changes necessitated by business and technology
• Display sound analytics, problem solving, presentation and inter-personal skills to handle critical situations
• Bachelor’s degree in Computer Science & Engineering or similar discipline
• Banking experience would be an advantage
• Abinito experience is a plus
• Big data integration and cloud experience would be preferable
• Bachelor’s Degree in Computer Science or related field of study required
• 3+ years of ETL experience utilizing Pentaho Data Integration required
• Advanced working knowledge of scripting languages necessary
• Previous professional or personal experience in Financial industry a plus
• Develop code for technical frameworks and application
• Manage the developed code through the various test cycles and eventual production implementation
• Work with global teams on development tasks
• 5+ year’s industry experience
• 5+ year’s hands-on experience writing code
• Experience with relational databases such as DB2 or Oracle
• Very good Unix and Shell scripts skills. Experience with Autosys will be a plus
• Experience with Volante will be a plus
• Financial industry experience is plus, preferably with Cards or Payments

Database / ETL Developer Resume Examples & Samples

• Under direct supervision, responsible for program analysis, design and specification for own programs
• Application coding using SQL Service (TSQL, SSIS, DDL) and SSRS Reporting
• Data loading using ETL tools
• Under general supervision responsible for coding, testing, debugging and implementation into production
• Participate and assist project leader in project planning
• Contribute task level estimates for work and time to project plan
• Complete required documentation
• Follow company standards, policies, procedures, and guidelines
• Escalate project issues in a timely manner
• Follow managers’ direction regarding project priorities, milestones and initiatives
• Assist in ensuring that systems are not vulnerable to known security exploits
• Satisfy programming requirements for the unit of work assigned, with moderate supervision
• Proficient with MS SQL Server, SSRS, SSIS, and other ETL tools
• Source code control using TFS
• Understand database design practices, including database normalization concepts
• Exhibit a disciplined approach in unit and component testing to ensure zero defects
• Determine the appropriate unit test cases, including functional and regression cases
• Perform analysis and design on the component level
• Complete appropriate documentation (test plans)
• Adhere to design and programming standards and principles as defined by senior team members
• Have a basic grasp of the core business functions in their area of work
• Have a good grasp of the main system flows and functions in their area of work
• May participate in the gathering, writing and reviewing of business requirements and translating into functional specifications (FRD process)
• Possess root cause analysis skills; able to quickly analyze and interpret code
• Escalate support issues appropriately
• Take ownership for issues; follow up on resolution even when resolved by other
• Participate in post-project review when appropriate
• Communicate with team leader regarding specifications and requirements relevant to unit of work
• Possess strong written and oral English communication skills
• Ensures ETL process is developed in modular fashion in shared folders and reusable objects to enforce consistency timely development. Reviews ETL production design for performance optimization
• Resolves issues through troubleshooting and quick diagnoses
• Bachelor’s Degree in Business or equivalent combination of education and experience required

Lead Etl Developer Resume Examples & Samples

• Provide technical leadership in the Design and the Development Phases of the SDLC lifecycle for the implementation of Informatica ETL components within the data warehouse architecture
• Accountable for the creation of the technical specification and the unit testing cases based on the specification. Details of the technical specification include the acquisition of source data, validation of data integrity, standardization of data, loading to the data warehouse, data reconciliation and archiving of data
• Be a sounding board for Analysts/Developers/QA and oversee the overall coding effort as it relates to the ETL components of the architecture
• Act as the primary interface to the architecture team and influence architectural decisions based on their platforms needs and the usage of tools to support the data warehouse architecture
• Responsible for setting ETL coding standards, establishing/maintaining best practices, adopting the CMMi framework and driving these principles throughout Delivery
• Ensure consistent on-time, within estimate delivery of quality systems initiatives in accordance with agreed upon plans
• 8+ years of IT based software development
• 8+ years developing data warehouse architecture components utilizing Informatica
• Knowledge of systems, application architecture, data warehouse architecture and data modeling
• Solid knowledge and experience of database and programming languages (specifically Oracle and Informatica)
• Knowledge of software development life-cycle for data warehouse and business intelligence projects
• Ability to effectively communicate and influence others
• An active participant in the growth of the organization; Being a Change Agent
• Critical thinker
• Excellent customer focus
• Multi-site team environment experience preferred
• Skill at resolving conflict and negotiating effectively and tactfully
• Ability to inspire and motivate teams and individuals
• Strong Interpersonal (listening, written and verbal communication) and presentation skills
• Design, Code, Test, and Document complex transformations of data being loaded to the Data Warehouse
• Function as Technical Lead to junior resources or our off-shore development team
• May translate Functional Specifications into Technical Design Specifications for off-shore development team
• May be asked to tune SQL statements to ensure optimal performance
• Provide input on physical database design decisions
• Trouble shoot and problem solve data integrity issues
• Maintain documentation in corporate data dictionary
• Contribute to physical database design
• May provide 24 x 7 production support
• Understanding of Dimensional Modeling design principles
• Knowledge of Extract, Transform, and Load (ETL) concepts, and working knowledge of some 3rd party ETL tool
• Knowledge of DataStage and Job Control Language (JCL) a plus
• Scripting skills (Shell, Bash, REXX) a plus
• 3 - 5 years of related experience

VP-ab Initio ETL Developer Resume Examples & Samples

• Design & develop custom ETL components using Oracle database, Talend and UNIX scripts
• Design & develop batch using AUTOSYS
• Maintain non-production Talend environments and keep in sync with production
• Maintaining all required technical documentation for Talend Implementation
• Ability to work with global development team with solid problem solving, decision making and analytical skills
• Prior 5 years of experience working as a Talend system engineer is strongly desired
• High Proficiency of Talend environments management in terms of installations and upgrades
• High Proficiency of Talend ETL Development
• High Proficiency in Unix Linux/Solaris environment and K-shell scripting skills
• High Proficiency in Oracle database development
• Good understanding of AUTOSYS batch scheduling tool
• Good understanding of PL/SQL
• Good understanding of Data Warehousing methodologies
• Bachelor’s degree in Computer Science or 8-10 years of experience in Information Technology
• Understand business analytics requirements and translate them into solutions that provide optimal user experience
• Design and Develop ETL jobs using Datastage
• Provide Solution Performance (analysis/tuning) and work across business/technology teams to ensure alignment between business solution definition & systems architecture for the organization
• Collaborate with Business Users to configure data services to extract, transform and load data
• Document reporting / analytical solutions and provide support during testing, end-user training and deployment
• Perform data profiling using information analyzer,qualitystage (datastage)
• Computer-related or Engineering-related four year College or University Degree (or equivalent)
• 4 to 6 years of progressively responsible IT job-related experiences in ETL
• 3-4 years of experience in Information Server (DataStage)
• Experience with a Distributed Scheduling Tool
• Experience with Application Development Lifecycle/Methodology
• Experience with Information Analyzer,Qualitystage ( Datastage)
• Experience in Teradata utilities (M load, Bulk load, Fast load)
• Experience in BTEQ scripts
• Experience in PL SQL statements
• Experience with Quality Stage
• Experience with ETL into IBM MDM tools
• Experience with Tidal or DataStage Scheduler
• Ability to work independently and in a dynamic team environment
• Exposure to manufacturing industry

Microstrategy ETL Developer Resume Examples & Samples

• The gathering and interpretation of Brand Management business requirements
• Partnering with our IT teams for the technical implementation and rollout of MicroStrategy reports
• The delivery and interpretation of insights for immediate and future campaign optimizations
• Understanding the Reebok business goals and the role that Brand Management plays within that
• Supporting the Brand Management Team in defining strategies to support the overall Reebok business goals
• Leading the brand management team to identify KPIs to track the strategy progress
• Build, support and operate the MicroStrategy reports needed to track the strategy progress
• Partner with the web and social analytics team to produce combined reports for data that cannot be retrieved from MicroStrategy
• Interpret the reports and provide immediate and long term recommendations for marketing changes to improve the KPIs
• Partner with our Global IT team on long-term projects for ensuring data availability through MicroStrategy
• Loading off offline data into the Reebok Global Consumer Database
• Extraction of consumer data from the Reebok Global Consumer Database
• Consumer Segmentation in MicroStrategy
• Degree in IT, Business IT or a related field preferable
• Understanding of digital technologies/methodologies
• Knowledge of MicroStrategy, Adobe Campaign, ETL Tools like Pentaho, PL/SQL, Visio Studio, Eclipse
• Experience in a multi-country digital deployment preferred
• Manages development and testing tasks and ensuring adherence to previously agreed to timelines communicating status
• Bachelor’s Degree in Computer Science or related field required
• 7 - 10years of experience at Enterprise-level ETL development and ETL architecture using Informatica and understanding the COBOL file structures
• Strong Teradata technical knowledge in the areas of general SQL
• Good knowledge of Erwin model generation tools (logical and physical)
• Performance tuning and end-to-end lifescycle experience with Enterprise wide data warehouse

ETL Developer / Analyst Resume Examples & Samples

• Develop and support data integrations for various entities within the healthcare enrollment data exchange space
• You will work closely with senior staff to develop your relevant technical and operational skillset
• Strong problem solving skills and attention to detail
• Strong knowledge of Microsoft Office tools
• Familiarity with data mapping formats and standards such as X12/834
• Understanding of FTP and other file transfer technologies and concepts

Oracle / ETL Developer Resume Examples & Samples

• Work closely with the clients to understand and finalize the requirements
• Play a lead role to facilitate the full product life cycle of new requests as necessary. This includes design technical solution, writing of detailed specifications, performing code reviews, coordinating code migrations, managing the user acceptance testing, ensuring successful migration to production
• Maintain awareness of current technology trends in the data warehousing
• 5+ years of Oracle experience with strong fundamentals in performance and tuning, efficient SQL writing, stored procedures/PLSQL coding etc
• 5+ years of Informatica experience with fundamentals in workflow, transformation etc
• 6+ years of industry experience in information technology. Data-warehousing experience is a strong plus
• Hands on experience with Autosys tool is a plus
• Ability to work late evening / early morning hours as and when needed for production support as well as interacting with
• Working as a part of a team to deliver quality and robust solutions in a demanding business environment
• Participating in process improvement initiatives
• Responsible for delivering to agreed constraints in terms of time and scope
• Managing time accordingly across multiple simultaneous projects with differing priorities
• Working closely with the business and technical stakeholders to deliver innovative and quality solutions
• Ensuring Macquarie's IT security, risk, audit and compliance frameworks are followed
• Contributing to the continuous improvement of IT processes and tools in the team

Advisory ETL Developer Resume Examples & Samples

• Quickly understands the business issues and data challenges of Manheim business and industry
• Identifies strengths and weaknesses in existing processes, suggests areas of improvement, and helps enhance existing ETL processes to meet evolving requirements
• Understands and review technical requirements, designs ETL process flow and walkthroughs and performs data profiling of required source systems
• Provides oversight of other ETL development activities and unit testing all objects and processes, and performs find-tuning and UAT issue resolution
• Assists in enforcement of project deadlines and schedules
• Help BI reporting developers with analyzing data source, designing, testing and implementing Analytics reports and dashboards
• Exhibits confidence and an extensive knowledge of emerging industry practices when solving business problems
• Mentors ETL Developers on the best practices and provides feedback/comments during ETL code reviews
• Seeks and participates in development opportunities above and beyond training
• Minimum of 12 years of working experience with Informatica PowerCenter in BI/Data Warehousing space or system integration work
• 3 years of working knowledge of OBIEE tool and understand how it interacts with other applications
• Working knowledge and experience with ETL/Data integration using Informatica and DAC
• Prefer previous team lead or Technical Architect responsibility for ETL development
• Experience in using SAS for development is a plus
• Solid working knowledge in cloud based integrations
• Responsible for design, development and implementation various tasks in building data warehouse and complex ETL process
• Experience in developing ETL process for loading stage, ODS, Data Marts and change data capture with sound knowledge of various aspects of data warehouse build process from scratch
• Understand the business requirements, design and develop ETL process
• Responsible for loading data into Data Warehouse and Data Marts. Should be able to schedule, maintain the refresh jobs
• Design and develop database objects using mysql or any other RDBMS
• Troubleshooting/debugging data issues and provide detailed Analysis on issues
• Constantly update technical knowledge, skills and learning new technologies
• 5+ years of experience in Data Warehousing, with in-depth knowledge of dimensional modeling required
• Extensive experience in ETL development and hands on ETL tools administration preferred
• Experience in Business Intelligence development, using Pentaho BI (PDI) or any other ETL tool is required
• Strong experience in design, development, testing, enhancement and performance tuning of complex ETL processes is required
• Strong experience in database development (including extensively developed and tuned complex stored procedures) with mysql database or any RDBMS with in-depth knowledge of analytical functions required
• In-depth understanding SQL performance tuning
• Experience in installation, configuration and administration of RDBMS, ETL Tools preferred (good to have)
• Strong knowledge of a scripting language (Python, Perl, Unix Shell or PHP)
• Experience with UNIX text searching/parsing commands (grep, sed, awk, etc.)
• Experience with one or more of the following financial file formats: SWIFT, FIXml, Murex XML and FpML
• Experience with an ETL workflow
• Experience with test driven development practices
• Knowledge of Visual Basic and XML

Risk-etl Developer Resume Examples & Samples

• Must have 7+ years of experience with Informatica ETL Tools / PowerCenter 9.1, databases, developing and tuning Informatica and database code
• Ability to design, code and unit test complex Informatica transformations and mappings
• Knowledge in SQL and SQL Tuning - Understand existing code and make tweaks as needed
• Strong UNIX/Linux experience preferred
• Experience with Autosys Job Scheduler
• Knowledge on dimensional modeling a plus
• Work on multiple, concurrent tasks
• Able to / experience with managing a team of developers
• Work within formal Change Management methodologies and excellent documentation skills
• Provide production support for the assigned applications
• 3 to 5 years of experience developing with ETL (Extract, Transform, Load) in large data volume environments
• Excellent UNIX/Shell Scripting experience
• Strong knowledge and experience with SQL, UNIX/AIX, Java/J2EE, XML, MQueue, SOA, WebSphere, Rational suite, UML, Schedulers and HP Quality Centre
• Excellent knowledge of DB2 and experience supporting large, mission critical databases including performance tuning
• Excellent time management and organization skills with the ability to work on competing priorities concurrently
• Experience delivering solutions using the iWay Tool Suite/MDM is highly desirable
• Knowledge of retail banking products and services is a nice to have
• Experience delivering integration or enterprise service bus (ESB) solutions is a nice to have

Datawarehouse ETL Developer Resume Examples & Samples

• Experience on Data warehousing applications preferably with a bank or financial Institution using Ab Initio. Any other ETL tool knowledge is advantage
• Experience in managing end to end process involving Planning, understanding Business requirements, Preparing FRD, UAT setup, Change control process and Production Rollouts
• Excellent communication skills – verbal and written in English
• 3+ years of experience in technical role with
• Designs, codes, tests, debugs, installs, documents and maintains moderately complex software applications
• Validate and transform data extracted from structured and unstructured data inputs, databases, and other repositories, using scripts and other automated capabilities, logs, and queries, as required. Demonstrate in-depth understanding of fundamentals of requirement/specifications gathering, database technologies, ETL programming, and EDW data warehousing technologies
• Produces the required analysis and application design, either individually or by actively participating in development process. Responsible for creating and maintaining data maps, design specification documents, technical requirements documents (TRDs) and standard operating procedures (SOPs) in accordance with internal and external standards
• Collaborate with BI developers, DBA, researchers, and IT in enhancing existing projects or data structures, and resolving project and programming issues. Supporting database issues for development team
• Act as a subject matter expert for the ETL architecture for the EDW. Primary technical owner for the ETL Processes
• 15% Designs, codes, tests, debugs, installs, documents and maintains moderately complex software applications
• 15% Produces the required analysis and application design, either individually or by actively participating in development process. Produces design specification documents
• 15% Translates design specifications into ETL programming
• 10% Interacts with users to determine their software application objectives, scope and requirements
• 10% Develops test data and routines required to test and revise application(s). Ensures application(s) is thoroughly tested before release. Writes reports of test results
• 10% Detects, defines and debugs programs whenever problems are reported or encountered
• 10% Prepares developer and end-user documentation for other programmers and users in accordance with internal and external standards
• 5% Trains users and programmers as required
• 5% Provides leadership, guidance and direction to other programmers, as needed. Reviews the work of others, as requested
• <5% Supports DBA/Integration functions on a backup/cross-training basis
• <5% Stays informed of new developments and technologies by reading journals and other pertinent publications, maintaining contact with vendors, and participating in professional organizations, meetings and seminars
• <5% Performs other duties as assigned or requested. The university reserves the right to add or change duties at any time

Business Intelligence ETL Developer Resume Examples & Samples

• Participating on high-impact initiatives involving business, technology and external partners
• Providing technical support and assistance with identifying and prioritizing technology education needs, determining project parameters, and ensuring quality education solutions are implemented
• Staying abreast of industry best practices, emerging technologies and LOB/client direction to anticipate and accommodate shifts in the business need and priorities
• Conducting technical training evaluation to identify program impact, return on investment, and areas of improvement
• Serving as an Oracle application development consultant for CAO CLO Instructional Design staff, critically evaluating, testing and potentially delivering Oracle PL/SQL Developer, DBA and APEX training in support of firm-wide Oracle curriculum development and delivery
• Designs, analyzes, develops, codes, tests, debugs and documents programming to satisfy business and data quality requirements
• Formulating and defining system scope and objectives through research and fact-finding to develop or modify complex information systems
• Preparing detailed specifications from which programs will be written
• Work independently on most phases of applications systems analysis, programming activities and testing
• Working directly with internal customers, including senior executives, developing a solid understanding of the business problem for which the applications are being designed
• Assisting internal customers with questions regarding the functionality of applications
• Working off-hours and weekends occasionally, as required by project work, systems maintenance, and staffing
• Proficient in all phases of the software development lifecycle
• Minimum of 5 years experience developing software solutions utilizing agile software development methodologies
• Minimum of 3 years experience modeling data structures for applications
• Experience in writing software requirements, design specifications, and design and documentation of system test plans
• Demonstrated experience in working with business analysts & key technology partners to identify solutions to their reporting needs, develop new workflows & modify existing workflows
• Ability to assist in the definition of the database requirements, analyze existing models and reports looking for opportunities to improve their efficiency, and resolve technical problems
• Experience with Business Intelligence reporting and visualization tools (e.g., MS Excel, Business Objects, QlikView, Tableau, Cognos)
• Minimum of 5 years experience developing SQL*Plus and PL/SQL solutions
• Minimum of 5 years experience performing operational support of applications that utilize Oracle technologies
• Minimum of 3 years experience with the UNIX operating system, preferably on Linux platforms, using Korn Shell, AWK, SED, and common system functions
• Ability to work independently, and escalate issues and seek guidance as necessary
• Deliver all work products to defined best practice standards and ensure high quality results
• Demonstrated use of system application skills that include programming logic, system analysis, system testing, documentation, troubleshooting, and user support
• Oracle APEX (Application Express) development experience
• Exceptional data analysis skills and problem solving ability
• Sharepoint development experience
• Technical content delivery experience
• High comfort level with all standard Microsoft Office development tools
• Excellent communication skills with the ability to communicate (oral, written, and active listening) to all levels of the business
• Strong customer service skills and demonstrated ability to build professional relationships
• Solid teamwork and interpersonal skills - able to work alone or with a team
• Capable of dealing effectively with change
• Extremely well organized
• Highly motivated individual who can work in a fast paced environment
• Ability to participate in the analysis and/or resolution of IT and business issues
• 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 Communication skills, co-ordination skills
• Experience in Oracle Database design, development
• One or more Informatica Data Quality/Analyst, Business Objects, Qlikview development

Senior Data Integration / ETL Developer Resume Examples & Samples

• Responsible for the efficient, compliant, timely, and secure acquisition, integration, provision, and exchange of the enterprise data
• Provide data integration architecture leadership across the enterprise
• Work with external vendors and internal business and technology staff to accurately gather and interpret requirements, specifications, and database models to determine appropriate ETL development solutions
• Develop ETL technical specifications and recommend, design, develop, test, implement, and support innovative and optimal data solutions
• Develop and document technical best practices for ETL-related activities including data movement, data aggregation, data quality, and data cleansing
• Work with the Data Warehousing and Business Intelligence team to design, implement, and support end-to-end data solutions across multiple platforms, environments, domains, and locations
• Integrate ETL development with existing codebase to maximize object reuse
• Document ETL processes, programs and solutions as per established standards
• Perform tasks required to conform to the company’s configuration management and software release processes
• Work with internal staff, vendors, consultants, and external partners to quickly identify and resolve data integration and ETL job issues
• Assess and document the structure, quality, and compliance of data source data and coordinate with business and technology staff to identify and resolve issues
• Mentor other Data Services team members in the ETL tools, programs, processes, and best practices
• Bachelor's Degree in Computer Science or Mathematics. Work experience as a senior ETL developer in an enterprise business environment may be considered equivalent
• Minimum 6 years experience designing, developing, testing, and implementing ETL solutions using enterprise ETL tools (experience with IBM DataStage/QualityStage is preferred)
• Minimum 6 years experience developing and implementing data integration and DW solutions in an Oracle 11g/12g database environment (experience with Netezza preferred; experience with DB2 is a plus; experience with Oracle EBS is a plus; experience with Salesforce is a plus)
• Minimum 2 years experience working with BI tools (IBM Cognos is preferred)
• Minimum 2 years experience working in a SOA environment
• Minimum 2 years experience working with high volume data exchange and transaction processing systems, preferably in a custom software development environment
• Minimum 1 year experience in 10+ TB data environment
• Minimum 2 years experience integrating large (100M+ rows) structured and unstructured data in multiple formats, character sets, and delivery methods
• Expertise in RDBMS, Data Mart and Data Warehouse design. Knowledge of data modeling, MDM, BI, and CRM is preferred
• Expert-level SQL and PL/SQL development skills in a multi-tier, SOA environment are required. Experience with advanced features such as PL/SQL analytic functions is highly preferred
• Expertise in flat file formats, XML within PL/SQL, and file format conversion
• Expertise in web services development
• Strong understanding of SDLC and Agile Methodologies
• Strong understanding of Model Driven Development
• Expertise and hands-on experience with design and development best practices
• Ability to handle multiple projects and deadlines with minimal supervision
• Dedicated to excellence in one’s work; detail-oriented and thorough

Intermediate ETL Developer Resume Examples & Samples

• Manage and participate ‘hands-on’ in the implementation by analyzing user requirements, providing technical specifications and designs, developing detailed work-plans, scheduling technical resources, monitoring progress against plan and developing/maintaining programs according to standards. The incumbent must ensure software, programs and applications developed and/or configured to meet high availability, integrity and reliability requirements
• Work within a development team to develop application programs that work with web and UNIX technologies using iWay Service Manager, Java, servlets, XML, HTML, JSP's, JavaScript, Web Services, Master Data Management Technology, and Mainframe/Host Technology Integration
• Participate in the development of application systems through to implementation
• Participate in the delivery of the negotiated function to the user while following BNS standards and methodology
• Provide technical expertise, guidance, advice and knowledge transfer to all development staff on all aspects of application development for assigned applications or technology
• Provide production and user acceptance testing application support to complex technical problems on all assigned applications and technology that serve each business unit by analyzing problems, implementing solutions and developing new procedures surrounding support
• Implement new systems or enhancements by reviewing programs written by team members, establishing and executing system test procedures, developing implementation plans, developing the required program and system documentation and ensuring all functionality has been delivered as required. The incumbent is also required to provide post implementation support and training to the support staff on production processing functionality
• 1-3 years of experience developing with ETL (Extract, Transform, Load) in large data volume environments
• UNIX/Shell Scripting experience
• Working knowledge and experience with SQL, UNIX/AIX, Java/J2EE, XML, MQueue, SOA, WebSphere, Rational suite, UML, Schedulers and HP Quality Centre
• Excellent interpersonal and communication skills in order to effectively liaise with business users, members of project team, and technology partners
• Develop cost effective and efficient applications to meet business objectives by analyzing user requirements, providing technical specifications and design and developing/maintaining programs according to standards. The incumbent must ensure programs and applications developed meet the high availability, integrity and reliability of the on-line transaction processing environment
• Provide production and user acceptance testing support to assigned applications by identifying, evaluating, escalating, resolving problems and supporting other team members. The incumbent is required to carry a beeper approximately 50% of the time to ensure systems support is readily available and that systems are operational according to documented user service level agreements
• Implement new systems or enhancements by reviewing programs written by team members, establishing and executing system test procedures, developing implementation plan, developing the required program and system documentation and ensuring all functionality has been delivered as required. The incumbent is also required to provide post implementation support and training to the computer operations staff on the production processing functionality
• Assist project leader or Manager by supervising more junior staff, providing backup support to the Project Leader or Manager, assisting with the development of detailed workplaces and monitoring progress against plan
• Keep current on rapidly changing technological trends, self teach new technologies and maintain an understanding of the Division’s business and technology strategies
• Experience using multiple operating platforms, such as UNIX and Linux
• Strong Relational Database experience; DB2 preferred
• Strong understanding of business systems analysis and development, and working knowledege of data processes and Reporting /Business Intelligence solutions
• Excellent analytical, problem solving and trouble shooting skills in order to develop and support systems to meet user requirements. The incumbent must be creative and flexible in identifying technical solutions to resolve business problems in a rapidly changing, demanding and complex business environment
• Excellent interpersonal and communication skills in order to deliver proposals, provide user support and interact with team members and other departments
• Good debugging, testing, coding, and productivity tools experience
• Banking or Financial industry experience is a nice to have

Etl-developer Bangalore Resume Examples & Samples

• Architect, design and implement and test back-end components of an n-tier application, including data model, data access objects, and application logic
• Minimum of 5-7 years of experience in Application Development using Informatica
• Minimum of 5-7 years of experience in writing SQLs (Proficiency in Stored Procedures, Triggers, Batch processing and Performance tuning is a must)
• Minimum 5-7 years of experience with ORACLE (Sybase also is a plus)
• Strong technical, analytical, problem solving, and communication skills
• Experience with SVN Source Code management techniques/ tools for software management, Knowledge SDLC tools (JIRA)
• Experience in Investment Management Technology applications preferred
• Conducts research into new data warehouse applications and determines viability for adoption
• Assists in several components of the overall architecture of the data warehouse system
• Performs quality assurance testing of data integration and report development. Monitors data load operations to ensure accuracy
• Assists and/or provides limited direction to lower level technical personnel
• Five or more years of experience in data management or computer programming
• Experience working with company database and statistical software
• Experience working with data warehousing standards, strategies, and tools, preferably Datastage
• Develops internal systems for data integration and reporting
• Conducts analysis and gathers requirements from internal stakeholders and customers
• Maintains communication with internal stakeholder on progress and deadlines
• Establishes excellent working relationships and promotes teamwork within geographically dispersed teams
• Accountable for delivering on commitments and managing time effectively with minimal supervision
• Three plus years of database or ETL development using either SQL Server, SSIS, MySQL or Redshift
• Experience with performance-tuning and troubleshooting

ETL Developer / Consultant Resume Examples & Samples

• Ability to travel and work at the client site
• Proven communication skills both with client and internally
• Excellent presentation and documentation skills.Yes
• Perform enhancements to existing applications
• Candidates should note that this list is not exhaustive and duties are liable to change from time to time in line with the
• Strong OOP development experience, E.g. Java, Spring, Hibernate, Java Script like JQuery, extJS, Web services
• Knowledge of MS SQL Server or Oracle or DB2 including complex queries, DDL/DML and stored procedures
• Knowledge on webservers like IBM Websphere ,or BEA Weblogic or JBOSS or Tomcat
• Proficient at UNIX Solaris/Linux and MS Windows. UNIX Shell Scripting
• Good understanding of full software life cycle development processes and Configuration Management SVN
• Knowledge of Financial sector is a plus
• Excellent analytical, communication and co-ordination skills
• Excellent Java designing skills - Design patterns
• Extract and manipulate data to be used in presentable reports and analytical tools
• Develop productivity models to be used in performance management
• Develop predictive models to complement intraday forecasts and support capacity planning activities
• Define business rules for new metric development
• Understand work drivers in the customer facing groups
• Recommend time utilization plans based on forecasts
• Produce and communicate results on a monthly / weekly basis
• Prepare presentations for the senior management team
• Ad-hoc analysis
• Must be proficient in MS PowerPoint and advance skills in MS excel
• Experience using SQL
• Exceptional writing, communication, and presentation skills
• Highly analytical and curious
• Proven experience in working with load predictions and completing statistical analysis
• Demonstrated problem solving skills
• Ability to influence internal and external teams
• Confident and demonstrated strong leadership
• Ability to adapt to a fast paced environment with high tolerance to change management
• Comfortable in working in a virtual environment (i.e. conference calls)
• Self motivated, autonomous
• 2 years of customer facing (call centre) management experience in service provisioning or a service assurance field
• Experience with Visual Basic for Applications (VBA)
• Experience using ETL management tools such as SAS, EG, or PENTAHO
• Experience creating performance dashboards and scorecards using business intelligence dashboards (i.e. Cognos, MicroStrategy, Tableau, or MS Excel)
• Bilingualism is an asset (English and French)

Finance ODS ETL Developer Resume Examples & Samples

• Adherence to Development Life Cycle, IT controls and change control policies for all developments
• 4-5 years of experience of Java development
• Good understanding of database development and SQL queries
• Experience of Unix scripting
• Experience in Agile/Iterative development methodologies, with an aspiration to learn and work on new technologies
• Informatica or any other ETL tool experience would be beneficial
• Cognos report development experience would be beneficial
• Experience of working with Autosys scripting would be desirable
• Good English skills, both verbally and in writing
• Websphere Message Broker
• Lotus Notes interfaces to Data Stage
• FileNet experience
• PureXML it is must have for the other one
• Websphere Application Server
• Manages development resources by assigning design, development and testing tasks and ensuring resource adhere to previously agreed to timelines communicating status
• Evaluates the integration a various data sources like Oracle, SQL server, VSAM and sequential files into staging area and recommends and/or implements efficiencies
• Develops ETL processes using Informatica, ETL control tables, error logging, auditing, data quality, etc
• Implements data cleanup procedures, transformations, scripts, stored procedures, and execution of test plans for loading the data successfully into the targets
• Understand reusability, parameterization, workflow design, etc
• Work on key development projects ensuring timely delivery
• Participate in technical discussions representing EMEA finance technology
• Work closely with other IT development function and ensure all deliverables from the requirements are met
• Interface with Finance and Regulatory business analysts and translate business requirements to Functional and technical specifications
• Adhere to SDLC and Software Quality standards always
• Oracle (Sql, Plsql)
• Good working knowledge of Project lifecycle methodologies
• Experience on Data warehousing applications, preferably with a bank or financial Institution using Ab Initio. Any other ETL tool knowledge is advantage
• Strong knowledge of English
• Ability to develop relationships with peers in business unit and risk management groups
• Skills to handle multiple work streams and ad-hoc tasks simultaneously
• Component Software Design & Development
• Participating in agile development projects
• Mentoring technical development team on optimal utilization of Big Data solutions and Apache Open Source Software
• B.S. in Computer Science
• Experience Delivering End to End Solutions in the Enterprise Space
• Fluency in Java is required
• Strong foundation of OO Design & Enterprise Architecture, Design Patterns, and Unit Testing
• Experience going from whiteboard concept to delivery of Service Oriented Architecture
• Experience with Database integration
• Experience with Linux platforms
• Experience with MPP platforms
• Experience with Hadoop and Map/Reduce development
• Experience with NoSQL technologies is a plus
• Experience with Name-Value and Columnar data stores is a plus
• Ability to work with the team and the business to identify business problems and design excellent solutions
• Experience in multi-threaded application development
• Experience with large data processing solutions
• Experience with Data Virtualization Solutions is a plus
• Experience with application development frameworks
• Knowledge with Maven and Jenkins
• Excellent quantitative and analytical skills
• Proven ability to prototype and develop in short cycles
• Excellent intuition as to how to design and implement distributed systems for Enterprise use
• Ability to work well independently
• Ability to develop use cases and software test plans
• Ability to properly stress test software
• Ability to work productively and efficiently in an agile environment
• Proven ability with R&D activities

ETL Developer Intern Resume Examples & Samples

• Collaborate with product development teams and senior designers to develop architectural requirements to ensure business requirements are met
• Develop & unit test Informatica ETL processes for optimal performance
• Maintains responsibility for unit testing and collaborates with other IT staff to ensure smooth deployment and ongoing management of the product
• Major: Computer Engineering, or a related field
• Experience with Informatica Metadata Manager (9.1 or above) to capture technical and business metadata and build out data lineage
• Expert in data warehousing methodologies and best practices required
• Plus-experience with Hadoop, MAP-R and Big Data
• Ability to work independently and in group settings
• Desire to enter the Media / Technology / Advertising industry upon graduation and passionate about innovation
• Design/development of enhancements for the existing flows
• Design/development of new functionalities/flows
• Ability to understand and develop business requirements and create design to meet those business requirements
• Development experience in IBM DataStage is a plus
• Works with external vendors and internal business and technology staff to accurately gather and interpret requirements, specifications, and database models to determine appropriate ETL development solutions
• Develops ETL technical specifications and recommends, designs, develops, tests, implements, and supports innovative and optimal data solutions
• Works with the Data Services and Business Intelligence team to design, implement, and support end-to-end data solutions across multiple platforms, environments, domains, and locations
• Integrates ETL development with existing codebase to maximize object reuse
• Performs tasks required to conform to the company’s configuration management and software release processes
• Monitors and administers ETL jobs to verify execution and measure performance
• Works with internal team, vendors, consultants, and external partners to quickly identify and resolve data integration and ETL job issues
• Assesses and documents the structure, quality, and compliance of source data and coordinate with business and technology teams to identify and resolve issues
• Minimum three years experience designing, developing, testing, and implementing ETL solutions using enterprise ETL tools (experience with IBM DataStage/QualityStage is preferred)
• Minimum two years experience developing and implementing data integration and DW solutions in an Oracle 11g/12g database environment (experience with Netezza preferred; experience with DB2 is a plus; experience with Oracle EBS is a plus; experience with Salesforce is a plus)
• Minimum one years experience working with high volume data exchange and transaction processing systems, preferably in a custom software development environment
• Understanding of Oracle RDBMS
• SQL and PL/SQL development skills in a multi-tier, SOA environment are required
• Proficient in flat file formats, XML within PL/SQL, and file format conversion
• Proficient in web services development
• Understanding of SDLC and Agile Methodologies
• Understanding of model driven development
• Understanding of ETL best practices
• Hands-on experience with design and development best practices
• Proficient in working with technical and business teams to extract and document data integration/exchange requirements
• Develop ETL and related components as specified in the design, functional and non-functional requirements within established time and quality standards
• Perform unit testing of ETL and related components and document test results
• Conduct or participate in code reviews to ensure quality, standards compliance, reusability and ease of maintenance
• Correct testing defects and support all testing phases
• Participate in maintaining the integrity of the source code by applying the appropriate retrofitting (in-flight projects) timely and using a version control tool
• Participate in the deployment preparation tasks such as packaging and documenting deployment instructions
• Support a positive work environment that promotes service to the business, quality, innovation and teamwork and ensure timely communication of issues/ points of interest
• Work effectively as a team, supporting other members of the team in achieving project/business objectives and providing client services
• Participate in knowledge transfer within the team and business units and keep current with leading-edge technologies trends
• Continuously enhance knowledge / expertise in own area and keep current with leading-edge technologies trends
• Identify and recommend opportunities to enhance productivity, effectiveness and operational efficiency of the business unit and/or team
• Experience in SDLC- Waterfall / Agile
• Experience in environments like Unix, Linux, Windows IIS, Data Warehouse (DHW) etc
• Working knowledge in application design concepts
• Working experience in C++ is a plus
• Able to contribute to Automation, Causal analysis and Develop shared/common solutions
• Work with the business end users to understand requirements and come up with a solution within the team
• Analyzing and documenting problems, recommending solutions, and initiating corrective action
• Minimum 4-5 years of financial application development/consulting experience including Reconciliation business
• Hands on development knowledge of Informatica

Lead Integration / ETL Developer Resume Examples & Samples

• Troubleshoot, optimize and tune ETL processes
• Determine the structure of data; experience in data analysis
• Handle multiple work related tasks
• Plan and coordinate project work stream development and deployment
• Manage assigned resources per company’s methodology and processes

Senior Integration / ETL Developer Resume Examples & Samples

• Build, review and analyze the ETL requirements
• Document all ETL related work per company's methodology
• Develop mapping / sessions / workflows
• Write and optimize SQL code (TERADATA 12.x AND ORACLE, 10 or 11 a MUST) and stored procedures
• 24x7 On-Call Support Rotation

Oracle Data & ETL Developer Resume Examples & Samples

• Consult with other business areas to create cost benefit analyses and prioritize current projects
• Collect, analyze and communicate competitive intelligence to influence network development strategies
• Support technical analysis by maintaining databases of network cost and competitive intelligence data and developing data extracts for routine and special studies
• Prepare and present recommendations to both internal and external audiences
• Resolve general issues and defects within Infra (Humana's Service Operations Issue Tracking system)
• Bachelor’s degree in Information Technology, Business, or related fields
• Prior experience in data management, data extraction and data reporting
• Comprehensive knowledge of relational databases and programming
• Comprehensive knowledge of ETL tools and data integration methodologies
• Oracle 12c or Exadata SQL tuning knowledge
• Informatica’s PowerCenter development knowledge
• SSIS and SSRS development experience
• .Net w/MVC or Java UI development is a plus
• Experience with healthcare information technology
• Collaborating with business users, solution vendors, and IT service managers, to define solution requirements for data acquisition, apply transformations, determine data quality, enforce data integrity, and define destination repository structures
• Acting BODS administrator responsible for setup of new users, client environment, managing configuration parameters for adapters, and working closely with SAP system administrators
• Production support for existing ETL applications involving debugging, data analysis, change management, and support documentation

Graduate ETL Developer Resume Examples & Samples

• Bachelor or Master degree (Mathematics, Computer science, Information Technology, Engineering, Economics, Management)
• A Graduate professional with relevant experience 0-2 years after university graduation
• Understanding of Oracle PL/SQL and/or MS SQL T-script
• The right attitude, Communication, Creativity, Problem Solving, Taking Ownership, Teamwork and Collaboration
• Flexibility to travel in Slovakia, as well as internationally
• Gathering, documenting, examining and managing data integration and data management requirements in an Agile/Scrum development team
• Building extensible data acquisition and integration solutions using various integration tools (Informatica, Pentaho, Ab>Initio, IBM DataStage, Kafka, Flume, etc.) and a variety of data environments (Hadoop, Oracle, Mongo, etc.)
• Optimising data integration platforms to provide optimal performance under increasing data volumes and complexity
• Creating test plans and scripts for data integration/data model testing, ranging from unit to integration testing
• Liaising with other technical areas, conducting technology research and evaluating software required for maintaining the data management environment
• Minimum 2 years development experience
• Bachelor’s degree in Computer Science or equivalent discipline
• ETL - Ab Initio GDE and Co>Op
• UNIX/Linux Shell scripting
• Oracle concepts, SQL, PL/SQL
• SQL performance tuning
• Prior industry experience with Reference Data
• Java EE: Servlets, JSP and EJB
• Perform source to target data mapping
• Review and assess business rules, project plans, development and test specifications
• Plan, schedule and coordinate changes internally and externally
• Provide on-going maintenance and support of production ETL processes. Monitor production processes and respond to errors and emergency issues
• Collaborate with business units to provide information as appropriate
• Skills:This job requires advanced knowledge and expertise in commercial software, tools and systems required to develop and maintain ETL. Additionally required are skills in analysis, critical thinking, problem solving and trouble shooting, oral and written communications and presentation and expertise in data profiling and data quality concepts and techniques
• Responsible for design, develop and maintain ETL jobs using the tool

Senior Oracle / ETL Developer Resume Examples & Samples

• A challenging position with responsibilities to develop and test robust software for the Treasury DWH
• Working on high-visibility projects related to regulatory and business requirements especially in the area of Liquidity Management
• The chance to learn datawarehousing technologies in a complex and time-critical environment
• Working in an agile environment
• Communication with the different teams within Credit Suisse
• Involvement at a global level in a multi-cultural team
• Ensuring that common standards, processes and tools are adopted across own deliverables
• Knowledge of RDBMS
• Interest in learning KDB/q
• Informatica Power Center 9.x
• Strong communication skils to be a liaison between Asia users/program management and developers
• Knowledge of equities and fixed income securities such as stocks, indices, options, bonds, swaps, futures, repos, etc

CIB IS Data Platform ETL Developer Resume Examples & Samples

• Design, build and testing complex Oracle Store Procedure/ Function/SQL and UNIX scripts
• Help with the tuning existing Store Procedure/ Function/SQL
• Review AWR reports and able identify bottleneck area and work with solution
• Troubleshoot errors as they occur
• Be a subject matter expert, with knowledge of all versions Oracle DB schemas
• Used Autosys for scheduling the jobs
• Guide junior developers with best practice and tuning technique
• Ability to multi-task and comfortable with quickly switching from one task to another
• Involved in Reviewing the Code developed by other team members with in the project
• Review all the coding and naming standards
• Train other team members as needed
• 4-5 years PL/SQL development and rational Database
• 2-3+ years as Application DBA
• Experience with Oracle 11g and 12c
• Familiar with with RMAN and other Oracle backup/Restore methods
• Experience using Oracle Enterprise Manager for monitoring and maintenance
• Ability effectively tune SQL and PL/SQL queries
• Experience on projects utilizing Agile methodology a strong plus
• Must be hands on ETL tools like Informatica,SAP BODS, ODI, SQL and procedural SQL languages
• Should have completed at least 1 full life cycle experience in a ETL project
• Understand and assess the Source to target map documents and provide the recommendations if any
• Must be hands on Unix scripting
• Good exposure to SSIS, SSRS, SQLServer, DB2, Oracle, Teradata
• Must be hands on SQL and procedural SQL languages and ETL tools like Informatica,SAP BODS, ODI etc
• Should have completed at least 2 full life cycle experience in a ETL project using any tools like Informatica, SAP BODS, ODI
• Must have at least 4 years of deep experience in ETL tools
• One life cycle implementation using any of the Data Quality tools like SAS Dataflux or Informatica DQ would be an added advantage
• Must be able to analyse, design and develop ETL mappings, workflows
• Need to work as a Senior team member to contribute in various technical streams of EI implementation project
• Design, build and unit test the DI application modules with Abinitio, DB2/scripting, K Shell scripting & Control M scheduling
• Perform development activities such as Source to target mapping validations, identify, document and execute unit test cases/scripts, peer and lead code reviews per code review checklist and document test and review results
• Be part of the ‘Run the Engine’/L2 application support activities and incident resolutions in Production
• Collaborate with BA’s, data architects, application leads, QA analyst and production support, through SDLC
• A minimum of 8 years of IT based software development experience
• A minimum of 6 years of data integration experience developing DI Applications using Abinitio or Informatica
• A minimum of 1-2 years of working experience with DB2
• A minimum of 1-2 years of experience developing Abinitio continuous flow components in support of mission critical applications is preferred
• DI architecture and data modeling experience

Pentaho / ETL Developer Resume Examples & Samples

• Develop and enhance software application modules specific to ETL
• Must have at least 2+ years of recent Pentaho experience
• ETL developer with data warehouse/datamart experience in the financial industry
• Experience working with Informatica, Pentaho, AbInitio or other third party ETL tools
• Good working knowledge of Unix and Unix Shell scripting
• Involvement in all parts of the project lifecycle
• Private Banking technology experience a plus
• Creating Automated Unit Tests using Flexible/Open Source Frameworks using a Test Driven Development / Behavior Driven Development approach
• Digesting and understanding Business Requirements and designing new modules/functionality which meet needs
• Utilize agile methodologies and adhere to coding standards, procedures and techniques while contributing to the technical code documentation
• 7+ years of solid IT experience with at least 5+ years in Informatica
• Responsible for the design, coding, testing, tuning and maintenance of DB2 datamarts and Informatica code
• Work directly with Modelers/Architects/DBA on data modeling, logical/physical schema design, SQL query tuning; and the application of data-related business rules while assisting in troubleshooting, debugging, and issue resolution
• Communicate effectively with end users, peers, and management regarding assignments, and must have a can-do attitude and a desire to provide solutions
• Provide support for the resolution of all reporting issues escalated by the Support Operations Team post-implementation
• Working with global development team to have designs implemented, tested, productionalized and present to user groups
• Used Autosys for scheduling the jobs and to automate the ETL process
• Work closely with business partners throughout the requirements gathering, technical design and development lifecycle phases
• Document functional/technical specifications
• Participate in design, implementation and peer reviews
• 1-2 years of experience in IBM InfoSphere DataStage or other ETL tools (Informatica PowerCenter, Pentaho and etc)
• Analytical & trouble shooting skills required
• JAVA and WebSphere MQ strong plus
• Informatica Developer will design, develop, implement and support enterprise initiatives around data integration and building a data and reporting infrastructure
• This position is primarily responsible for data analysis, Developing and maintaining Informatica ETL processes along with a rotational on-call production support responsibilities
• Create and maintain SQL Server databases, stored procedures, tables, views, and functions to support application and ETL initiatives
• Develop and maintain the database architecture for specific projects as needed
• Plan and develop data ETL procedures, and secure data transfer processes
• Utilize mature (3rd or 4th Generation) programming methodologies and languages and platforms (TM1, Java, SQL, big data- near future) and adhere to coding standards, procedures and techniques while contributing to the technical code documentation
• Incorporate Architectural Standards into application design specifications
• Translate technical requirements into programmed application modules and develop
• Identify application code-related issues
• Minimum 5+ years experience in coding, testing and or debugging skills
• Minimum 5+ years experience in informatica
• Experience working with large scale/enterprise wide Data Warehouse and Business Intelligence projects
• In depth knowledge of data mart design and dimensional modeling
• Minimum 3+ years experience in creating stored procs, tables and functions in SQL server
• Unix shell or PERL scripting experience is a plus
• Experience with other Data Integration tools like Pentaho is a Plus
• Knowledge of reporting or Analytical tools a Plus
• Bachelor's degree in MIS, Computer Science, Statistics, Business or equivalent work experience
• Extensive hands on Application Development experience throughout the entire project lifecycle
• J2EE experience (SDK 7 and above)
• Gang of four and J2EE design patterns
• Experience on spring and hibernate framework
• Web development with jQuery – knowledge of Angular JS/backbone/nodejs would be an advantage
• SQL development - They will be expected to write complex queries, procedure, functions, dynamic sql that are scalable
• Have worked in Agile development environment
• Experience in working with Build management tools – Ant or Maven
• Experience on continuous integration tools like Jenkins, bug tracking tool jira, and code repository svn
• Experience on Test Driven development
• Ability to attain results, convey a sense of urgency and drive issues to closure, persists despite obstacles and opposition, sets high standards of performance and pursues challenging goals
• Strong interpersonal skills; promoting healthy relationships and team dynamics
• Customer or end-user focused and has ability to manage expectations
• Good knowledge of industry best development practices
• Familiarity with metadata tools and management
• Strong knowledge of Windows server environment
• Proven ability to work independently
• Strong leadership and influencing skills
• Knowledge of Git
• Experience on Restful webServices
• Knowledge of BDD
• Experience on Reverse proxy server like Apache
• Develop, maintain, and administer complex ETL processes using MS SQL Server 2005/2008/2012 (DTS and SSIS), Ab Initio
• Provide thought leadership on data and system architecture, system administration, schedule management, performance tuning, and expansion
• Participate in ongoing DW/BI performance tuning activities
• Develop, troubleshoot and fine tune existing and new reports
• Evaluate and implement products and implement best-practices to enhance our BI/DW solution
• Provide expertise on decisions and priorities regarding the enterprise’s overall data warehouse architecture
• Facilitate the development of data integration efforts with the development team
• Expand the company’s use of data as a strategic enabler of corporate goals and objectives
• Establish methods and procedures for tracking data quality, completeness, redundancy and improvement; and processes for governing the identification, collection and use of corporate metadata to assure metadata is accurate and valid in the business intelligence environments
• Be able to define requirements, analyze data, design solutions, program, test, implement, and train end-users and fellow IT team members
• Bachelor's degree in Engineering/Science in Computer Science or Information Technology/Systems
• 3-5 years of experience developing, maintaining and administering Teradata, MS SQL Server databases
• Experience with Business Intelligence and Data Warehouse products
• Hands on ETL experience with Ab Initio
• Relational and Dimensional data models
• Strong software logic design, analytical/analysis and problem solving skills
• Excellent team player and ability to work in a highly-dynamic environment
• Excellent communications and interpersonal skills, including ability to interact and communicate within IT and Business teams
• Proven track record as a self-directed, energetic, individual contributor
• Design and document ETL process for new DW subject areas
• Create data extraction, cleansing and load programs to move data into and out of the data warehouse
• Develop, implement and maintain schedule/dependency logic for automated ETL processing. Develop monitoring, logging, and error notification processes to ensure data is updated as expected and processing metrics reported
• Accountable for conforming to established architectural, developmental, and operational standards and practices including creation of ETL metadata
• Assist in the maintenance and administration of applications and software used by the ACE foundations team
• Evaluate and recommend database development tools
• Assist in application and database performance tuning
• Participate in system architecture design
• Implement integration and interface tools between transactional and data warehousing systems
• Work with quality assurance to assist with unit and integrated testing
• Share trouble-shooting and maintenance duties
• Four years experience in SQL, database programming and utilities (preferably Oracle)
• Knowledge and experience in relational and dimensional database design techniques
• Experience developing applications in Windows and UNIX operating environments
• Experience with data modeling required
• Experience with developing sound technical documentation
• Experience with data warehousing systems design and development a plus
• DataStage experience desired
• PL/SQL, Perl, UNIX desired
• Experience within the health care realm preferred
• In depth knowledge and experience with ETL development and applying sound ETL techniques and modular system design skills
• Ability to identify and resolve data quality issues within the ETL realm
• Understanding of basic DBA skills such as, physical modeling, table partitioning and indexing
• Knowledge of system architecture design
• Create data extraction, cleansing and load programs to move data into and out of the Data Warehouse
• Assist in the maintenance and administration of applications and software used by the ACE Foundations team
• Work with Quality Assurance to assist with unit and integrated testing
• 5 years experience in SQL, database programming and utilities
• Excellent analytical skills required
• Previous experience with data warehousing systems design and development a plus
• Previous experience with data modeling required
• In depth knowledge and experience with ETL development and applying sound ETL techniques and modular system design skills are essential
• Experience with developing sound technical documentation is required
• Understanding of and experience with basic DBA skills such as, physical modeling, table partitioning and indexing is required
• Bachelor’s degree from an accredited college or university in Computer Science, Computer Information Systems or related field
• 7+ years in IT related field
• 5+ years Data Warehousing and Business Intelligence experience
• 5+ years of technical experience relating to ETL design, development, performance and validation
• Direct experience with enterprise data warehouses
• Ability to analyze clinical and business source systems on a variety of platforms
• Experience with healthcare data from EMRs like Epic
• Experience with any type of -omic data
• Experience a variety of ETL development tools, e.g., Informatica, SSIS, Talend
• Experience with Oracle Enterprise Health Analytics or Google Cloud Platform components
• 3 years' experience
• Working with ETL toolset in Enterprise Data Warehouse and with Enterprise Integrations environment
• Working with Informatica Power Center
• 1 year experience
• Working with Teradata (ETL and BTEQ scripting)
• Scheduling tools (Tidal and AutoSys)
• Working with BW/SAP extraction (ETL); and
• Working with SAP AFS data including Sales Orders, Purchase Orders, Materials and Inventory
• Over all 4 to 8 years ETL experience
• Understand user requirements and provide solutions using ETL tools – Informatica power center and Teradata scripts (BTEQ/Multiload/TPT/Fastload/Fastexport) along with Unix and shell scripts
• Having good amount of experience in Analysis, design, Coding and Data validation cycles
• Design, Develop, Test ETL programs and scripts to acquire data from the source systems and loading in to enterprise data warehouse by writing transformation views
• Strong Hands on experience-Teradata SQL
• Ensure product quality and completeness of unit testing and documentation
• Ability to understand and document requirements
• Able to deploy and implement the codes according to the functional specifications in SIT/UAT and Production
• Experience with software configuration management and release processes
• Knowledge and understanding of data warehouse fundamentals and architecture
• Excellent written and verbal communication and presentation skills
• BS/MS EE/CS degree or equivalent
• Candidates must have hands on expertise designing high volume repeatable ETL processes for large enterprise software and developing very complex data transformations
• Candidate will be responsible for the design, development and support of secure and efficient ETL (Extraction, Transformation and Loading) components, which will be used to move large amounts of data from source data and software application data stores into the optimized operational databases
• Working with technical and/or business teams to extract and document data integration/exchange requirements
• Tuning the ETL processes
• Leading and/or participation in technical design sessions and development of related technical project artifacts (including technical and system documentation) necessary to support ETL processes including well tested, detailed deployment documentation
• Participation in development and execution of unit, system and user testing
• Completion of applications development by coordinating requirements, schedules, and activities
• Stakeholder management with different interfaces of ETL and Reporting
• Collaboration with teams (onsite and offsite)
• Troubleshoot development and production problems across multiple environments and operating platforms
• Design and develop ETL jobs used to process the data from our clients
• Propose architectural improvements and implement overall systems designs for internally hosted platforms using ETL, Database, and Business Intelligence tools
• Write ad hoc SQL queries to troubleshoot and for unit testing the data loads
• Assist with database design and modeling used to manage our data as a resource
• Responsible for ensuring Continuous Delivery and Release Management of all components works smoothly in an automated fashion
• Responsible for design, maintenance, and monitoring of UNIX infrastructure for availability, stability, while providing good response time to our end users
• Provide support in monitoring, back-ups, reporting, problem identification and mitigation, and service improvements
• Keep up to date with the newest technologies by continuing research and learning
• Mentoring colleagues as new processes and tools are introduced and retired
• Experience with ETL tools such as Pentaho or Talend
• Experience with SQL and/or non-SQL databases as Postgres, MongoDB
• Experience with Reporting Tools as JasperSoft, Highcharts or Tableau
• Experience with Data Management best practices, including multiple data formats
• Experience with Agile software development, teams, CI/CD, delivery tools, and best practices
• Experience with UNIX OS distributions (Centos/SUSE/Redhat) and shell scripting (bash, ksh), Perl, Python, etc
• Experience with UNIX software installation processes, systems monitoring, daily operational activities, first level support, detection of issues, and abnormal systems behavior
• Ability to perform initial problem identification, categorization, and incident notification
• Desirable experience with OpenLDAP or Liferay operations
• Java Development experience is a plus
• Strong automation, problem-solving skills, and ability to follow through to completion
• Bachelor’s degree (or equivalent) in Computer Science, Information Systems
• 1-3 years of experience in ETL/BI domain highly desired
• Strong team-player
• 10+ years’ experience in a consulting or cloud development organization with at least 2 years’ experience in a SaaS environment
• Excellent skills in analyzing and debugging the capabilities of Kettle Community/Enterprise Edition
• Demonstrated ability to evaluate architectures and designs,
• Experience developing ETL for cloud solutions
• Must have skills : Kettle (3-4 years), Java, XML, SQL, and SVN
• Demonstrated ability to work on any two or more of the following technologies: JBoss / Tomcat, SQL Server / Oracle / DB2, RedHat Linux, Windows
• Demonstrated strong verbal and written communication skills
• Experience working in a self-directed, independent capacity
• Demonstrated ability to work collaboratively with different geographic and functional groups

Senior Big Data ETL Developer Resume Examples & Samples

• At least 7 years experience within a total information technology (IT) environment
• At least 5 years experience with design, development, automation, and support of applications to extract, transform, and load data
• Strong communication & problem management skill. Able to communicate clearly and concisely across different levels of management
• Any scripting language such as Python & R
• Application development tools
• At least 2 years experience with Informatica PowerCenter
• Technical troubleshooting
• Unix/Linux shell scripting
• Must have extensive experience in java server-side development including multi-threading programming and service-oriented architecture
• 3+ years of hands-on programming experience in design and coding of commercial application using Java
• Experience developing data access and APIs for distributed applications
• Experience with low-latency platforms
• Hands on experience with JDBC/ODBC
• Experienced with ORM technologies
• Good knowledge of XML/XSD, JSON and related technologies
• Have basic SQL and general knowledge of TCP/IP
• Experience with iterative SDLC such as Agile, SCRUM, Test-Driven Development
• Effective written and verbal communication skills required
• Proven ability to solve problems
• Must be highly motivated, to work independently or on a team and drive solutions with minimal supervision
• Ability to work productively in a globally distributed development team
• Analyzes and evaluates existing or proposed systems, and devises computer programs, systems and related procedures to process data
• Encodes, tests, debugs and installs the operating programs and procedures in coordination with computer operations and user departments
• May train junior level personnel in technical complexities of assigned work
• Reviews progress with management
• Extensive hands-on experience with configuration of MDM platforms, including data model development, data steward UI configuration, source integrations, and export/target integrations
• Experience with API based transaction and bulk integrations with cloud based platforms
• Extensive background developing ETLs and integration of MDM platforms with data warehousing environments
• Deep understanding of MDM designs and implementation strategies
• Excellent communication verbal and written communication skills are a must
• Experience with Cloud Based MDM platforms that utilize API based integrations: Reltio, Informatica Cloud MDM/Data Scout, Talend
• Experience with API based transaction and bulk integrations utilizing Mulesoft
• Experience with ETL tools such as Microsoft SSIS/DTS, SAP Data Services, Informatica, Data Stage
• Experience with cloud based data cleansing / prep platforms such as Informatica Rev, Paxata Rev, etc
• Experience working with cloud based hosting platforms such as Microsoft Azure and/or Amazon AWS
• Serve as development lead on Solution Design and Delivery team with healthcare measurement and engagement portfolio (HCME)
• Acting in a technical SME role, support development, QA, and production support teams in SDLC and operational activities
• 5+ years of experience in IT systems analysis, data analysis, software design, or a combination of roles within the SDLC lifecycle
• 3+ years of recent hands-on experience with ETL toolset in Unix/Linux environments involving data management (Data Stage or Talend preferred, but other ETL tools considered)
• 1+ years of Teradata experience (must have worked with Teradata within the last 1 year)
• 2+ years of experience writing and tuning the SQL queries and stored procedures with relational databases
• Excellent understanding on data warehousing concepts (ELT) and worked in an enterprise data warehouse environment with large volume of data processing
• Typically 8-10 years of relevant work experience
• Clear understanding of IT infrastructure and its components
• Knowledge about varied ETL tools (Ab Initio, DataStage, Informatica, Talend) and other BI tools (Cognos, MicroStrategy, Tableau)
• Work with cross functional teams ( Support teams for platform, applications, Project Managers)
• Ready to take additional responsibilities
• Ability to acquire skills on own
• Coaching and mentoring for Level 1 and Level 2 engineers
• Independently generates solutions based on analytical, technical skills and business knowledge
• Ability to articulate and compare alternative approaches
• Strong ETL background (SPSS, Informatica, Etc.)
• Extensive Linux/UNIX server experience (from a production support perspective)
• Data integration/data warehousing experience

Atlanta Data & Analytics ETL Developer Senior Consultant Resume Examples & Samples

• Strong project management and client relationship skills
• Prior management and direct supervisory experience in a team environment
• Self-starter and can operate independently as needed
• A high threshold for ambiguity and lack of structure and process during early phases of engagements
• Creative and logical problem-solving abilities
• Excellent leadership, interpersonal, and team building skills
• Mentoring and people development capabilities
• Advanced listening skills and written and verbal communications
• Ability to multi-task and maintain professional demeanor under pressure
• Organization and time management expertise
• Proficient in Microsoft Office suite applications with specific emphasis on Access, Excel, Visio and PowerPoint
• Prior experience working in either Data warehousing or Business Intelligence
• Experience with any major ETL vendor, such as SSIS, Informatica, Data Stage, etc
• Experience designing and implementing data models for applications or reporting
• 3+ years working with SQL including intermediate to advanced knowledge on DML / DDL
• Experience with any of the major Business Intelligence reporting tools, such as BusinessOjbects, Hyperion, Cognos, Microstrategy, Tableau, QlikView, or SSRS
• Experience working within a Microsoft SQL Server, MySQL, Oracle, TeraData, or other major database management systems
• Experience with either Master or Meta Data repositories
• Experience working with business stakeholders to translate business issues into technology solutions and vice versa
• Demonstrated knowledge of technology project risks and strategies for managing and mitigating them
• Data Governance is a plus
• Travel throughout the month frequently required based on client requests/commitments
• Bachelor's degree from a 4 year college or university required
• US Citizen / Permanent resident (Sogeti does not sponsor any work visas)
• Data Stage is required
• 5+ years of deep experience as an ETL developer well-versed in ETL tool usage, architecture, design and development
• 2+ years working on projects with both onshore and offshore resources
• 5+ years working on BI/DW projects

EIM ETL Developer Resume Examples & Samples

• Participate in the development and support of an enterprise wide data transformation and movement architecture and platform
• Design, develop and test ETL applications consistent with application architecture guidelines
• Design error-processing routines
• Analyze business requirements as they relate to the ETL process, research, evaluate and recommend alternative solutions
• Transform business requirements into technical requirement documents
• Work productively in a team environment
• Communicate effectively with business and IT staff across functional departments
• Work with management and staff to establish best practice standards for ETL functions
• Lead development of new methodologies for supporting data transformations and processing in a corporate-wide ETL solution
• Provide after business hours support for production ETL systems
• Ability to create high complexity detailed technical design specifications, Develops detailed analysis, design, construction and testing specifications ensuring technical compatibility and integration
• Ability to act as a developer responsible for the planning, completion and coordination of work activity for projects involving more than one developer. Ability to lead walk though of design documents and provide technical leadership over programming team
• Strong analytical and technical aptitude
• An understanding of 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
• Demonstrate collaborative skills working within a project team of diverse skills Bring strong communication skills including oral, written and presentation skills plus creativity, and problem solving skills to a challenging environment
• Provide guidance and direction to less-seasoned staff
• Coordinate with deployment and support resources to ensure the solutions gets implemented smoothly into QA and Production environments
• Take an active role in joint solution design and be an advocate for long term quality in the process
• Experience working with multiple file structures
• Experience with complex shell scripting using Unix
• Thorough understanding of technological infrastructure and how it relates to projects
• Financial Services / Banking Industry domain background
• 5 years of experience troubleshooting performance issues
• Develop complex Talend ETL processes for integration between systems
• Design & Develop web Services in RESTful & SOAP
• Ability to break down business stories into smaller development components
• Ability to work in fast-pace, agile environment
• Gather business requirements and follow through to design and execution
• Work with other developers to implement requirements
• Responsible for software development including software, unit test plans, unit testing, QA support and post-release
• 5 years of IT experience with a Bachelor's Degree in computer related field or equivalent
• General application development (4+ years)
• Talend (1+ years preferred)
• 2+ years’ experience in developing ETL processes
• Experience in one or more of the following: Oracle / MSSQL / MySQL (2+ years)
• Java (Core, Servlets, JDBC, etc) (1+ years)
• Knowledge of integrating into Salesforce, Oracle, Unidata or BigCommerce an advantage
• Familiarity with integrating data from various sources (flat files, databases, web services)
• Data Modeling (2+ years)
• Experience utilizing and extending ETL solutions (e.g., Informatica, Talend, Pentaho, Ab Initio) in a complex, high-volume data environment
• Proven proficiency with development of high performance ETL to transform and load high volume of data
• Knowledge of Big Data technologies (e.g., Hadoop, BigQuery) is preferred
• Proficiency in the Microsoft Office Suite
• Excellent verbal and written communication skills, and ability to communicate with individuals at all levels of the organization
• Ability to prioritize and work with minimal supervision
• Strong leadership skills with a demonstrated ability to motivate and coordinate projects
• Ability to work in a flexible environment where requirements and procedures continuously evolve
• Analyze customer requirements, design and implement Informatica mappings, sessions and workflows
• Perform data analysis and develop source to target mapping specifications
• Create and maintain ETL documentation
• Interface with project teams to perform rapid development using agile methodology
• Must possess a Bachelor's or higher degree in Engineering, Information Systems, or an equivalent degree program
• Must possess a minimum of 6 years of experience with Informatica PowerCenter or ETL software equivalent
• Must possess a minimum of 6 years of experience developing Data Warehouses
• Must possess experience with Oracle databases and strong SQL background
• Must possess excellent written, verbal and interpersonal communication skills
• Must be capable of a high level of accuracy and attention to detail
• Must possess these essential qualifications: (1) ability to quickly adapt to new situations, (2) strong commitment to a team environment, (3) willingness to learn new technologies, (4) ability to resolve and clarify requests/requirements, and (5) ability to establish, maintain and follow documented processes and procedures
• Must possess or be able to obtain a DHS/CBP Clearance
• Experience with CBP
• Experience with Atlassian toolset, including JIRA and Confluence
• 6 + years' of Informatica development experience with exposure to version 9.x. Should be at or near expert level with Informatica and possess a solid working knowledge of SQL and ETL load and extract processes within Informatica
• Expected to have hands-on experience in development of complex ETL mappings that include usage of SCDs and various transformations like Normalizer, XML Parser/Transformer, Joiner, Aggregate, Expression, Filter, Router, Lookup, Procedure, and Union etc
• Hands-on development experience in Unix Shell Scripting
• Should have specialization on root cause analysis for discrepancies occurring during reconciliation of reports
• Working experience on requirement gathering, preparation of technical specification documents, design and build of ETL. Should be well aware of SDLC for ETL project
• Knowledge of enterprise scheduling tool (like Control-M)
• Exposure to reporting tool (like Business Objects)
• Team player and self-driving with excellent verbal and written communication skills
• Self-sufficient, independent requiring very little supervision or intervention a must

Software Engineer / ETL Developer Resume Examples & Samples

• Design, build, test and maintain scalable and stable off the shelf application or custom built technology solutions to meet business needs
• Contribute to the entire implementation process for new applications and enhancements to existing applications
• Meet with business partners to understand business needs
• Contribute to overall solution design
• Responsible for build and test of applications
• Conduct root causes analysis and complex performance tuning
• Bachelors degree in Computer Science, MIS, related field or equivalent experience
• Experience in data development and ETL
• Understanding of data architecture
• Python, SWL, & ETL
• Web Services, e.g. RESTful/SOAP
• Relational data bases: Oracle, SQL Server, Teradata
• Experience with call center systems
• Knowledge of data warehousing and data modeling strategies
• Knowledge of Agile development strategies
• Act as a role model to demonstrate the company's core values of respect, honesty, integrity, diversity, inclusion, and the safety of others
• Support and maintain applications using the required tools and technologies
• Provide support for applications, including involvement with the support center, network operations center (NOC), infrastructure teams, and vendors as appropriate
• Assist other personnel on assignments, including mentoring or providing on-the-job training to more junior associates
• Lead and participate in the design and implementation of large and/or architecturally significant applications
• Champion company standards and best practices
• Work to continuously improve software delivery processes and practices
• 2+ years’ experience working on systems integration, data integration and/or database design
• Experience with ETL tools, ideally experience developing in Pentaho Kettle (SSIS or Alteryx a plus)
• Strong understanding of the SQL language
• Experience with Linux / UNIX operating systems
• Program management experience-from requirements gathering through implementation
• Experience with columnar store databases (such as Vertica) and working in a massively, parallel processing (MPP) environment a plus
• Experience with Shell scripting a plus
• Experience with Customer Relationship Management (CRM) applications, Campaign Management applications, and / or Database Marketing are a plus
• Experience writing Java, J2EE, Java Applets, Object-Oriented Design (OOD), Web Programming (HTML/CSS/Java Script), Servlet/JSP development a plus
• Ability to manage conflicting priorities and deadlines
• Strong communication and client interaction skills
• BS degree (Computer Science, Engineering, Information Systems preferred)
• A Minimum of 5 years development work with Ab Initio ETL
• Strong experience with UNIX/Linux
• Strong experience with Oracle PL/SQL
• Experience Bash and/or Korn Shell Scripting
• Experience with JAVA J2EE
• Experience with TIBCO BW
• Experience with Autosys
• Good understanding of Perl
• Good knowledge of GAAP Accounting and General Ledger process is a plus
• Excellent communication skill is preferred

Doh-ssis ETL Developer / TS Resume Examples & Samples

• 5-7 years of experience as an SSIS ETL developer
• Data profiling and data modeling experience
• Strong in data warehousing concepts and techniques
• Experience creating custom reporting tables using SQL (such as fact, dimension, aggregate, slowly-changing dimension)
• Snowflake and Star Schema design
• Effective verbal and written communications skills and effective presentation skills
• Self-motivator, independent, cooperative, flexible, creative
• Strong OLAP/cube/analytical data model design expertise
• Cognos experience
• 25% of Total Work Effort: Requires 5-7 years' experience as an SSIS ETL Developer working in Microsoft SQL Server
• 25% of Total Work Effort: Knowledge of administration of SQL Server for transactional and analysis systems
• 25% of Total Work Effort: Strong cube/analytical data model design expertise (preferred)
• 25% of Total Work Effort: Snowflake and Star Schema design
• Designs, develops and monitors Enterprise Transformation Language (ETL) processes using SSIS
• Performs data profiling, ETL development and administration, and release management
• Data modeling using modeling tools and methodologies
• Gathering, documenting, and designing data requirements
• Creates and maintains the logical and physical data models for the production and Business Intelligence Data Warehouse and Data Marts
• Develops prototype views and works with business users both internal and external to refine their requirements
• Demonstrates self-reliance in researching technical solutions and product functionality
• Understanding of ETL concept and solutions
• DataStage or equivalent
• DB2 on z/OS
• As an Applications Developer, you will provide high quality technology solutions that address business needs by developing applications within mature technology environments
• Participate in code reviews and ensure that all solutions are aligned to predefined architectural specifications; identify/troubleshoot application code-related issues; and review and provide feedback to the final user documentation
• 5 + years experience in Ab-Initio coding of medium to large scale ETL applications
• Experience using Ab-Initio GDE, BRE, Continuous Flow and EME required
• Experience in UNIX operating environment is required
• Experience in Java/J2EE development a plus
• Mainframe experience is a plus
• Exposure to DB2 is a plus
• Ability to communicate at all levels of management and with customers
• Demonstrated skills both written and oral are required
• Financial industry experience and credit card or payment systems experience in large scale/high volume industry is preferred
• Good business knowledge of end to end Credit Card Authorizations processing preferred
• Healthcare Experience Preferred
• Informatica or similar ETL tools required
• Teradata or other relational database systems preferred
• Unix Experience Preferred
• Researches and evaluates alternative solutions and recommends the most efficient and cost effective application programming solution
• The ETL candidate needs to have experience
• Developing ETL jobs in IBM InfoSphere DataStage / QualityStage version 8.5 or 8.7
• Experience with importing various data sources (flat files or Database tables), editing and transforming the data to be loaded into a Database stage
• Experience with Netezza data environments
• Healthcare experience 3 to 5 years
• Good communication skills and be able to be a technical team lead for the ETL developers
• Familiar with general ETL "leading coding practices” and common coding standards. The candidate should also demonstrate good written skills to be able to write technical documentation
• Minimum of 5 years progressive experience in a large-scale development environment including all phases of a system development lifecycle (SDLC) with minimum of 3 years leadership/supervisory experience

ETL Developer Senior Resume Examples & Samples

• Analyze reporting requirements to determine development methods and development templates
• Determine the job scheduling
• Develop ETL jobs that satisfy identified model
• Create and run tests on all solutions while optimizing ETL processes
• Document all ETL processes
• Support other ETL Developers in development and troubleshooting data issues. Monitor nightly loads and troubleshoot any issues that arise
• Participate in the development of best practices in ETL development for Georgia Tech
• Education:Bachelor's Degree or an equivalent combination of education and experience
• Work Experience:Four to five years of job related experience
• Certifications:N/A
• Skills: Experience in Design, Development & Build activities. Ability to maintain technical support documentation. Experience in Project life cycle activities on data warehousing or business intelligence development and maintenance projects. Knowledge of data extractions techniques. Understanding of Linux or UNIX operating systems, file systems, shell scripting. Understanding of Oracle and/or SQL Server, data marts, database management systems and data warehouses. Knowledge of full life-cycle experience on large/complex enterprise projects. Proficiency with automated data modeling tools, business intelligence and performance management software, MS Excel. Problem solving and analytical skills. Good written and verbal skills
• Gather requirements from Business and IT teams, Identify source and target systems, Map and transform the data based on requirements
• Design SAP Data Services job flows to extract data from SAP and non-SAP systems, fine-tune jobs as necessary and schedule jobs using built-in or 3rd party schedulers
• Create and manage metadata objects
• Manage the assigned subject area in SAP BW and a SQL Server based Enterprise Data Warehouse and serve as the Point of Contact for any data needs
• Work with onsite and offshore consultants as needed
• Work closely with other team members and ensure standards are followed
• Monitor, communicate and troubleshoot issues with data integrity, data design, and technical software issues
• Effectively communicate status to IT and Business teams
• Data modeling experience in SAP HANA with some experience in tools like ERWIN or Power Designer
• Some experience in Microsoft SQL Server Integration Services
• Experience with SAP BPC
• Experience in setting up a new SAP Data Services environment
• 6+ years of experience with PostgreSQL
• 6+ years of experience with Informatica Power Center and SQL
• 4+ years of experience in the development, maintenance, and enhancement of Informatica Mappings, work-flows, and processes
• Experience with ETL development and processes from diverse data sources
• Experience with Informatica Power Exchange and Control-M at an advanced level
• Experience with data modeling concepts
• Experience with Data Warehouse, Oracle, Linux, and AIX
• Knowledge of IRS business systems and data
• Experience with the IRS
• Designs, develops, codes, tests and debugs highly complex new software products or makes significant enhancements to existing software
• Factors emerging technologies and product supportability into design and implementation
• ETL Experience- particularly the TRANSFORM aspect of data
• General familiarity populating/loading data into databases
• Scripting language experience, as well as, string manipulation experience
• User-level knowledge of Pentaho, or similar ETL tools such as INFORMATICA, is preferred
• Experience mapping datasets to a predetermined model
• Familiarity with various databases (Oracle and Netezza) and associated utilities (such as SQL Loader, SQL Developer and SQuirreL)
• User-level understanding of JIRA is helpful
• ETL tool Ab Initio experience required
• Experience utilizing SQL to create, load, and modify intermediate and data mart tables
• Experience with Unix shell scripting to create and execute SQL scripts
• Experience with a list processing tool (i.e. Group1 ,etc.)
• Strong knowledge of SQL, SAS and Microsoft Excel (pivot tables) for auditing and generating reports
• 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 Test Strategy definition and creation of test scenarios/cases for DEV(Unit Test) /SIT/UAT and execution of the same
• Works with other team members, including DBA's, Other ETL developers, Technical Architects, QA , Business Analysts & Project Managers
• 3-5 years of hands on work experience in Ab Initio (Application development)
• 3-5 years of hands on work experience in Oracle (SQL and Stored procedures)
• Good understanding of UNIX systems and shell scripts
• At least 5 years of software development experience required in Operational Data Store / Data Warehouse environment
• Must have full life-cycle experience in ETL projects, preferably in the finance industry
• Strong partnership skills to ensure the effective management of all stakeholders involved
• Experience of testing methodologies including test strategy, test plan and script creation and execution
• Defect management experience
• Hands on experience with the ALM and QTP
• Flexibility to work on different projects and support both manual and automation testing

Teradata ETL Developer Resume Examples & Samples

• Translate business, and functional requirements into documented technical and architectural specifications
• Utilize development skills to build (code) and unit test new or existing systems functionality per technical specifications, with deliverables to include code builds and documented unit test results
• Develop application support documentation as required by the application support teams for acceptance of systems changes into production
• Build and unit test production deployment packages and implementation plans for scheduled systems enhancements
• Utilize planning skills to oversee development deliverables as required to implement new systems capabilities
• Facilitate/lead reviews (walkthroughs) of technical specifications and program code with other members of the technical team, communicating design, requirements, feature set, functionality and limitations of systems/applications to team and development lead
• Contribute to and work to meet project schedules by providing accurate estimates of effort required for development deliverables by providing updates on project progress to development and project management and by escalating issues which may affect project success
• 7+ experience working with Teradata systems as developer
• 3+ experience working with ETL tools like Informatica
• 6+ experience working with UNIX & Unix Scripting
• 5+ experience designing and implementing complex applications
• 6+ strong SQL and analytical skills
• Build partnerships across the application, business, and infrastructure teams
• Develop programming specifications
• Design, code, and unit-test application code using SDLC best practices
• Complete estimates and work plans with the assistance of more senior team members as appropriate for design, development, implementation, and rollout tasks
• Communicate with the appropriate teams to ensure that assignments are managed properly and that completed assignments are of the highest quality
• Support and maintain applications using required tools and technologies
• Provide support for applications, including involvement with the Support Center, NOC, Infrastructure teams, and vendors as appropriate
• Provide off-hours support (24/7) as required
• Participate in the application technical design process
• Communicate timely status, including any potential risks/issues, to the appropriate teams to ensure that assignment releases are managed appropriately and that completed assignments are of the highest quality
• Potentially assist other personnel on assignments, including mentoring or providing on-the-job training to more junior associates
• Strive to continuously improve the software delivery processes and practices
• Bachelor's degree in information systems or related equivalent work experience in an information systems position

FCC ETL Developer Resume Examples & Samples

• Candidates must have experience in Ab-Initio(say 5+ years on Ab-Initio)
• Candidates can have preliminary Ab Initio experience but should have experience in any other ETL tool
• Strong knowledge in Extraction, Transformation and Loading (ETL) methodology
• Ab Initio (GDE, EME, Co>Op) knowledge or equivalent technology like TalenD
• Good working Knowledge of Database (Sybase and/or Oracle) and other ETL tools like TalenD would be a plus
• Strong Test Driven Development experience
• Strong in UNIX Shell Scripting
• Strong SDLC capability for medium to large projects
• Experience of Futures/OTCC or Capital Markets back office flows in general desirable
• Practical experience in analysis/design/implementation of successful projects in the Futures back/middle office area desirable
• Strong oral/written communication skills and ability to facilitate discussions
• Flexible communication style of multi-geography stakeholder groups
• Quickly grasp/master new requirements and related knowledge
• Manage tight deadlines or unexpected requirement changes
• Ability to learn/understand technical implications of system design
• Team player in solid/matrix reporting organisations
• Willingness to ask questions, challenge the process and seek out answers
• Ability to work independently, multi-task, take ownership and drive strategy
• Educated to degree standard preferable
• Exceptional candidates who do not meet these criteria may be considered for the role provided they have the necessary skills and experience

Analytics ETL Developer Resume Examples & Samples

• 4+ years ETL development using SQL Server and SSIS
• Experience planning and designing data mart/EDW/EIM projects
• Thorough understanding of typical DB design practices, ETL development including
• Proficiency in: R, Python, and/or JavaScript
• Alteryx or Talend a significant plus
• Strong knowledge of quality assurance methods and best practices
• Experience with a visualization platform (Tableau, PowerBI)
• Working knowledge of AWS/Azure, NoSQL, Oracle, SAP HANA platforms

Oracle ETL Developer Resume Examples & Samples

• Manage the full lifecycle of the Problem Management process
• Proactively identify problem trends and known error conditions and work towards a permanent solution
• Perform trend analysis based on statistical data provided by Problem Analysts, the Incident Management Team or PM Tools
• Work with design/architecture teams to ensure best practices are adopted to ensure stability and supportability of applications and infrastructure
• Responsible to provide problem resolution and document
• Ability to coordinate with multiple teams to source appropriate skills for effective problem resolution
• 5-7 years’ experience in ETL (Informatica is preferred), Oracle and related technologies
• 3+ years’ of experience in Relational database concepts, Data analysis and SQL
• 3+ years’ of robust Knowledge and implementation experience of Informatica is required
• Experienced in working with Unix and Ctrl-M jobs
• Knowledge of Optimization of the ETL and Oracle Pl/SQL is a plus
• Ability to work in agile kind of environment
• Understanding of Collateral business domain is a value add
• Understanding of capital markets and investment banking regulations is a value add
• Bachelor or graduate degree in computer science (or related field) plus a minimum of 7 years experience in a Data Warehouse environment
• Dimensional Modeling experience
• Expert knowledge of various ETL tools like Informatica, Cognos, Hammerstone
• Structured Query Language (SQL)
• 5+ years experience working with relational databases

Etl Developer Data Management Resume Examples & Samples

• Create and enhance existing ETL/models/ Loads using Talend
• Partner with architecture team and optimize existing Talend Jobs
• Develop Sources of Truth models and expose the same for the consumable layer of the data lake
• Prepare required documents to migrate code in production
• Minimum 4 years of overall IT experience in Business Intelligence, data warehousing or data ingestation
• 3 yrs. experience in Developing/designing data models using Talend
• Minimum 1 yr. experience in developing solutions using databases like Greenplum, or Postgress
• Ability to take ownership of tasks and deliver without supervision while using their discretion to seek help when necessary
• Strong team player that collaborates well with others to solve problems and has experience working within a global environment
• Should have good communication skills and should be able to bridge the communication gap between business users and the technical team
• 8+ years technology experience
• 5+ years Oracle PL/SQL and Sybase Transact SQL
• 2+ years Scrum team member experience
• 2+ years Unix scripting
• Securities industry experience, especially compliance domain knowledge
• Distributed teamwork experience

SQL / ETL Developer Resume Examples & Samples

• Works directly with users in defining new application requirements and resolving project issues
• Analyzes a chain of events and applies technical knowledge following established procedures and/or detailed specifications
• Troubleshoots most applications problems independently
• Tests, implements, documents and maintains system components based on specifications
• Writes basic documentation of a new or proposed system
• Translate business requirements into specific ETL process designs
• Provide expert advice, counsel and technical expertise to the project team to help assure that ETL solutions are designed and developed in the optimal manner and in accordance with industry best practices
• Create and maintain Technical Design document (Logic Flow Diagrams), Mappings and Production Support & Administration document
• Deploy ETL solutions to production and provide support for operations and problem resolution
• 4+ years of experience using and developing complex SQL scripts to manipulate large data structures
• Experience in Data Modeling skills especially have solid experience working with dimensional modeling in support of large environments
• Experience building reusable ETL components
• Design and architecture background is a plus to assist in providing data integration solutions using best practices
• Experience in trouble shooting technical issues, and mentoring team members is a strong component to the team environment
• Strong preference for healthcare experience, general healthcare experience or experience with clinical data sets
• Strong knowledge of relational database design. Working knowledge of any one of these domains – Teradata, Vertica , DB2 – preferred
• Strong experience in ETL Tools - IIS Data stage is required
• Extensive hands on experience in UNIX shell scripting, complex SQL queries and with performance tuning queries
• Must be a team player in a fast paced environment with competing priorities and deadlines
• Knowledge in Java, MQ, Rule based engines is a plus
• Experience working with regulated financial organizations is a nice to have
• Minimum one (1) year of software development and configuration experience required
• Demonstrated working knowledge of ETL, PL/SQL and Oracle database technologies
• Familiar with a variety of the field's concepts, practices, and procedures, and relies on experience and judgment to plan and accomplish goals
• Perform and oversee development, quality assurance reviews, documentation, system deployment, training, and project setup/support for the Enterprise Data Warehouse and ETL processes
• Lead the Build, Test, and Implementation phases of assigned projects, with a diverse development team spread across multiple locations and time zones
• Performing project setups, analyzes, designs data integration solutions. Responsibilities also include selection, acquisition, installation and configuration of applications licensed from third parties, and interaction with vendors is required
• Investigate production ETL issues and work to determine the root cause of problems
• Prepare detailed development cost estimates
• Conceptual schema: Understand and design of the Conceptual schema including the semantics of a domain being the scope of the model its entity classes, and relationships assertions about associations between pairs of entity classes
• Physical Database: Physical Database design which includes: includes detailed specification of data elements, data types, indexing options and other parameters residing in the DBMS data dictionary
• Build specifications for extract, transform, and load processes, following standards for Informatica to facilitate the data mart/warehouse fact and dimension models as well as system integration
• Work with business to design specific subset of warehouse data for producing analytical data stores. Understanding elements of the data warehouse and facilitating the build of a warehouse to produce data marts that meet the business requirements
• Ensure warehouse and database functions are in accordance with Data Governance policies as set forth by KBR policies and standards
• Maintain proper metadata tools in order to perform proper usage and impact analysis
• Perform data queries for analysis by understanding existing warehouse structures and being able to answer user questions regarding the data
• Ensure consistency with existing databases and warehouses, enforcement of standards and consistent processes
• Define and recommend BI and integration standards, processes and technologies
• Research and recommend software technology direction
• Supervision and mentoring of staff; allocating and monitoring work
• A minimum of 7 years of experience working with enterprise data warehouse projects
• A minimum of 7 years of experience with Informatica PowerCenter
• Experience with installation and configuration of Informatica PowerCenter
• Experience with SQL Tools such as Toad/SQL Navigator
• Extensive experience working with Oracle and Microsoft SQL Server databases
• SQL query and performance tuning
• Excellent organizational, oral, written, and presentational communication skills in order to work with all levels of staff and management
• Extensive experience deploying and supporting large, complex data warehouse/business intelligence solutions
• Experience with data modeling tools such as Embarcadero or Erwin. Embarcadero experience is preferred
• Experience with Scheduling tools
• Experience with project planning and management, including making operational decisions, monitoring progress, taking corrective action, and communicating results
• Candidate must have a strong customer service orientation
• Design, code, test, debug, document and support all types of applications consistent with established specifications and business requirements to deliver business value
• Lead complex projects to achieve key business objectives
• Collaborate with the team on application architecture design and decision-making
• Develop innovative solutions to meet the needs of the business
• Provide alternate design solutions along with project estimates
• Design and implement application enhancements in collaboration with different teams
• Troubleshoot production support issues post release deployment and come up with solutions. Ability to solve complex production issues
• Predict emerging customer needs and develops innovative solutions to meet them
• Will be expected to function as a mentor for junior developers, providing assistance where needed
• Will be expected to handle smaller projects completely on their own, including interactions with other teams and 3rd parties for design and architecture
• Involvement with senior management in terms of supplying input for key design and architecture decisions, as well as work estimation and resource planning
• 5+ years ETL experience
• 5+ years relational database experience
• 3+ years SQL Server experience
• ASP.Net and C#.Net experience
• Healthcare Industry experience
• Design and build ETL solutions against RBMS and also dimensional databases to address business requirements
• Partner with other technical teams and in defining data mapping rules, data load procedures in accordance with data governance policies and controls
• Plan and model data integration processes and to build data models supporting complex transformation
• Troubleshoot data integration issues in a timely manner, in collaboration with DBAs, system administrators and other technology teams
• Drive solution delivery by closely working with business users, PMO, infrastructure and other technology teams in all phases of SDLC (Agile and Waterfall)
• Work with management in building the project/technology roadmaps, project scoping and analysis
• Develop functional and technical specifications
• Lead/mentor offshore technical developers and review deliverables for accuracy, quality, application performance and completeness
• Strive for top quality results and continuously look for ways to improve and enhance Enterprise Applications functionality, reliability and performance
• 5 + years of experience in designing and building ETL solutions against RBMS (Oracle, MySQL, SQL Server) and also dimensional databases (Hyperion Essbase), including job scheduling, exception handling & data reconciliation
• 4+ years of hands-on experience with IBM InfoSphere Data Stage (at least 6 months on 11.5)
• 4+ years of experience with writing SQL queries, DB views and stored procedures
• Strong knowledge of database systems principles/design, data construction and integration of applications systems
• Good understanding IBM Metadata Asset Manager
• Exposure to other industry standard ETL solutions (ODI, Pentaho and/or Informatica)
• Excellent customer service orientation, business communication skills and ability to deliver results under tight timelines
• PREFERRED EXPERIENCE
• Exposure to Hadoop
• Experience with one or more of the reporting platforms (Oracle Hyperion , OBIEE or Business Objects)
• Prior experience in a financial services company, supporting Finance / Accounting /Balance Sheet Management /Risk applications
• Work on design and development of large volume data processing applications/operational stores in iterative/agile development model
• Work with Data Analysis teams to verify requirements, and Source to Target mappings
• Prepare design/solution analysis based on requirements from internal and external sources to evaluate and demonstrate program effectiveness and efficiency, and problem solving
• Develop scalable reporting processes in collaboration with larger development team
• Research complex functional data/analytical issues
• Implement appropriate checks for data integrity, data quality as part of development effort
• Make recommendations and communicate status to leadership as needed
• Deliver high quality results in a fast changing and high growth business environment
• Utilize Talend for ETL within a Hadoop/Big Data environment
• 5 or more years of ETL development experience (SSIS, Informatica, DataStage, Talend, etc.)
• 5 or more years of RDBMS development experience
• 3 or more years’ experience designing and implementing effective data strategies in enterprise level data stores, data marts or data warehouses
• Experience with Talend
• Data modeling and data architecture experience
• Experience working in Big Data/Hadoop environment
• Healthcare industry/claims experience
• Experience developing innovative approaches
• Works with external vendors and internal business and technology staff to accurately gather and interpret requirements, specifications, and database models
• Designs, develops, tests, implements, and supports innovative and optimal data solutions
• Works with the Data Architects, DBAs and Business Intelligence team to design, implement, and support end-to-end data solutions across multiple platforms, environments, domains, and locations
• Minimum three years experience designing, developing, testing, and implementing ETL solutions using enterprise ETL tools (experience with SSIS is preferred)
• Minimum two years experience developing and implementing data integration and DW solutions in a SQL Server database environment (experience with Netezza, DB2, and an Oracle 11g/12g is a plus)
• Expert SQL development skills are required (T SQL is required)
• Proficient in converting flat file, XML, and fixed length formats
• Understanding of SQL Server RDBMS
• Serve on the Systems Integration Solutions team, which provides data feeds to many applications and third-party vendors and uses Ab Initio, Informatica, AIX/UNIX, UNIX shell scripting, Tivoli Workload Scheduler, Connect:Direct, SQL scripting and stored procedures, DB2, and Oracle
• Lead and participate in the design and implementation of large or architecturally significant applications
• Support and maintain applications using required tools and technologies, which will include working with the Support Center, the Network Operations Center, infrastructure teams, and vendors
• Provide off-hours 24/7 support as required
• Communicate with the appropriate teams to ensure that assignments are delivered with the highest quality and in accordance to standards
• Bachelor’s degree in information systems or related equivalent work experience in an information systems position
• Experience working with and planning projects of medium size or complexity
• 1-2 years development experience with Hive, Spark & Python
• Java- at least 3 years of Java development experience
• Batch Processing for data extraction and analysis
• Pythons and Shell Scripting experience (1 - 5 years). This expertise will help create the batch processes
• 1-2 years Hadoop experience
• Extracting production related information from various databases and formulating analytics to import to Data warehouses
• Develop appropriate metrics and associated reporting to support test/control analysis on new processes or procedures
• Provide analytics support/justification for project business cases
• Identify and troubleshoot code-related issues associated with security and performance – then get to design and build solutions to these issues
• Follow best practices around code maintenance and deployment strategies
• Incorporate security requirements
• Code, test, modify, debug, document, and implement ETL and SQL
• Adhere to IT Control Policies throughout design, development and testing and incorporate Corporate Architectural Standards into application design specifications
• Participate in code reviews and ensure that all solutions are aligned to pre-defined architectural specifications; identify/troubleshoot issues; and review and provide feedback to the final user documentation
• Manage multiple priorities and projects coupled with the flexibility to quickly adapt to ever-evolving business needs
• An ideal candidate will have a bachelor degree in data analysis, operations research, computer science, mathematics, statistics or any other engineering with 5+ years for work experience
• Bachelor's degree in Computer Science, Business, or related field with minimum 5+ years of Database Development work experience
• 5+ years of database development and design experience in Oracle/MSSQL database platform
• 5+ years of experience in PL/SQL, Perl, UNIX, and Java
• 4+ years of experience in ETL tool Informatica and/or Pentaho
• Experience using modeling tools such as ERWin a plus
• Experience in designing database models including star, snow-flake schema, and cubing technology
• Experience in designing database feeds from various systems
• Experience of Java, .NET and QlikView is huge plus
• Must have work related experience in data modeling, analytics and reporting
• Must have experience in SQL using various tools such as Toad, SQL Developer etc
• Must be able to collate from various data sources (data warehouses, different database environments) and analyze large amounts of data and summaries findings
• Must have proven ability to work with large-scale/complex issues and work effectively across functional and organizational lines
• Ability to translate business requirements into technical requirements documentation
• Experience with full development lifecycle from inception through implementation
• Experience in Data Warehousing environment
• Knowledge of big data technologies like Hadoop/HDFS/Hive/Hbase/Impala & ETL tool integration experience with Hadoop file system a plus
• Eagerness to learn new technologies

Talend ETL Developer Resume Examples & Samples

• 2+ years of Data Integration experience with Talend Data platform
• Experience with both data integration and data quality Talend products (enterprise edition)
• Experience using Talend against both on premise databases such as Oracle, Microsoft SQL Server, DB2, MySQL as well as cloud platforms preferably AWS
• SQL programming skills
• ETL parallelization and performance tuning
• Applies developed subject matter knowledge to solve common and complex business issues within established guidelines and recommends appropriate alternatives
• Works on problems of diverse complexity and scope
• Acts as a team or project leader providing direction to team activities and facilitates information validation and team decision making process
• Exercises independent judgment within generally defined policies and practices to identify and select a solution
• Ability to handle most unique situations
• May seek advice in order to make decisions on complex business issues
• Participates as the lead of a development team; may architect changes for others
• Completes code and reviews code of others, to implement solutions
• Typically a technical Bachelor's degree or equivalent experience and a minimum of 6 years of related experience or a Master's degree and a minimum of four years of experience
• 6 or more years of experience writing code (such as, and not limited to, C, PL/SQL, Unix Shell scripting; databases like Oracle/SQLServer; and Testing tools
• Advance understanding of modern software design and development methodologies
• Advance understanding of modern SCM (software configuration management)
• Advance understanding of testing tools and unit test scripting, and testing methodologies
• An understand of performing ETL without the use of ETL tools
• An understanding of Oracle Database Administration
• Familiarity with the UNIX operating system
• Understanding of quality and security standards
• Team lead for large teams or managing one customer with multiple projects
• Responsible for estimation, planning and execution – with specific focus on requirement analysis and design
• Good awareness on DW architecture and design using Teradata
• Awareness of Teradata bteq, mload, fastload, tpump etc
• Performance tuning experience in Teradata
• Coordinate with customer, vendor and onsite/offshore folks
• DW architecture and design using Teradata
• Lead ETL developer utilizing SSIS / SSMS to load client and operational data into SQL Server or other ERA reporting repositories
• Best practice ETL design / recommendations to guide data management processes and executions
• Execution and management of ETL services for key initiatives
• ETL process management including documentation, source control, security and maintenance
• 5+ year’s experience in data systems management
• 3+ years ETL software and process experience
• 3+ years Strong understanding of SQL
• Familiarity with multiple database platforms
• Intermediate level of proficiency with MS Office platform
• Intermediate understanding of Business Intelligence software tools (Tableau and / or SSRS / etc.)
• Project / program management experience
• 3+ years of experience working with healthcare data
• Positions in this function include those responsible for assessment, design, management and programming ETL and data management projects
• Provides process analysis utilized for decision making involving complex ETL process management
• May make recommendations based on the analysis, and enable reporting capabilities as needed
• 4+ years of experience performing significant data design/ analysis and/or development
• Intermediate level of programming knowledge and relational databases, database structures and design, systems design, data management, data warehouse
• Define data integration process and collaborate with Business analyst for various project needs
• Develop, test, and integrate code for existing data warehouse development in compliance with firm wide data management principles and security controls
• Develop and maintain controls on data quality and process
• Make recommendations, based on data profiling and data analysis, for changes to existing systems
• Document data integration strategies for data flows between disparate source/target systems for data warehouse
• Support production processes in NY and London　
• Minimum 5 - 7 years strong hands-on development experience in SQL Server 2012/2014 Integration Service (SSIS) development, scripting development, error checking, performance tuning, job scheduling, and deployment methodology
• Minimum 5-7 years of experience in SQL Server 2012/2014 database development such as SQL, XML, function, procedure, indexes, table partition, and query optimization
• Minimum 5-7 years of experience in large complex 1TB + data warehouse environment and strong knowledge in ETL and data warehouse methodology
• Experience in Erwin Data Modeler
• Experience in scheduling tool such as Autosys
• Experience in C#, ASP.net, Java script is a plus
• Experience in SSRS and understand Microsoft full BI stack is a plus
• Experience in cloud technology such as AWS EC2, S3, RDS is a plus
• Experience in SQL Server Data Quality and Profiling is a plus
• Understanding of the project development life cycle
• Understand modern data warehouse design
• Advanced skills and experience with data modeling and enterprise data marts
• 3+ years' experience working with SQL Server or supporting other database technologies (e.g. Oracle)
• 3+ years of experience writing reports using Microsoft SQL Server Reporting Services (SSRS 2005, 2008 or later version
• 3 years with SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) is required
• Responsible for (1) development and maintenance of database systems to extract, cleanse, transform, load and maintain data; and (2) data migration * Five - ten years Informatica ETL developer experience * Strong, demonstrated analysis and problem solving skills * Strong planning and organizational skills * Strong written and oral communication skills * Demonstrated track record of strong UI development capabilities
• Proven working knowledge of ETL
• Strong analysis and design skills, including requirements analysis, Object Oriented design patterns, and UML
• Experience in Financial Services, preferably Wealth Management Social skills, persistence and backbone to work with difficult stakeholders
• Define project delivery phases, activities and milestones
• Create solutions to complex problems
• Provide frequent and effective progress updates to project stakeholders
• Cooperate closely with other teams to ensure proper alignment and coordination across application landscape as decisions often impact the team in which they reside and occasionally impact other teams
• Minimum 3 years of experience with design and implementation of data warehouses, management information systems, operational data stores including relational and multi-dimensional data modelling; and esign and implementation of ETL processes
• Solid knowledge of one or more of the leading RDBMS platforms (e.g.. Oracle, Teradata, DB2, MS SQL Server)
• Extensive knowledge of one or more leading ETL tools (e.g. Informatica PowerCenter, IBM Data Stage, Oracle Data Integrator, SAS Data Integration Studio, Business Objects Data Integrator, Microsoft SQL Server Integration Services)
• Strong problem-solving skills combined with the ability to creatively untangle complex issues and develop innovative and efficient solutions within a narrow time frame
• Some management skills would be nice to have
• Ability to easily communicate in English
• Support of 9 out of 10 technology mergers in Poland
• Facilitation of 80% of mobile calls in Poland by systems implemented by Accenture
• Most complex IT transformations in Poland
• 60% of current accounts in Polish banks work on systems implemented by Accenture
• Design and implement medium and large scale Data Warehouses, Management Information Systems, analytical repositories (CRM, subject oriented Data Marts) and operational data stores
• Design logical and physical data models for normalized and multidimensional repositories
• ETL processes performance assessment, recommend improvements and fine tuning
• Maintain and support of the Data Warehouse systems operating in production environment
• Design and implement tools, processes and methods supporting Data Quality monitoring and management
• Plan, prepare and execute automated and manual tests of ETL processes
• Minimum 1 year of experience with design and implementation of Decision Supporting Systems (Data Warehouse, Management Information System, subject oriented Data Marts) in ETL and data modeling areas
• Solid knowledge related to ETL processes and architectures (e.g. operations metadata, data cleaning and conforming, slowly changing dimensions, data lineage, etc.)
• Excellent command of SQL
• Solid knowledge of one or more of the leading RDBMS platforms (e.g. Oracle, DB2, MS SQL Server, Teradata). Practical knowledge of Oracle would be considered as additional asset
• Solid knowledge of one or more leading ETL platforms (e.g. Informatica PowerCenter, Ab Initio, IBM Data Stage, Oracle Data Integrator, SAS Data Integration Studio, Microsoft SQL Server Integration Services) would be considered as additional asset
• Knowledge of column oriented RDBMS platforms (e.g. Netezza, SAP IQ) would be considered an asset
• Knowledge of multidimensional modeling patterns (e.g. star schema or snowflake) would be considered as additional asset
• Knowledge of banking services business and operating model would be considered an asset

ETL Developer, IHC Resume Examples & Samples

• Extracts structured and unstructured data from source systems, transforming it to fit business performance management needs, and loading it into a data mart. Data source formats include relational databases, flat files and non-relational database structures
• Collaborates with business functional leaders by analyzing and evaluating business requirements; diagnose the design, propose/design alternatives and recommendations. Plans and coordinates the implementation of new data requirements
• Oversees the data load production process and the implementation of new data load files in accordance with the department’s change management process
• Ensures data quality by designing and implementing adequate internal controls and monitoring processes. Includes controls to identify individual ETL flows that are performance issues. Ensures controls are maintained when designing new structures by utilizing object naming conventions to encourage consistent development and ease of migration from development to test to production
• Works closely with Information Technology staff through the phases of coding and implementation of external data source files providing clarifications as necessary. Maintains effective ongoing communications with the business and IT community and operational management regarding system plans, projects, budgets, expenditures and policies
• Prepares systems procedures, system operating guides, contingency and recovery plans and maintain technical application level documentation
• Master’s/Advanced Degree in Business preferred
• 4 or more years in banking and financial services
• 2+ years in a technical lead role
• The candidate must demonstrate senior knowledge and practice with Relational and Dimensional Database development concepts and database life cycle methods and procedures
• Deep knowledge of indexing, partitioning and fragmentation strategies
• Possesses very strong facilitation and evangelizing skills that assisting in translating business needs into effective IT Solutions
• In-depth understanding and experience with ETL, data warehousing/data marts, and design and management processes associated with each
• Must be a data technologist and evangelist for the organization and be able to train and mentor other team members and senior staff
• Highly motivated self-starter, detail and quality oriented and able to work independently and be able to resolve complex problems that have implications beyond your own area
• Bachelor's Degree in Computer Science, Information Systems, or other related field
• 2+ years of experience with big-data platforms and/or data warehouse appliance
• Experience in delivering solutions on premise and cloud technology
• Experience in ETL, reporting and analytics, and business intelligence tools

Senior PL / SQL & ETL Developer Resume Examples & Samples

• Help lead and coordinate ETL resources and project activities across the platform
• Maintain and update data warehouse extract transform & Load (ETL) processes using Cognos decision stream
• Develop near real time PowerExchange ETLs
• Understand database design and attribute descriptions
• Performance analyze and tune database functions, procedures and loaders
• Supporting and implementing data integration processes for multiple source systems
• Identification and resolution of problems encountered by the users of the systems
• Work experience within financial management organization
• Excellent collaboration, communications, negotiation, and conflict resolution skills
• Ability to think creatively and seek optimum solutions

Datawarehouse / ETL Developer Resume Examples & Samples

• Leading developers for providing DWH Development
• Coordinate with Customer, Technical and various stakeholders
• Design solutions and architecture with assumption and risks
• Obtain approval for design review
• Review ETL process as pre the design and requirement
• Review test cases for UNIT testing
• Prepare other artifacts as required
• Support Testing team and deployment team till project go live
• Mentor Jr members
• Provide KT to production support team
• Provide analytical support and design data collection processes for workforce analytics including data collection, ETL and analysis
• Integrate disparate data from multiple systems and tools
• Create reports of analytical findings – both written and graphical
• Implement processes and procedures to support, standardize, streamline, and in some cases automate
• Ensure timely and accurate execution of monthly reporting activities, including: reporting, metrics, scorecards, and dashboard reporting
• Assist in development of tools and applications as needed
• Define and design ad-hoc reporting as needed, following reporting standards
• 2 to 3 years of experience in SAS programming and complex ETL
• 2 to 3 years of experience doing data reporting and analysis
• 2 or more years IT Development experience in object-oriented programming
• Knowledge of statistics a plus
• Experience with database consolidation and integration projects
• Expertise in relational database design
• Strong Microsoft Office skills
• Experience with BI and data visualization tools using Tableau a plus

IT ETL Developer Resume Examples & Samples

• 1-2 years relevant experience
• Basic knowledge of the business, technical environment, standards, processes, procedures, programming languages and operating systems
• Experience in data oriented solutions including: database, data warehouse, ETL, visualization or analytics
• Ability to code, test and debug unit level programs
• Readiness and motivation to perform tasks under general supervision
• Commitment to and belief in the quality of your deliverables
• Design, development and integration testing in a Regulatory Reporting tool Axiom Controller View
• Requirements and functional specification documentation for existing or future automation projects
• Interacting with different stakeholders and Project Management team to work on BAU Quarterly and Annual filings
• 5+ years data gathering, data analysis, design and development
• 3+ years in Banking preferably in regulatory projects is strongly desired
• 3+ years in ETL development with complete SDLC cycle. Axiom Controller View experience is strongly desired
• 2+ in SQL, UNIX is strongly desired
• Knowledge of Oracle Database and server migrations is required
• Knowledge of any web technology and scheduling tool is desired
• Expert in data analysis using excel and in using pivot tables is required
• Experience directly communicating with project members and stakeholders on a regular basis
• Must be a team player who works well with technical and non-technical resources
• Must be able to see tasks through to completion without significant guidance
• Prior work experience in Regulatory reporting is a plus
• ETL Developer/Analyst
• Perform analysis, Design and Development of ETL processes using Datastage for Business intelligence and Data Warehouse projects
• Responsibilities will also include providing technical expertise on ETL Design, Data modeling, Data Warehousing and Data Integration
• Handle multiple project assignments with minimal direction and escalate issues as necessary to the management
• Be flexible to respond to changing priorities
• Over five year experience in Datastage and Data warehousing skills
• Strong data design, data modeling and facilitation skills
• Ability to work with cross-functional teams and all levels of Management
• Experience Required: Over five years of experience in Datastage, Teradata, designing and developing ETL applications in Teradata data warehousing environment
• Designing Data Warehousing applications, Writing Specs, data analysis
• Experience coding in Python
• Experience with REST API's
• Demonstrated knowledge of data models and relational and multidimensional designs
• Demonstrated knowledge of source and target data structures, ETL processes and products
• Experience in problem solving skills
• Demonstrated knowledge of SQL
• Demonstrated knowledge of design review, analysis, trouble-shooting, code review, implementation and integration for applications
• Demonstrated knowledge of functional automated software and current advances in technologies that would enhance the functional performance of the system
• Experience in identifying and resolving problems with computer hardware and software products
• Experience in establishing and maintaining effective working relationships
• Experience in work effectively in a team environment

ETL Developer Manager Resume Examples & Samples

• Experience with database development and design including experience with Oracle and/or Sybase
• Source code control software (eg. Clearcase, subversion)
• Code Reviews, Performance, Memory Management

Ssis ETL Developer Resume Examples & Samples

• Develop, maintain and support SSIS packages related to the extraction, transformation and loading (ETL) process with SQL Server Integration Services (SSIS) 2012+
• Write T-SQL queries, complex stored procedures and functions to perform database tasks such as inserts, updates and deletes
• Responsible for data profiling as well as SQL and database tuning / optimization
• Provide business and technical analysis, development and project management expertise for business and technology initiatives focusing on Data Warehouse and Business Intelligence solutions
• Develop detailed technical specifications and ETL documentation in collaboration with data warehouse architect and Business Intelligence developers
• Design ETL audit control and scheduling processes
• Develop testing and implementation strategy, conduct appropriate functional and performance testing to identify and resolve process bottlenecks and data quality issues
• Provide expertise and leadership to offsite development team
• Collaborate with Business Intelligence Developers through dashboard and application development process for requirements gathering, feedback on proposed designs and models, and acceptance testing
• 5 - 10 years’ experience, with both hands-on and lead experience in supporting data warehousing solutions
• Bachelor's degree in computer science, information technology or another computer-based discipline
• Must possess the following technical skills
• ETL Tools: SSIS
• Database & Utilities: Microsoft SQL Server 2012+
• Platforms: Primarily Microsoft, some Unix
• SQL Language
• Sales Analytics
• Marketing Analytics
• Accounting / Financial Services
• Data Warehousing Concepts
• Star and Snowflake schemas
• Writing technical documentation
• Software Development Life Cycle
• Knowledge of job schedulers and experience in developing batch and real time integrations (Flat Files, EDI, XML) is a plus
• Knowledge of Data modeling concepts (e.g. Entity Relationship Diagrams) is a plus
• XML/XSLT experience is a plus
• Familiarity with ASP.NET, C# platform is a plus

DWH ETL Developer Resume Examples & Samples

• Perform data warehouse ETL-SQL development tasks for large projects (ETL development, stored procedures development, SQL optimization)
• Deliver business and application specific consulting services included in the integrated Teradata solutions
• Support the pre-sale process as well as communicate with the client
• Build data warehouse (DWH) competency
• Experienced in customer interactions
• Self-directed and keen on learning
• Strong problem solving skills and optimization techniques
• Undergraduate degree in Information Systems (or related program) or equivalent work experience as a systems and/or data analyst at an enterprise level
• Understanding of EDI/ETL and data integration principles
• Understanding of XML document technology and concepts
• The ability to multitask and handle multiple projects simultaneously
• Understanding of command line interfaces (Unix/Linux/Windows)
• Helpdesk or other direct technical client support experience
• Healthcare industry experience, preferably in enrollment data exchange or administration

ETL Developer / Data Integration Specialist Resume Examples & Samples

• Bachelor's degree in Computer Science or a related quantitative field
• Experience in software application development
• Strong programming experience in at least 1 language
• Experience with Data Management (Extracting, Transforming, Loading)
• Some exposure to SAS solutions and products
• Experience in technical lead role
• Ability to mentor other staff members
• Ability to comprehend the details of complex system software
• Excellent verbal, written communication skills
• SAS programing experience
• Experience with Java and Java Script
• Experience working with Unix
• Experience with relational and multi-dimensional databases and data management tools
• Advanced report design and build experience
• 3 + Years of Java experience
• 3+ years of Big Data/Hadoop ETL experience
• 3+ years of traditional ETL experience on RDBMS
• Development, validation, and support of the ELT/ETL procedures
• Build, analyze, and maintain all data flows and related processes, continually striving to improve them, including increased automation, usability, transparency, documentation, and QA. This includes design, development, and implementation of data structures, database management, data quality, and data warehousing as well as determining data accuracy and determine optimal structure for analysis and reporting purposes. Works with inter-departmental teams to analyze and understand business requirements
• Implementation of data integration and data loading tasks and responsibility for all aspects of data management, ETL, data flows, data quality evaluation and management, and a host of other activities essential to the ongoing operations. Collaborate with business users and IT teams, analyze requirements, apply business rules to data processing and integration and develop functionality by following internal development standards
• Monitors and troubleshoots daily production data loads; diligently identify and pursue data anomalies, correct not just the data but also the source of the corruption; quickly adapt to an ever changing environment, fix issues and support both real-time data flows, and batch/ETL data flows; documentation of technical and system specifications documents for ETL processes; performs unit, regression, connectivity and full end-to-end integration tests; provides technical expertise during the requirements gathering phase of a project
• Bachelor Degree in Computer Science or a related discipline
• Minimum of 3 years hands-on experience with Informatica and experience in ELT/ETL development in a InfoSphere, DB2 environment
• 2+ years of insurance experience in an IT environment preferred
• Knowledge of the business both from a historical/warehouse perspective, and an operational/transactional perspective; ability to understand and analyze the existing system and provide quick solutions to resolve issues and meet new requirements
• Understanding of database and data management concepts as it relates to data movement, ETL development: including dimensional modeling, normalization, indexing and partitioning
• Ability to work in a matrix environment and to value the importance of teamwork
• Understanding of common system architecture frameworks and concepts
• Technical awareness of Security and Application Software Development
• Familiarity with paired programming would be beneficial
• Experience implementing ETL solutions, particularly utilizing Informatica PowerCenter
• Proven relevant experience in systems integration and implementation
• Experience improving Data Quality in Data Warehouses, Operations data stores, Datamarts
• Experience with Informatica Metadata and Business Glossary
• Experience testing ETL solutions and debugging complex software/data integration systems
• Experience Designing Data movement and ETL systems
• Demonstrated ability to liaise with multiple stakeholders
• Experience automating implementations and batch schedules using CAW/ESP Ver12 (Computer Associates Workload Automation tool)
• Strong Database Development Skills, particularly implementing DB2 and SQL solutions. Good experience with large datasets
• Experience working in Agile development software methodology, authoring technical documents / specifications
• Significant experience implementing data-driven systems with large-scale relational or object-oriented databases
• Responsible for the overall integrity of the JH Insurance Data Management environments
• Ensure data management processes are in place to achieve data accuracy, completeness and reliability
• Serve as primary data management escalation point by proactively identifying and managing escalation of potential risk and issues, offering innovate ideas for solutions
• Coach data management/ETL specialists on best practices. Mentor and provide technical guidance for Data Developers. Assist with staff and resource management of project team members
• Liaising closely with data architects, business analyst, data consultants and senior stakeholders across the business
• Data analysis, profiling and development of technical specifications for data loading rules
• Applies data analysis, data modelling, and quality assurance techniques, based upon a detailed understanding of business processes, to establish, modify or maintain data structures and associated components (entity descriptions, relationship descriptions, attribute definitions). Advises database designers and other application development team members on the details of data structures and associated components
• Database, system, data integration, data movement design for efficient information management
• Creation of estimates for new project efforts and project budget management, planning for individual efforts
• Issue resolution & escalation, and project status reporting. On-call support team for handling production issues
• Develops and maintains specialist knowledge of database concepts, object and data modelling techniques and design principles and a detailed knowledge of database architectures, software and facilities. Analyses data requirements to establish, modify and/or maintain object/data models. Evaluates potential solutions, demonstrating, installing and commissioning selected products
• Designs, codes, tests, corrects and documents complex programs or processes and scripts from agreed specifications, and subsequent iterations, using agreed standards and tools, to achieve a well-engineered result. Takes part in reviews of own work and leads reviews of colleagues' work
• Specifies user/system interfaces, and translates logical designs into physical designs taking account of target environment, performance security requirements and existing systems. Produces detailed designs and documents all work using required standards, methods and tools, including prototyping tools where appropriate
• Minimum 7+ years' of Informatica development experience with exposure to version 9.x or later to include
• Certifications with Informatica or other ETL technologies
• Bachelor’s Degree or higher, in a related field such as Information Technology/Computer Science, Analytics, Business Technology
• Project Management training and certification a plus
• Have extensive experience in a data delivery role and use of data tools and intellectual capital in order to hold credibility
• Able to confidently interact with roles ranging from Developers to mid-level managers
• Ability to work in a high pressure, result/deadline oriented environment
• Solid written, verbal, and presentation communication skills
• Strong team and individual player
• Maintains composure during all types of situations and is collaborative by nature
• Ability to shift project priorities as needed to support program objectives
• High standards of professionalism, consistently producing high quality results
• Self-sufficient, independent requiring very little supervision or intervention
• Demonstrate flexibility and openness to bring creative solutions to address issues

Ssis / Ssrs ETL Developer Resume Examples & Samples

• 4 years full life cycle development experience
• 3 + years data warehousing experience
• Expertise with SSIS/ SSRS, designing and managing data integration standards
• Data design & development
• Experience in data modeling & data mining
• Adopt efficient design and development principles to "transform and load" data for MI production
• Provide support to other team members to manage complex requirements
• Develop and validate requirements by adopting an iterative & incremental approach
• Collaborate with BICC teams to resolve queries
• Utilise and promote internal BICC processes
• Provide support to other areas of the BICC as required
• Designs and develops Informatica mappings within the framework of the warehouse architecture set by the Data Architects
• Implements complex ETL code using Informatica, PL/SQL, Oracle Workflows and Shell Scripting
• Develops and executes test plans to ensure that the ETL process fulfills data requirements
• Assists in Data Analysis and Data Profiling activities
• Provides day-to-day support for operational data warehouse environment
• Ensures compliance with standard software development practices, processes and enterprise standards
• Communicates project/issue status in a reliable and accurate manner through appropriate tools and processes
• Mentors and helps to develop more junior-level developers
• Bachelor’s degree in Computer Science or equivalent experience required
• Advanced skills using Informatica
• Experience developing PL/SQL packages and procedures
• Proven knowledge of SQL, PL/SQL and Oracle 10g
• Experience working with dimensional modeling
• Experience developing shell scripts and process monitoring in a Unix environment
• Experience analyzing complex source systems and data structures
• Demonstrated ability to deliver software projects of high complexity and risk
• Strong knowledge of systems development life cycle
• Experience in an operational environment
• Strong inter-personal skills and ability to communicate information clearly, concisely, and effectively both orally and in writing, and be comfortable working in a collaborative, team-centric environment
• Develop Extract, Transformation, and Load (ETL) procedures for implementing data integration and data loading tasks
• Design, develop, test, and deliver code for the project’s user interfaces, system interfaces, and back-end components
• Define, prepare and execute migration packages for new ETL objects
• Develop SQL programs and Stored Procedures as required for the ETL processes and Data Integration activities
• Configure and maintain scheduled ETL jobs
• Provide batch execution support during testing and QA
• Integrate data extraction techniques from various engineering tools to collect and transform relevant data
• Perform data science-type and utility developer functions
• Develop complex Oracle PL/SQL programs for the Data Warehouse
• Analyze transaction errors and troubleshoot issues in the software
• Develop bug-fixes and oversee performance-tuning efforts
• Maintain currency and provide leadership in the use of the newest technologies and techniques such as prototyping, component-based development, object-oriented design, database design, web tools and architecture
• Prior experience providing support to technical teams for ETL processes, and experience developing unit test plans, test cases, and resolve ETL related test problems
• Strong technical and team-focused attributes
• Experience working with SQL, Oracle, PL/SQL, SQL Loader and BI tools
• Ample experience working with Oracle databases and SQL, Postgres, XML, and JSON
• Demonstrated experience developing and maintaining effective ingestion code to receive process, monitor, curate/cleanse, tag, and manipulate high volumes of data
• The ability to work in a mixed technical environment and maintain productivity when switching between languages or technologies
• Self-motivated with advanced extraction, transformation, and load (ETL) and programming skills
• Prior experience meeting aggressive deadlines
• Experience with Java software development
• Experience working in full development lifecycles within an agile environment
• ) 3-5 Years of experience with MS C#.net. 9Version 4 and above ( currently using 4.62) and MS SQL server. 80% of the time spent in the role will be with MS C#.net and SQL
• ) 3-5 Years of experience with Web technologies, such as ASp.net, Restful, web API
• ) Experience with TFS - Team Foundation Server and MVC
• Design, develop, code, test, implement and support the data platform
• Design & Develop basic and advanced transformation activities such as normalization, cleansing, aggregation, summarization, and integration; designs automation processes to control data access, transformation and movement; ensures source system data availability and update accessibility, data integrity, restorability and appropriately handles errors, in a time sensitive manner
• Understanding supported business processes, and engage business areas using advanced/expert understanding of business requirements for translation into feasible process
• Verify and support existing ETL code bases to ensure data accuracy. Identify manual processes and automate those
• Manage multiple broader efforts that span multiple projects/initiatives. Prioritize and monitor project/task status and risk management/mitigation, by working with appropriate manager on level of effort/estimates, resource assignments, etc
• Bachelor's Degree in Computer Science, Management Information Systems or related field or equivalent knowledge
• Strong Experience in Pentaho/Kettle is Mandatory
• Hands-on experience with all aspects of designing, developing, testing and implementing ETL solutions using Pentaho/Kettle
• Eperience with with JSON, XML, HTTP, HTML, Web Services
• Experience on a cross-functional team (Agile or other)
• Bachelor’s degree in Computer Science, Engineering or Business (equivalent professional experience considered)
• Minimum 2 years’ experience in the IT industry with hands-on continuous work experience in developing end to end Business Intelligence solutions (ETL, reports, dashboards, scorecards) using Informatica and Oracle Business Intelligence technologies or similar Business Intelligence products (like SSAS, SSIS, SSRS, COGNOS, SAS)
• Minimum 2 years’ experience creating SQL queries from scratch (including complex stored procedures) and data processes
• Experience in gathering and analyzing business requirements and translating them to a technical solution
• Ability to quickly learn new systems, adapt and refocus in a fast paced, agile development environment
• Ability to share and grow knowledge across all team members

Junior SQL / ETL Developer Resume Examples & Samples

• Determining computer user needs
• Analyzing system capabilities to resolve problems on program intent, output requirements, input data acquisition, programming techniques and controls
• Preparing operating instructions
• Designing and developing compilers and assemblers, utility programs, and operating systems
• Ensuring software standards are met
• At least 4 years experience with PostGres SQL
• At lease 4 years experience with Informatica Power Center; SQL
• At least 4 years experience with ETL development and process from diverse data sources
• Advanced experience with Informatica Power Exchange Control-M
• At least 4 years experience in development maintenance and enhancement of Informatica Mappings Work-flows and processes
• Experience with Data Warehouse; Oracle; Linux; AIX
• At least 8 years experience designing and developing extract, transform and load (ETL) processes utilizing for example DataStage, Informatica, BigInsights, Pentaho or other vendors
• At least 8 years experience moving/migrating/managing data from operational & external environments to the business intelligence environment based on business rules and requirements
• At least 2 years experience designing and developing extract, transform and load (ETL) processes utilizing for example DataStage, Informatica, BigInsights, Pentaho or other vendors
• At least 2 years experience moving/migrating/managing data from operational & external environments to the business intelligence environment based on business rules and requirements
• At least 2 years experience working with data warehouses, data marts, operational data stores, data feeds and associated query mining/reporting for business analytics
• At least 2 years experience with data modeling/data workflow diagrams (conceptual, logical and physical)
• Basic Knowledge working with PL/SQL, SQL and Object Oriented concepts and design
• Works with graphic designers and other members of a project team to develop the site concept, interface design, and architecture of the website. Responsible for interface implementation
• 2+ years of ETL experience using products such as Data Stage or Informatica
• 2+ years of SQL experience
• A Bachelor's degree in Computer Science or related field. Or a Master’s degree in a related field and zero years’ experience. 4 additional years’ experience will be considered in lieu of a Bachelor’s degree
• Creative problem solving abilities and strong work ethic with “can do” attitude
• Ability to take high-level requirements and compile them into development tasks
• Ability to thrive in a team/collaborative environment
• Possess a SECRET clearance or have the ability to obtain one (SAIC will process the clearance for the candidate.) Must have at least an interim SECRET to begin work on the contract
• Must be CompTIA Security+ certified
• Must obtain as a related certification relevant to the computing environment, such as Oracle Certified Associate, with the first 90 days of employment
• Must be enrolled in CompTIA Continuing Education program. Preferred Qualifications
• Experience with PowerBuilder development
• Knowledge of DoD STIGs. WORK LOCATION: Fort Knox, KY
• 4+ years of experience in the development, maintenance, and enhancement of Informatica Mappings, work
• Flows, and processes
• Experience with Informatica Power Exchange and Control
• M at an advanced level

ETL Developer w / Mainframe / Teradata exp Resume Examples & Samples

• Handle all aspects of systems life cycle for ETL processes related to DB2, Teradata and extract files using Datastage, Database and Warehousing skills
• Strong working knowledge in Teradata and data warehousing
• Strong experience in relational databases, advanced SQL and ETL programming/tools/utilities
• Mainframe skills including MVS, JCL, CA7, TSO/SPF, COBOL
• Strong drive for results and ability to multi-task and work Independently
• Design, develop and implement ETL solutions employing Informatica Power Center and Master Data Management technologies
• Address ETL solution requirements including compliance, security, latency, archiving and lineage
• Design appropriate data staging architectures for fact and dimension data including cleaning and conforming the data
• Develop appropriate meta data storage and management methods addressing business, technical and process data types
• Analyze, design and develop appropriate scheduling and data movement choreography solutions comprehending existing scheduling activities within and between in-scope source systems
• Design, develop and implement robust exception and quality handling capabilities
• Develop ETL solutions that integrate with cloud based applications and data sources
• Incorporate data encryption methods where appropriate
• Performance tuning and optimization of previously implemented SSIS integration packages
• Convert existing SSIS integration packages to Informatica Power Center
• Provide support to technical team, write the necessary required documentation as per the company standards for ETL processes, and develop unit test plans, test cases and resolve related issues
• Undergraduate degree in computer science, management of information science or equivalent combination of education and work experience
• A minimum of 10 years hands-on experience in design and development of enterprise ETL solutions using ORACLE and SQL databases and Informatica Power Center and MS SSIS technologies
• Expert knowledge of SQL Server 2012-2016 and Oracle database technologies
• Hands on Experience with UNIX scripting (FTP, SFTP and Keys exchange, Shell Scripting)
• Previous Informatica Power Center or DIH implementation success highly desired
• Previous Informatica Meta Data Manager, Administrator and alerting capabilities a plus
• Demonstrated expertise with the Application Development Life Cycles, including both waterfall and agile methods
• Contributes to ETL development solutions, standards, controls, procedures, and documentation. Serves as a team member and works to maintain a positive work environment
• Contributes to ETL design, development and unit testing
• Cooperates closely with the project team to translate client descriptions and ideas into workable solutions
• Contributes to the development of design and coding standards
• Secret clearance must be obtainable
• Minimum 3 years of experience in ETL programming, data management, warehousing, and data mart development including technical development/design experience in complex systems and producing formal implementation plans
• Minimum 3 years of experience developing with any or a combination of the following ETL tools: IBM DataStage, Informatica, Ab Initio, SSIS, Talend, or Pentaho)
• Minimum 3 years of experience in designing processes to migrate data from one environment to another
• Minimum 3 years of experience using Oracle (Version 10g or higher)
• Good understanding of data warehousing, dimensional, relational, and OLAP data modeling
• Attention to detail and maintaining high data quality standards
• Effective at working on small teams and ability to think logically and independently with strong analytical, research and problem solving skills
• Experience with XML data and data exchange implementations (especially the NIEM standards)
• Incorporate security requirements into design; and provide input to information/data flow, and
• Document the detailed application specifications, translate technical requirements into programmed application modules and develop/enhance software application modules. Participate in code reviews and ensure all solutions are aligned to pre-defined architectural specifications
• Identify and troubleshoot application code-related issues; and review and provide
• Feedback to the final user documentation
• Conduct research to determine if solutions to business requirements currently
• Exist within or outside the business unit, and if not, whether new solutions are feasible
• Analyze impact of proposed data warehouse solutions across the business, develop use cases, functional specification and source to target mappings to demonstrate business requirements to IT team, and contribute a business or process perspective during design reviews
• Facilitate implementation of new functionality through training sessions, demos, and the development of appropriate documentation
• Coordinate with development team to implement data warehouse and business intelligence
• No direct reports and no managerial duties. Individual contributor level position
• Education: Bachelor's degree in Computer Science, Engineering or related technical field
• Experience: 3 years of progressive, post-baccalaureate work experience in job offered or five years of progressive, post-baccalaureate
• Work experience in a software engineering-related occupation
• Experience must include
• Software Development using iterative / agile methodologies
• Partnering with the Trust and Estates business analysts and existing Application Development teams to understand functional and data requirements for multiple business processes
• Support production rollouts of the functionality on-site by partnering closely with the Infrastructure and Operate team
• Must be detail oriented , needs to be able to investigate and solve for the details independently by partnering with relevant technology or business colleagues
• Experience working closely with AD architects and Design Authorities
• 6+ years’ experience with application development and design
• Must be well versed in database development database interfaces, data analysis, and database performance tuning
• Design, Develop and support database applications
• Optimize tune and make recommendations for database design
• Design solutions using ORACLE, SYBASE, TOAD, SQL Developer
• Maintain and support oracle database instances and applications in high transaction environment
• ETL pentaho and informatica is a big plus
• Develop, implement and maintain change control and testing processes for modifications to databases
• Produce adhoc queries and develop reports to support business needs
• Must be able to work with configuration management to migrate work through all project stages and environments
• Fair knowledge in Java programming
• Ability and inclination to learn & pick-up new tools & technologies quickly

Data Architect / ETL Developer Resume Examples & Samples

• Providing recommendations and solutions for improving data accessibility
• Developing data management strategies
• Maintaining and enhancing the existing data infrastructure
• Performing extraction and manipulation of data
• 4+ years of Teradata or SQL Server database experience is required with expert skills in writing advanced SQL, creating packages, leveraging functions, building stored procedures and optimizing SQL queries
• 4+ years experience in ETL tools (SSIS Preferred)
• 4+ years experience in data warehousing & data management
• 2+ years experience in data modeling and demonstrated experience with data driven decision making

ETL Developer / Data Integration Engineer Resume Examples & Samples

• Develop and implement the full suite of BI solutions: Reports, Frameworks / Metadata layers, Data Marts, Multi-dimensional Cubes, Dashboards
• Serves as a leader, coach, and mentor to business units on developing their business intelligence reports
• Executes proficiently all tasks and responsibilities. Identifies gaps and provides solutions
• Reviews and provides constructive feedback on the work of others
• Develops innovative approaches for managing capacity and project queues
• Sought out by others as an expert
• Identifies development opportunities for self and clients to promote efficiency
• Has ability to multi-task and prioritize, both individually and for a large team
• Solves complex problems and develops innovative solutions
• Provides explanations and information to others on the most complex issues
• Experience with Data Integration tools (especially Talend)
• 5+ years' experience with developing reporting modules, including dashboards and scorecards within a BI tool (Microstrategy, Cognos, Jaspersoft, Pentaho, Tableau, etc.)
• Experience working with non-relational data. Hadoop, Spark, Mongo, Cassandra
• Good verbal and written communicator. Can meet objectives with minimal supervision
• Bachelor's Degree or equivalent work experience
• Knowledge of health insurance industry
• Excellent organizational and time management skills

Senior Oracle ETL Developer Resume Examples & Samples

• Partner with architecture and front end developers to create conceptual designs and detailed technical specifications for data management solutions
• 5+ years of experience working as an Oracle database developer (Oracle Database 10g or greater)
• 5+ years of working in a data warehousing environment, ETL development, PL/SQL development and database performance tuning
• Oracle 11G, Oracle GoldenGate 11g, SAP Data Services 4.2; Data movement architectural patterns, and a thorough understanding of system development lifecycles
• Bachelor degree in computer science or related field
• Design and develop applications and software tools to automate, improve, or change business processes and procedures
• Serve as a lead developer or Support medium for large sized projects from analysis through implementation by serving as developer
• Involved in project from startup through implementation to ensure all aspects of the technology plan are accounted for, understood, defined and executed successfully
• Build technical designs that properly leverage our architecture
• Effectively give and receive a thorough design and/or code review following documented coding standards and design template
• Develop and perform effective unit testing procedures
• Work with Business Analysts and Solution Managers to address requirement questions
• Work closely with Business Analysts to design scalable solutions to problems
• Work with other team members on medium and large-sized projects
• Work with peers, team leads and supervisors in a collaborative and shared-learning environment
• Work with third party software providers to ensure solutions meet the needs of Ferguson
• Participates in associate meetings and communicates any concerns to management
• Provide estimates for development work and meets deadlines
• Provide mentorship to other developers
• 3-5 years’ experience designing, developing, testing and implementing scalable, high-performing BI solutions
• Must have experience with one or more BI/Data Integration tools such as Pentaho BA, PDI, OBIEE, Business Objects, SAP Data Services
• Experience working with web application development tools and languages including HTML/XSLT, Java, JSP, JavaScript
• Experience working with relational databases (e.g. MySQL, MariaDB, PostgreSQL, Oracle) and/or column store databases (e.g. MemSQL, Vertica etc.) and database languages including SQL, MDX
• Working experience with application servers (e.g Tomcat, JBoss, Weblogic is a plus
• Work in an Agile development cycle as part of an onshore Scrum team contributing to scoping and estimating discussions, design reviews, code reviews and delivery of functional demos
• Preference will be given to candidates with Pentaho DI and BA toolsets experience
• Excellent communication, presentation, interpersonal skills

Ab Initio / ETL Developer Resume Examples & Samples

• General responsibility in the design, development and delivery of human resources data integration between multiple external systems and PeopleSoft, using Ab Initio ETL
• Develop technical solutions to business challenges and functional requirements
• Bachelor's degree in Computer Science or Information Systems or other technically relevant degree
• Experience with Ab Initio ETL Platform (plans, graphs, psets, meta-programming capabilities, etc.)
• Experience with PeopleSoft PeopleTools 8.5x and Integration Broker
• Experience with Ab Initio Express>It, Metadata Hub, Control Center
• Experience with existing Army Human Resources data and systems

Senior Business Intelligence & ETL Developer Resume Examples & Samples

• Participate in a full solution development lifecycle including: business case, prioritization, planning, design, development, testing, migration, and production support
• Work within an Agile/Scrum team to develop and maintain standard and ad-hoc reports
• Work within an Agile/Scrum team to develop and maintain data warehouse and ETL processes
• Assist internal business users with developing reports with web-based tools, including OBIEE
• Develop, design, tune and maintain SSIS packages to perform the ETL process
• Assist in strategic placement of business logic within the ETL and/or metadata models
• Work with System Administrators and DBAs to design monitoring and maintain the BI environment
• Commercial software development experience a plus
• Three years of experience with report building, data warehousing and metadata modeling is preferred
• Experience with Jasper Reports
• T-SQL, stored procedures and CTE querying techniques
• Participate in Design reviews, Test Case reviews, and Production Support readiness reviews for new releases, provide inputs for Go/No Go decision
• Provides team leadership in areas of specific technical knowledge that is frequently sought out by others with significant experience in a single, complex development environment or across multiple platforms
• Ensure that all documentation has been updated and that work product meets UDP / SOX compliance requirements
• Assist in Providing estimates on break/fix, and problem-management activities
• Identify application performance improvement initiatives and implement the same in consultation with the Service Manager
• Independent communication with business partners to resolve issues and negotiate project related items such as priorities and completion deadlines
• Document suggestions for continuous process improvements for both OM and development activities
• Provide timely updates on tasks to reporting supervisor
• Adherence to the defined delivery process/guidelines (SLA Compliance etc)
• Adherence to the defined OM delivery process/guidelines (SLA Compliance etc)
• Coordinating ETL strategies with other areas to ensure consistency across the enterprise
• Experience with Datastage is required
• Developing and maintaining standards, common processes and best practices
• Guiding, training, instructing and assisting others onshore/offshore on a variety of technical issues
• Help team members in technical problem of data stage, UNIX and Oracle
• Strong SQL Background

Microsoft ETL Developer Resume Examples & Samples

• Responsible for building tables and views in SQL Server
• Responsible for building SSIS packages to load data from source to SQL Server
• ETL Unit Testing
• Documenting entities that have been built
• BI Generalist with strong technical and nontechnical acumen
• 5+ yrs. SQL Server
• 5+ yrs. SSIS
• 5 yrs. experience in BI programming languages – T/SQL, PL/SQL, R, Python, Map Reduce, etc
• ETL technologies
• Thorough understanding of the major components of a BI platform implementation including Data Architecture, Analytics and Delivery
• Minimum of 5 years of experience working on Data warehousing and Business Intelligence projects
• Preference given to candidates with experience with SSRS and other MS reporting tools such as Power View and Power BI
• Self-starter and self-motivated with the ability to prioritize multiple demands
• Strong verbal and written communication skills, including: presentation, meeting facilitation, and documentation skills
• Good organizational, multi-tasking, interpersonal, and planning skills
• Ab>Initio
• Oracle 10 and 11g
• Unix basics and shell scripting
• L3 Support experience
• Experience in ETL development and implementation
• Well versed with ETL concepts and performance tuning
• Hands on Ab>Initio and Informatica PowerCenter development with design and build of medium to large enterprise projects
• Maintaining and demonstrating a good knowledge of the Financial Services and IT industries, having an in depth knowledge of either several technologies/ systems/ business operations, or expert knowledge of a particular subject area
• Working on a single complex project, or multiple standard projects
• Assisting in the definition and maintenance of middleware implementation level architectures
• Demonstrated experience in designing ETL processes using Informatica for high-volume, complex data environments
• Data warehouse data modeling experience
• Excellent Written and Verbal skills; Ability to Communicate effectively with all levels especially Executives
• Travel Industry data knowledge experience
• Code, test, modify, debug, document, and implement Ab Initio Graphs utilizing the GD Environment and EME
• Adhere to coding standards, procedures and techniques utilizing programming skills and contribute to the technical code base
• Document detailed application specifications
• Create and translate requirements into programmed application modules
• Participate in unit testing and integration testing
• At least 1 year of experience in design and delivery of ETL process development using Ab Initio and Unix shell script
• Proven track record of implementation and delivery of ETL Application
• Hands on experience in PL/SQL programming is preferred
• Knowledge of any of Ab Initio tools like Express>It, Authentication Gateway, Conduct>It, Metadata Hub and EME is preferred
• ETL and Informatica skills
• SOAP Web Services
• SSO SAML 2.0
• SFTP File Transfer
• 5-10 years of application development and familiarity integrating with 3rd Party applications
• Bachelor’s degree in Computer Science, Information Systems or related field, or an equivalent combination of education and work experience
• Minimum 5 years experience in application integration and development
• Possesses advanced skills and knowledge of development methodologies across various technologies
• Ability to effectively communicate both verbally and written to multiple levels of the organization
• Proven ability to lead teams and drive for results through others
• Proven ability for influencing current enterprise standards, industry standards, technologies, methodologies and best practices
• Exposure to project management preferred
• Completes integration development requests for both project and maintenance assignments
• Design, Build, Test and Maintenance of the process to properly load the transformed data into the target database
• 3, Development and Execution of ETL test plans
• Works in conjunction with development lead/manager to determine a strategic approach for each development assignment
• Work with tools and tech such as: lnfoSphere Data Stage CETL), Netezza (EDW), Embarcadero (Data Modeling)
• Follows change management procedures through the development process
• 7, Achieve the SLA’s defined by the team for support maintenance tasks
• Knowledge of Bl-related features and limitations for common database platforms (SQL
• Server, Oracle, 082)
• Ability to plan a solution architecture within an existing client environment
• Knowledge to plan and model data integration processes and to build data modelssupporting complex transformation
• Demonstrates ability to quickly learn new tools based on conceptual understanding of technology
• Exhibits ongoing personal commitment to staying current in field, architecture, technology changes in assigned areas using multiple sources and methods
• Strong analytical and troubleshooting skills required * Excellent planning and organization skills
• Efficiently managing multiple priorities in a fast paced and continuously changing environment
• Ability to work well independently with limited direction * Strong verbal and written communication skills
• Ability to effectively collaborate with business users
• Bachelor’s degree in computer science or related field is preferred * 3-5 years in the ETL technology space
• Emphasis on ETL/Data architecture and modeling for BI and Data Integration services
• Hands-on experience with ETL technologies (e.g. IBM DataStage/QualityStage, Informatica)
• Hands-on experience with Data Warehouse platforms (e.g. Netezza, Teradata, Exadata)
• Proven experience in working with all phases of the development lifecycle
• Convert designs and specifications into well structured, high quality, useable / re-usable code in a timely fashion
• Understand ETL specifications and build the ETL applications like Mappings
• Create mappings, sessions and Workflows as per requirement of business to implement the logic
• Perform code walk-through and debugging program code
• Perform Unit Testing on developed code / jobs
• Understand and perform Data Analysis, requirement gathering and Design and Development of code
• Create a mapping document based on High level design document
• Assist development team
• Coordinate with development team to create all ETL processes
• Provide an efficient interface for all processes across various platforms
• Evaluate functional requirements and map the documents
• Adhere to defined processes and involvement in process improvements
• Excellent UNIX and KORN shell scripting skills
• Demonstrated expertise in developing and maintaining complex ETL code to support large data volume movement
• Familiar with system automation techniques and best practices
• Strong knowledge and experience operating within and supporting data processing solutions that utilize Oracle RDBMS
• Excellent planning and time management skills
• 5+ Years working with and supporting the development, maintenance and production of complex database solutions – marketing solutions experience preferred
• Strong knowledge of PL/SQL and Oracle processing environments

Digitalisation ETL Developer Resume Examples & Samples

• Designing and documenting the ETL process for both Traditional and Big Data platforms
• Creating data extraction, cleansing and load programs to move data into and out of the Databases and Data Lake
• Working with Agile team members to document and execute test plans for data loading and data validation scripts
• Supporting the code promotion process through development and production as required
• Developing, implementing and maintaining the schedule/dependency logic for automated ETL processing
• Developing monitoring, logging, and error notification processes to ensure data is updated as expected and processing
• Bachelor’s degree in Computer Science, Mathematics or equivalent
• At least 5 years of ETL programming experience required
• At least 3 years of experience in complex SQL with high-value databases
• Solid experience in in a big data environment (Hadoop DFS) as well as with traditional data warehouses required
• Experience with Hadoop (HortonWorks), Talend, Tibco SAP
• Flexible and open minded to change
• Ability to work both independently and contribute to the Team
• English: Negotiation level

Data Mart ETL Developer Resume Examples & Samples

• Business requirement gathering and creating technical specifications
• Design and implement Extract, Transformation, and Load (ETL) processes
• Follow change management, deployment and process/procedure documentation
• Experience working with databases ( DB2, Sybase, Oracle, etc)
• Proficient SQL and stored procedures
• Scripting knowledge (UNIX or Perl)
• ETL development experience
• Integrity & ownership, good team player, ability to work under time and
• Informatica Power Designer
• Q/KDB, Greenplum, DB2
• Tableau and Qlikview
• 3 to 6 years in a development role
• The candidate should be proficient with Oracle PL/SQL, Stored Procedures and Unix
• Non-technical knowledge, experience, and skills (leadership, management, oral, and written communication)
• The candidate must possess excellent communication skills as they will be interacting with people with diverse skills and seniority across different locations and time zones
• The candidate should have strong analytical skills
• Educational requirements: BE/B Tech
• Language requirements (including proficiency levels for speaking, reading, and writing): English - excellent
• Candidate should be willing to be flexible in terms of working hours to have overlap with the India Development team
• Comfortable working directly with business partners in Marketing, Finance and Operations at all levels of the organization (senior leadership, resort partners, and other technologists)
• A “can-do” attitude to dig into existing challenges, get creative, and efficiently build out solutions across the business
• Ability with and interest in mentoring more junior ETL Developers
• Has experience working with and architecting ETL technologies, specifically Informatica
• Has experience with SQL Server, SQL Analysis Services
• Experience designing and implementing information solutions
• Has experience working with other data integration technologies, such as Data Stage, SSIS, etc
• Has experience incorporating API’s into data reporting experience
• Loves being hands-on in a fast-paced, entrepreneurial environment
• 3-5 years of experience with Informatica Power Center
• 3-5 years of experience with Microsoft SQL Server
• 1-3 years of experience with Salesforce.com, Heroku and Pentaho
• Experience with Master Data Management principles and technologies
• Collaborate with Investments Operations, Accounting and Controllership teams to construct long term IT solutions to support Genworth’s investment goals
• Support the operation and maintenance of Genworth Investments Accounting Platform (PFI)
• Manage the day to day operation and coordination of systems processes and enhancements
• Code and maintain custom or canned reports, system interfaces and extracts
• Create interfaces and load-scripts to ancillary financial and reporting systems
• Coordinate with project, support, and business analysts to deliver new or enhanced application code solutions
• Collaborate with Business Analysts to create technical/functional test plans and scripts to validate design, development and implementation of system/reporting deliverables, and obtain user sign-off
• Monitor Accounting system related IT processes and ensure successful completion of production daily and monthly runs
• Support the Genworth Investments and accounting functions by trouble-shooting and performing root cause analysis of application problems. Identify action items and make recommendations to address process and/or coding issues
• Monitor process metrics and initiate process improvement efforts for IT processes
• Coordinate the conversion of accounting interfaces, reporting and downstream extracts to the new Enterprise Data Management environment
• Some travel may be required (<10%) between Genworth's Richmond and Stamford facilities
• 2+ years of software development experience and working knowledge of Relational DBMS development using PL/SQL (Oracle) or T-SQL (Microsoft SQL Server)
• Solid experience with Informatica
• Demonstrated expertise in developing complex backend systems using Java, C#, .NET or C++ with solid object oriented programming design concepts
• Bachelor’s degree in a computer and/or finance or accounting related fields
• Minimum 2 years as applications developer
• Working knowledge of System Development Life Cycle (SDLC) and/or Relational Database Management Systems (RDBMS)
• Experience in developing and/or supporting Accounting, Finance, Investments, Portfolio Management and/or Capital Markets systems
• Experience translating functional business requirements to technical specifications (preferably in the finance, accounting, derivative or portfolio management sectors)
• Proven history of detail oriented execution and commitment to customer satisfaction
• Experience and working knowledge in Data Warehouse, ETL, & Hadoop framework components
• Experience or working knowledge of investments accounting systems such as PAM/PFI
• Experience in working with securities & reference data feeds, such as Bloomberg, Thomson Reuters, S&P, Moody’s, IDC, Markit, or similar
• Experience and working knowledge of financial reporting and investments accounting principles
• Experience in supporting complex production application processes
• Experience working in a matrix and distributed environments
• Ability to multi-task, prioritize and execute on assigned deliverables
• Ability to quickly learn new systems and business processes
• 1+ years of experience with Java and JavaScript
• 1+ years of experience with relational databases
• 1+ years of experience in the development, maintenance, and enhancement of data mappings, work–flows, and processes
• Experience with PostgreSQL, Pentaho Kettle, Accumulo, SOLR, NetOwl, Tableau, and PhantomJS
• Experience with a variety of data feed types, including RSS, SOAP, and REST
• Experience with DoD or IC clients
• Experience as a database administrator
• Knowledge of the Agile software development process, including Kanban
• BS degree in IT, CS, Computer Engineering, or Systems Engineering preferred
• Professional Certifications related to Database Administration, ETL, or Business Intelligence preferred
• DoDD 8570 Compliance, including Security+ Certification
• Engineer position will support full systems development life cycle for enterprise information management services team
• Research and evaluate current and upcoming technologies and frameworks. Bring innovative new thoughts and ideas to team and help facilitate ideation with team members at various levels
• Support senior technical team in PoCs (Proof of Concept) and help the Department with selection of Vendor Solutions, Technologies, Methodologies and Frameworks. Collaborate with Vendor Resources for Support of Products
• Follow and promote Quality Assurance and Quality Control processes in the department. Actively look for opportunities to enhance standards and improve process efficiency. Ensure adequate test coverage in Unit Testing, System Testing/Integration Testing and Performance Testing. Support senior technical team with Quality Inspections and Walkthroughs throughout the SDLC including Requirements Review, Design Review, Code Review and Security Review to ensure compliance with MasterCard standards
• Partner with globally distributed team to collaborate on day to day activities
• Enterprise Architecture team provides data and integration services across multiple technology domains within MasterCard Technologies
• Capabilities supported include Master Data Management, Data Integration, Data Quality, Data Transformation, Data Governance and various other enterprise level data integration and information management capabilities
• Associate Software Engineer position will be responsible for the analysis, design, development and delivery of software solutions
• Assists with the creation of documentation such as user guides and software development guides for less-complex projects
• Assists senior team members in the development of web applications, system to system interfaces and complete software solutions
• Significant code development and day-to-day support duties
• Do you have the ability to work in a fast paced environment, are you adaptive to change, and do you possess the through leadership to challenge status quo?
• Do you consider yourself to be an innovator, and do you enjoy the challenge of building sophisticated solutions to solve global business problems?
• Are you motivated to be a part of driving a world beyond cash?
• Associate Software Engineer position will support full systems development life cycle for enterprise information management services team
• At least 5 years of experience with design, development, automation, and support of applications to extract, transform, and load data
• At least 5 years experience within a total information technology (IT) environment
• At least 2 years experience with Informatica PowerCenter Big Data Edition (BDE ) or Talend
• Excellent verbal and written communication skills, including communicating technical issues to non-technical audience
• Self-motivated, Inclination to learn new things and ability to adapt and change and make progress
• Minimum of 5 years of experience with Relational databases and working with large data warehouses
• Minimum of 2 years of experience with HortonWorks Framework and Hadoop technologies like HDFS, Hive, MapReduce and experience with developing ETL using these technologies (Talend, SQoop and SPARK)
• Minimum of 5 years of hands-on experience with Unix/Linux shell scripting
• Performance tuning and optimization techniques of Hive QL to process big data from heterogeneous sources
• Excellent Problem solving and Technical troubleshooting skills to provide application support
• Ability to handle multiple projects and prioritize tasks in a rapidly changing environment
• Work on design and development of large volume data processing applications / operational stores in iterative / agile development model
• Prepare design / solution analysis based on requirements from internal and external sources to evaluate and demonstrate program effectiveness and efficiency, and problem solving
• Research complex functional data / analytical issues
• Utilize Talend for ETL within a Hadoop / Big Data environment
• 3+ years of ETL development experience (SSIS, Informatica, DataStage, Talend, etc.)
• 3+ years of RDBMS development experience
• 3+ years experience designing and implementing effective data strategies in enterprise level data stores, data marts or data warehouses
• Experience working in Big Data / Hadoop environment
• Healthcare industry / claims experience
• Design and develop Business Objects reports, universes, Explorer Information spaces
• Design and develop ETL from multiple data sources into relational or In-Memory database engine
• Troubleshoot with SAP Business Object Data Services or other similar tools
• Server management and administration including basic scripting
• **An interim Secret clearance is required to begin working onsite with our client, and a Secret clearance must be maintained throughout the project duration. Due to the nature of the government contract requirements and/or clearance requirements, US citizenship is required
• Experience in BI reporting and data migration
• 2-3+ years’ experience in dimensional data modeling, ETL development, and Data Warehousing or data-mart environment
• Excellent knowledge of SQL and Windows/ Linux OS
• Knowledge of Data migration / integration with SAP Business Object Data Services
• Business Intelligence background in SAP Business Object is highly desired,
• Understanding reporting essentials in order to coordinate with and assist reporting teams with issues and/or Server side
• Good knowledge of Oracle database, and/or In-Memory database SAP-HANA
• SAP Business Object Data Services ETL technical capabilities to include experience in implementing and optimizing ETL process using SAP Business Object Data Services
• Knowledge of an Enterprise Job Scheduling software is a plus
• Effectively communicating with customers to gather requirements, resolve issues
• Implementation of automated ETL routines
• The construction of OLAP databases in Microsoft SQL Analysis Services
• User-Defined Functions, etc. in Microsoft SQL Server
• Implementing data marts
• Development of Stored Procedures
• As a successful candidate, you will have skills for the construction and delivery of multi-delivery of multi-dimensional databases, OLAP cubes, Star Schemas, and Dimensional Data Models
• Your experience will include (at least one of) the following tools
• Microsoft SQL Server 2005 Integration Services
• Microsoft DT
• Ascential DataStag,
• Sagent or other enterprise-type ETL tool
• Experience coding, optimizing, analyzing Transact-SQL on a Microsoft SQL Server platform
• Microsoft Analysis Services or other OLAP engines such as Hyperion, Cognos, Business Objects, or MicroStrategy
• Data Warehouse / Data Mart Development
• Experience leading and mentoring a team
• Bachelor's degree in Statistics, Mathematics, Engineering, Computer Science, Information Technology or related fields
• 2+ years in ETL development
• SQL Scripting Experience
• Knowledge of financial industry data is an advantage
• Statistical analysis and data mining packages such as SAS, SPSS, Minitab or R is an advantage
• Big Data Development experience is an advantage
• ETL development
• The primary responsibility and majority of the work will be hands-on development
• Performance tuning and bug fixing (secondary responsibilities)
• Interacting with QAs and UAT Testers and occasionally with PMs
• 24/7 Support (rotation every 5 weeks)
• Strong database SQL experience
• ETL experience - strong preference for SSIS 2012

Migration ETL Developer Resume Examples & Samples

• Industrial engineering or computer science graduate - advantage
• Good Knowledge of the insurance business (experience in the actuarial or insurance fields) – advantage
• Experience working with customer’s requirements and to translate them into functional, data mapping/transformation requirement and interface specifications
• Good knowledge of Office tools
• Ability to translate functional requirements to test scenarios
• System analyst with experience in Data Migration or Data Integration - advantage
• Excellent communications skills in English – must
• Personal skills: Independent worker, outside the box thinking, presentable
• Knowledge on K2VIEW or any other ETL tool - must
• Experience working with data models and data structures of complex systems
• Experience in analyzing and implementing interfaces between system - advantage
• SQL knowledge – Must
• PHP experience - advantage
• Experience or degree in programming - advantage
• Agree to travel in some cases extensively
• Experience with overseas customers
• Five years’ developing and implementing enterprise-scale ETL processes utilizing Informatica and/or Microsoft SSIS
• Extensive experience with data warehouse technologies and implementations such as ETL (Informatica) processes, dimensional modeling, and reporting tools
• Experience with Kimball Dimensional Modeling, Bus Matrix and DW Lifecycle (Facts, Dimensions and SCD’s)
• Experience creating complex ETL data processed in a clear and concise format
• Experience in analyzing query performance issues and modifying data structures or application code to remedy performance problems
• Experience in Oracle 11g with Progress experience a plus
• Experience in Columnar Database Technologies a plus
• Experience working with predictive analytics and statistical software (SAS) a plus

ETL Developer Informatica Resume Examples & Samples

• Provide complete life-cycle in designing, developing, implementing and supporting sophisticated BI data manipulation processes
• Proactively analyze and identify problem areas and plan/implement steps for process improvement
• 4+ years of experience with Data Integration Solutions
• Exposure to OLAP, OLTP, Data warehouse, Data mart development, Fact and Dimensional DB designs
• Strong professional consulting skills and ability to communicate well at all organizational levels
• Knowledge of other ETL tools (e.g. SAP Business Objects Data Services/Data Integrator, Informatica, Oracle Data Integrator, or Data Stage) is preferred
• Exposure to Business Intelligence tools such as: SAP Business Objects, Microsoft BI Stack, IBM Cognos, Oracle OBIEE or Microstrategy is preferred
• Develop relationships with application owners and business partners to understand and translate business requirements into data strategies
• Work closely with Data Warehouse Architect and BI Solution Architect to design data and analytics solutions to increase the usability, completeness, and accuracy of enterprise data
• Develop SSIS and T-SQL packages and stored procedures related to the extraction, transformation, and loading (ETL) of the organization’s data assets
• Monitor and support ETL processes ensuring integrity and proper integration of all data sources
• Research and resolve data, procedural, and technical issues with a sense of urgency
• Responsible for data profiling as well as SQL and database tuning and optimization
• Proactively identify, communicate, and implement opportunities for data integration and quality improvements
• Implement production fixes, support packs, and enhancements; on-call rotation included
• Provide SQL Server database support such as capacity planning, backups, restores, tuning, and user provisioning
• Develop, adopt, and enforce Data Warehouse and ETL standards and architecture
• Write and maintain Data Warehouse and ETL knowledge base documents
• Bachelor’s Degree in Computer Sciences or equivalent education and experience is required
• 3+ years of experience delivering Data Warehousing and ETL solutions
• 3+ years of experience with SQL Server databases
• Strong understanding of data architecture, data warehouse modeling, data integration, data quality, and other data services related to business intelligence environments
• Proficient in SQL and at least one ETL development tool such as SSIS, Informatica, etc
• Ability to thrive in both individual and team environment

ETL Developer, Junior Resume Examples & Samples

• Creates, updates, captures and edits functional and technical design specifications and solutions to satisfy project requirements
• Provides hands-on technical solutions to business challenges and translates them into process/technical solutions
• Conducts testing and resolves issues found in testing
• Meet deadlines and manage multiple, dynamic prioritiesEDUCATION & EXPERIENCE
• Bachelor’s degree in Computer Science, Mathematics, Information Systems or other technically relevant degree
• One year or more years of experience or equivalent training/studies in system design and development of enterprise applications/systems
• Good understanding of programming concepts, relational databases and experience with SQL development
• Must have strong analytical skills and can demonstrate strong problem solving skills
• Experience in design, development of conversions and interfaces with ETL tools such as Data Stage, Informatica or Ab Initio
• Experience with PeopleSoft or similar ERP Applications
• ETL Operations of Oracle 12c DB (L2 support)
• Develop and maintain Oracle PLSQL code necessary to support the ETL processes
• Manage automation of file processing as well as all ETL processes within a job work flow
• Ensure data quality throughout entire ETL process
• To support availability and outcomes of Prepaid system
• Solving incidents & problems in cooperation with internal and external partners (e.g. Business owner, Care/Tech. Support Team, Oracle support, data center operation)
• Operations of essential financial processes (e.g. Month End Closing)
• Metadata Management & Operations Support for BI/Tableau Applications
• Ensuring data quality and data consistency
• Monitoring jobs and run times
• Conducting preventative maintenance of the systems
• Drive system optimization and simplification
• Supporting business power users in system handling and optimizing
• Bachelor's Degree in computer science or equivalent experience required
• 5 years' experience in managing data lineage and performing impact analyses
• Expert ability in SQL, PL/SQL and ETL tools
• Excellent ODI ETL design and documentation skills
• 5 years' experience with ETL tool development to include 2 years' experience with the Oracle Data Integrator ETL tool development
• 6 years' experience with Oracle 10, 11g or 12c
• Unix/Shell scripting knowledge
• Java knowledge a plus

AWS / ETL Developer Resume Examples & Samples

• Translating functional and technical requirement into detailed architecture and design
• Coding and testing complex system components
• Participating in code and design reviews to maintain out high development standards
• Candidate should have good on working knowledge on AWS cloud
• Candidate should have AWS Service knowledge with S3 storage understanding
• AWS Pipeline knowledge to develop ETL for data movement to Redshift
• AWS Redshift knowledge for DB design
• AWS Dynamo DB knowledge
• AWS EMR (Elastic Map Reduce) knowledge is good to have
• Candidate should have good knowledge of Data warehouse knowledge
• Candidate should have Data Analysis exp. to map the source to target rules and fields

Senior Manager, ETL Developer Resume Examples & Samples

• Strong ETL (extract-transform-load) developer
• 10 years’ experience with Oracle versions including 9, 10 and ODI or MS SQL Server and SSIS or Informatica
• 5 years’ experience in managing data lineage and performing impact analyses
• Expert ability in SQL and PL/SQL
• Responsible for the design and implementation of quality logical and physical ETL designs that have been optimized to meet the operational performance requirements for our multiple solutions and products
• Development of ETL code, metadata definitions and models, queries and reports, schedules, work processes and maintenance procedures
• Design, development, and delivery of data from operational systems and files into a staging area, ODSs (operational data stores), Data Warehouse, downstream Data Marts and files
• Develop and deploy ETL job workflow with reliable error/exception handling and rollback framework
• Manages automation of file processing as well as all ETL processes within a job workflow
• Ensures data quality throughout entire ETL process
• Manage software upgrades, capacity planning and system optimization
• Perform the unit testing, system integration testing and assist with user acceptance testing
• Adapt ETL code to accommodate changes in source data and new business requirements
• Document the ETL detailed design and test results
• Prioritize development and enhancement requests
• He/she has the experience to design the optimal performance strategy, and manage the technical metadata across all ETL jobs
• Ensures compliance with regulatory requirements for data transmission, storage, and data access including documentation, testing, and remediation
• Collaborates with subject matter experts, department Leaders and consultants to define and execute cross-functional data movements
• Able to develop simple, complete useful solutions
• Understand database object development, security and connectivity services, batch scripting, automation, scheduling, real-time processing, columnar data structures and processing, in-memory processing
• Understands delegation of duties requirements
• Modeling and technical design for BI – including materialized views, Stored procedures, reporting views, MOLAP structures
• Understands / worked with master data management and governance
• BS degree, or greater in a computer discipline or relevant certification
• This role can involve working to tight deadlines and when necessary, long hours. IT professionals working in this area may also be needed to be available for call-outs on evenings and weekends
• Problem solving skills and ability to think algorithmically
• Experience working directly with user-group
• Advanced ability in follow-through and task management
• Works in agile environment

Interface / ETL Developer, Senior Resume Examples & Samples

• Supports and independently owns tasks related to design, development of conversions and interfaces
• Conduct Unit testing and resolve issues found in testing
• Provides overall technical and logistical support to the program
• At least 2 years of experience in design, development of conversions and interfaces with ETL tools such as Data Stage, Informatica or Ab Initio
• Experience in reading/writing source to target mapping documents
• Strong analytical skills and can demonstrate strong problem solving skills
• Ability to attain active Secret clearance
• Experience with PeopleSoft HCM 9.2
• Experience with DoDAF Artifacts
• Work under the direction of the Manager to provide technical application solutions for assigned business areas
• Possess technical knowledge of assigned application technology
• Work with Business Analyst to understand the customer’s product-specific requirements and configuration and translate them to technical design specifications and data flow from which programs are developed and coded
• Codes, tests, debugs, implements, and documents programs or technical configuration
• Ensure programs meet technical specifications and standards
• Interact with Business and clinical representatives during the software build or configuration and testing process
• Perform technical application configuration and configure /run reports at user request
• Design and execute unit, system and integration test plans for new developments/releases/reports
• Design, develop, and implement ETL solutions using SSIS
• Data profiling, outcomes reporting, and build solutions
• Maintain technical documentation based on standard operating procedures in support of the assigned application
• Perform application maintenance activities
• Assist in resolving support calls escalated by the Service Desk
• Identify the common causes of the defects, prioritize them and systematically remove them so that they do not reoccur in further development work
• Coordinate with Project Managers to ensure project deadlines are met
• Participate in focus groups and workshops, attend vendor training and demonstrations
• Assist in supporting activations and rollouts
• Consistent efforts to deliver quality solutions as per agreed scope
• Customer focus and close alignment with the customers’ business objectives
• Ensure efforts to continually improve domain knowledge
• Ensure the quality of the deliverables as per the defined standards
• Document issues with resolutions and share with team members to improve team productivity
• Provide data to generate team performance metrics
• Knowledge transfer with other team members to improve overall team education level
• Take complete ownership for the assigned task and timely inform the progress of the project / task to all stakeholders
• Adherence to the defined standards
• Take initiative and drives to bring to logical conclusion; proactive approach
• Provide accurate and timely information and escalates when there are issues
• Actively participate in meetings and make valuable contribution
• BA or BS degree preferred or other relevant combination of training and experience
• 2-5 years health care industry experience focusing Utilization management and Quality reporting preferred
• 5 plus years extensive experience in providing analytical support in assigned product preferred
• 2-5 years of ETL development experience using SSIS
• 2-5 years of hands on MS SQL experience
• 1-2 years of data stage experience preferred

ETL Developer, Temporary Resume Examples & Samples

• Write and maintain documentation of the ETL processes via process flow diagrams
• Develop/make enhancements to new/existing data systems and assist with the development of logical data models
• Perform unit testing of ETLs and related components and document test results
• Perform troubleshooting on ETLs and related components, identify application bottlenecks and opportunities to optimize performance
• Provide resolution to an extensive range of complicated ETL-related problems, proactively and as issues surface
• Strong understanding of relational database structures, theories, principles, and practices
• Understanding of Data Warehousing methodologies and concepts, including and not limited to: star schemas, ETL processes, dimensional modeling and data modeling techniques
• Experience in query performance analysis, and issue detection
• Knowledge of TSQL and exposure to Microsoft SQL Server technologies including SSIS
• Understanding of network topology
• 3+ years of Development experience, specifically working with ETL
• Strong expertise in SQL Server Integration Services (SSIS) and SQL Server Databases
• Extensive experience working on the full SDLC
• Hands-on experience working with AS400 and Destination
• Expert experience with data extraction and mapping
• Deliver projects/work on-time, on-budget, and in a way that accomplishes client goals
• ETL Repository Management, maintain appropriate backups and Multi-project/Multi-concurrent release ETL environment
• Able to read Data Models to translate them into ETL or ELT loads into Data Warehouses and Data Marts
• Analyze source system data to assess data quality. Work with technical and business representatives to determine strategies for handling data anomalies that are identified. Design ETL processes and develop source-to-target data mappings, integration workflows, and load processes. Design, develop, and implement enterprise-class data warehousing solutions
• Use the SSIS platform to extract, transform, and load data. Develop, test, integrate, and deploy ETL routines using ETL tools and external programming/scripting languages as necessary. Write and maintain unit test cases
• Apply creative thinking to identify possible bottlenecks and reporting solution alternatives
• 5+ years of business/technology work experience
• 6+ years of hands-on experience with ETL Processes
• Possess understanding of modern data warehouse architectures and data warehouse modernization techniques
• Good knowledge of BI architecture, data warehousing concepts
• Data Integration Tools: MS SQL Server SSIS
• Knowledge and experience with Informatica products a plus
• Able to critically think and be solution-oriented
• Great organizational, time management and problem solving skills
• Possesses a professional demeanor
• 2+ years of experience with DWH projects
• Advanced SQL and procedural SQL (PL-SQL) knowledge
• Experience with database systems such as Teradata, Oracle or DB2 in similar positions (DWH ETL development, stored procedures development, DDL scripts, DML scripts)
• Development experience with some ETL tool (e.g. Informatica, Datastage, ODI, Abinitio, etc.)
• Willingness to relocate to Prague, Czech Republic and travel abroad
• EU Citizenship
• Support the maintenance and development of the extract transform and load (ETL) aspects of the data warehouse
• Maintain an understanding of the inputs received from the data source providers
• Support the analysis, design, development and implementation of new ETL requirements
• Mentor developers in best practices and techniques
• Support testing and validation of the new data conversion processes
• Utilize oral and written skills and strong analytical and problem solving capabilities
• Work in a dynamic environment and have a working knowledge of the SDLC and the associated processes and documentation

Data Analyst & ETL Developer Resume Examples & Samples

• Perform ETL development work during iterations. Participate in Iterations, including Scrum meetings, to understand functionality that will be deployed to Production. Complete assigned development during iterations and resolve defects. Develop and maintain documentation according to Data Lake standards. Accountable for quality and timeliness of technical and business solution that meets Data Lake's business needs
• Participate with Dev team for awareness. Reviews Dev plans and Dev tasks after completion as well as test scripts for learning new function
• Perform hands-on data analysis and development using Datastage
• Ability to continue to work on open issues as required (i.e. some issues must continue to be worked through resolution across shifts; some issues are in progress of being worked and require continued follow-up and communication to Super user Community, etc.)
• Perform operational and project tasks related to Production Support activities as needed. This covers tasks such as request analysis, design, documentation, test management and test execution
• Monitor job schedules/check data load schedules and take corrective action for failures. Resolve issues quickly to maintain SLA for report distribution. Conduct initial Root cause analysis for errors and defects, provide as much details as possible when requesting help from others, clearly communicate the status of the issue, including analysis that has been completed and the help that is required to work through the issue. Conduct RCA to determine root cause. Identify preventive measures and implement to avoid future issues
• Write stored procedures and functions as required using the PDA (Netteza) platform
• Log and track defects, respond/communicate with Super users and IBM Teams. Works closely with Super users, provide good responses, timely responses to concerns, questions, issues
• Helping with missing/incorrect data and comparison with the DB. Helping/Testing incorrect functionality issues. Investigate incorrect/missing data issues, functionality issues, US errors or user profiling issues
• Degree in Computer Science or Computer Engineering
• 3-5 years DataStage experience in large Information Warehouse (IW) projects, preferably in Manufacturing / Supply Chain environments
• At least 3 years experiences in Data Analysis
• Good understanding of IBM InfoSphere Data Stage (Data Stage designer, director and administrator)
• Solid Knowledge of SQL, writing stored procedures
• Strong development experience in ETL using Data Stage
• Good understanding of ETL design patterns (load strategies, error handling techniques & data cleansing methods)
• Knowledge of installation & configuration of Data Stage will be added advantage
• Data Modeling concepts (Dimensional and Relational) will be plus
• Experience in Manufacturing or Supply chain centric industries would be preferred
• Experience in DB2 and Nettezza database is a plus
• Solid communication skills, ability to articulate clearly the status, next steps and recommendations
• Self-motivated, proactive, fast learner takes ownership of tasks and works through completion
• Ability to do research, analysis of issue and understand how to analyze the jobs and dependencies to find the cause of the issue
• Collaboration and problem solving skills, analytical thinking and troubleshooting are critical

Related Job Titles

• • Led the design and deployment of a scalable data warehousing solution, processing over 2TB of data daily with optimized ETL processes.
• • Spearheaded a successful data migration project transferring 5+ years of historical data to a new cloud-based platform, enhancing data accessibility.
• • Managed a team of developers in the creation of complex SQL queries and Python scripts, which reduced data retrieval times by 35%.
• • Developed and maintained robust DataStage pipelines, contributing to a 20% improvement in data integrity and accuracy across key business segments.
• • Collaborated closely with cross-functional teams to understand data needs, resulting in the delivery of nearly 100% uptime for critical analytics services.
• • Implemented comprehensive unit test plans and supported regression testing, achieving a defect reduction rate of 25%.
• • Enhanced data integration strategies, effectively consolidating data sources by 15%, which streamlined reporting functions.
• • Facilitated ETL processes and best practices that led to a 30% increase in process efficiency for data warehousing tasks.
• • Implemented Python scripts that automated routine data transformation tasks, saving over 200 hours of manual effort annually.
• • Pioneered a cloud-based ETL solution using AWS services, setting a foundation for subsequent cloud initiatives.
• • Resolved critical issues in production systems, drastically reducing downtime by 40% through proactive problem-solving.
• • Designed and executed DataStage jobs for complex data transformations, supporting key decision-making processes.
• • Developed SQL queries for data analysis purposes, enhancing reporting capabilities for stakeholders.
• • Collaborated on the technical design of new feature development, improving data throughput by 25%.
• • Played a crucial role in the development team that achieved 99.9% accuracy in data migrations.

10 ETL Developer Resume Examples & Guide for 2024

Your ETL developer resume must prominently display your technical expertise. Highlight your experience with tools like Informatica, Talend, or SSIS. Showcase your proficiency in data warehousing concepts and SQL. Your resume should reflect your ability to transform complex data into actionable insights.

All resume examples in this guide

Junior ETL Developer

Senior ETL Developer

Informatica ETL Developer

Python ETL Developer

SSIS ETL Developer

Datastage ETL Developer

ETL BI Developer

Java Developer with ETL

Big Data ETL Developer

Resume guide.

Resume Format Tips

Resume Experience

Skills on Resume

Education & Certifications

Resume Summary Tips

Additional Resume Sections

Key Takeaways

By Experience

As an ETL developer, articulating the complexity of data extraction, transformation, and loading processes on your resume can be a formidable challenge. Our comprehensive guide is designed to help you distill your technical accomplishments into clear, impactful statements that will captivate potential employers.

• [Job title] resume samples that got people hired at top companies.
• How to perfect the look-and-feel of your resume layout.
• How to showcase your achievements and skills through various resume sections.
• How you could hint to recruiters why your resume is the ideal profile for the job.

If the etl developer resume isn't the right one for you, take a look at other related guides we have:

• System Analyst Resume Example
• IT Specialist Resume Example
• Computer Engineer Resume Example
• System And Network Engineer Resume Example
• SAS Clinical Programmer Resume Example
• Technology Manager Resume Example
• Security Director Resume Example
• .Net Full Stack Developer Resume Example
• Splunk Developer Resume Example
• IT Security Manager Resume Example

Creating the best etl developer resume format: four simple steps

The most appropriate etl developer resume format is defined by precision and a systematic approach. What is more, it should reflect upon how your application will be assessed by recruiters. That is why we've gathered four of the most vital elements to keep in mind when designing your resume:

• It's all about presenting how your experience or skills align with the job. Use the reverse-chronological resume format , if your expertise is relevant to the etl developer role. Otherwise, select the functional skill-based resume format or the hybrid resume format to shift the focus to your skill set.
• Resume header - make sure you've filled out all relevant (and correct) information, like your contact details and link to your portfolio.
• Resume length - unless you've over a decade of applicable expertise in the field, stick with a one-page resume format. If you'd like to present more of your professional experience, go up to two pages.
• Resume file - submit your etl developer resume in a PDF format to ensure all information stays in the same place.

Upload & Check Your Resume

Drop your resume here or choose a file . PDF & DOCX only. Max 2MB file size.

Bold the names of educational institutions and certifying bodies for emphasis.

The key to your etl developer job-winning resume - present your expertise with these sections:

• A header to make your resume more scannable
• Snapshot of who you are as a professional with your resume soft skills, achievements, and summary or objective
• Job advert keywords in the skills section of your resume
• Resume experience quantifying your past job successes with metrics
• A relevant education, certification, and technical sills section to provide background to your technological/software capabilities

What recruiters want to see on your resume:

• Proficiency in ETL tools such as Informatica, Talend, SSIS, or DataStage
• Experience with SQL and database technologies like Oracle, SQL Server, and DB2
• Knowledge of data warehousing methodologies and concepts, such as dimensional modeling and star schemas
• Experience with data integration and transformation processes, including data cleaning, standardization, and deduplication
• Understanding of big data technologies such as Hadoop, Spark, or NoSQL databases, and experience with cloud data services like AWS, Azure, or GCP

Creating your etl developer resume experience to catch recruiters' attention

Remember that for the etl developer role, hiring managers are looking to see how your expertise aligns with their requirements. Here's where your resume experience section can help out. Make sure you:

• Include mainly roles that are relevant to the etl developer job you're applying for;
• Don't go too far back in your experience - recruiters will only care what you did a decade ago if it's really important for the etl developer role;
• Each bullet you include should say what you did, followed by the skills you used and the actual end result of your efforts;
• Quantify each of your achievements with numbers and possibly the overall effect it had on the organization;
• Highlight transferrable skills - or personal skills you've attained thanks to past jobs - that could be applicable within your potential workplace. This would showcase your unique value as a professional.

Formatting the experience section of your resume doesn't have to be an over-the-top deep dive into your whole career. Follow the etl developer resume examples below to see how industry-leading professionals are presenting their experience:

• Designed and implemented robust ETL pipelines for streaming and batch data processing using Apache NiFi, handling over 500GB of data daily with a 99.9% uptime.
• Collaborated closely with the data science team to deploy machine learning models into production, leading to a 20% increase in the precision of targeted marketing campaigns.
• Optimized data warehousing solutions in AWS Redshift, including designing sort and distribution keys, resulting in a 30% reduction in query response time.
• Developed ETL processes using SQL Server Integration Services (SSIS) to integrate data from multiple sources, achieving consistent data formats across the organization.
• Created and scheduled SQL jobs to automate daily data cleansing, which eliminated 90% of the manual data entry errors.
• Led the migration of ETL workflows from legacy systems to modern platforms, which streamlined data operations and supported a 25% growth in data volume without additional resources.
• Engineered real-time ETL solutions using Apache Kafka, processing over 100,000 messages per second to support operational analytics.
• Automated data quality checks that reduced data discrepancies by 40%, ensuring higher accuracy for business intelligence reports.
• Pioneered the adoption of a test-driven development workflow for ETL tasks that decreased production rollbacks by 60%.
• Developed complex data extraction scripts using Python and SQL which serviced over a dozen downstream analytics applications.
• Collaborated on a cross-functional team to support the launch of a new product line, which increased company revenue by 15%.
• Introduced automated monitoring tools for ETL jobs that reduced downtime incidents by 50% and significantly improved data SLA compliance.
• Implemented an ETL framework using Talend Open Studio, which improved ETL job development speed by 35%.
• Conducted performance tuning of Informatica PowerCenter ETL jobs, cutting down average load times from 60 minutes to under 30 minutes.
• Trained a team of junior ETL developers, enhancing the team's productivity and knowledge base in ETL best practices.
• Streamlined ETL processes which integrated data from multiple e-commerce platforms, boosting analytical capabilities and supporting a 10% annual revenue increase.
• Implemented comprehensive data validation and error handling logic within SSIS packages, ensuring a 98% accuracy rate of data loads.
• Facilitated compliance with GDPR and other data governance standards by establishing encrypted data transfer and storage protocols.
• Designed end-to-end ETL processes for a major financial services firm, which enabled real-time analytics and reporting on transactional data.
• Resolved long-standing data consistency issues by redesigning the staging area and implementing a metadata-driven ETL framework.
• Created custom SQL scripts to extract and transform complex financial datasets for regulatory reporting, ensuring 100% compliance.
• Developed ETL procedures to migrate legacy CRM data into a new cloud-based platform, improving data accessibility for remote sales teams.
• Optimized the loading process of dimension tables in a star schema data warehouse, cutting the ETL execution time by half.
• Crafted detailed documentation for all ETL jobs, which became the standard for the company's data management practices.

Quantifying impact on your resume

• Highlight the amount of data you've managed and processed to demonstrate your ability to handle large-scale ETL projects effectively.
• Quantify the number of ETL pipelines you have developed, showcasing your experience and productivity.
• Specify the percentage of data quality improvement achieved through your data cleansing and transformation work.
• Detail the number of data sources you have integrated, illustrating your versatility and integration skills.
• Enumerate any performance optimizations made in ETL processes that led to time and cost savings.
• Include the scale of databases or data warehouses you've worked with to show your competency with various storage solutions.
• State the number of business intelligence solutions you've supported with ETL, underscoring the value you added to decision-making processes.
• Count any reductions in data latency you contributed to, reflecting your efficiency and understanding of real-time data requirements.

Action verbs for your etl developer resume

How to shift the focus from your etl developer resume experience section to your professional profile

If you're at the start of your career journey or transitioning industries, you might be concerned about the lack of professional experience while crafting your etl developer resume.

How can you effectively present your etl developer resume experience section under these circumstances?

Rather than a traditional, extensive experience section, demonstrate your expertise through:

• Emphasizing your education. Your academic background might impress recruiters, especially if it includes recent, industry-relevant knowledge;
• Creating a compelling objective statement. The first few sentences of your resume should map out your motivations and career aspirations, offering insight into your goals;
• Highlighting your transferable skills. For example, if you've honed communication skills through volunteering, illustrate on your etl developer resume how these can benefit a potential employer;
• Detailing your technical background in certifications and skills sections. As a recent graduate, your technological foundations might be particularly attractive to employers looking to develop these skills further.

It's important to remember that employers sometimes prefer candidates with less experience but who are a better cultural fit for their organization.

Recommended reads:

• Should You Include Eagle Scout On Your Resume?
• How to List Expected Graduation Date on Your Resume

List your educational qualifications and certifications in reverse chronological order.

How to showcase hard skills and soft skills on your resume

Reading between the lines of your dream job, you find recruiters are looking for candidates who have specific software or hardware knowledge, and personal skills.

Any technology you're adept at shows your hard skills. This particular skill set answers initial job requirements, hinting at how much time your potential employers would have to invest in training you. Showcase you have the relevant technical background in your skills section , as well as your certificates ones.

Meanwhile, soft skills hint at how well you communicate, solve problems, and adapt to new environments . Basically, your interpersonal communication skills that show recruiters if you'd fit into the team and company culture. You could use the achievements section to tie in your greatest wins with relevant soft skills.

It's also a good idea to add some of your hard and soft skills across different resume sections (e.g. summary/objective, experience, etc.) to match the job requirements and pass the initial screening process. Remember to always check your skill spelling and ensure that you've copy-pasted the name of the desired skills from the job advert as is.

Top skills for your etl developer resume:

Data modeling

Data warehousing

ETL Tools (e.g., Informatica, Talend, SSIS)

SQL programming

Database management

Scripting languages (e.g., Python, Bash)

Data integration

Performance tuning

Big Data technologies (e.g., Hadoop, Spark)

Cloud platforms (e.g., AWS, Azure, GCP)

Analytical thinking

Problem-solving

Attention to detail

Communication

Adaptability

Time management

Project management

Continuous learning

Critical thinking

The more time and effort you've put into obtaining the relevant certificate, the closer to the top it should be listed. This is especially important for more senior roles and if the company you're applying for is more forward-facing.

Discover the perfect certification and education to list on your etl developer resume

Value the insights your resume education section offers. It can shed light on various proficiencies and experiences tailored for the job.

• Add only college or university degrees, stating the institution and duration.
• If you're nearing the end of your degree, note your graduation date.
• Weigh the pros and cons of including unrelated degrees - it might not be your best choice with so little space on your resume.
• Talk about your educational achievements if they amplify your relevant experience.

There are so many certificates you can list on your resume .

Just which ones should make the cut?

• List your prominent higher education degree in a separate box, alongside the name of the institute you've obtained it from and your graduation dates
• Curate only relevant certificates that support your expertise, hard skills, and soft skills
• Certificates that are more niche (and rare) within the industry could be listed closer to the top. Also, this space could be dedicated to more recent certifications you've attained
• Add a description to your certificates or education, only if you deem this could further enhance your chances of showcasing your unique skill set

When listing your certificates, remember that it isn't a case of "the more, the merrier", but rather "the more applicable they are to the industry, the better".

Recruiters have hinted that these are some of the most in-demand certificates for etl developer roles across the industry:

The top 5 certifications for your etl developer resume:

• Certified Data Management Professional (CDMP) - Damascu
• Informatica Certified Specialist (ICS) - Informatica
• Microsoft Certified: Data Analyst Associate (MCDAA) - Microsoft
• AWS Certified Big Data - Specialty (AWS Big Data) - Amazon Web Services
• IBM Certified Data Engineer – Big Data (IBM Big Data Engineer) - IBM

Always remember that your etl developer certifications can be quantified across different resume sections, like your experience, summary, or objective. For example, you could include concise details within the expertise bullets of how the specific certificate has improved your on-the-job performance.

• How To List Certifications On A Resume (Examples Included)
• How to List GPA on Your Resume

Should you write a resume summary or an objective?

No need to research social media or ask ChatGPT to find out if the summary or objective is right for your etl developer resume.

• Experienced candidates always tend to go for resume summaries. The summary is a three to five sentence long paragraph that narrates your career highlights and aligns your experience to the role. In it you can add your top skills and career achievements that are most impressive.
• Junior professionals or those making a career change, should write a resume objective. These shouldn't be longer than five sentences and should detail your career goals . Basically, how you see yourself growing in the current position and how would your experience or skill set could help out your potential employers.

Think of both the resume summary and objective as your opportunity to put your best foot forward - from the get go - answering job requirements with skills.

Use the below real-world etl developer professional statements as inspiration for writing your resume summary or objective.

Resume summaries for a etl developer job

• Seasoned ETL Developer with over 8 years of experience designing and implementing data warehousing solutions using SQL Server Integration Services (SSIS) and Informatica. Recognized for outstanding performance in streamlining the data transformation process for a multinational finance corporation, resulting in a 30% increase in process efficiency.
• Dedicated ETL Specialist with a proven track record in Oracle Data Integrator (ODI) and Talend, bringing 5 years of expertise in complex data migration projects. Successfully led a team to integrate disparate data sources for a leading healthcare provider, enhancing the accuracy of patient data while complying with HIPAA standards.
• Dynamic Software Engineer looking to transition into ETL development, bringing a robust knowledge of object-oriented programming, Python, and Java. Having contributed to an award-winning SaaS product, eager to apply a passion for data processing and analytics in a challenging new data engineering environment.
• Accomplished Database Administrator pursuing a career shift into ETL development, armed with 10 years of experience in managing high-volume databases and proficiency in SQL scripting. Adept in problem-solving, I aim to leverage deep data management skills to excel in developing innovative data integration solutions.
• As a fresh graduate with a degree in Computer Science and a fervor for data analysis, I am eager to embark on a career in ETL development. Armed with a strong foundation in programming languages such as Python and a solid understanding of database concepts, my objective is to contribute to impactful projects by harnessing my academic knowledge and quick learning capabilities.
• With no direct experience in ETL but possessing a zeal for data-driven decision-making and advanced analytical abilities, I seek to immerse myself in ETL development. Aim to utilize my proficiency in statistical software and a Masters in Business Analytics to comprehend complex datasets and transform them into comprehensible formats that empower business intelligence.

More relevant sections for your etl developer resume

Perhaps you feel that your current resume could make use of a few more details that could put your expertise and personality in the spotlight.

We recommend you add some of these sections for a memorable first impression on recruiters:

• Projects - you could also feature noteworthy ones you've done in your free time;
• Awards - showcasing the impact and recognition your work has across the industry;
• Volunteering - the social causes you care the most about and the soft skills they've helped you sustain and grow;
• Personality resume section - hobbies, interests, favorite quote/books, etc. could help recruiters gain an even better understanding of who you are.

Key takeaways

• Pay special attention to the tiny details that make up your etl developer resume formatting: the more tailored your application to the role is, the better your chances at success would be;
• Select the sections you include (summary or objective, etc.) and formatting (reverse-chronological, hybrid, etc.) based on your experience level;
• Select experience items and, consequently, achievements that showcase you in the best light and are relevant to the job;
• Your profile will be assessed both based on your technical capabilities and personality skills - curate those through your resume;
• Certifications and education showcase your dedication to the particular industry.

ETL Developer resume examples

Explore additional etl developer resume samples and guides and see what works for your level of experience or role.

The Python ETL Developer role comes straight out of the fields of data engineering and processing, thus why trends in data analytics, big data, and Python programming significantly influence this profession.

Here are some guidelines on how to present a more successful Python ETL Developer application:

• An understanding of ETL (Extract, Transform, Load) procedures and tools is key. Present your experience with ETL processes, emphasizing Python-based tools like Pandas, NumPy, or PySpark.
• Document coding skills specifically in Python. Showcase how your python code has optimized or transformed processes, improving accuracy or speed.
• Prioritize previous ETL projects and your role in them. A considerable proportion of successful ETL developers have a data project background, hence, highlight your technical participation in such projects.
• Don’t just enumerate skills, display how they have contributed to project success, i.e., "optimized data extraction by...”, “enhanced data load speed through..." and so forth. Adhere to the “skill-action-results” format.

Looking to build your own ETL Developer resume?

• Resume Examples

How to Tell a Story in a Cover Letter

Making the call: will calling after a job application give you a better chance, the power of power words in a cover letter, how to use volunteer experience to make your resume stand out, real resume examples that stand out and get people hired, 30+ project manager resume objective and summary examples.

• Create Resume
• Terms of Service
• Privacy Policy
• Cookie Preferences
• Resume Templates
• AI Resume Builder
• Resume Summary Generator
• Resume Formats
• Resume Checker
• Resume Skills
• How to Write a Resume
• Modern Resume Templates
• Simple Resume Templates
• Cover Letter Builder
• Cover Letter Examples
• Cover Letter Templates
• Cover Letter Formats
• How to Write a Cover Letter
• Resume Guides
• Cover Letter Guides
• Job Interview Guides
• Job Interview Questions
• Career Resources
• Meet our customers
• Career resources
• English (UK)
• French (FR)
• German (DE)
• Spanish (ES)
• Swedish (SE)

© 2024 . All rights reserved.

Made with love by people who care.

• Knowledge Base
• Free Resume Templates
• Resume Builder
• Resume Examples
• Free Resume Review

Click here to directly go to the complete ETL Developer Resume Sample

This blog is all about helping you create an impeccable ETL developer resume. To help you create your own resume, we have provided a complete ready-made ETL Developer resume in the blog.

Not only that. We know candidates struggle mostly with creating bullet points with power verb. That's why we have created a massive resource of power verbs for 250+ resume profiles.

The fascinating job of an ETL Developer can be your full-time profession if you implement the right steps to perfect it.

Before we begin, here's a summary of our ETL Developer Resume 2022 Blog:

• Read the job description and make sure that you optimize your ETL resume for your target job.
• Since ETL developer is a technical profile, ensure to include links of projects and GitHub in the personal information section.
• If you are applying for a entry level job, ensure to education, certification, projects and volunteer experience in the resume
• Instead of using paragraphs, use crisp one-liner points to create the professional experience section
• Write the ETL developer resume summary in paragraph format

Following these resume tips would put you on the right track to perfecting your resume. But this is not all there is to it.

To make a shortlist-worthy resume, you need to pull your weight and do what it takes to ensure that every section is done to perfection.

The blog will help you in finding the answers to the following questions:

• How to choose an ETL developer resume format that suits your career trajectory?
• How to use resume sections to organize information in your ETL Developer Resume
• How to optimize the header section of your ELT Developer resume?
• How to perfect the professional experience section of the ETL developer resume?
• How to create the education section of the ETL developer resume?
• How to present your ETL developer skills using a distinct section?
• How to write a perfect ETL developer resume objective or a profile summary?

By the end of this blog, you will be able to make an impeccable ETL resume from scratch, and you will also learn how to perfect each section with no help.

If you are looking for different profiles similar to ETL Developer, you can check out these resume guides:

• ETL Tester Resume
• Oracle DBA Resume
• Informatica Resume
• Database Developer Resume

Look no further for those looking for a reliable Online Resume Builder to create your ETL developer sample resume!

Hiration’s Online Resume Builder is powered by the goodness of AI to give you the resources you need to help you make an impeccable resume that is optimized for both the ATS and your target job.

Our job scan functionalist is one of a kind feature that you won't find anywhere!

Here's a video showing Hiration's JD functionality feature . See it to believe it! We believe that you'll fall in love with it right away!

ETL Developer Job Description

The full form of ETL is Extract, Transform and Load. It is a process of collecting data from different sources into one data warehouse.

And the responsibility of a ETL developer is to design those data storage systems. Not only that, but they are also responsible for storing big data into those data warehouses. ETL developers test the warehouse system performance and troubleshoot before making it live.

Here is a typical job description of an ETL developer:

• Monitor the data storage needs
• Build various data warehouses for internal usage
• Ensure seamless delivery of data across all departments
• Collect, analyze and maintain a large set of data
• Design complex applications to extract, transform and load data on the data warehousing systems
• Develop data models for ETL software

ETL Developer Salary

According to indeed.com , the average salary of an ETL/Informatica developer is $106,110 per year.

According to payscale.com senior ETL developer average salary is $94,238 per year .

According to talent.com, ETL developers in the USA makes an average salary of $108,689 per year

Additionally here is a breakdown of the salaries based on region.

ETL Developer Interview Questions

1. Can you explain what ETL testing operations include?

The ETL testing operation includes:

• Ensure the transformation of data is accurate based on the business requirements
• Ensure that the data is perfectly loaded in the data warehouse system without data loss
• Check ETL application reports for invalid data and replace them with default values
• Check the data loading performance to scale the performance

2. What are the tools of ETL?

Here are the tools of ETL developer:

• Cognos Decision Stream
• Oracle Warehouse Builder
• Business Objects XI
• SAS business warehouse
• SAS Enterprise ETL server

3. Explain What is Grain of Fact?

Grain facts are where information is stored. It is also called Fact Granularity.

ETL Developer Resume Bullet Points

We know firsthand that creating one-liner bullet points is the most challenging task for many people. It needs a lot of things:

• It needs to have a cause-effect relationship
• Every bullet should start with power verbs
• You need to back up your statements with statistics
• You need to group similar points under a single sub-heading

Hiration has created a massive resource of ETL developer resume bullet points , which you can simply copy-paste and use. Some of the resources are:

• Full Stack Developer Resume Points
• Front End Developer Resume Points
• Java Developer Resume Points
• Web Developer Resume Points

ETL Developer Resume Format

Not many professionals give a lot of thought to the structure of their resumes. Often finding themselves at a crossroads of resume writing dilemma, they copy the design and format of the first resume they find online.

If you have been doing this stop, right away. There are three resume formats you can choose from to structure your ETL developer sample resume. They are:

• Chronological resume format : ideal for most professionals with a steady career trajectory.
• Functional resume format : considered the best for frequent jo switchers and professionals with career gaps.
• Combination resume format : considered ideal for mid-senior professionals with a lot of work experience.

Click on this Informatica developer resume sample to work on it. You will be redirected to this template on our Resume Builder within seconds!

Use resume sections to organize information in your ETL Developer Resume

Your resume is all about presentation. Perfect it, and you would keep the recruiter interested enough to evaluate your ETL developer sample resume.

Here are the 7 must-have sections that you should include in your Informatica resume:

Read Hiration's Guide to composing sections in a resume to understand better these sections and their role play in Suppose you resume writing.

While you're at it, feel free to use our Online Resume Builder to modify your ETL experience resume into an impeccable shortlist-worthy document.

ETL Developer Resume: Header

The ETL developer resume headline is nothing but the thing you're supposed to write at the topmost part of your resume. Keep yourself from the embarrassment of writing ' resume ' right on top.

Instead, use your real full name as your resume header.

Here are some resume tips for your resume header:

• As a rule of thumb, your real full name should feature at the topmost part of your ETL experience resume.
• This name should be the same as the name on your birth certificate or official government ids such as your social security number or driving license.
• To communicate to the recruiter that the ETL experience resume belongs to you in one go, write it in the largest font size, preferably 16-20 font-size .
• If you have a middle name, write your first name, followed by the first initial of your middle name in capital letters, followed by your last name.
• Example "Sarah M. Scott."

To perfect the ETL developer resume headline for your ETL developer/data warehouse developer resume sample, take some clues from our exhaustive Guide to composing the resume header .

Here's an etl developer resume example illustrating the ideal etl developer resume headline / resume header:

ETL Developer Resume: Personal Information

The personal information section is one of the most under-rated sections of a resume. It comes as no surprise to us that most professionals tend to overlook it.

The name personal information does not suggest that you should write just about anything and everything in this section.

Hiration Pro Tip : Research the resume guidelines of your country before fashioning your ETL sample resume. This will save you the embarrassment of unnecessarily cluttering your resume with useless information that is not needed.

Whether you include other details or not, make sure that you have the following information in your ETL sample resume:

• Updated mobile number
• Professional email ID
• Current Location
• LinkedIn Profile
• GitHub Profile

Read our Guide to composing the resume contact information for a better understanding of the personal information section of your resume.

Here's an Informatica ETL developer resume example showcasing what this section looks like when perfected:

To make an ETL resume with perfectly arranged and well-spaced sections, use our Online Resume Builder now!

ETL Developer Resume: Profile Title

You may not know this to better understand, but the profile title says it all. It needs to be correctly written in your ETL resume because it communicates such crucial information:

• Your current designation
• Your functional niche or industry
• Your seniority level

Follow the below-mentioned guidelines to write it impeccably:

• Write it in the second-largest text.
• Write it in the font range of 14-16 points .

Here's an ETL developer resume example showcasing the profile title:

Meanwhile, get your existing ETL resume reviewed by our Resume Strategists at Hiration.

ETL Developer Resume Professional Experience

Perfecting the work experience section of your ETL resume puts you at an advantage over other job applicants.

After all, this section communicates the work you have done in the past, your skill proficiency, overall expertise, and the value you can bring to the following organization.

Here's what you can do to achieve this:

• Use one-liner points (not paragraphs!) to showcase your professional contribution.
• Include figures/numbers to quantify your achievements wherever you can - even ballpark figures will do.
• Begin each point with a power verb . Example : Directed, Formulated, Executed, Spearheaded, etc. You can find a list of 200+ such power verbs you can use right away!
• Group relevant points under unique subheadings to instantly communicate your key expertise.
• Mark relevant words/phrases in bold to direct the recruiter’s attention to where YOU want. Don't overdo it, though!

ETL Developer Resume Sample for Professional Experience

To get a better understanding of the professional experience section, read Hiration's Blog on how to compose the work experience in your resume .

Here's an ETL developer resume example showcasing the ideal professional experience section:

For section-wise ETL developer resume samples like this, read on.

ETL Developer Resume Education Section

The education section of your ETL resume is a must-have section. You should include this section in your resume at all costs.

Here's a list of the top things to include in the education section of your ETL resume:

• Name of the school/university.
• Name of the courses you have pursued.
• The location of your school/university.
• Dates of enrollment and graduation.

Refer to our Resume Education Section Guide to learn how to correctly & effectively curate the education section.

Here's an ETL sample resume showcasing the ideal resume education section:

For ETL resume samples like this and many more, read on.

And while you're at it, check out our Online Resume Builder to create a stellar ETL developer resume for yourself.

ETL Developer Resume Key Skills

Did you know that recruiters look for your ETL developer skills?

Whether you're an experienced professional writing an ETL developer resume for two years of experience and more, or a fresher with no relevant work experience, your skills can make all the difference.

Here's a list of the top ETL skills that recruiters will look for in your ETL sample resume:

Here's a list of the top technical skills that recruiters will look for in your ETL sample resume:

Your job is to present these skills effectively on your resume. The recruiter should easily identify it in one glance.

So make a 'Key Skills' section in your ETL resume. Put all your core ETL skills in this section. Within this section, make a 'technical skills' subsection to present the technical skills that are unique to you.

Read our Resume Skills Guide to get a better understanding of how to effectively curate this section.

Here's a resume sample showcasing the perfect key skills section. It illustrated what your resume skills should look like when composed in this section.

Get your existing resume for ETL developer jobs the touch of perfection it rightfully deserves with our expert Resume Review Service now!

ETL Developer Resume: Profile Summary

A summary statement is for those experienced ETL professionals who are writing a senior ETL developer resume.

You should write a profile summary for ETL developer resumes if you have more than 3 years of ETL experience.

Here are some of the tips to write a resume summary:

• Begin writing your profile summary for the ETL developer resume after concluding all other sections. Doing this saves you the unnecessary trouble of repeatedly working on the same draft.
• It also helps you curate a practical resume summary as you can easily pick the highlights of your career from relevant sections.
• While you're busy curating your perfect profile summary for ETL developer resume, don't get carried away.
• Keep it short and effective. Stick to the 1-5 lines paragraph limit . Exceed it only in sporadic cases. Example : you have 10+ years of relevant ETL experience.

For a fuller understanding of the resume summary and to learn how to perfect it, refer to our Resume Summary Guide .

Attached below is an etl developer resume example showcasing the perfect resume profile summary for etl developer jobs:

ETL Developer Resume Objective

You should write an ETL developer resume objective if you are a fresher or you have less than 3 years of relevant ETL work experience.

Highlight the reasons why you are the ideal fit for the organization you are targeting. Talk about your relevant ETL skills & achievements.

The point is, you have to show that despite the lack of relevant work experience or very limited ETL experience, you are the ideal fit for the job.

For more understanding of this, read our Resume Objectives Guide .

Resume Review Service

At Hiration, we take great pride in our Resume Review Service.

All thanks to it, thousands of happy customers have received interview calls from top companies like Facebook and BCG.

We are proud to convey that our in-house team of Resume Strategists has mastered the art of doing a detailed resume assessment and providing valuable feedback on this assessment.

Here's a list of the top metrics we use to do an effective review of your ETL resume:

• Compliance with industry norms
• Content Relevance
• Recruiter Friendliness
• Design Compatibility
• Conversion Scope
• ATS Compliance
• Global Compatibility
• Performance Assessment
• Resume Formatting (font, margins, the order of sections, etc.)

Online Resume Builder

Hiration's Online Resume Builder comes with the following resources:

• 1-click design change
• A sharable link
• Auto bold feature
• 25+ resume designs
• LIVE resume score
• JD-resume matcher
• Full rich-text editor
• Unlimited PDF downloads
• Intuitive next text suggestion
• 100+ pre-filled resume templates
• Option to save unlimited resumes

What's more, our resume builder supports an ETL Developer Resume PDF download of your resume. This means that the content of your resume will be purse-friendly post downloading it from our platform!

ETL Developer Resume Sample

This blog is all about teaching you how to make an impeccable resume from scratch. Once you perfect it, it will look like the ETL developer/informatica resume sample we have illustrated below:

• Orchestrated the designing , testing, support, and debugging of new and existing ETL & reporting processes
• Cooperated with developers, data architects, DBAs, project managers , & client business users to develop specifications
• Resolved client questions around problems & enhancements to achieve a rating of 4.5 out of 5
• Figured out the exact storage needs , analyzed data situation and examined different options to figure out the best fit
• Liaised with the Development team of 25 to design a data warehousing system that meets the specific business needs
• Extracted the necessary data and transferred it to the new system after the development of warehousing system
• Tested the designs to ensure the proper functioning of the system and fixed any issues that may arise
• Formed Informatica based solutions for data integration/migration in both OLTP and Data Warehouse environments
• Supervised impact analysis of changing upstream processes to Data Warehouse and Reporting systems
• Played a key role in developing 3 + software that meets and exceeds the needs of the company
• Maintained 7 + software and created updates regularly to address customer & company concerns
• Collaborated with the cross-functional teams to determine best practices and client requirements for software
• Ensured 100 % software security by developing programs to actively monitor the sharing of private information
• Analyzed, tested and troubleshot programs and products before the formal launch
• Troubleshot coding problems quickly and efficiently to ensure a productive workplace ; increased productivity by 25%
• Designed new databases to meet the needs of the customers and users ; achieved 95% customer satisfaction
• Developed database code to perform specific tasks which includes extracting data for reports, updating or deleting data
• Upgraded existing databases and ensured new IT & business projects meet database standards & requirements
• Employed databases to design business intelligence reports and created documents for new and existing databases
• Cumulative GPA: 3.8/4.0

Also read : How to make an ETL tester resume?

Key Takeaways

Here are the key takeaways of our ETL Developer Resume 2022 Blog:

• Use resume sections to organize information in your ETL developer resume.
• Choose a relevant ETL developer resume format that best complements your career trajectory.
• Write your contact information correctly. Why? Because using basic contact information like your mobile number and email ID , a recruiter gets in touch with you.
• Research the hiring guidelines of your country before formulating your ETL experience resume.
• Write your profile title as it is. Do not exaggerate it as it can lead to loss of credibility.
• As a rule of thumb, use your real full name as the official ETL developer resume headline. Place it at the topmost part of your ETL resume.
• Use a distinct ' key skills section ' to present your core ETL skills.
• Perfect the professional experience section at all costs.
• To do this, use one-liner points to communicate information (not paragraphs). This improves the readability of your ETL resume.
• Quantify your achievements wherever possible. Doing this helps you show the extent of your professional contributions.
• Conclude your resume with a profile summary for ETL developer resumes or an ETL developer resume objective. Present the highlights of your career and relevant achievements.

With this, you have officially reached the end of this blog.

Go to Hiration resume builder and create a professional resume for yourself. Additionally, reach out to us at [email protected] and you can get 24/7 professional assistance with all your job & career-related queries.

Share this blog

Subscribe to Free Resume Writing Blog by Hiration

Get the latest posts delivered right to your inbox

Stay up to date! Get all the latest & greatest posts delivered straight to your inbox

Is Your Resume ATS Friendly To Get Shortlisted?

Upload your resume for a free expert review.

Talend Sample Resumes

Boost your job search with our talend  resume.

Our expert-approved Industry’s Best Downloadable Templates are suitable for all levels – Beginner, Intermediate and Advanced professionals. IT Professionals or IT beginner can use these formats to prepare their resumes and start to apply for IT Jobs.

Mindmajix also offers advanced  Talend Interview Questions  to crack your interviews along with free  Talend Tutorials . Let's Hurry!

Just Three Simple Steps:

Click on the Download button relevant to your  (Fresher, Experienced). Fill your email Id for which you receive the Talend Build document. Download your resume, Easy Edit, Print it out and Get it a ready interview! Best Wishes From MindMajix Team!!!

Our expert-approved industry's best downloadable templates are suitable for all levels - beginner, intermediate and advanced professionals. IT Professionals or IT beginner can use these formats to prepare their resumes and start to apply for IT Jobs.

Talend Sample Resumes Resume Templates:

Check your knowledge before you attend an interview with our informative resources to help Angular JS Developers to crack interviews with ease .

Quick Quizzes

Evaluate your job-ready skills before you attend your first interview. We assure you improve your chances 100%.

Exclusive Tech Webinars

Masterclass webinars to educate everything you need to start, learn, master, and pursue a healthy tech career.

• Unlock +200 courses of +50 categories with one subscription key
• out the best solution now is simply
• This will add space between and below the last item, so not a perfect solution

STILL GOT QUERIES?

Get a Live FREE Demo

• Explore the trending and niche courses and learning maps
• Learn about tuition fee, payment plans, and scholarships
• Get access to webinars and self-paced learning videos

Copyright © 2013 - 2024 MindMajix Technologies

• Resume Builder
• Resume Templates
• Resume Formats
• Resume Examples
• Cover Letter Builder
• Cover Letter Templates
• Cover Letter Formats
• Cover Letter Examples
• Career Advice
• Interview Questions
• Resume Skills
• Resume Objectives
• Job Description
• Job Responsibilities
• FAQ’s

ETL Developer Resume Examples

The job search process can seem overwhelming, especially when it comes to creating a resume that stands out among the competition. Writing a strong resume is an essential part of the job search process, but it can be difficult to know where to start. This ETL developer resume writing guide will provide helpful tips and examples to help you create a resume that will grab the attention of potential employers. We’ll cover topics such as best practices for formatting and content, as well as how to highlight your relevant experience and technical skills. With the right guidance and a clear strategy, you can create a resume that will launch you into your next job opportunity.

If you didn’t find what you were looking for, be sure to check out our complete library of resume examples .

Start building your dream career today! 

Create your professional resume in just 5 minutes with our easy-to-use resume builder!

ETL Developer

123 Main Street | Anytown, USA 99999 | Phone: (123) 456-7890 | Email: [email protected]

I am an experienced ETL Developer with 8+ years of experience in extracting, transforming, and loading data from different sources. I possess extensive knowledge of multiple programming languages and technologies including Oracle, SQL, and Python. I have extensive experience creating ETL data pipelines, developing and debugging stored procedures and functions, developing back- end API integrations, and providing data warehousing solutions. I am also highly proficient in identifying, diagnosing, and resolving data issues.

Core Skills :

• Experience in Extracting, Transforming and Loading data from different sources
• Proficiency in Oracle, SQL and Python
• Extensive experience creating ETL data pipelines
• Developing and debugging stored procedures and functions
• Developing back- end API integrations
• Providing data warehousing solutions
• Identifying, diagnosing, and resolving data issues

Professional Experience :

• ETL Developer, ABC Company, 2017- Present
• Designed and developed ETL processes to extract and load data from multiple sources
• Developed and debugged stored procedures, scripts, and functions in Oracle, SQL, and Python
• Developed and maintained back- end API integrations
• Resolved data issues and provided data warehousing solutions
• Provided comprehensive data analysis in support of business intelligence
• Data Analyst, XYZ Company, 2015- 2017
• Led data analysis and generated reports for multiple projects
• Maintained and monitored existing data sets for accuracy and completeness
• Provided data- driven insights to support key business decisions
• Developed and implemented data models and algorithms to support data analysis

Education :

• Bachelor of Science in Computer Science, University of Washington, 2010- 2015
• Certified Oracle Database Administrator, Oracle Corporation, 2016

Create My Resume

Build a professional resume in just minutes for free.

ETL Developer Resume with No Experience

Highly organized and driven individual with a passion for learning and development. Exceptional analytical and problem- solving skills, able to quickly understand complex systems and processes. Well- versed in programming languages including SQL, Python and Java. Proven ability to work under pressure in a fast- paced environment.

• Experience with SQL and database development
• Proficiency in scripting languages Python and Java
• Familiarity with data management tools
• Strong problem- solving and analytical skills
• Excellent communication and organizational skills
• Ability to work under pressure and multitask

Responsibilities

• Developing ETL pipelines for data processing
• Designing efficient data structures
• Building and maintaining data models
• Analyzing and understanding complex data sets
• Testing ETL processes and applications
• Creating and optimizing database queries
• Working with developers and business stakeholders

Experience 0 Years

Level Junior

Education Bachelor’s

ETL Developer Resume with 2 Years of Experience

A highly motivated, passionate, and experienced ETL Developer with more than 2 years of professional experience. Possesses a strong technical background and an in- depth knowledge of the ETL development process. Highly organized and driven with excellent problem- solving skills. Utilizes excellent communication and interpersonal skills to collaborate effectively with other team members and stakeholders.

• Strong understanding of ETL development process
• Data warehouse and ETL architecture implementation
• Experience developing ETL processes and scripts
• Advanced SQL and PL/SQL skills
• Proficient in data modelling and data integration
• Knowledge of data integration tools such as Informatica, Talend, and Mulesoft
• Ability to manage multiple tasks simultaneously
• Excellent analytical and problem- solving skills
• Strong communication and interpersonal skills

Responsibilities :

• Developing ETL processes and scripts using Informatica and/or Talend
• Design, develop and maintain ETL jobs
• Debugging and troubleshooting of errors in ETL jobs
• Analyze and document data integration requirements
• Develop data models to support data integration
• Test and validate ETL processes
• Perform monitoring and maintenance of ETL jobs
• Analyze, tune and optimize ETL jobs for performance
• Collaborate with other teams to define data integration requirements and design solutions
• Develop data cleansing and data quality processes

Experience 2+ Years

ETL Developer Resume with 5 Years of Experience

A highly experienced ETL Developer with five years of professional experience in software development and the analysis, design, and implementation of data warehouses and ETL processes. Possesses strong technical skills in scripting, SQL, and data modeling. Experienced in developing ETL processes using ETL tools such as SSIS and InForm as well as creating databases and queries in SQL Server. Experienced in optimizing performance, troubleshooting, and maintaining data warehouses.

• SQL scripting
• ETL tools such as SSIS and InForm
• Data Modeling
• Database creation
• Query creation
• Database maintenance
• Performance optimization
• Troubleshooting
• Developed ETL processes using ETL tools such as SSIS and InForm
• Developed databases and queries in SQL Server
• Analyzed and optimized existing ETL processes
• Provided troubleshooting support for ETL processes
• Maintained and monitored data warehouses
• Prepared and maintained technical documentation
• Provided technical support for other team members
• Performed data analysis and data mining tasks
• Developed data models for data warehousing

Experience 5+ Years

Level Senior

ETL Developer Resume with 7 Years of Experience

A highly experienced ETL Developer with 7 years of hands- on development experience of Business Intelligence & Database Projects. Possesses in- depth knowledge of designing, developing, testing and delivering ETL solutions using different open source and proprietary tools. Expertise in data extraction, transformation, loading and data migration from multiple sources from different databases. Skilled in developing reports, cubes and dashboards using OLAP, SQL and various BI tools.

• Designing, developing and testing ETL solutions
• Data extraction, transformation, loading and data migration
• Developing cubes, dashboards and reports using OLAP, SQL and BI tools
• Extensive knowledge of ETL tools like Pentaho, Informatica and SQL
• Proficiency in database development, database architecture and data warehousing
• Sound understanding of database management systems (Oracle, SQL Server, DB2, etc.)
• Expertise in programming languages such as Python, Java, PL/SQL and T- SQL
• Defined ETL processes to extract, transform and load data from multiple sources into different databases
• Developed cubes and dashboards for data analysis using OLAP, SQL and BI tools
• Implemented ETL solutions using tools such as Pentaho, Informatica and SQL
• Developed database objects such as tables, views, functions and stored procedures
• Created complex queries to analyze large amount of data and generate reports as needed
• Maintained and monitored databases to ensure data integrity and accuracy
• Provided technical support to database users and troubleshoot database issues
• Collaborated with other teams to ensure successful completion of projects on time and budget

Experience 7+ Years

ETL Developer Resume with 10 Years of Experience

Highly experienced ETL Developer with 10+ years of professional experience in the area of software engineering. Adept in developing Extract- Transform- Load (ETL) processes for both batch and real- time data integration jobs on a variety of databases, including Oracle, SQL Server, and Big Data. Proven ability to design and maintain efficient, scalable, and automated ETL processes to ensure successful data loading. Skilled in Project management, Data profiling, and Data Warehousing.

• Problem- solving
• Analytical and decision- making
• Database design and development
• SQL programming
• ETL development and implementation
• Data Warehousing
• Data processing
• Project management
• Developed ETL processes for batch and real- time data integration jobs.
• Implemented Stored Procedures, Triggers, and Functions on various databases, including Oracle, SQL server, and Big Data.
• Created data mappings for transferring data from source to target databases.
• Performed data profiling and data analysis to identify irregularities in data.
• Designed and maintained efficient, scalable, and automated ETL processes.
• Developed data warehouse architectures and models to facilitate data storage, access, and manipulation.
• Monitored ETL jobs and performed troubleshooting and tuning to ensure successful data loading.
• Developed unit tests to ensure data integrity and accuracy.
• Developed documentation for ETL processes and data models.
• Collaborated with other software engineers to design and develop data solutions.

Experience 10+ Years

Level Senior Manager

Education Master’s

ETL Developer Resume with 15 Years of Experience

Highly experienced ETL Developer with 15 years of experience in the software development industry. Possessing a strong working knowledge of database components, ETL processes, database programming and software design processes. Proven ability to create technical solutions for data management and data integration, develop ETL processes, and build robust data warehouses. Adept at designing transformation processes, designing and writing database code using SQL, and developing software to meet customer requirements.

• Extract, Transform, and Load (ETL) processes
• Database programming and software design
• Data integrity, data quality and data cleansing
• Database components, database development and design
• Software development and programming languages
• Data modeling and data manipulation
• SQL queries and stored procedures
• Data warehousing and business intelligence
• QA testing and debugging
• Project management and process improvement
• Developed ETL processes to move data from source systems to target systems
• Created complex SQL queries, stored procedures and functions to manipulate data
• Designed and developed ETL processes to extract, transform and load data into data warehouses
• Performed data quality and data integrity checks to ensure data accuracy
• Developed software applications to meet customer requirements
• Designed and implemented database components such as tables, views and indexes
• Developed database code using SQL to perform data manipulation and data analysis
• Designed data models to facilitate data integration and data mapping
• Developed process improvements to increase efficiency and reduce costs
• Performed QA testing and debugging to ensure software functionality
• Managed projects and identified areas for improvement

Experience 15+ Years

Level Director

In addition to this, be sure to check out our resume templates , resume formats ,  cover letter examples ,  job description , and  career advice  pages for more helpful tips and advice.

What should be included in a ETL Developer resume?

A resume for an ETL developer should include the following information:

• Education: List relevant degrees or certifications related to engineering, software development, or data engineering. Include the name of the institution, year of graduation, and any awards or honors received.
• Professional Experience: Summarize professional experience related to ETL development. Include the title of the position, the name of the company, and a description of the duties and responsibilities associated with the position.
• Technical Skills: List any technical skills relevant to ETL development, such as experience with SQL, software development, and data engineering. Include specific knowledge of ETL development tools and programming languages.
• Project Experience: Summarize any project experience related to ETL development. Include the name of the project, the client or organization it was for, and a description of the scope of the project and results.
• Problem-Solving: Describe any challenges faced while developing ETL solutions and how they were solved.
• Soft Skills: List any relevant soft skills, such as communication, problem-solving, and teamwork.
• Awards: Include any professional awards or recognition received related to ETL development.

What is a good summary for a ETL Developer resume?

A good summary for an ETL Developer resume should highlight the candidate’s experience and expertise in data integration, data warehousing, ETL development, and data analysis. The summary should also emphasize their abilities to implement industry-leading ETL solutions, understand and develop data migration strategies, and integrate data from multiple sources. Additionally, a good summary should showcase the job seeker’s problem-solving and analytical skills and any keen eye they may have for spotting trends and anomalies in data. Finally, the summary should paint a picture of the job seeker as an organized and detail-oriented professional who can develop and maintain high-quality ETL systems.

What is a good objective for a ETL Developer resume?

ETL (Extract, Transform, Load) developers are responsible for developing and managing the processes that move data from one source to another. A good objective for an ETL developer resume should highlight the applicant’s knowledge of the ETL process, their ability to create and maintain ETL solutions, and their experience working with databases and data warehouses.

• Demonstrate extensive professional experience in designing, coding, testing, and maintaining ETL solutions
• Proven ability to troubleshoot and optimize ETL processes and databases
• Knowledge of object-oriented programming languages and experience with data warehousing
• Ability to work within a team and independently to develop, implement, and maintain ETL solutions
• Experience working with large amounts of data efficiently and accurately
• Expertise in developing, deploying, and managing ETL solutions in an enterprise environment

How do you list ETL Developer skills on a resume?

When writing a resume, it is important to make sure your skills are highlighted in an effective way to stand out to potential employers. As an ETL (Extract, Transform, and Load) developer, you have a range of technical and non-technical skills that you should feature in your resume to showcase your value and experience.

To list your ETL Developer skills on your resume, you should include a section that outlines both your technical and soft skills. This should be placed directly below your summary statement, as this is one of the most important parts of your resume. For each of your skills, include a brief description of your experience and any accomplishments to help demonstrate your competency.

• Proficiency with ETL tools: Detail the ETL tools you have experience with, such as Microsoft SSIS, Informatica, etc.
• Data integration and manipulation: Demonstrate your knowledge of data integration and manipulation techniques, such as data warehousing, data cleansing, data migration, etc.
• Database skills: Showcase your experience with various databases, including Oracle, SQL, NoSQL, etc.
• Programming: Describe your programming skills, such as your experience using Java, Python, etc.
• Analytical thinking: Explain how you use your analytical skills to make informed decisions and solve complex problems.
• Strong communication: Highlight how you effectively communicate and collaborate with team members, stakeholders, and business partners.
• Attention to detail: Demonstrate your ability to critically review, analyze, and troubleshoot data.

Including these skills in your resume will help make it stand out to potential employers and give them a better understanding of your capabilities as an ETL developer.

What skills should I put on my resume for ETL Developer?

When applying for an ETL Developer position, it is important to highlight the skills that make you the most qualified for the job. Your resume should clearly demonstrate your technical experience, any certifications you’ve earned, and your ability to effectively manage ETL development projects.

When creating your resume for an ETL Developer position, here are some skills to consider including:

• Expertise with ETL development: Your resume should demonstrate detailed knowledge of ETL development processes and tools, such as Informatica, SSIS, Ab Initio, Oracle Data Integrator and DataStage.
• Programming experience: Include your proficiency in programming languages such as Java, C# and SQL.
• Database knowledge: Demonstrate your expertise of database systems such as Oracle, SQL Server, and MySQL.
• Data analysis: Show your ability to analyze data and develop reports.
• Troubleshooting: Demonstrate your aptitude for resolving problems and finding solutions.
• Communication: Highlight any experience you have in presenting complex information in an easily understood format.

By highlighting your relevant skills and experience, you’ll be able to improve your chances of landing an ETL Developer position.

Key takeaways for an ETL Developer resume

As an ETL (Extract, Transfer, Load) Developer, you’re responsible for designing, developing, and maintaining the data integration processes that move data from one system to another. Your resume should show employers that you possess the technical knowledge and experience needed to successfully manage and complete ETL projects. Here are some key takeaways to include on your ETL Developer resume:

• Experience with ETL tools: Showcase your knowledge and experience of using ETL tools like Informatica, Talend, and Pentaho to design, develop, and maintain data integration processes.
• Database knowledge & experience: Highlight your experience with various database platforms such as Oracle, SQL Server, and MySQL.
• Programming Languages & Scripts: Demonstrate your knowledge of programming languages like Java, Python, and C#, as well as scripting languages like JavaScript, HTML, and CSS.
• Data Modeling & Data Warehousing: Demonstrate your understanding of concepts like data modeling, data warehousing, and dimensional modeling.
• Data Quality & Integration Testing: Showcase your ability to ensure data quality and perform integration testing.
• Performance Tuning & Troubleshooting: Highlight your ability to troubleshoot data integration issues and tune applications for better performance.

By ensuring that your ETL Developer resume includes these key takeaways, you’ll be able to demonstrate to employers that you have the technical skills and experience necessary for the job. Good luck!

Let us help you build your Resume!

Make your resume more organized and attractive with our Resume Builder

Resume Worded   |  Career Strategy

Etl developer resume summary examples.

Approved by hiring managers, here are proven resume summary examples you can use on your ETL Developer resume. Learn what real hiring managers want to see on your resume, and when to use which.

• ETL Developer
• ETL Analyst
• ETL Architect
• ETL Consultant
• ETL Data Engineer
• ETL Specialist
• Junior ETL Developer
• Senior ETL Developer
• ETL Developer resume templates
• Similar summary examples

ETL Developer Resume Summary Example

Demonstrating tangible improvements.

Talking about the impact of your work in concrete terms is a smart move. This ETL Developer didn't just vaguely mention that they improved ETL processes, they quantified it, demonstrating a 50% reduction in data processing time. This gives recruiters a clear idea of what you're capable of, and how your efforts can lead to actual, measurable improvements.

Highlighting accuracy enhancements

Here, the candidate impressively shows how he contributed to improving the accuracy of data extraction by 35%. This is a crucial aspect in ETL development, as it directly affects the quality of business intelligence derived from the data. This is a clear signal to recruiters about the candidate’s diligence and their passion for precision.

ETL Analyst Resume Summary Example

Emphasizing on quality improvement.

The ETL Analyst here highlights their role in improving data quality, an important aspect in any data-driven business. It shows they understand the importance of clean, reliable data and can put processes in place to ensure this.

Participation in performance enhancement projects

By mentioning their role in a project that led to a 20% increase in query performance, the candidate shows they're not just a passive participant, but an active contributor to improvement initiatives. This indicates they're a valuable team player who can make a significant difference.

Applying for jobs is competitive. Give yourself an edge with our resume optimization tool. Get a detailed analysis of your resume and find out exactly what you need to change to stand out to hiring managers. Start optimizing your resume today and land your dream job faster.

ETL Architect Resume Summary Example

Highlight your accomplishments with specific metrics.

In the IT world, especially for roles like ETL Architect, showing tangible results is key. Mentioning that you 'Designed an ETL system for a large healthcare company, reducing data processing time by 40%' clearly demonstrates your ability to drive efficiency and bring about substantial improvements. You're not just listing a duty, you're showing the impact of your work, which recruiters love to see.

Showcase leadership and financial management skills

By stating 'Managed a team of 10 ETL developers, delivering projects on time and under budget', you're essentially wearing two hats - that of a technical leader and a project manager. It shows you're capable of handling multiple facets of a project, which definitely adds value to your profile.

ETL Consultant Resume Summary Example

Effective project leadership.

By highlighting their leadership in a major data warehouse design project, the ETL Consultant demonstrates their ability to handle big responsibilities and deliver results. This also shows they understand the importance of data accessibility, a key factor in efficient business operations.

Proficiency in popular ETL tools

By stating they developed ETL processes using SSIS, a widely-used tool in the industry, the candidate shows they're equipped with the right technical skills. It's not just about having skills, but about effectively using them to achieve significant improvements, such as the 30% speed increase mentioned here.

ETL Data Engineer Resume Summary Example

Versatility in tools and techniques.

The candidate smartly reveals their expertise in Python and SQL, popular tools in ETL development, while also showing they used this competence to reduce data transformation losses. This showcases their versatility and the ability to apply their skills effectively.

Attention to data quality

By stating they implemented data quality checks, the candidate shows their commitment to maintaining high standards of data quality, a crucial aspect in data management. It also suggests they are proactive in identifying and mitigating potential issues, a highly desirable trait in this field.

ETL Specialist Resume Summary Example

Demonstrate your expertise with tools and the result.

When you mention 'Developed ETL workflows using Talend, resulting in a 20% increase in data processing speed', you're not just listing a tool you've used, but you're also connecting it to a concrete improvement in data processing. This shows recruiters that you have the practical skills to use ETL tools for efficient data management.

Emphasize your impact on data quality

'Implemented data quality checks that improved data accuracy by 30%' gives recruiters a direct glimpse into your ability to improve data reliability. In a world where data is king, this skill is invaluable and shows you're committed to maintaining high standards of data integrity.

Junior ETL Developer Resume Summary Example

Focusing on accuracy.

This Junior ETL Developer took a wise approach by emphasizing their role in improving data accuracy, a pressing issue in data warehousing. It portrays them as a reliable professional who can ensure the correctness of data, a key aspect in decision-making processes.

Teamwork on cost-saving initiatives

By mentioning their role in a project that led to significant cost savings, this candidate shows they're not just technically proficient, but also understand the financial implications of their work. This insight into the broader business context is a big plus in the eyes of employers.

Senior ETL Developer Resume Summary Example

Showcasing leadership and efficiency.

This Senior ETL Developer smartly highlights their leadership skills and how it led to a significant boost in efficiency, delivering projects faster than industry averages. It's not just about technical skills, but also how you lead, manage, and motivate your team to deliver top-notch work on time.

Innovation with impactful results

By stating they implemented a new ETL framework that contributed to a 30% reduction in data load time, the candidate shows they're capable of successful innovation. This hints at a problem-solving mindset, always seeking better ways to get the job done - a trait highly valued by employers.

ETL Developer Resume Templates

SharePoint Developer

Software Developer

Engineering Resume Summary Examples

• > Civil Engineer Summary Examples
• > Electrical Engineer Summary Examples
• > Front End Developer Summary Examples
• > IT Manager Summary Examples
• > Java Developer Summary Examples
• > Manufacturing Engineer Summary Examples
• > Mechanical Engineer Summary Examples
• > Network Administrator Summary Examples
• > Python Developer Summary Examples
• > Quality Assurance Tester Summary Examples
• > Quality Engineer Summary Examples
• > Scrum Master Summary Examples
• > Software Developer Summary Examples
• > Software Engineer Summary Examples
• > System Administrator Summary Examples
• > Web Developer Summary Examples

Engineering Resume Objective Examples

• > Civil Engineer Objective Examples
• > Electrical Engineer Objective Examples
• > Front End Developer Objective Examples
• > IT Manager Objective Examples
• > Java Developer Objective Examples
• > Manufacturing Engineer Objective Examples
• > Mechanical Engineer Objective Examples
• > Network Administrator Objective Examples
• > Python Developer Objective Examples
• > Quality Assurance Tester Objective Examples
• > Quality Engineer Objective Examples
• > Scrum Master Objective Examples
• > Software Developer Objective Examples
• > Software Engineer Objective Examples
• > System Administrator Objective Examples
• > Web Developer Objective Examples

Engineering Resume Guides

• > Civil Engineer Resume Guides
• > Electrical Engineer Resume Guides
• > Front End Developer Resume Guides
• > IT Manager Resume Guides
• > Java Developer Resume Guides
• > Manufacturing Engineer Resume Guides
• > Mechanical Engineer Resume Guides
• > Network Administrator Resume Guides
• > Python Developer Resume Guides
• > Quality Assurance Tester Resume Guides
• > Quality Engineer Resume Guides
• > Scrum Master Resume Guides
• > Software Developer Resume Guides
• > Software Engineer Resume Guides
• > System Administrator Resume Guides
• > Web Developer Resume Guides

Thank you for the checklist! I realized I was making so many mistakes on my resume that I've now fixed. I'm much more confident in my resume now.

ETL Developer Resume Sample

The resume builder.

Create a Resume in Minutes with Professional Resume Templates

Work Experience

• Experience with UNIX shell scripting
• Experience with Data warehousing techniques (Star Schema, snow flaking, denormalization, Normalization, Aggregations)
• Oversees the data load production process and the implementation of new data load files in accordance with the department’s change management process
• Create, execute, and document unit test plans for ETL and data integration processes and programs
• Perform tasks required to conform to the company’s configuration management and software release processes
• Monitor and administer automated and manual data integration and ETL jobs to verify execution and measure performance
• Dedicated to excellence in one’s work; detail-oriented and thorough
• Review proposed mappings with relevant personnel, e.g. Business Analyst, Data Stewards, Business System and Data Analyst
• Generate detailed design documentation for the source-to-target transformations
• Create test scenarios and be responsible for their execution
• Support the efforts of the Data Staging Developer(s)
• Work with enterprise application integration personnel to anticipate and resolve data integration issues across applications and technical infrastructures
• Applies in-depth or broad technical knowledge to maintain one or more technology areas (e.g. Database Administration, ETL Design)
• Applies technologies to software solutions of high complexity
• Strong database (Oracle) skills including database design, development (packages, functions, procedures)
• Solid hands-on experience in using IBM DataStage / Information Server
• Performs tasks required to conform to the company’s configuration management and software release processes
• Business Analyst(s) to understand informational requirements
• Data Administrator and Data Stewards to understand information quality definitions and expectations of end users
• Data Modeler and Database Designer in the design of target environment data structures
• Business System and Data Analyst to understand source system data and structures
• Detail design of source to target data mappings

Professional Skills

• Excellent functional, analytical, interpersonal and communication skills, including strong listening skills
• Strong written communication skills; outstanding interpersonal and oral communication skills
• Exceptional verbal and written communication skills desired along with strong interpersonal skills to interact with internal customers and third party vendors
• Strong experience on RDBMS (preferably DB2) with good PL/SQL concepts & strong SQL skills
• ETL Development experience with strong ETL and SQL programming skills (required); MySQL experience (desired)
• Strong ETL testing experience and verification utilizing SQL querying skills (PL/SQL, Toad or other tool) and formal testing methodologies
• Demonstrated strong coding skills in one or more high-level languages such as Python, R, Java, Smalltalk or Perl

How to write ETL Developer Resume

ETL Developer role is responsible for sql, analytical, etl, technical, development, design, interpersonal, business, analysis, database. To write great resume for etl developer job, your resume must include:

• Your contact information
• Work experience
• Skill listing

Contact Information For ETL Developer Resume

The section contact information is important in your etl developer resume. The recruiter has to be able to contact you ASAP if they like to offer you the job. This is why you need to provide your:

• First and last name
• Telephone number

Work Experience in Your ETL Developer Resume

The section work experience is an essential part of your etl developer resume. It’s the one thing the recruiter really cares about and pays the most attention to. This section, however, is not just a list of your previous etl developer responsibilities. It's meant to present you as a wholesome candidate by showcasing your relevant accomplishments and should be tailored specifically to the particular etl developer position you're applying to. The work experience section should be the detailed summary of your latest 3 or 4 positions.

Representative ETL Developer resume experience can include:

• Demonstrated strong data visualization skills and strong attention to detail
• Good knowledge of analytical and logical conceptual level programming skills, data analysis, data mapping, data loading, and data validation
• Excellent analytical, mathematical, and creative problem-solving skills. Excellent understanding of the organizations goals and objectives
• Organizational skills, problem-solving skills with close attention to detail
• Experience working with cross functional teams, with strong interpersonal and written communication skills
• Excellent analytical and troubleshooting skills with a good track record of successful ETL application development

Education on an ETL Developer Resume

Make sure to make education a priority on your etl developer resume. If you’ve been working for a few years and have a few solid positions to show, put your education after your etl developer experience. For example, if you have a Ph.D in Neuroscience and a Master's in the same sphere, just list your Ph.D. Besides the doctorate, Master’s degrees go next, followed by Bachelor’s and finally, Associate’s degree.

Additional details to include:

• School you graduated from
• Major/ minor
• Year of graduation
• Location of school

These are the four additional pieces of information you should mention when listing your education on your resume.

Professional Skills in ETL Developer Resume

When listing skills on your etl developer resume, remember always to be honest about your level of ability. Include the Skills section after experience.

Present the most important skills in your resume, there's a list of typical etl developer skills:

• Good interpersonal skills and good customer service skills
• Excellent time management skills – ability to effectively prioritise workloads and to meet business expectations
• Excellent analytic skills, attention to detail, and problem-solving skills
• Good communication skills, efficient time management and organization skills, ability to handle multiple tasks and work well in a team environment
• Demonstrate effective organizational and time management skills while managing multiple priorities and projects

List of Typical Experience For an ETL Developer Resume

Experience for junior etl developer resume.

• Strong collaboration skills with the ability to work in a team-based environment including employees, vendors, and third party contractors
• Effectively prioritize and execute tasks in a high‐pressure environment
• Prior experience designing and building complete ETL processes, including moving and transforming data for ODS, Staging, and Data Warehousing, required
• Experience designing and implementing effective data strategies in enterprise level data stores, data marts or data warehouses

Experience For SQL / ETL Developer Resume

• Strong ETL development experience using ETL tool Informatica - Data warehousing environment
• Has experience incorporating API’s into data reporting experience
• Database code performance tuning skills required
• Experience: 5+ years of programming/systems analysis experience
• Good understanding of RDBMS concepts and development experience in Oracle
• Experienced in using Talend would be a strong advantage
• Proven experience and working knowledge of database management systems and standards

Experience For Ssis ETL Developer Resume

• Strong experience in SQL ETL or other comparable programming language
• Strong customer service orientation. Experience working in a team-oriented, collaborative environment
• ETL experience including experience with ETL tools
• Trong data design, data modeling and facilitation skills
• Skills with Oracle and SQL for tuning large-volume queries
• Exceptional skills managing through conflicts
• Provide functional expertise within his/her skills to assist delivery team members, and foster collaboration within Technology
• Strong experience in SQL / T-SQL

Experience For ETL Developer / Analyst Resume

• Proven ability to provide technical leadership and guidance to less experienced team members
• Strong command and experience on Oracle database (including DDL, DML, DCL, TCL, data modelling, query optimisation, database instance tuning)
• Experience or Equivalent Project development experience using ETL Technologies like DataStage, Informatica with any Database, UNIX, Autosys
• Effectively translate technology terms and functionality into a business vocabulary understandable by non-technical staff
• Applies analytical skills to profile and work with travel data
• Working technical experience with designing, building and supporting data warehouses
• Understanding of ETL concepts of data flow, data enrichment, data consolidation, change data capture and transformation
• Experience in leading and developing data warehousing applications / Costing applications in financial and banking domain
• Two to three years of data warehousing experience including dimensional modeling, implementation and support

Experience For Database / ETL Developer Resume

• Software development experience using (Java, Python, Shell scripting, API designing ) are required
• Highly skilled in SQL development (writing, troubleshooting, optimizing)
• Experience using scheduling tools like Autosys, Tivoli etc. creating jobs for design
• Experience with scheduling ETL jobs using SQL Agent, and external scheduling tool
• Five years of experience developing, maintaining and supporting ETL programs with various target/source types and ETL transformations

Experience For Oracle ETL Developer Resume

• Data analysis, data mapping, data loading, and data validation; - Understand reusability, parameterization, workflow design, etc.
• Experience using a full life cycle methodology for ETL development utilizing IBM’s InfoSphere suite, DataStage, QualityStage, etc
• Experienced in query profiling and performance tuning
• Experience in dimensional data modeling, ETL development, and Data Warehousing or data-mart environment
• Five or more years of experience in full lifecycle ETL processing using DataStage and related tools
• Good knowledge in identifying performance bottlenecks and also in tuning the Mappings and Sessions
• Deep experience troubleshooting, and constructing performance improvements in Informatica Powercenter
• Experience developing DB schemas, creating ETLs, and familiar with Hadoop/MPP systems

Experience For Senior Manager, ETL Developer Resume

• Design, Development & Implementation experience using ETL tool Datastage, Talend, Abnitio in Banking industry
• Recent experience with development process; including requirements, design, construction, testing and implementation required
• Experience in developing best practices, unit testing and developer code reviews
• Experience leading, mentoring ETL staff in data warehouse domain
• Experience in data profiling, sub setting, obfuscation, and test data fabrication
• Programming experience using SQL, PL/SQL, shell scripts on windows server
• Strong proficiency with reading and writing SQL
• Experience using Informatica including mappings, workflows, etc
• Experience using Oracle RDBMS including PL/SQL development and ability to design and tune complex queries

Experience For Digitalisation ETL Developer Resume

• Experience of working closely with a marketing department
• Strong understanding of data modeling techniques
• Experience in managing data lineage and performing impact analyses
• Two to three years of experience using ETL tool SAP Data Services
• Demonstrated ability to communicate complex technical information to non-technical personnel both verbally and in writing
• Experience in systems analysis, design or programming and the associated development methodologies
• Solid understanding of relational and dimensional database structures, theories, principles, and practices
• Experience with data warehouse architecture, extract/transform/load (ETL) and business requirements gathering and analysis

Experience For Business Intelligence ETL Developer Resume

• Strong Knowledgeable in ETL & BI development and implementations, data architecture and data warehousing
• Knowledge on concepts and experience writing SQL and ETL code with the ability to analyze, diagnose, and tune for scale and performance
• Strong understanding and adherence to IT SDLC and operational best practices
• Less than 1 year of experience in a data warehousing environment
• Follow managers’ direction regarding project priorities, milestones and initiatives
• More than 4-6 years of experience in systems analysis, design, or programming, and the associated development methodologies
• Substantial development experience in creating stored procedures, PL/SQL Packages, Functions, Cursors, and Triggers
• Experience in integration of various data sources like DB2, SQL Server, and Flat Files into the staging area

Experience For Microsoft ETL Developer Resume

• Perform tests and validate the data flow, prepare all ETL processes according to business requirements
• Strong knowledge of dimensional data modeling
• Experience working with databases (Greenplum, KDB, DB2, Sybase, Oracle, etc)
• Proven track record for data driven decision making
• Enterprise Reporting Tool Experience, such as Cognos or Business Objects
• Data Modeling and Data Warehouse experience
• Experience in Data Warehousing and Business Intelligence

List of Typical Skills For an ETL Developer Resume

Skills for junior etl developer resume.

• Excellent interpersonal and communications skills necessary to work effectively with all levels of the organization as well as geographically disbursed teams
• Demonstrated skills in developing and maintaining good interpersonal relationships
• Experience of solid SQL Server/Oracle database skills including the ability to write complex SQL and stored procedures
• Evidence of strong leadership and communication skills at a senior level
• Demonstrate strong communication, organization, and data analysis skills
• Differentiating factors: Experience with Oracle E Business Suite. Greater number of overall years of experience. Experience in finance industry

Skills For SQL / ETL Developer Resume

• Advanced skills in RDBMS, Data Modeling and Design, and building data warehouses, data marts using Star Schema for faster and effective querying
• Strong skills in testing individual processes, integration testing and data quality testing
• Demonstrated team-building skills, including leadership, personnel recruitment, retention, hiring, delegation and development
• Experience Writing shell scripts Experience producing effective reports
• Proven strategic thinking and problem-solving skills
• Strong critical thinking and problem-solving skills and a desire to take initiative

Skills For Ssis ETL Developer Resume

• Strong Perl programming skills, PERL DBI module & multithreaded
• Strong Oracle SQL programming skills
• Strong data analysis and modelling skills
• Experience working effectively with small groups of highly talented data scientists
• Strong interpersonal, problem solving and verbal communication skills
• Familiarity with reporting tools and good analytical skills
• Experience with Informatica tool set with good working experience in Informatica 8.6.1

Skills For ETL Developer / Analyst Resume

• Effectively communicate with people from many different disciplines with varying degrees of technical experience
• Strong SQL skills & understanding of FTP processes
• Demonstrated skills in leadership, organization, and team building
• Excellent listening, interpersonal, written and oral communication skills. Logical and efficient, with keen attention to detail
• Solid programming development skills with emphasis on modular code that is well tested and maintainable

Skills For Database / ETL Developer Resume

• Standard ETL Informatica development experience of 3-5 years. Also, strong Oracle knowledge and working experience of Informatica+Oracle
• Good hands-on experience in UNIX/Solaris OS along with a good exposure to shell scripting
• Demonstrated ETL skills using SSIS to access data in Flat File, SQL, and MS Access
• Good oral and written communication, analytical, and problem-solving skills
• Good interpersonal skills and collaborative style to include team-working ability

Skills For Oracle ETL Developer Resume

• Strong skillsets working within Talend ETL framework
• We need candidates with strong SSIS and strong Informatica experience
• Strong critical and creative reasoning skills
• Attention to detail and strong organization skills essential
• Demonstrated ability to interact effectively across capability group boundaries
• Work as a team with good communication skills

Skills For Senior Manager, ETL Developer Resume

• Strong analytical skills and the ability to work within a group
• Database experience, data analysis and analytical skills
• Excellent, proficient SQL skills
• Work effectively in short-cycle, team oriented environment, managing multiple priorities and tasks
• Skill in documenting processes and procedures effectively
• Excellent writing and analytical skills; ability to work well independently and in a team environment
• Strong analytical and problem-solving skills along with the ability to explain solutions from a technical and a business point of view
• Excellent communication skills and ability to work independently and in a team is required

Skills For Digitalisation ETL Developer Resume

• Strong experience in design and development of SQL Server SSIS packages and extensive experience in writing TSQL queries, stored procedures and views
• Strong troubleshooting and risk highlighting skills
• Excellent Oracle & SQL skills
• Good client facing skills, ability to communicate with business and IT stakeholders, understand requirements and incorporate them into designs
• Strong performance-tuning, problems-solving and analytical skills

Skills For Business Intelligence ETL Developer Resume

• Possession of excellent oral and written communication skills, including providing recommendations on ETL plan and execution
• Prior experience building data warehouses – Teradata experience required
• Prior experience building data warehouses –SAP BW and/or Hadoop experience beneficial
• Excellent problem solving skills ? able to focus both on the big picture and finite details
• Strong communication and collaboration skills, focus on customer service

Skills For Microsoft ETL Developer Resume

• Experience with data analysis, mapping skills and the ability to understand and create data models
• Strong T-SQL knowledge and skills required
• Demonstrated independent problem solving skills and ability to develop solutions to analytical/data-driven problems
• Strong writing, documentation, and oral communication skills
• Strong analytical skills with the ability to collect, organize and analyze information with attention to detail and accuracy
• Excellent ETL/SSIS development skills
• Demonstrated advanced skills in Tableau visualization

List of Typical Responsibilities For an ETL Developer Resume

Responsibilities for junior etl developer resume.

• Excellent interpersonal and communication skills, including presentation, written and oral
• Work independently, possess strong problem-solving skills and have a willingness to work with new technologies
• Strong quantitative, analytical, problem-solving and organizational skills
• Creative problem solver with excellent communication, leadership and collaboration skills
• Good time management and organizational skills, with a desire to improve
• Experience in data warehousing that includes job scheduling, data profiling, data cleansing, data quality validation and Testing
• Advanced SQL query-writing skills, Windows/Linux scripting, and automated job scheduling

Responsibilities For SQL / ETL Developer Resume

• Proven ETL/Data Integration experience using the following: IBM Data Stage, Shell scripting, Oracle PL/SQL, and Microsoft SSIS
• Demonstrated hands-on experience Developing and testing query solutions using Oracle PL/SQL query
• Extensive Experience on Data-warehousing Projects & strong understating of Data-warehousing concepts
• Create reporting specifications, including report creation, data validation, and report validation
• Olid hands-on database development & SQL programming experience (stored procedures, triggers) using MS SQL Server, Oracle, and/or other databases

Responsibilities For Ssis ETL Developer Resume

• Experience in software development experience demonstrating depth of technical understanding with in ETL, BI/BO disciplines
• Demonstrated hands-on experience ETL design/Data Warehouse development using SQL and PL/SQL programming/IBM DataStage
• Demonstrated experience mentoring and assisting other developers
• Strong SQL knowledge; ability to write highly efficient queries and experience creating and modifying stored procedures, indexes, views
• Proven ETL/Data Integration experience using the following
• Demonstrated hands-on experience ETL design/Data Warehouse development using SQL and PL/SQL programming/ IBM Data Stage
• Demonstrated hands-on development experience using ER Studio for dimensional data modeling for Cognos or OBIEE 10/11g environment

Responsibilities For ETL Developer / Analyst Resume

• Excellent experience working with Oracle, PL/SQL and writing stored procedures and triggers
• Communicate effectively both verbally and in writing (Clearly and Succinctly)
• Proven experience in developing functional applications and systems of medium to high technical complexity
• Technical experience relating to ETL design, development, performance and validation
• Mainframe skills including MVS, JCL, CA7, TSO/SPF, COBOL S
• Proven recent experience of Performance Optimization and Tuning
• Balance high-priority work with lower priority maintenance work to ensure both success of projects and smooth operation of existing functions

Responsibilities For Database / ETL Developer Resume

• Critical thinking and analytical skills; ability to take loosely formed ideas, coordinate and evolve them
• Convert business rules into transformation logic 3+ years strong experience participating in multiple technical projects through a SDLC
• Experience developing ETL processes with SSIS in a data warehouse environment. Requires experience in Visual Studio, 2008, 2010, and 2012
• Experience with Shell scripts or other scripting experience
• Strong hands on experience in developing batch and real time integrations (Flat Files, EDI, XML)
• Strong hands on experience with data warehousing ETL projects

Responsibilities For Oracle ETL Developer Resume

• Skill at combining theoretical elegance with effective, practical approaches
• Demonstrated hands-on experience with UNIX Shell Scripting
• Strong problem-solving ability, and a strong customer service orientation
• Great communication skills and fluency in English as a working language

Responsibilities For Senior Manager, ETL Developer Resume

• Proven experience with one or more leading ETL tools and delivery of enterprise data integration solutions (i.e. Informatica power center, Oracle ODI..)
• Experience with Data modeling – ERWin experience is beneficial
• Prior experience with SQL coding languages
• Data Warehouse application developer with Informatica, Oracle, Netezza and UNIX Skills
• Understanding of Data encryption, TDE, and key management - Intermediate level knowledge/experience

Responsibilities For Digitalisation ETL Developer Resume

• Understanding of data replication capabilities – Informatica data replication and/or Teradata-TAS experience beneficial
• Understanding of source and target data structures and relationships – SAP experience beneficial
• Experience designing and building complete ETL/SSIS processes moving and transforming data for ODS, Staging, and Data Warehousing
• Experience in performance tuning of the SSIS packages, deploying and administering SSIS packages, proficient in utilizing scripting in SSIS
• Experience in Spark development including data frames, data transformations, performance tuning, memory sizing and tuning Spark Master and Executors
• Moderate to high-level scripting experience using any coding/scripting languages such as Unix Shell, C++, C#, Java, Python etc
• Knowledge of and experience in programming slowly changing dimension loads and update processes (ETL) including maintenance of existing ETL processes

Responsibilities For Business Intelligence ETL Developer Resume

• Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS). Capable of designing ETL mappings for flexibility
• Strong working knowledge of Databases ( Indexing, partitioning, space management)
• Extensive experience with securing sensitive data and systems, including firewalls, networking and infrastructure
• Related experience developing and implementing solutions using IBM datastage
• Some programming experience (scripting, C/C++ for data handling/manipulation)
• Experience gathering and documenting reporting requirements from stakeholders at both executive and operational levels

Responsibilities For Microsoft ETL Developer Resume

• Demonstrated working knowledge in designing reporting data sets, related meta-data, and reports
• Good understanding of data warehousing principles and modeling
• Experience with BI reporting development using MS SQL Server Reporting Services (SSRS), Tableau, and others
• Three years of experience using Unix Shell Scripting and developing Oracle and SQL Server stored procedures

Related to ETL Developer Resume Samples

Etl application developer resume sample, etl applications developer resume sample, informatica etl developer resume sample, senior cyber resume sample, consultant crm resume sample, lead sap resume sample, resume builder.

• Data Warehouse Developer Resume Example

Resume Examples

• Common Tasks & Responsibilities
• Top Hard & Soft Skills
• Action Verbs & Keywords
• Resume FAQs
• Similar Resumes

Common Responsibilities Listed on Data Warehouse Developer Resumes:

• Designing and developing data warehouse solutions to support business intelligence and reporting needs.
• Collaborating with business analysts and stakeholders to understand data requirements and translate them into technical specifications.
• Extracting, transforming, and loading (ETL) data from various sources into the data warehouse using tools like Informatica, Talend, or SSIS.
• Building and maintaining data models, schemas, and dimensional structures to optimize data storage and retrieval.
• Writing complex SQL queries and stored procedures to extract and manipulate data for reporting and analysis purposes.
• Implementing data quality and data governance processes to ensure accuracy, consistency, and integrity of data in the warehouse.
• Performance tuning and optimization of data warehouse processes and queries to improve overall system efficiency.
• Monitoring and troubleshooting data warehouse performance issues, identifying bottlenecks, and implementing solutions.
• Collaborating with database administrators to ensure proper configuration, backup, and recovery of the data warehouse.
• Conducting data profiling and data analysis to identify data quality issues and recommend improvements.
• Participating in data warehouse architecture design and providing input on technology selection and best practices.
• Keeping up-to-date with industry trends and advancements in data warehousing technologies and methodologies.

Speed up your resume creation process with the AI-Powered Resume Builder . Generate tailored achievements in seconds for every role you apply to.

Data Warehouse Developer Resume Example:

• Designed and implemented a data warehouse solution that improved data retrieval time by 40% and reduced storage costs by 25% through efficient data modeling and schema optimization.
• Collaborated with business analysts to understand data requirements and successfully translated them into technical specifications, resulting in a 15% increase in data accuracy and improved decision-making processes.
• Implemented data quality and data governance processes, resulting in a 20% reduction in data errors and ensuring compliance with industry regulations.
• Developed and maintained ETL processes using Informatica, resulting in a 30% improvement in data extraction and loading efficiency and reducing data processing time by 20%.
• Identified and resolved performance bottlenecks in data warehouse processes, resulting in a 25% increase in overall system efficiency and improved data retrieval time for end-users.
• Collaborated with database administrators to optimize database configurations, leading to a 15% improvement in query performance and enhanced overall system stability.
• Wrote complex SQL queries and stored procedures to extract and manipulate data for reporting and analysis purposes, resulting in a 20% reduction in report generation time and improved data accuracy.
• Participated in the design and implementation of a data warehouse architecture, resulting in a 30% increase in data storage capacity and improved scalability for future business needs.
• Conducted data profiling and analysis, identifying data quality issues and recommending improvements, resulting in a 15% increase in data accuracy and improved decision-making processes.
• Proficiency in SQL
• Expertise in ETL processes and tools, particularly Informatica
• Data modeling and schema optimization
• Data warehouse design and implementation
• Data profiling and analysis
• Knowledge of data quality and data governance processes
• Ability to translate business requirements into technical specifications
• Performance optimization and bottleneck resolution
• Collaboration with cross-functional teams, including business analysts and database administrators
• Knowledge of database configurations and optimization
• Understanding of industry regulations related to data management
• Ability to write complex queries and stored procedures
• Experience with data storage solutions and scalability planning
• Strong problem-solving skills
• Knowledge of data retrieval techniques and efficiency improvement
• Familiarity with data reporting and analysis tools
• Understanding of data accuracy improvement techniques.

Top Skills & Keywords for Data Warehouse Developer Resumes:

Hard skills.

• Data modeling
• ETL (Extract, Transform, Load) processes
• SQL (Structured Query Language)
• Data integration
• Data warehousing concepts
• Database design and optimization
• Data quality management
• Data migration
• Performance tuning
• Data governance
• Data profiling
• Business intelligence tools

Soft Skills

• Analytical Thinking and Problem Solving
• Attention to Detail and Accuracy
• Collaboration and Teamwork
• Communication and Interpersonal Skills
• Critical Thinking and Decision Making
• Adaptability and Flexibility
• Time Management and Prioritization
• Self-Motivation and Initiative
• Continuous Learning and Curiosity
• Attention to Data Quality and Integrity
• Troubleshooting and Debugging
• Documentation and Reporting

Resume Action Verbs for Data Warehouse Developers:

• Implemented
• Collaborated
• Streamlined
• Transformed

Generate Your Resume Summary

Resume FAQs for Data Warehouse Developers:

How long should i make my data warehouse developer resume, what is the best way to format a data warehouse developer resume, which keywords are important to highlight in a data warehouse developer resume, how should i write my resume if i have no experience as a data warehouse developer, compare your data warehouse developer resume to a job description:.

• Identify opportunities to further tailor your resume to the Data Warehouse Developer job
• Improve your keyword usage to align your experience and skills with the position
• Uncover and address potential gaps in your resume that may be important to the hiring manager

Complete the steps below to generate your free resume analysis.

Related Resumes for Data Warehouse Developers:

Big data engineer, data engineer, etl data engineer, data warehouse, data modeling, business intelligence analyst, azure data engineer, aws data engineer.

We provide IT Staff Augmentation Services!

Senior etl talend developer resume, chicago, il.

• 7+ years IT experience in Design, Development, Maintenance, Enhancements and Production Support of which includes Data warehousing and Legacy applications using ETL tools like Talend /Informatica.
• IT Experience in various industries like Financial, CRM - Address Standardizations (Establishing Global Customer Processes Address Cleansing and Standardized customer data), Telecom (CRM, Billing, provisioning, Order management, Inventory System), US - Healthcare (RxClaim pharmacy PBM (Integration OR Implementation OR SDLC, Claims OR Benefits OR Eligibility, Medicare &Medicaid like Rebates, Iris.
• Experience in adhering software methodologies like waterfall, Agile .
• Experienced in using TBD and Talend Data Fabric tools ( Talend DI, Talend MDM, Talend DQ, Talend Data Preparation, ESB, TAC )
• Experienced in using All Talend DI, MDM, DQ, DP, ESB components.
• Experienced in match/merge in MDM to run match rules to check the effectiveness of MDM process on data.
• Experienced in Data Ingestion projects to inject data into Data lake using multiple sources systems using Talend Bigdata
• Experienced in Talend Service Oriented Web Services using SOAP, REST and XML/HTTP technologies using Talend ESB components .
• Experienced in scheduling Talend jobs using Talend Administration Console (TAC) .
• Experienced in ETL Talend Data Fabric components and used features of Context Variables, MySQL, Oracle, Hive Database components .
• Good Understanding of relational database management systems, experience in integrating data from various data source like Oracle, MSSQL Server, MySQL and Flat files too.
• Experience with Talend to develop processes for extracting, cleansing, transforming , integrating, and loading data into data mart database.
• Capable of processing large sets of structured, semi-structured and unstructured data and supporting systems application architecture.
• Good experience on Talend architecture and Talend installation .
• Familiar with data architecture including data ingestion pipeline design , Hadoop information architecture, data modelling and data mining, machine learning and advanced data processing and Experience optimizing ETL workflows.
• Good experience in Big Data and Hadoop Ecosystem components like, Pig, Hive, Sqoop, Flume, MapReduce.
• Experience in Debugging, Error Handling and Performance Tuning of sources, targets, Jobs etc.
• Profound experience with Informatica Power Center tool 9.6.1/9.1/8.6/8.1 Power Exchange.
• Good Knowledge and experience in using distributed Environments for providing BI solutions to build analytics systems.
• Experience in writing UNIX scripts for Informatica jobs that are used for data movement and transformation purpose.
• Good Knowledge and experience in performance tuning in the live systems for ETL jobs that are built on Informatica as well as Talend.
• Experience in writing database objects like Stored Procedures , Triggers for Oracle , MYSQL databases and good knowledge in PL/ SQL , hands on experience in writing medium level SQL queries.
• Experience in converting the Store Procedures logic into ETL requirements.
• Hands on experience in scheduling tools like Talend Administrator , Autosys, Informatica Scheduler, Control M for ETL jobs
• Hands on experience in working with Jira, Rally , HP QC - Quality Center Systems, Perforce - Versioning applications, BMC Remedy , Ticketing &Change Request Management applications
• Experience in leading mid-size team and offshore-onsite team coordinator.

TECHNICAL SKILLS:

ETL Tool: Talend Data Fabric 6.2, 6.1, Informatica Power Center 9.6.1/9.1/8.6/8.1 , Informatica IDQ

ETL Scheduling Tool: TAC, Informatica Scheduler, Autosys, Control M, UC4 Manger

Databases: Netezza, Oracle 10g & 11i, Teradata, MS SQL Server, DB2, Hive, MySQL

DB Tool: Toad, SQL Developer, WinSQL, Squirrel Client & SQL Assistant

Other Tools: HP QC, BMC-Remedy, TTS

Operating Systems: Window Family, Linux and Solaris

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Senior ETL Talend Developer

Responsibilities:

• Responsible to build the jobs by looking to the ETL Specification documents.
• Responsible for profiling the source systems data using Different DQ Techniques.
• Responsible for develop the DI jobs to load the data from PeopleSoft to Oracle ERP.
• Responsible to define the framework for reusability system for all interfaces for Extracting, load, zipping and archiving files.
• Experienced in Creating the Context load using the parameter variables.
• Experienced in implementing the project end to end Solutions.
• Experienced using the Talend with Big data using Hive, Sqoop, Hdfs components.
• Experienced in loading the data into Data Lake .
• Developed and executed Talend jobs one module using DI for Rebate systems.
• Extensively used Talend Administrator Console ( TAC ) for running the jobs on different servers by passing various context parameters.
• Have the knowledge on scheduling jobs on TAC .
• Used SVN for version control tool for Talend jobs.
• Developed jobs to perform Address Standardization where customer addresses are standardized and loaded into HBase table which involves Talend jobs.
• Developed joblets that are reused in different processes in the flow.

Confidential, Milwaukee, WI

Senior ETL Talend Developer (DQ/DI/MDM)

• Responsible for develop the DI jobs to implement the address validations, cleans and standardization on Talend ETL with different components like tRecordMatching, tFuzzyMatch, tMatchGroup and other components DI, DP, DQ components used features such as context variables, database components.
• Responsible for understanding & deriving the new requirements from Business Analysts/Stakeholders.
• Responsible for Data Ingestion to inject data into Data Lake using multiple sources systems using Talend Bigdata.
• Responsible for MDM for Customer Data Talend MDM Customers Suppliers Products Assets Agencies Stores Address Standardizations and Reference Data Employees MDM is about creating and managing the golden records of your business
• Configured match rule set property by enabling search by rules in MDM according to Business Rules.
• Responsible for develop the modelling using Talend MDM at the same time responsible to develop the DI jobs to populate the data in REF/XREF tables and to create the data stewardship tasks.
• Experience in using Talend MDM components like tMDMBulkLoad, tMDMClose, tMDMCommit, TMDMConnection, tMDMDelete, tMDMInput, tMDMOutput, tMDMReceive, tMDMRollback, TStewardshipTaskDelete, tStewardshipTaskInput, tStewardshipTaskOutput.
• Responsible for inject the data from multiple source systems to Hive.
• Responsible for run the Talend jobs using TAC.
• Responsible for understanding &deriving the new requirements from Business Analysts/Stakeholders.
• Responsible for develop the jobs using ESB components like tESBConsumer, tESBProviderFault, tESBProviderRequest, tESBProviderResponse, tRESTClient, tRESTRequest, tRESTResponse to get the service calls for customers DUNS numbers.
• Experienced on Match and Merge scenarios for different domains.
• Responsible for preparing the logical/physical design of tables involved for this new enhancement within EDW.
• Created Tables, Indexes, Partitioned Tables, Materialized Views, Stored Procedures and Packages in oracle Database.
• Worked on designing the table layout in hive, scripts to write the data into Hadoop
• Responsible for modelling the new requirements based on BDD method for ELT applications.
• Developing the re-usable UNIX scripts for executing the above Teradata utility jobs for data load and extraction purpose
• Interacting with Business owners directly and provide the tested solutions for their user sign-off.
• Responsible for accepting ad hoc modifications/new enhancements from Business users for existing & new applications& incorporated the change without effecting the current functionalities.
• Responsible for improving/maximising the ELT jobs performance by modifying the query/mappings and partitioning the sessions using performance-tuning techniques.
• Lead the team both development team & support team.
• Responsible for monitoring the Daily/Weekly/Monthly Jobs that are scheduled using UC4 manager.

Environment: Talend Data Fabric 6.2, 6.1, Oracle, Hive, MYSQL, Visual Studio, SOAP and Restful web services, TAC

Confidential 

Senior ETL Informatica Consultant

• Developed number of complex Informatica Mappings, Mapplets and reusable Transformations to implement the business logic and to load the data incrementally ( delta load/full load )
• Extracting the data from the flat files and heterogeneous Relational databases into staging area and populated into data warehouse using SCD logic to maintain the history.
• Created and Used Workflow Variables, Session Parameters and Mapping Parameters , partitioning, Incremental aggregation, scheduler, Indirect method loading, Constraint Based loading, Incremental loading, Target Load Plan, SCD-Type1 and Type2, Tasks.
• Worked on optimizing and tuning the Teradata views and SQL’s to improve the performance of batch and response time of data for users.
• Created Informatica Mappings to load data using transformations like Filter, Expression, Router, Sorter, Rank, Transaction Control, Source Qualifier, Stored Procedure, SQL Transformation, Normalizer, Sequence Generator, Aggregator, Union, Joiner, Update Strategy, Dynamic Lookup, and Connected and unconnected lookups, Source Qualifier
• Implementing the error handling strategies whenever we required in the mappings and applying the default values
• Experienced in the performance tuning part in SQL/PLSQL quires and Informatica level
• Identified and resolved the bottlenecks in source, target, transformations, mappings and sessions to improve performance.
• By looking into logs based on busy percentage, identify the issue whether bottleneck is at reader/writer/transformation thread and fixing the same based on that log to improve the performance.
• Implemented Slowly Changing Dimensions ( SCDs, Type1and Type 2 )
• Maintained Code standards in warehouse metadata, naming standards and warehouse standards for future application development
• Created & maintained tables, views, synonyms and indexes from Logical database design document.
• Extensively Worked on Extraction, Transformation and Load (ETL) process using PL/SQL to populate the tables in OLTP and OLAP Data Warehouse Environment
• Tested the mappings using the Test Load option and Unit Test cases
• Performed the Unit and Integration Testing, which validated that the data is mapped correctly which provides a qualitative check of overall data flow.
• Created and Documented ETL Test Plans, Test Cases, Expected Results, Assumptions and Validations
• Created Teradata External loader connections such as MLoad, UPsert and Update, Fastload while loading data into the target tables in Teradata Database
• Provided technical Support in deployment of workflows, worklets and sessions for weekly releases using repository manger and maintained the same Runbook.
• Data corrections - problem finding using custom scripts written in SQL/PLSQL and problem solving using SQL/PLSQL with procedures and functions
• Regular maintenance of billing activities and daily issues resolving using SQL/PLSQL
• Efficient design and construction of the system to extract data from operational systems into the defined physical data model per the business and technical requirement.
• Review the requirement documents with the Client Data Analyst team and the Business teams as Business System analyst.
• Strong experience in production support & implementation part and RCA part and fixing the issues as per SLA and Provided the L1 and L2 level support for team as well client for normal and emergency issues on production environment.
• We did some poc kind of thing for 1 yr to migrate the project using Talend tool.
• Extensively used Talend Administrator Console (TAC) for running the jobs on different servers by passing various context parameters.
• Have the knowledge on scheduling jobs on TAC.

Environment:  Informatica 9.6.1 PC, Informatica 9.6.1 IDQ Developer, Teradata, SQL/PLSQL.

Confidential

ETL Informatica - Netezza Developer

• Responsible for remodelling the Existing business logic to new Netezza models for EDW
• Understanding the exiting SQL Server Store procedures logic and convert them into ETL Requirements.
• XML Generation Process - Identifying the required NZ source tables from the re-modelled NZ tables
• Creating the hybrid mappings for XML generation process for different frequencies
• Identifying the Rulesets to be applied on each Client Info along with Members &Providers’ info.
• Validate the data received & generate the XML files for each client and transferred to require to third parties/downstream systems.
• Modifying the generated XML files using XML formatter/Validator/Beautifier as per business owner/third-party requirements
• Preparing the UNIX scripts for SFTP of XML files to different vendors on external Servers.
• Unit testing and System Testing of mappings scheduling the ETL jobs using Control M scheduler
• Monitoring the daily/weekly DW ETL workflows

Environment: Informatica 9.1 PC, Oracle, Netezza, MySQL Server, Autosys, Toad, WinSQL, XMLReader, Windows XP &UNIX.

Senior ETL Informatica Developer

• Understanding the exiting PL/SQL Procedures & re-engineering the logic into Informatica requirements
• Extracted source definitions from oracle and flat files
• Developed mappings and workflows as per the new target databases
• Converting oracle stored procedures into Type1&Type2 mapping as per new business requirements.
• Loaded data from files to Netezza tables (stage area) using NZLOAD utility & to HDFS files using UNIX scripts.
• Understanding the Oracle Golden-Gate Data Integration application errors & support the
• Oracle DBA team for fixing the issues.
• Unit testing and System Testing
• Scheduling the ETL jobs using Informatica scheduler
• Fixing the issues occurring on daily ETL load

Environment: Informatica 9.0.1 PC, Oracle 11g, Netezza, WinSQL, Toad, Windows XP and UNIX

ETL Informatica Developer

• Preparation of ETL High level design document and publish and review the same with various teams like Modelling, testing and the End Users.
• Created mappings using Informatica PowerCenter Designer 8.6, as per ETL specification document & Implemented Reject report for finding the reject records along with the reason for rejecting those in ETL
• Developed Informatica mappings for TYPE 1, 2, 3 & Hybrid Slowly Changing Dimensions with two levels of staging to cleanse data.
• Creating the Multi group sources (Multi Group Application SQ) using Informatica Power Exchange for mainframes sources.
• Scheduling the Informatica jobs using the Autosys tool for weekly/monthly base
• Involved in system Integration testing support and responsible to drive until SIT signoff
• Lead a team of three members for new enhancements and delivering the tested code.
• Interacted with Business owners in status meeting and understand their requirements for enhancing and fixing the current issues in the existing system. Come up with recommendations on improvements to the current applications.

Environment: Informatica 8.6.1 PC & PX, Oracle, Netezza, Autosys, Toad, Squirrel, Windows XP, UNIX

• Transforming the Oracle PL/SQL procedure logic into ETL requirements
• Created mappings using Informatica PowerCenter Designer 8.6 , as per ETL specification document & Implemented Reject Record Report for finding the reject records along with the reason for rejecting those records in ETL process
• Developed Informatica mappings for TYPE 1 and TYPE 2 Slowly Changing Dimensions with two levels of staging to cleanse data

Environment:  Informatica 8.6.1, Oracle (PL/SQL), Netezza, Autosys, Toad, Squirrel, Windows, XP, UNIX

• Creating mappings using Informatica power center designer 8.1 , as per ETL specification document & creating the jobs for the mappings.
• Monitoring the Daily/weekly/monthly/quarterly jobs by fixing the Issues
• Developed Informatica mappings for TYPE 1 and TYPE 2 Slowly Changing Dimensions

Environment: Informatica 8.1, Oracle, Toad, Windows XP &UNIX

We'd love your feedback!

Resume Categories

• .NET Developers/Architects Resumes
• Java Developers/Architects Resumes
• Informatica Developers/Architects Resumes
• Business Analyst (BA) Resumes
• Quality Assurance (QA) Resumes
• Network and Systems Administrators Resumes
• Help Desk and Support specialists Resumes
• Oracle Developers Resumes
• SAP Resumes
• Web Developer Resumes
• Datawarehousing, ETL, Informatica Resumes
• Business Intelligence, Business Object Resumes
• MainFrame Resumes
• Network Admin Resumes
• Oracle Resumes
• ORACLE DBA Resumes
• Other Resumes
• Peoplesoft Resumes
• Project Manager Resumes
• Quality Assurance Resumes
• Recruiter Resumes
• SAS Resumes
• Sharepoint Resumes
• SQL Developers Resumes
• Technical Writers Resumes
• WebSphere Resumes
• Hot Resumes

Are you Hiring?

Talk to a Recruitment Specialist Call: (800) 693-8939

• Schedule A Meeting
• Franchise Opportunity
• LCA Posting Notices
• Hire IT Global, Inc - LCA Posting Notices
• Electronic PERM posting Notice

Client Services

• IT Staff Augmentation
• Hire Programmers
• Government Services
• IT Project Management
• Industry Expertise
• Resume Database

Job Seekers

• Browse Jobs
• Upload Resume
• Employee Benefits
• Resume Marketing
• Us Citizens/Green Cards

Visa Sponsorship

• Employer on Record Services (EOR)
• Forms Checklists
• H1B Visa Transfer
• E3 Visa Sponsorship
• TN Visa Sponsorship
• EB3 to EB2 Porting
• Green Card Sponsorship