SalaryNot Specified
Job TypeFull Time
Job Location Chennai,Tamil Nadu,India • Tiruchirappalli,Tamil Nadu,India

Skills

ETL Informatica
Experience
10 to 15 Years
Industry
IT - Software Services
Functional Area
Software Development - Others

Job Summary

The ETL developer will be responsible for designing, developing, testing and implementing new/modifications to the Statutory, Vendor, and Batch Feeds utilizing ETL (Informatica) processes. Activities will involve participating in Business Requirements review, assistance with system specifications, development of technical specifications, development of code changes in Informatica, unit testing and implementation in production. The developer must follow the defined Informatica development standards and best practices and attend code reviews to assure compliance.

Responsibilities:

Ø The ETL developer's responsibility is to ensure that the goals of the business with regards to data management are met.

Ø Plan, coordinate, develop and support EDW development including architecting table structure, building ETL process, documentation, and long-term preparedness

Ø Define Technical Approach documents (define calculated logic, process flow, etc.)

Ø Provide production support of existing ETL processes

Ø Document steps needed to migrate database objects between various environments including Development, UAT, Staging, and Production

Ø Document ETL process thoroughly to allow peers to assist with support as needed

Ø The ETL developer has a full understanding of each step in the ETL process and can write ETL mappings/workflows with scripts, packages, mappings, etc. (depending on the tool).

Ø Analysis, development, QA, implementation, monitoring and administration of the ETL process.

Ø Experience in Database development using DB2 and SQL Server.

Ø Experience using a software development life cycle (SDLC) methodology

Ø Work with DBA’s to implement database changes

Ø Develop code changes using Informatica

Ø Stored Procedures/Unix scripting knowledge

Ø Implement, support and maintain data process models, including sourcing, loading, transformation and extraction.

Ø Define and capture metadata and rules associate with ETL processes

Ø Coordinate with program-level ETL architect to ensure compliance with standards and consistency with long-term infrastructure plans

Ø 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

Ø 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.

Ø Provide high quality technology solutions that address business needs

Ø Designing software and producing scalable and resilient technical designs

Ø Creating Automated Unit Tests using Flexible/Open Source Frameworks using a Test Driven Development / Behavior Driven Development approach

Ø Utilize agile methodologies and adhere to coding standards, procedures and techniques while contributing to the technical code documentation

Desired Skills:

Ø Strong SQL and data modeling skills required

Ø Development Experience with Informatica ETL

Ø 5 years of solid Informatica experience

Ø Excellent analytical and problem solving skills

Ø Experience in BI Reporting Tools such as Cognos and Oracle OBIEE

Ø Hands-on experience developing ETL programs using Informatica PowerCenter in UNIX and Oracle 12c environment. In-depth understanding and development experience using SQL and PL/SQL

Ø Prior experience providing support to technical teams for ETL processes, and experience developing unit test plans, test cases, and resolve ETL related test problems

Ø 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


Company
WBC Software Lab
Location
WBC Software Lab
WBC Software Lab # 6/1, Ambalpuram 3rd street, Facing Sagayamadha Church Karaikudi-630002
Website
http://www.wbcsoftwarelab.com
 
View Jobs By This Company

Looking for Talent ?

Find the right people, Hire them now


Post a Job, It's Free

Get Matching Jobs in your Inbox

(No Registration Needed)


Create a Job Alert

Similar Jobs

Posted By

Wbc Software Lab Lab

Executive HR

Karaikudi,Tamil Nadu,India

View Profile