ETL Developer in Indianapolis, IN at BCforward

Date Posted: 8/9/2019

Job Snapshot

Job Description

ETL Developer

BCforward is seeking a highly motivated and experienced ETL Developer for their onsite requirement in Indianapolis, IN.

10+ years' experience in Primary technical skill

Primary Technical Skills:- Informatica, RDBMS, Unix/Linux
Nice To have: Experience in Insurance domain and knowledge in Reporting tool like Business Object, Tableau etc..

Responsibility
Ø Analyzing the business requirements, design, develop and implement highly efficient, highly scalable ETL processes
Ø Required to perform daily project functions with a focus on meeting the business objectives on time in rapidly changing work environment
Ø Thorough understanding of DWH concepts and Data Models
Ø Design and Develop detailed ETL specifications based on business requirements
Ø Analyze functional specifications and assist in designing potential technical solutions
Ø Works with source system team and data analyst to define data extraction methodologies
Ø Advanced Oracle & SQL Server database skills including PL/SQL, packages, procedures, indexing and query tuning (5+ years)
Ø Enhance/Re-architect existing components to satisfy new performance and scalability requirements
Ø Regular meeting with team and stakeholders to avoid impediments
Ø Innovative ideas on automation and Proof Of concepts to get it implemented
Ø Proficient in ETL Informatica
Ø Well versed in Unix shell scripting
Ø Interact with multiple teams and translate reported problems/issues into JIRA items to implement to meet enterprise standards.
Ø Good knowledge in writing complex queries. Experience in MS SQL is value added
Ø Maintain highest levels of software quality and stability through continuous improvement of the SDLC
Ø Build and maintain design standards and best practices and ensure the team adhere these standards
Ø Evaluates and recommends unique hardware /software configurations; defines special hardware/software requirements, capacities, capabilities, etc. to meet user needs while adhering to technical standards
Ø Unit Integration testing activities and assist in User Acceptance Testing
Ø Effective time management skills in order to manage multiple priorities with flexibility on time zones and timelines
Ø Must have strong interpersonal skills and outstanding communication skill

Technical Skill
Informatica
* Strong hands on experience in Informatica 10.x +.
* Strong understanding of concepts and techniques for design, development and implementation of ETL
* Ability to perform detailed data analysis (i.e. determine the structure, content, and quality of the data through examination of source systems and data samples)
* Involved in coding, testing, implementing, debugging and documenting the complex programs.

RDBMS
* Strong hands on experience in any of the database like MS SQL(Preferable), DB2, Oracle, MYSQL, etc and interested to work in all databases
* Should be well-versed in data analysis and query methods
* Strong knowledge in data warehousing concepts
* Use of Data Modeling, Database Query Optimization and Data Access techniques and concepts

Unix/Linux
* Good knowledge in Unix, Linux, Shell Scripting
* Hands on experience in using informatica command utility like PMCMD, PMREP



Location: Indianapolis, IN

Duration: 12 month contract with strong possibility of extension or permanent placement

Wage: Negotiable

Who to Contact: Victoria DiMarco

How to Apply: Please send your resume to

About BCforward

BCforward began as an IT business solutions and staffing firm. Founded in 1998, BCforward has grown with our customers' needs into a full service personnel solutions organization. BCforward's headquarters are in Indianapolis, Indiana and also operates delivery centers in 17 locations in North America as well as Hyderabad, India and Puerto Rico. We are currently the largest consulting firm and largest MBE certified firm headquartered in Indiana. With 14+ years of uninterrupted growth, the addition of two brands (Stafforward and PMforward) and a team of more than 1400 resources our teams deliver services for multiple industries from both public and private sectors. BCforward's team of dedicated staffing professionals has placed thousands of talented people over the past decade, with retention rates that are consistently higher than the industry average.

www.bcforward.com

Stay in the lead - Find the latest in Hot Job posts, tips to stand out in the crowd, and more! Join BCforward on Facebook today!

www.facebook.com/bcforward

Interested candidates please send resume in Word format Please reference job code 90774 when responding to this ad.