Informatica Developer Resume Sample
Work Experience
- Build and maintain job schedules using Control-M
- Provide cost and time estimates for assigned work packages to support the development of time tables and project plans
- Coordinate coding, testing , implementation, integration and documentation of solution
- Provide solutions that potentially impact other dependent projects and applications
- Ensure that errors are detected to avoid production outages
- Development, implementation review, evaluation, and communicating status.
- Knowledge of developing within Hadoop platform
- Experience with Informatica
- Working knowledge of Java, testing, and application analysis
- Very strong SQL knowledge and understanding
- Work with product owners and other development team members to determine new features and user stories needed in new/revised application
- Participate in code reviews with peers and managers to ensure that each increment adheres to original vision as described in the user story and all standard resource libraries and architecture patterns as appropriate
- Serve as a technical lead for an Agile team and actively participate in all Agile ceremonies. Participate in all team ceremonies including planning, grooming, product demonstration and team retrospectives
- Leverage Fannie Mae DevOps tool stack to build, inspect, deploy, test and promote new or updated features
- Respond to trouble/support calls for applications in production in order to make quick repair to keep application in production
- Set up and configure a continuous integration environment
- Intermediate proficiency in unit testing as well as coding in 1-2 languages (e.g. Java, etc)
- Intermediate proficiency in Object Oriented Design (OOD) and analysis. Intermediate proficiency in application of analysis/design engineering functions. Intermediate proficiency in application of non-functional software qualities such as resiliency, maintainability, etc. Intermediate proficiency in applying behavior-driven testing techniques
- Develop and maintain ETL process and support multiple lines of Business and IT initiatives
- Work independently or collaborate with a smaller group of developers in similar efforts
- Be responsible for technical analysis, design, development, testing, and deployment of IT solutions as needed by business or IT
- Works closely with other subject matter experts to help design and build solutions for a multitude of applications, including; batch processing, OLTP, OLAP and data and data warehouse architecture
- Work with product owners and other development team members to determine new features and user stories needed in new/revised applications or large/complex development projects
- Develop and test tasks, ensure adherence to agreed timelines, and communicate status of tasks to team lead
- To get technically involved in the Design and Development of Database objects such as Tables, Views, Index, Stored Procedures, Packages, Functions, Triggers and Integrity Constraints
Education
Professional Skills
- Strong data analysis skills required. Hands on experience with managing data using Excel; data analysis, standardization, clean up, consolidation and audit
- Skills in database design with some data modeling skills, as well as proficiency with ANSI SQL-99
- Strong analytical skills (able to read/write complex SQL queries to analyze data, investigate defects, validate data quality, etc.)
- Proven skills in tuning Oracle database by adding Indexes and creating Materialized views
- Strong in analytical/problem solving/Trouble shooting skills
- Strong Skills in Relational Database – Oracle including database design & SQL writing
- Excellent time management, decision-making, problem solving, presentation, documentation skills
How to write Informatica Developer Resume
Informatica Developer role is responsible for sql, database, informatica, analytical, oracle, software, business, modeling, design, integration.
To write great resume for informatica developer job, your resume must include:
- Your contact information
- Work experience
- Education
- Skill listing
Contact Information For Informatica Developer Resume
The section contact information is important in your informatica 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 Informatica Developer Resume
The section work experience is an essential part of your informatica 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 informatica 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 informatica developer position you're applying to.
The work experience section should be the detailed summary of your latest 3 or 4 positions.
Representative Informatica Developer resume experience can include:
- Interact with functional and technical representatives of project teams in order to understand business functionalities, technical modules, integration mechanism and data sources
- Strong Data Issue troubleshooting skills
- Proven fast learning & problem management skills
- Trustworthy technical skills with a proven track-record of working successfully in various projects
- Strong SQL Skills and ETL Testing Concepts
- Strong problem solving, organizational and time management skills
Education on an Informatica Developer Resume
Make sure to make education a priority on your informatica developer resume. If you’ve been working for a few years and have a few solid positions to show, put your education after your informatica 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 Informatica Developer Resume
When listing skills on your informatica 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 informatica developer skills:
- Excellent written and verbal communication skills with strong commitment to learn new tools and technologies
- Experienced in effective management of multiple competing and frequently changing assignments and priorities
- Proven SQL skills in performance tuning and creating efficient stored procedures and functions
- Strong SQL skills including stored procedures and triggers
- A self-starter with strong analytical, problem solving, interpersonal and communication skills to engage with Senior -Business Stakeholders
- Skillfully deploy knowledge and skills in a combination of the following technology and business areas
List of Typical Experience For an Informatica Developer Resume
Experience For Senior Informatica Developer Resume
- Strong experience with UNIX shell scripting and Autosys job scheduling
- Strong data modelling fundamentals; experience with relational databases
- RDMBS (Oracle, Teradata & SQL Server) database skills, including complex SQL constructs and DDL generation
- Owns analytical skills for trouble shooting in 3rd Level
- Use data modeling skills to define target RDBMS structures and map disparate source formats to the target
- Strong 5+ years of experience in Informatica MDM and Data Warehousing
- Can scope and structure work effectively for team; adapts to changing demands
- Strong experience in DWH Technologies (Informatica, Oracle, PL/SQL, Unix, Autosys)
Experience For ETL Informatica Developer Resume
- Proven experience on large projects with 10+ integrations (this project has 20-30)
- Microsoft Excel knowledge and skills
- Oracle development / tuning skills
- Strong knowledge and experience with full lifecycle development methodologies, standards and procedures
- BDM development skills
Experience For Lead Informatica Developer Resume
- Preparing design documents, building proof of concepts, validating design solution
- Working experience in Informatica with regards to administration, support and development
- Nice to have experience on Tracking and Reporting of defects using Defect Tracking Tools such as Rally, HP Quality Center
- Experience developing ETL processes using Informatica - ETL control tables, error logging, auditing, data quality, etc
- Experience in ETL/Data ware housing debugging and testing
- Experience designing and developing data integration solutions using Informatica PowerCenter and SSIS
- Extensive experience in designing and developing ETL process for the project's data warehouse along with performance tuning aspects
Experience For ETL / Informatica Developer Resume
- Experience in DW environment- development and usage of Data Warehousing best practices and standards, ideally some data modeling
- Experience developing data integration (ETL) processes in a Data Warehouse environment using Informatica PowerCenter
- Experience in Unit Testing, Data Testing
- Skilled at unit testing code and preparing unit test documents
- Experience coding queries and stored procedures using T-SQL in a SQL Server environment
- In technical development on data warehouse related projects with experience designing and developing ETL tools
- DLC experience, including system design, integration and testing
- Other responsibilities include enhancement, performance tuning, and support of the existing applications, project coordination and prioritization
Experience For Senior ETL / Informatica Developer Resume
- Strong working knowledge of Informatica 9.1/10.x, SSIS, Unix, oracle 10g/11 g, SQL, Oracle PL/SQL, Scripting (Unix, Java, Perl, etc.)
- Experience dealing with teams working onsite and offshore
- Experience in writing or maintaining UNIX shell scripts
- Nice to have experience in Manual and Automated Testing using Mercury/HP Quality center (QC), Quick Test Pro (QTP
- Nice to have experience in creating and executing automated scripts
- Experience in using continuous integration using tools such as Jenkins & GIT to source control test assets and execute test runs
- Experience in evaluation of SQL Execution plans and providing recommendations for tuning
Experience For Software Engineer Informatica Developer Resume
- Experience in implementing and supporting large scale complex solutions and integrations
- Experience in installing Informatica and conducting upgrades of the Informatica software
- Experience designing and implementing technical solutions that are aligned with business strategy
- Proven technical expertise in Informatica Powercenter with SQL, PL/SQL (Oracle 10g / 11g), Data warehousing and Data Modeling concepts
- Hands-on experience working with relational database management system platforms including Oracle and Microsoft SQL Server, or similar
- Strong understanding of data warehousing basics and concepts
- Experience with Informatica- functional design, technical design, coding, and testing of data acquisition and ETL process
Experience For Senior ETL Informatica Developer Resume
- Experience with other reporting tools including Business Objects, Crystal Reports, Tableau
- Strong working knowledge of Oracle DDL / DML and performance tuning strategies
- Skill in writing and testing computer code
- Proven use and understanding of .Net/C# programming language
- General knowledge of UNIX/Linux with some hands-on experience developing and maintaining Shell scripts
- Experience designing and developing Data Management applications
Experience For Temp Senior Informatica Developer Resume
- Professional experience designing and developing complex multi-tiered application with Services Oriented Architecture SOA and Java applications
- Experience in systems analysis, design or programming and the associated development methodologies
- Strong proficiency in database interfacing and relational database management systems
- Designs and develops data validation processes using Informatica Data Quality
- Experience developing ETL programs and familiarity with Informatica
- 4yrs experience in relational database concepts, relational logical modeling, and physical design
Experience For Software Engineering Informatica Developer Resume
- Experience with developing an ETL lifecycle. Review and recommend the
- Experience building jobs, mappings in Informatica Cloud for Cloud Application Data Replication/ Extractions or Data Integrations
- Experience with Informatica Developer developing rules and mappings for Data Quality efforts
- Experience with SQL development, Stored Procedures, Functions and Data Modeling
- Experience developing scalable enterprise level ETL applications, preferably on Informatica Powercenter
- Experience working with Unix, SQL, XML & Java
- Experience using Informatica development tools (designer, workflow manager, etc.)
Experience For Senior Oracle / Informatica Developer Resume
- Experience leading open source frameworks and development of web services
- Experience in ETL using Informatica Powercenter
- Experience in working with Oracle database
- Proven knowledge in optimizing Informatica Powercenter mappings
- Experience using ITSM systems (Remedy, ServiceNow, etc)
List of Typical Skills For an Informatica Developer Resume
Skills For Senior Informatica Developer Resume
- Possess excellent human relations and oral and written communication skills
- Excellent verbal and written communication skills to be able to interact with technical and business teams
- Highly professional with strong communication skills
- Strong SQL and stored procedure development skills, preferably in Oracle and MS SQL Server platforms
- Strong communication skills; proved ability to work with client, business users and team members
- Strong documentation skills (scope, requirements, high-level design)
- Strong Oracle SQL/PL-SQL skills
- Good Analytical and Communication skills; Work with no/little guidance; Quick Learner
Skills For ETL Informatica Developer Resume
- Develops ETL processes using Informatica, ETL control tables, error logging, auditing, data quality, etc. Data analysis skills
- Strong experience administrating the Informatica environment - managing services, repository maintenance, deployments, user administration, versioning, etc
- In LINUX / UNIX shell scripting. Strong experience with Linux and Shell scripting is required
- Strong experience writing SQL queries in Oracle and Unix scripting
- Hands on experience of Data Profiling, Standardization, Matching and Consolidation Techniques
- Strong experience in working with ETL tool
Skills For Lead Informatica Developer Resume
- Proven experience with Unix scripting
- Eight years related experience and/or training; or equivalent combination of education and experience
- Experience in relational databases and data modeling and development with demonstrated strength in SQL, and stored procedures
- Demonstrated thorough understanding of modern enterprise architecture, hands-on experience with data integration solutions
- Knowledge and skills in data warehousing methodologies and tools, implementation strategies, and integration
- Prior experience in Real Estate and/or Property Management technologies
Skills For ETL / Informatica Developer Resume
- Informatica development skills, 10.1 or greater
- SQL development skills, Server 2012 or greater
- Solid experience with Teradata BTEQ Scripts, TPT Utilities and stored procedures/macros
- Coach and develop the skills of staff and build a team focused on delivery
- Exemplary motivation, enthusiasm, professionalism, and team skills
Skills For Senior ETL / Informatica Developer Resume
- Excellent experience in ETL, Informatica
- Proven experience on Informatica
- Strong database-development experience (Sybase, DB2, ORACLE or MS SQL Server)
- Effectively present information and interact in group situations
- Strong Informatica, Oracle, Autosys, SQL, PL/SQL experience
- Strong background in SDLC, Agile and Data Quality project experience
- Strong experience with UNIX shell scripting and Autosys job scheduling
- Strong background in SFDC framework and project experience
Skills For Software Engineer Informatica Developer Resume
- Informatica Data Quality as a primary skill with Informatica MDM experience as optional (nice to have)
- Experience with Informatica’s Data Quality and Data Validation Option tools
- Srong communication skills and ability to develop and present solutions to superiors
- Work with specifications to design and develop infrastructure to provide business users with the tools and data needed to do their jobs more effectively
- Strong hands-on experience in Informatica Powercenter, Oracle and Teradata
- Strong hands-on experience in Informatica Power center, Oracle and Teradata
- SAP experience is required along with RFC, R/3 connectivity experience
Skills For Senior ETL Informatica Developer Resume
- Follow functional ETL specifications and challenge business logic and schema design where appropriate, as well as manage their time effectively
- Mentor Jr. developers to grow skills in applying PetSmart’s best practices and standards
- Effectively communicate project information to customer and superiors
- Proactive engagement and interaction with our user base in EMEA and North America to understand and capture their business demands effectively
- Exceptional communication skills, both verbally and written
- Effectively communicate at different levels across the organization
- Demonstrated experience with all phases of a project's development lifecycle
- Proven experience of working under pressure
Skills For Temp Senior Informatica Developer Resume
- Communicate with report analysts and business stakeholders effectively and efficiently
- Demonstrates strong expertise in data warehouse concepts, practices, and procedures related to ETL design and development
- Strong ETL and data modelling experience
- Solid SQL and Unix command level experience
- Possess great SQL skills
- Good communication and strong attention to detail
Skills For Software Engineering Informatica Developer Resume
- Strong experience with SQL and Teradata databases, preferably version 15.10
- Strong Oracle 11g experience
- Senior ETL architect, developer with good experience in Design and Development of data integration components in Informatica
- Strong supply chain experience in a multisite organization
- 2) Strong experience in complex SQL
- Understanding of reporting functions, and front end reporting tool experience
Skills For Senior Oracle / Informatica Developer Resume
- Looking for a seasoned/senior Informatica developer/designer with 8-10 years of experience
- Seeking Informatica Administrator experience, with full knowledge of installation, performance turning and operational aspects of the full tool suite
- Working within Scrum team to deliver priority production fixes, often against time critical paths
- Experience in Data Warehousing and understanding of BI design including modeling, relational and multi-dimensional databases
- Design, develop and test processes for extracting, validating, transforming and loading data into data store solution (Data Lake, Data Warehouse, Data Mart)
List of Typical Responsibilities For an Informatica Developer Resume
Responsibilities For Senior Informatica Developer Resume
- Strong Experience with reporting tools /languages: Informatica, SQL, SQL Loader, Abinitio, Business Objects
- Experience communicating with Marketing Departments
- Resolve tickets according to priority and before pre-determined Service Level Agreement
- · Over all 7+ years of Experience and working in Informatica 9.5
- A good understanding of the concepts and best practices of data warehouse ETL design and be able to apply these suitably to an organization
- Able to demonstrate expertise in the writing the SQL queries/Oracle
- IT experience in Design ETL solutions and data conversion strategy and solutions for multiple disparate systems using Oracle and Informatica
- ETL experience using Informatica within large enterprise environments
- Experience with job scheduling software like Autosys
Responsibilities For ETL Informatica Developer Resume
- Experience using Informatica as ETL Tool
- Experience creating stored procedures with either T-SQL for SQL Server databases or P/L SQL for Oracle Databases
- Significant practical experience with project management including interaction with clients outside of your organization
- Responsible for validation of DDL/Informatica code during Production deployment. Also responsible for documentation of release documents
- Experience with Master Data Management (MDM) concepts using any MDM tool
- Experience in PUB/SUB, OAGIS modeling, contract governance
Responsibilities For Lead Informatica Developer Resume
- Experience in Orchestrating business processes
- Experience in PUB/SUB, OAGIS modeling, contract governance
- Programming / system analysis experience
- Experience in writing C# code in multi-tiered, multi-threaded .NET environment
- Experience with preparing technical and/or user documentation
- Have the professional maturity to take ownership, operate with transparency, and focus on producing results
- Has a good knowledge of underlying standards used in SOA and BPM such as XML, Web Services (SOAP/REST), WSDL standards
- Experience using a relational database
Responsibilities For ETL / Informatica Developer Resume
- Experience in data analysis and troubleshooting
- QL query-writing experience
- Exp working w & able to demonstrate knowledge of complex Informatica transformations
- Oracle Database Experience- Performance tuning to display large sets of data (2000 rows + with 200 + columns)
- Experience working with EDI transactions
- Experience in developing data integration and ETL with Informatica Power Center
- Good working knowledge in UNIX script
Responsibilities For Senior ETL / Informatica Developer Resume
- Good to have but basic exposure to scheduling
- Possess strong SQL background, preferable in Oracle 11g, and working knowledge in UNIX shell script
- Strong knowledge of data analysis, data transformation, conceptual data modeling, data transformation &metadata management
- Strong knowledge of Unix & Unix Shell scripting
- Informatica development experience
- Informatica Powercenter and PowerExchange development experience
Responsibilities For Software Engineer Informatica Developer Resume
- Possesses drive, demonstrable initiative and a strong work ethic
- Extensive experience with database development tools (Oracle, Powercenter), ETL and integration technologies
- Experience in IT
- Experience with the Azure technologies
- Experience with different data sources such as Oracle, DB2, Flat files, SQL Server etc
- Strong Informatica technical knowledge in the areas of Informatica Developer Components – Parser, Match, Comparison, Case Converter, labeler, Key Generator etc
Responsibilities For Senior ETL Informatica Developer Resume
- Has a good knowledge of SOA and Enterprise Architecture
- Has a solid proficiency with core XML Technologies XML, XML Schema, XPath, XQuery
- Previous experience with BPM and Service Orchestration Tools (ActiveVOS, IBM BPM, Oracle BPM, JBMPM)
- Previous experience with EAI and EAI Design Patterns
- Experience with Oracle SQL, PL/SQL
- Relational database experience in the logical and design areas
- Experience with Informatica Power Center 10.x, Power Exchange 10.1, Information Analyst, Metadata Manager
Responsibilities For Temp Senior Informatica Developer Resume
- Strong expertise with advanced SQL on Oracle/DB2/Microsoft SQL Server
- Experienced with agile project methodologies
- Experience in BI/DW development
- Good knowledge of database stored procedures
- Handle constant use of tact, discretion, and good judgement
- Experience in data-intensive application design
- Overall 5+ Yrs. of application development experience
- Good knowledge in Database and PLSQL procedure
Responsibilities For Software Engineering Informatica Developer Resume
- Good knowledge in Agile/Scrum methodology
- Informatica development experience
- Take a structured and effective approach to own work
- Expertise and experience in BI Tools – Informatica
- Prioritize workload assigned and work with minimal supervision
- Strong knowledge of ETL concepts especially as applied to Informatica, Informatica cloud & SSIS
Responsibilities For Senior Oracle / Informatica Developer Resume
- Strong knowledge of data design for various applications
- Good knowledge of various RDBMS, Mainframe
- Good knowledge of Project Life Cycles methodologies
- ETL experience in Informatica (10.1/9.6.1/9.1.1), Oracle 12c/11g/10g) - SQL, and Unix
- Result-driven individual with ability to deliver good quality solutions within tight timeline
- Understanding of business intelligence, data warehousing, data modeling, architectures and terminology