• Author code for projects that meet functional and technical requirements within project timelines. Toolsets required for this development are Informatica PowerCenter and SQL Server. • Participate in team standups providing status on development activities. • Participate in providing estimates for development efforts. • Develop technical designs for implementation on assigned features in collaboration with dev team lead, and provide supporting documentation as needed. • Communicate with development team on technical decisions, to facilitate understanding and consensus on approach. • Write code that adheres to best practices and company standards with a philosophy of simpler is better, but also ensuring the security, scalability, and performance of the application. • Demonstrate a high level of effectiveness in issue resolution and performance tuning. • Write unit tests and test code thoroughly before checking into repository. • Determine appropriate updates to data warehouse landing, staging and data mart tables and develop SQL scripts to update data as required to maintain dimensions and address issues. Understand impacts of updates and identify proper approach applying understanding of Type 1 and Type 2 changes and CDC. • Write supporting documentation for deployment of software, assist in deployments, and develop deployment communications as required. • Debug and find root cause of bugs found in software; troubleshoot and fix complex issues. Find root cause and fix performance issues relating to reports, queries and ETL processes. • Identify opportunities to improve code and provide cost effective solutions for those opportunities. • Identify ways to automate coding processes and make recommendations to manager. • Work well with external team members to facilitate the development of synergies between the EDW/BI team, other IT teams and customer groups. Address job failures, monitor ETL processes to ensure data will be available on time for all BI users. • Provide 3rd level support to BI users which will be in the form of analyzing data in the data warehouse to identify root cause of problem or validate as non-issue. • Act as first point of contact for 3rd level on call for the network operations center (NOC) and address failed or stopped ETL processes accordingly to ensure data will be available for users by 8 a.m. CST. • Advanced ETL development experience (Informatica PowerCenter) is mandatory. • SQL server development experience is required. • SQL query and performance tuning skills are highly preferred. • Prior experience working with these tools in a data warehouse environment is highly preferred • Knowledge of OLAP data sources and SSIS is a plus, but not required. • Data Quality tools experience is a plus. • Prior experience with OBIEE, BIP, or Siebel is a plus, but not a requirement and lack of these will not inhibit the candidate from being exceptional in the role. • Prior experience with agile methodology and TFS, also a plus but not required.
• Excellent written and verbal communication skills - must be able to communicate with our US staff